CUSTOM.pll to change LOV

Custom PLL file path  example : $AU_TOP/12.0.0/resource

------this  is the to be used and pasted in custom pll

 

v_lov LOV;

  rg_name VARCHAR2(40);

  rg_id RecordGroup;

  v_sql  varchar2(5000);

  result Number;

  rec_id RecordGroup;

  -- 

  -- Real code starts here 

  --change lov of tax classifcation code in sales order form 19-11-2024

  

  -------------------

  -- 

  begin 

    null; 

    begin

 

  IF (event_name = 'WHEN-NEW-ITEM-INSTANCE' AND form_name= 'OEXOEORD') THEN

    IF (block_name = 'LINE') THEN

    rg_id := FIND_GROUP('TAX_CODES_RG');

    v_lov := FIND_LOV('TAX_CODES');

    v_sql := 'select TAX_CLASSIFICATION_CODE,TAX_CLASSIFICATION from zx_output_classifications_v1';

    rec_id := CREATE_GROUP_FROM_QUERY('PO_GRP_548741',v_sql);

    result := POPULATE_GROUP(FIND_GROUP('PO_GRP_548741'));

    SET_LOV_PROPERTY('TAX_CODES',GROUP_NAME ,'PO_GRP_548741');

    END IF;

    END IF;

  

 

  end;

-------------------------------------------------------------------------------------------

after this put this new custom.pll into instance and run the below code in putty

. ./EBSapps.env  RUN

cd $AU_TOP/12.0.0/resource

frmcmp_batch module=CUSTOM.pll userid=apps/apps output_file=CUSTOM.plx module_type=LIBRARY batch=yes compile_all=special