APPS.AMW_CONSTRAINTS_PKG dependencies on AMW_CONSTRAINTS_B

Line 22: -- in AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL

18: -- Procedure name
19: -- INSERT_ROW
20: -- Purpose
21: -- create new constraint
22: -- in AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
23: -- ===============================================================
24: procedure INSERT_ROW (
25: X_ROWID in out nocopy VARCHAR2,
26: X_CONSTRAINT_ID in NUMBER,

Line 63: cursor C is select ROWID from AMW_CONSTRAINTS_B

59: X_CLASSIFICATION in VARCHAR2,
60: X_OBJECTIVE_CODE in VARCHAR2,
61: X_CONTROL_ID in NUMBER
62: ) is
63: cursor C is select ROWID from AMW_CONSTRAINTS_B
64: where CONSTRAINT_REV_ID = X_CONSTRAINT_REV_ID
65: ;
66: begin
67: insert into AMW_CONSTRAINTS_B (

Line 67: insert into AMW_CONSTRAINTS_B (

63: cursor C is select ROWID from AMW_CONSTRAINTS_B
64: where CONSTRAINT_REV_ID = X_CONSTRAINT_REV_ID
65: ;
66: begin
67: insert into AMW_CONSTRAINTS_B (
68: CONSTRAINT_ID,
69: CONSTRAINT_REV_ID,
70: START_DATE,
71: END_DATE,

Line 251: from AMW_CONSTRAINTS_B

247: APPROVAL_STATUS,
248: CLASSIFICATION,
249: OBJECTIVE_CODE,
250: CONTROL_ID
251: from AMW_CONSTRAINTS_B
252: where CONSTRAINT_REV_ID = X_CONSTRAINT_REV_ID
253: for update of CONSTRAINT_REV_ID nowait;
254: recinfo c%rowtype;
255:

Line 357: -- update AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL

353: -- ===============================================================
354: -- Procedure name
355: -- UPDATE_ROW
356: -- Purpose
357: -- update AMW_CONSTRAINTS_B and AMW_CONSTRAINTS_TL
358: -- ===============================================================
359: procedure UPDATE_ROW (
360: X_CONSTRAINT_ID in NUMBER,
361: X_CONSTRAINT_REV_ID in NUMBER,

Line 396: update AMW_CONSTRAINTS_B set

392: X_OBJECTIVE_CODE in VARCHAR2,
393: X_CONTROL_ID in NUMBER
394: ) is
395: begin
396: update AMW_CONSTRAINTS_B set
397: START_DATE = X_START_DATE,
398: END_DATE = X_END_DATE,
399: ENTERED_BY_ID = X_ENTERED_BY_ID,
400: TYPE_CODE = X_TYPE_CODE,

Line 467: delete from AMW_CONSTRAINTS_B

463: if (sql%notfound) then
464: raise no_data_found;
465: end if;
466:
467: delete from AMW_CONSTRAINTS_B
468: where CONSTRAINT_ID = X_CONSTRAINT_ID;
469:
470: if (sql%notfound) then
471: raise no_data_found;

Line 489: from AMW_CONSTRAINTS_B B

485: begin
486: delete from AMW_CONSTRAINTS_TL T
487: where not exists
488: (select NULL
489: from AMW_CONSTRAINTS_B B
490: where B.CONSTRAINT_ID = T.CONSTRAINT_ID
491: );
492:
493: update AMW_CONSTRAINTS_TL T set (