APPS.PN_TERM_TEMPLATES_PKG dependencies on PN_TERM_TEMPLATES_PKG

Line 1: PACKAGE BODY pn_term_templates_pkg AS

1: PACKAGE BODY pn_term_templates_pkg AS
2: -- $Header: PNTTRMTB.pls 120.4 2005/12/01 08:35:18 appldev ship $
3:
4:
5: /*============================================================================+

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 117: pn_term_templates_pkg.check_unq_term_template (

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
119: ,x_term_template_id
120: ,x_name
121: ,x_org_id

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 347: pn_term_templates_pkg.check_unq_term_template (

343: INTO l_org_id
344: FROM pn_term_templates_all
345: WHERE term_template_id = x_term_template_id;
346:
347: pn_term_templates_pkg.check_unq_term_template (
348: l_return_status
349: ,x_term_template_id
350: ,x_name
351: ,l_org_id

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: -------------------------------------------------------------------------------

Line 896: END pn_term_templates_pkg;

892: -- fnd_message.set_token ('NAME', x_name);
893: x_return_status := 'E';
894: END check_unq_term_template;
895:
896: END pn_term_templates_pkg;