DBA Data[Home] [Help]

APPS.AMS_ATTB_LOV_PKG dependencies on AMS_ATTB_LOV_B_S

Line 221: update AMS_ATTB_LOV_B set

217: X_PROGRAM_APPLICATION_ID in NUMBER,
218: X_PROGRAM_UPDATE_DATE in DATE
219: ) is
220: begin
221: update AMS_ATTB_LOV_B set
222: DATA_TYPE = X_DATA_TYPE,
223: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
224: REQUEST_ID = X_REQUEST_ID,
225: VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID,

Line 307: SELECT AMS_ATTB_LOV_B_S.NEXTVAL

303: FROM AMS_ATTB_LOV_B
304: WHERE ATTB_LOV_ID = X_ATTB_LOV_ID;
305:
306: CURSOR c_get_id is
307: SELECT AMS_ATTB_LOV_B_S.NEXTVAL
308: FROM DUAL;
309: BEGIN
310: if X_OWNER = 'SEED' then
311: l_user_id := 1;