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