DBA Data[Home] [Help]

APPS.PN_TERM_TEMPLATES_PKG dependencies on PNP_DEBUG_PKG

Line 114: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.insert_row (+)');

110: l_return_status VARCHAR2 (30) := NULL;
111: l_rowid VARCHAR2 (18) := NULL;
112: BEGIN
113:
114: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.insert_row (+)');
115: -- If no TERM_TEMPLATE_ID is provided, get one from sequence
116:
117: pn_term_templates_pkg.check_unq_term_template (
118: l_return_status

Line 265: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.insert_row (-)');

261: END IF;
262:
263: CLOSE c;
264:
265: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.insert_row (-)');
266: END insert_row;
267:
268:
269: -------------------------------------------------------------------------------

Line 340: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.update_row (+)');

336: l_return_status VARCHAR2 (30) := NULL;
337: l_org_id NUMBER;
338: BEGIN
339:
340: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.update_row (+)');
341:
342: SELECT org_id
343: INTO l_org_id
344: FROM pn_term_templates_all

Line 419: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.update_row (-)');

415: IF (SQL%NOTFOUND) THEN
416: RAISE NO_DATA_FOUND;
417: END IF;
418:
419: --PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.update_row (-)');
420: END update_row;
421:
422:
423: -------------------------------------------------------------------------------

Line 495: PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.lock_row (+)');

491: tlinfo c1%ROWTYPE;
492:
493: BEGIN
494:
495: PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.lock_row (+)');
496:
497: OPEN c1;
498: FETCH c1 INTO tlinfo;
499:

Line 810: PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.lock_row (-)');

806: THEN
807: pn_var_rent_pkg.lock_row_exception('ATTRIBUTE15',tlinfo.attribute15);
808: END IF;
809:
810: PNP_DEBUG_PKG.debug (' PN_TERM_TEMPLATES_PKG.lock_row (-)');
811:
812: END lock_row;
813:
814: -------------------------------------------------------------------------------