APPS.PN_VAR_CONSTRAINTS_PKG dependencies on PN_VAR_CONSTRAINTS_PKG

Line 1: package body PN_VAR_CONSTRAINTS_PKG as

1: package body PN_VAR_CONSTRAINTS_PKG as
2: /* $Header: PNVRCONB.pls 120.3 2007/03/14 12:23:33 pikhar noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 60: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (+)');

56: l_return_status VARCHAR2(30) := NULL;
57:
58: BEGIN
59:
60: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (+)');
61:
62: -------------------------------------------------------
63: -- We need to generate the constraints number
64: -------------------------------------------------------

Line 83: PN_VAR_CONSTRAINTS_PKG.CHECK_MAX_CONSTR

79: END IF;
80:
81: -- Check for constraint range
82: /*l_return_status := NULL;
83: PN_VAR_CONSTRAINTS_PKG.CHECK_MAX_CONSTR
84: (
85: l_return_status,
86: x_period_id,
87: x_constraint_id,

Line 179: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (-)');

175: RAISE NO_DATA_FOUND;
176: END IF;
177: CLOSE c;
178:
179: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.INSERT_ROW (-)');
180:
181: END INSERT_ROW;
182:
183: -------------------------------------------------------------------------------

Line 231: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (+)');

227:
228: tlinfo c1%rowtype;
229:
230: BEGIN
231: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (+)');
232:
233: OPEN c1;
234: FETCH c1 INTO tlinfo;
235: IF (c1%notfound) THEN

Line 433: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (-)');

429: else
430: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('CONSTR_END_DATE',tlinfo.CONSTR_END_DATE);
431: end if;
432:
433: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.LOCK_ROW (-)');
434:
435: END LOCK_ROW;
436:
437:

Line 485: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');

481: l_return_status VARCHAR2(30) := NULL;
482:
483: BEGIN
484:
485: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');
486:
487: -- Check for constraint range
488: l_return_status := NULL;
489:

Line 490: /*PN_VAR_CONSTRAINTS_PKG.CHECK_MAX_CONSTR

486:
487: -- Check for constraint range
488: l_return_status := NULL;
489:
490: /*PN_VAR_CONSTRAINTS_PKG.CHECK_MAX_CONSTR
491: (
492: l_return_status,
493: x_period_id,
494: x_constraint_id,

Line 540: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');

536: IF (sql%notfound) THEN
537: RAISE NO_DATA_FOUND;
538: END IF;
539:
540: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.UPDATE_ROW (+)');
541:
542: END UPDATE_ROW;
543:
544:

Line 559: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (+)');

555: )
556: IS
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:

Line 568: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (-)');

564: IF (sql%notfound) THEN
565: RAISE NO_DATA_FOUND;
566: END IF;
567:
568: PNP_DEBUG_PKG.debug ('PN_VAR_CONSTRAINTS_PKG.DELETE_ROW (-)');
569:
570: END DELETE_ROW;
571:
572: -------------------------------------------------------------------------------

Line 623: END PN_VAR_CONSTRAINTS_PKG;

619: --x_rent_num);
620: x_return_status := 'E';
621: END CHECK_MAX_CONSTR;
622:
623: END PN_VAR_CONSTRAINTS_PKG;