APPS.AMS_ATTB_LOV_VALUES_PKG dependencies on AMS_ATTB_LOV_VALUES_B

Line 22: cursor C is select ROWID from AMS_ATTB_LOV_VALUES_B

18: X_PROGRAM_ID in NUMBER,
19: X_PROGRAM_APPLICATION_ID in NUMBER,
20: X_PROGRAM_UPDATE_DATE in DATE
21: ) is
22: cursor C is select ROWID from AMS_ATTB_LOV_VALUES_B
23: where ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID
24: ;
25: begin
26: insert into AMS_ATTB_LOV_VALUES_B (

Line 26: insert into AMS_ATTB_LOV_VALUES_B (

22: cursor C is select ROWID from AMS_ATTB_LOV_VALUES_B
23: where ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID
24: ;
25: begin
26: insert into AMS_ATTB_LOV_VALUES_B (
27: ATTB_LOV_VALUE_ID,
28: OBJECT_VERSION_NUMBER,
29: REQUEST_ID,
30: VIEW_APPLICATION_ID,

Line 120: from AMS_ATTB_LOV_VALUES_B

116: VIEW_APPLICATION_ID,
117: ATTB_LOV_ID,
118: VALUE_CODE,
119: SECURITY_GROUP_ID
120: from AMS_ATTB_LOV_VALUES_B
121: where ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID
122: for update of ATTB_LOV_VALUE_ID nowait;
123: recinfo c%rowtype;
124:

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 230: delete from AMS_ATTB_LOV_VALUES_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from AMS_ATTB_LOV_VALUES_B
231: where ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 244: from AMS_ATTB_LOV_VALUES_B B

240: begin
241: delete from AMS_ATTB_LOV_VALUES_TL T
242: where not exists
243: (select NULL
244: from AMS_ATTB_LOV_VALUES_B B
245: where B.ATTB_LOV_VALUE_ID = T.ATTB_LOV_VALUE_ID
246: );
247:
248: update AMS_ATTB_LOV_VALUES_TL T set (

Line 354: FROM AMS_ATTB_LOV_VALUES_B

350: l_db_luby_id number;
351:
352: CURSOR c_obj_verno IS
353: SELECT object_version_number, last_updated_by
354: FROM AMS_ATTB_LOV_VALUES_B
355: WHERE ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID;
356:
357: CURSOR c_chk_exists is
358: SELECT 'x'

Line 359: FROM AMS_ATTB_LOV_VALUES_B

355: WHERE ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID;
356:
357: CURSOR c_chk_exists is
358: SELECT 'x'
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

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;