APPS.AMW_CONTROLS_PKG dependencies on AMW_CONTROLS_B

Line 61: cursor C is select ROWID from AMW_CONTROLS_B

57: x_control_frequency in number := NULL,
58: ---NPANANDI 12.10.2004: ADDED BELOW FOR CTRL CLASSIFICATION
59: x_classification IN NUMBER DEFAULT NULL
60: ) is
61: cursor C is select ROWID from AMW_CONTROLS_B
62: where CONTROL_REV_ID = X_CONTROL_REV_ID
63: ;
64: begin
65: insert into AMW_CONTROLS_B (

Line 65: insert into AMW_CONTROLS_B (

61: cursor C is select ROWID from AMW_CONTROLS_B
62: where CONTROL_REV_ID = X_CONTROL_REV_ID
63: ;
64: begin
65: insert into AMW_CONTROLS_B (
66: OBJECT_VERSION_NUMBER,
67: CONTROL_REV_ID,
68: ORIG_SYSTEM_REFERENCE,
69: LATEST_REVISION_FLAG,

Line 316: from AMW_CONTROLS_B

312: UOM_CODE,
313: CONTROL_FREQUENCY,
314: ---npanandi 12.10.2004: added below for Ctrl Classification
315: classification
316: from AMW_CONTROLS_B
317: where CONTROL_REV_ID = X_CONTROL_REV_ID
318: for update of CONTROL_REV_ID nowait;
319: recinfo c%rowtype;
320:

Line 511: update AMW_CONTROLS_B set

507: ---npanandi 12.10.2004: added below AND clause for Ctrl Classification
508: X_classification IN NUMBER default null
509: ) is
510: begin
511: update AMW_CONTROLS_B set
512: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
513: ORIG_SYSTEM_REFERENCE = X_ORIG_SYSTEM_REFERENCE,
514: LATEST_REVISION_FLAG = X_LATEST_REVISION_FLAG,
515: REQUESTOR_ID = X_REQUESTOR_ID,

Line 594: delete from AMW_CONTROLS_B

590: if (sql%notfound) then
591: raise no_data_found;
592: end if;
593:
594: delete from AMW_CONTROLS_B
595: where CONTROL_REV_ID = X_CONTROL_REV_ID;
596:
597: if (sql%notfound) then
598: raise no_data_found;

Line 608: from AMW_CONTROLS_B B

604: begin
605: delete from AMW_CONTROLS_TL T
606: where not exists
607: (select NULL
608: from AMW_CONTROLS_B B
609: where B.CONTROL_REV_ID = T.CONTROL_REV_ID
610: );
611:
612: update AMW_CONTROLS_TL T set (