APPS.PN_VAR_TEMPLATE_PKG dependencies on PN_VAR_TEMPLATE_PKG

Line 1: package body PN_VAR_TEMPLATE_PKG as

1: package body PN_VAR_TEMPLATE_PKG as
2: /* $Header: PNVRTEMB.pls 120.3 2006/09/14 04:10:05 pikhar noship $*/
3:
4: -----------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 67: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (+)');

63: l_return_status VARCHAR2(30) := NULL;
64:
65: BEGIN
66:
67: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (+)');
68:
69: IF ( X_AGREEMENT_TEMPLATE_ID IS NULL) THEN
70: Select PN_VAR_TEMPLATES_S.nextval
71: into X_AGREEMENT_TEMPLATE_ID

Line 180: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (-)');

176: raise no_data_found;
177: end if;
178: close c;
179:
180: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.INSERT_ROW (-)');
181:
182: end INSERT_ROW;
183:
184:

Line 241: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (+)');

237:
238: tlinfo c1%rowtype;
239:
240: BEGIN
241: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (+)');
242:
243: open c1;
244: fetch c1 into tlinfo;
245: if (c1%notfound) then

Line 538: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (-)');

534: else
535: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15', to_char(tlinfo.ATTRIBUTE15));
536: end if;
537:
538: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.LOCK_ROW (-)');
539:
540: end LOCK_ROW;
541:
542:

Line 598: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');

594: l_return_status VARCHAR2(30) := NULL;
595:
596: BEGIN
597:
598: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');
599:
600: update PN_VAR_TEMPLATES_ALL set
601: AGREEMENT_TEMPLATE = X_AGREEMENT_TEMPLATE,
602: PURPOSE_CODE = X_PURPOSE_CODE,

Line 649: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');

645: if (sql%notfound) then
646: raise no_data_found;
647: end if;
648:
649: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.UPDATE_ROW (+)');
650:
651: end UPDATE_ROW;
652:
653: -----------------------------------------------------------------------

Line 663: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (+)');

659: ) is
660:
661: BEGIN
662:
663: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (+)');
664:
665: delete from PN_VAR_TEMPLATES_ALL
666: where AGREEMENT_TEMPLATE_ID = X_AGREEMENT_TEMPLATE_ID;
667:

Line 672: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (-)');

668: if (sql%notfound) then
669: raise no_data_found;
670: end if;
671:
672: PNP_DEBUG_PKG.debug ('PN_VAR_TEMPLATE_PKG.DELETE_ROW (-)');
673:
674: END DELETE_ROW;
675:
676: PROCEDURE check_unq_vr_template (

Line 700: end PN_VAR_TEMPLATE_PKG;

696: fnd_message.set_name ('PN', 'PN_DUP_TERM_TEMPLATE');
697: x_return_status := 'E';
698: END check_unq_vr_template;
699:
700: end PN_VAR_TEMPLATE_PKG;