APPS.AMS_ATTB_LOV_PKG dependencies on AMS_ATTB_LOV_B

Line 26: cursor C is select ROWID from AMS_ATTB_LOV_B

22: X_PROGRAM_ID in NUMBER,
23: X_PROGRAM_APPLICATION_ID in NUMBER,
24: X_PROGRAM_UPDATE_DATE in DATE
25: ) is
26: cursor C is select ROWID from AMS_ATTB_LOV_B
27: where ATTB_LOV_ID = X_ATTB_LOV_ID
28: ;
29: begin
30: insert into AMS_ATTB_LOV_B (

Line 30: insert into AMS_ATTB_LOV_B (

26: cursor C is select ROWID from AMS_ATTB_LOV_B
27: where ATTB_LOV_ID = X_ATTB_LOV_ID
28: ;
29: begin
30: insert into AMS_ATTB_LOV_B (
31: DATA_TYPE,
32: ATTB_LOV_ID,
33: OBJECT_VERSION_NUMBER,
34: REQUEST_ID,

Line 137: from AMS_ATTB_LOV_B

133: STATUS_CODE,
134: LOV_SEEDED_FOR,
135: SEEDED_FLAG,
136: SECURITY_GROUP_ID
137: from AMS_ATTB_LOV_B
138: where ATTB_LOV_ID = X_ATTB_LOV_ID
139: for update of ATTB_LOV_ID nowait;
140: recinfo c%rowtype;
141:

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 266: delete from AMS_ATTB_LOV_B

262: if (sql%notfound) then
263: raise no_data_found;
264: end if;
265:
266: delete from AMS_ATTB_LOV_B
267: where ATTB_LOV_ID = X_ATTB_LOV_ID;
268:
269: if (sql%notfound) then
270: raise no_data_found;

Line 298: FROM AMS_ATTB_LOV_B

294: l_db_luby_id number;
295:
296: CURSOR c_obj_verno IS
297: SELECT object_version_number, last_updated_by
298: FROM AMS_ATTB_LOV_B
299: WHERE ATTB_LOV_ID = X_ATTB_LOV_ID;
300:
301: CURSOR c_chk_exists is
302: SELECT 'x'

Line 303: FROM AMS_ATTB_LOV_B

299: WHERE ATTB_LOV_ID = X_ATTB_LOV_ID;
300:
301: CURSOR c_chk_exists is
302: SELECT 'x'
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

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;

Line 399: from AMS_ATTB_LOV_B B

395: begin
396: delete from AMS_ATTB_LOV_TL T
397: where not exists
398: (select NULL
399: from AMS_ATTB_LOV_B B
400: where B.ATTB_LOV_ID = T.ATTB_LOV_ID
401: );
402:
403: update AMS_ATTB_LOV_TL T set (