Saturday 10 May 2014

Create table type LOV in WEB ADI through API

Create table type LOV in WEB ADI through API.


BEGIN
BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV
                  (p_application_id       => 20106,
                   p_interface_code       => 'GENERAL_122_INTF',
                   P_INTERFACE_COL_NAME   => 'P_BUSINESS_GROUP_ID',
                   P_ID_COL               => 'BUSINESS_GROUP_ID',
                   P_MEAN_COL             => 'NAME',
                   P_DESC_COL             => 'NAME',
                   P_TABLE                => 'PER_BUSINESS_GROUPS',
                   P_ADDL_W_C             => null,
                   P_WINDOW_CAPTION       => null,
                   P_WINDOW_WIDTH         => NULL,
                   P_WINDOW_HEIGHT        => NULL,
                   P_TABLE_BLOCK_SIZE     => NULL,
                   P_TABLE_SORT_ORDER     => 'ascending',
                   P_USER_ID              => 0,
                   P_TABLE_COLUMNS        => 'BUSINESS_GROUP_ID,NAME',
                   P_TABLE_SELECT_COLUMNS => 'BUSINESS_GROUP_ID',
                   P_TABLE_COLUMN_ALIAS   => 'BUSINESS_GROUP_ID',
                   P_TABLE_HEADERS        => 'BUSINESS_GROUP_ID,NAME',
                   P_POPLIST_FLAG         =>'N'
);
EXCEPTION
when NO_DATA_FOUND then
dbms_output.put_line('error no data ' ||sqlerrm);
when others then
dbms_output.put_line('error ' ||sqlerrm);
end;

No comments:

Post a Comment