APPS.AHL_UNIT_DEFERRALS_PKG dependencies on AHL_UNIT_DEFERRALS_B

Line 42: cursor C is select ROWID from AHL_UNIT_DEFERRALS_B

38: X_LAST_UPDATE_DATE in DATE,
39: X_LAST_UPDATED_BY in NUMBER,
40: X_LAST_UPDATE_LOGIN in NUMBER
41: ) is
42: cursor C is select ROWID from AHL_UNIT_DEFERRALS_B
43: where UNIT_DEFERRAL_ID = X_UNIT_DEFERRAL_ID
44: ;
45: begin
46: insert into AHL_UNIT_DEFERRALS_B (

Line 46: insert into AHL_UNIT_DEFERRALS_B (

42: cursor C is select ROWID from AHL_UNIT_DEFERRALS_B
43: where UNIT_DEFERRAL_ID = X_UNIT_DEFERRAL_ID
44: ;
45: begin
46: insert into AHL_UNIT_DEFERRALS_B (
47: ATA_SEQUENCE_ID,
48: ATTRIBUTE5,
49: ATTRIBUTE6,
50: ATTRIBUTE7,

Line 94: AHL_UNIT_DEFERRALS_B_S.NEXTVAL,

90: X_ATTRIBUTE12,
91: X_ATTRIBUTE13,
92: X_ATTRIBUTE14,
93: X_ATTRIBUTE15,
94: AHL_UNIT_DEFERRALS_B_S.NEXTVAL,
95: X_UNIT_EFFECTIVITY_ID,
96: X_UNIT_DEFERRAL_TYPE,
97: X_SET_DUE_DATE,
98: X_APPROVAL_STATUS_CODE,

Line 220: from AHL_UNIT_DEFERRALS_B

216: ATTRIBUTE1,
217: ATTRIBUTE2,
218: ATTRIBUTE3,
219: ATTRIBUTE4
220: from AHL_UNIT_DEFERRALS_B
221: where UNIT_DEFERRAL_ID = X_UNIT_DEFERRAL_ID
222: for update of UNIT_DEFERRAL_ID nowait;
223: recinfo c%rowtype;
224:

Line 356: update AHL_UNIT_DEFERRALS_B set

352: X_LAST_UPDATED_BY in NUMBER,
353: X_LAST_UPDATE_LOGIN in NUMBER
354: ) is
355: begin
356: update AHL_UNIT_DEFERRALS_B set
357: ATA_SEQUENCE_ID = X_ATA_SEQUENCE_ID,
358: ATTRIBUTE5 = X_ATTRIBUTE5,
359: ATTRIBUTE6 = X_ATTRIBUTE6,
360: ATTRIBUTE7 = X_ATTRIBUTE7,

Line 420: delete from AHL_UNIT_DEFERRALS_B

416: if (sql%notfound) then
417: raise no_data_found;
418: end if;
419:
420: delete from AHL_UNIT_DEFERRALS_B
421: where UNIT_DEFERRAL_ID = X_UNIT_DEFERRAL_ID;
422:
423: if (sql%notfound) then
424: raise no_data_found;

Line 434: from AHL_UNIT_DEFERRALS_B B

430: begin
431: delete from AHL_UNIT_DEFERRALS_TL T
432: where not exists
433: (select NULL
434: from AHL_UNIT_DEFERRALS_B B
435: where B.UNIT_DEFERRAL_ID = T.UNIT_DEFERRAL_ID
436: );
437:
438: update AHL_UNIT_DEFERRALS_TL T set (