APPS.AMS_ATTB_LOV_VALUES_PKG dependencies on AMS_ATTB_LOV_VALUES_B_S

Line 189: update AMS_ATTB_LOV_VALUES_B set

185: X_PROGRAM_APPLICATION_ID in NUMBER,
186: X_PROGRAM_UPDATE_DATE in DATE
187: ) is
188: begin
189: update AMS_ATTB_LOV_VALUES_B set
190: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
191: REQUEST_ID = X_REQUEST_ID,
192: VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID,
193: ATTB_LOV_ID = X_ATTB_LOV_ID,

Line 363: SELECT AMS_ATTB_LOV_VALUES_B_S.NEXTVAL

359: FROM AMS_ATTB_LOV_VALUES_B
360: WHERE ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID;
361:
362: CURSOR c_get_id is
363: SELECT AMS_ATTB_LOV_VALUES_B_S.NEXTVAL
364: FROM DUAL;
365: BEGIN
366: if X_OWNER = 'SEED' then
367: l_user_id := 1;