APPS.AMS_PROGRAMS_ALL_PKG dependencies on AMS_PROGRAMS_ALL_B

Line 36: cursor C is select ROWID from AMS_PROGRAMS_ALL_B

32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER
35: ) is
36: cursor C is select ROWID from AMS_PROGRAMS_ALL_B
37: where PROGRAM_ID = X_PROGRAM_ID
38: ;
39: begin
40: insert into AMS_PROGRAMS_ALL_B (

Line 40: insert into AMS_PROGRAMS_ALL_B (

36: cursor C is select ROWID from AMS_PROGRAMS_ALL_B
37: where PROGRAM_ID = X_PROGRAM_ID
38: ;
39: begin
40: insert into AMS_PROGRAMS_ALL_B (
41: PROGRAM_ID,
42: OBJECT_VERSION_NUMBER,
43: REQUIRED_FLAG,
44: ATTRIBUTE_CATEGORY,

Line 174: from AMS_PROGRAMS_ALL_B

170: ATTRIBUTE12,
171: ATTRIBUTE13,
172: ATTRIBUTE14,
173: ATTRIBUTE15
174: from AMS_PROGRAMS_ALL_B
175: where PROGRAM_ID = X_PROGRAM_ID
176: for update of PROGRAM_ID nowait;
177: recinfo c%rowtype;
178:

Line 282: update AMS_PROGRAMS_ALL_B set

278: X_LAST_UPDATED_BY in NUMBER,
279: X_LAST_UPDATE_LOGIN in NUMBER
280: ) is
281: begin
282: update AMS_PROGRAMS_ALL_B set
283: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
284: REQUIRED_FLAG = X_REQUIRED_FLAG,
285: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
286: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 336: delete from AMS_PROGRAMS_ALL_B

332: if (sql%notfound) then
333: raise no_data_found;
334: end if;
335:
336: delete from AMS_PROGRAMS_ALL_B
337: where PROGRAM_ID = X_PROGRAM_ID;
338:
339: if (sql%notfound) then
340: raise no_data_found;

Line 350: from AMS_PROGRAMS_ALL_B B

346: begin
347: delete from AMS_PROGRAMS_ALL_TL T
348: where not exists
349: (select NULL
350: from AMS_PROGRAMS_ALL_B B
351: where B.PROGRAM_ID = T.PROGRAM_ID
352: );
353:
354: update AMS_PROGRAMS_ALL_TL T set (

Line 465: from AMS_PROGRAMS_ALL_B

461: l_program_id number;
462:
463: cursor c_obj_verno is
464: select object_version_number
465: from AMS_PROGRAMS_ALL_B
466: where program_id = X_PROGRAM_ID;
467:
468: cursor c_chk_prg_exists is
469: select 'x'

Line 470: from AMS_PROGRAMS_ALL_B

466: where program_id = X_PROGRAM_ID;
467:
468: cursor c_chk_prg_exists is
469: select 'x'
470: from AMS_PROGRAMS_ALL_B
471: where program_id = X_PROGRAM_ID;
472:
473: cursor c_get_program_id is
474: select AMS_PROGRAMS_ALL_B_S.nextval

Line 474: select AMS_PROGRAMS_ALL_B_S.nextval

470: from AMS_PROGRAMS_ALL_B
471: where program_id = X_PROGRAM_ID;
472:
473: cursor c_get_program_id is
474: select AMS_PROGRAMS_ALL_B_S.nextval
475: from dual;
476:
477: BEGIN
478: