APPS.AMW_AUDIT_PROCEDURES_PKG dependencies on AMW_AUDIT_PROCEDURES_B

Line 43: cursor C is select ROWID from AMW_AUDIT_PROCEDURES_B

39: X_LAST_UPDATED_BY in NUMBER,
40: X_LAST_UPDATE_LOGIN in NUMBER,
41: X_CLASSIFICATION in NUMBER
42: ) is
43: cursor C is select ROWID from AMW_AUDIT_PROCEDURES_B
44: where AUDIT_PROCEDURE_REV_ID = X_AUDIT_PROCEDURE_REV_ID
45: ;
46: begin
47: insert into AMW_AUDIT_PROCEDURES_B (

Line 47: insert into AMW_AUDIT_PROCEDURES_B (

43: cursor C is select ROWID from AMW_AUDIT_PROCEDURES_B
44: where AUDIT_PROCEDURE_REV_ID = X_AUDIT_PROCEDURE_REV_ID
45: ;
46: begin
47: insert into AMW_AUDIT_PROCEDURES_B (
48: PROJECT_ID,
49: ATTRIBUTE10,
50: ATTRIBUTE11,
51: ATTRIBUTE12,

Line 227: from AMW_AUDIT_PROCEDURES_B

223: ATTRIBUTE2,
224: ATTRIBUTE3,
225: ATTRIBUTE4,
226: CLASSIFICATION
227: from AMW_AUDIT_PROCEDURES_B
228: where AUDIT_PROCEDURE_REV_ID = X_AUDIT_PROCEDURE_REV_ID
229: for update of AUDIT_PROCEDURE_REV_ID nowait;
230: recinfo c%rowtype;
231:

Line 364: update AMW_AUDIT_PROCEDURES_B set

360: X_LAST_UPDATE_LOGIN in NUMBER,
361: X_CLASSIFICATION IN NUMBER
362: ) is
363: begin
364: update AMW_AUDIT_PROCEDURES_B set
365: PROJECT_ID = X_PROJECT_ID,
366: ATTRIBUTE10 = X_ATTRIBUTE10,
367: ATTRIBUTE11 = X_ATTRIBUTE11,
368: ATTRIBUTE12 = X_ATTRIBUTE12,

Line 429: delete from AMW_AUDIT_PROCEDURES_B

425: if (sql%notfound) then
426: raise no_data_found;
427: end if;
428:
429: delete from AMW_AUDIT_PROCEDURES_B
430: where AUDIT_PROCEDURE_REV_ID = X_AUDIT_PROCEDURE_REV_ID;
431:
432: if (sql%notfound) then
433: raise no_data_found;

Line 443: from AMW_AUDIT_PROCEDURES_B B

439: begin
440: delete from AMW_AUDIT_PROCEDURES_TL T
441: where not exists
442: (select NULL
443: from AMW_AUDIT_PROCEDURES_B B
444: where B.AUDIT_PROCEDURE_REV_ID = T.AUDIT_PROCEDURE_REV_ID
445: );
446:
447: update AMW_AUDIT_PROCEDURES_TL T set (