APPS.AMW_CERTIFICATION_PKG dependencies on AMW_CERTIFICATION_B

Line 46: cursor C is select ROWID from AMW_CERTIFICATION_B

42: X_CERTIFICATION_PERIOD_NAME in VARCHAR2,
43: X_CERTIFICATION_PERIOD_SET_NAM in VARCHAR2,
44: X_LAST_REMINDER_DATE in DATE
45: ) is
46: cursor C is select ROWID from AMW_CERTIFICATION_B
47: where CERTIFICATION_ID = X_CERTIFICATION_ID
48: ;
49: begin
50: insert into AMW_CERTIFICATION_B (

Line 50: insert into AMW_CERTIFICATION_B (

46: cursor C is select ROWID from AMW_CERTIFICATION_B
47: where CERTIFICATION_ID = X_CERTIFICATION_ID
48: ;
49: begin
50: insert into AMW_CERTIFICATION_B (
51: ATTRIBUTE10,
52: ATTRIBUTE11,
53: ATTRIBUTE12,
54: ATTRIBUTE13,

Line 244: from AMW_CERTIFICATION_B

240: ATTRIBUTE8,
241: ATTRIBUTE9,
242: STATEMENT_GROUP_ID,
243: FINANCIAL_STATEMENT_ID
244: from AMW_CERTIFICATION_B
245: where CERTIFICATION_ID = X_CERTIFICATION_ID
246: for update of CERTIFICATION_ID nowait;
247: recinfo c%rowtype;
248:

Line 386: update AMW_CERTIFICATION_B set

382: X_CERTIFICATION_PERIOD_SET_NAM in VARCHAR2,
383: X_LAST_REMINDER_DATE in DATE
384: ) is
385: begin
386: update AMW_CERTIFICATION_B set
387: ATTRIBUTE10 = X_ATTRIBUTE10,
388: ATTRIBUTE11 = X_ATTRIBUTE11,
389: ATTRIBUTE12 = X_ATTRIBUTE12,
390: ATTRIBUTE13 = X_ATTRIBUTE13,

Line 454: delete from AMW_CERTIFICATION_B

450: if (sql%notfound) then
451: raise no_data_found;
452: end if;
453:
454: delete from AMW_CERTIFICATION_B
455: where CERTIFICATION_ID = X_CERTIFICATION_ID;
456:
457: if (sql%notfound) then
458: raise no_data_found;

Line 468: from AMW_CERTIFICATION_B B

464: begin
465: delete from AMW_CERTIFICATION_TL T
466: where not exists
467: (select NULL
468: from AMW_CERTIFICATION_B B
469: where B.CERTIFICATION_ID = T.CERTIFICATION_ID
470: );
471:
472: update AMW_CERTIFICATION_TL T set (