APPS.AMW_RISKS_PKG dependencies on AMW_RISKS_B

Line 46: cursor C is select ROWID from AMW_RISKS_B

42: X_LAST_UPDATED_BY in NUMBER,
43: X_LAST_UPDATE_LOGIN in NUMBER,
44: X_CLASSIFICATION in NUMBER
45: ) is
46: cursor C is select ROWID from AMW_RISKS_B
47: where RISK_REV_ID = X_RISK_REV_ID
48: ;
49: begin
50: insert into AMW_RISKS_B (

Line 50: insert into AMW_RISKS_B (

46: cursor C is select ROWID from AMW_RISKS_B
47: where RISK_REV_ID = X_RISK_REV_ID
48: ;
49: begin
50: insert into AMW_RISKS_B (
51: RISK_REV_NUM,
52: RISK_REV_ID,
53: REQUESTOR_ID,
54: ORIG_SYSTEM_REFERENCE,

Line 246: from AMW_RISKS_B

242: ATTRIBUTE6,
243: APPROVAL_STATUS,
244: OBJECT_VERSION_NUMBER,
245: CLASSIFICATION
246: from AMW_RISKS_B
247: where RISK_REV_ID = X_RISK_REV_ID
248: for update of RISK_REV_ID nowait;
249: recinfo c%rowtype;
250:

Line 390: update AMW_RISKS_B set

386: X_LAST_UPDATE_LOGIN in NUMBER,
387: X_CLASSIFICATION in NUMBER
388: ) is
389: begin
390: update AMW_RISKS_B set
391: RISK_REV_NUM = X_RISK_REV_NUM,
392: REQUESTOR_ID = X_REQUESTOR_ID,
393: ORIG_SYSTEM_REFERENCE = X_ORIG_SYSTEM_REFERENCE,
394: LATEST_REVISION_FLAG = X_LATEST_REVISION_FLAG,

Line 459: delete from AMW_RISKS_B

455: if (sql%notfound) then
456: raise no_data_found;
457: end if;
458:
459: delete from AMW_RISKS_B
460: where RISK_REV_ID = X_RISK_REV_ID;
461:
462: if (sql%notfound) then
463: raise no_data_found;

Line 473: from AMW_RISKS_B B

469: begin
470: delete from AMW_RISKS_TL T
471: where not exists
472: (select NULL
473: from AMW_RISKS_B B
474: where B.RISK_REV_ID = T.RISK_REV_ID
475: );
476:
477: update AMW_RISKS_TL T set (