APPS.PN_VAR_CONSTRAINTS_PKG dependencies on PN_VAR_CONSTRAINTS_ALL

Line 53: FROM PN_VAR_CONSTRAINTS_ALL

49: )
50: IS
51: CURSOR C IS
52: SELECT ROWID
53: FROM PN_VAR_CONSTRAINTS_ALL
54: WHERE CONSTRAINT_ID = X_CONSTRAINT_ID;
55:
56: l_return_status VARCHAR2(30) := NULL;
57:

Line 67: FROM PN_VAR_CONSTRAINTS_ALL

63: -- We need to generate the constraints number
64: -------------------------------------------------------
65: SELECT nvl(max(CONSTRAINT_NUM),0)
66: INTO X_CONSTRAINT_NUM
67: FROM PN_VAR_CONSTRAINTS_ALL
68: WHERE PERIOD_ID = X_PERIOD_ID;
69:
70: X_CONSTRAINT_NUM := X_CONSTRAINT_NUM + 1;
71:

Line 97: INSERT INTO PN_VAR_CONSTRAINTS_ALL

93: APP_EXCEPTION.Raise_Exception;
94: END IF;*/
95:
96:
97: INSERT INTO PN_VAR_CONSTRAINTS_ALL
98: (
99: CONSTRAINT_ID,
100: CONSTRAINT_NUM,
101: PERIOD_ID,

Line 224: FROM PN_VAR_CONSTRAINTS_ALL

220: )
221: IS
222: CURSOR c1 IS
223: SELECT *
224: FROM PN_VAR_CONSTRAINTS_ALL
225: WHERE CONSTRAINT_ID = X_CONSTRAINT_ID
226: FOR UPDATE OF CONSTRAINT_ID NOWAIT;
227:
228: tlinfo c1%rowtype;

Line 503: UPDATE PN_VAR_CONSTRAINTS_ALL SET

499: IF (l_return_status IS NOT NULL) THEN
500: APP_EXCEPTION.Raise_Exception;
501: END IF;*/
502:
503: UPDATE PN_VAR_CONSTRAINTS_ALL SET
504: CONSTRAINT_NUM = X_CONSTRAINT_NUM,
505: PERIOD_ID = X_PERIOD_ID,
506: CONSTR_CAT_CODE = X_CONSTR_CAT_CODE,
507: TYPE_CODE = X_TYPE_CODE,

Line 561: DELETE FROM PN_VAR_CONSTRAINTS_ALL

557: BEGIN
558:
559: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (+)');
560:
561: DELETE FROM PN_VAR_CONSTRAINTS_ALL
562: WHERE CONSTRAINT_ID = X_CONSTRAINT_ID;
563:
564: IF (sql%notfound) THEN
565: RAISE NO_DATA_FOUND;

Line 602: FROM pn_var_constraints_all constr

598: FROM dual
599: WHERE not exists
600: (
601: SELECT 1
602: FROM pn_var_constraints_all constr
603: WHERE constr.amount < (x_amount)
604: AND ((x_constraint_id is null) or
605: (constr.constraint_id <> x_constraint_id))
606: AND constr.period_id = x_period_id