APPS.PN_VAR_BKDT_DEFAULTS_PKG dependencies on PN_VAR_BKDT_DEFAULTS_PKG

Line 1: PACKAGE BODY PN_VAR_BKDT_DEFAULTS_PKG AS

1: PACKAGE BODY PN_VAR_BKDT_DEFAULTS_PKG AS
2: /* $Header: PNVRBDDB.pls 120.1 2011/11/22 11:45:35 ppenumar ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 57: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (+)');

53: WHERE BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID;
54:
55: BEGIN
56:
57: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (+)');
58:
59: -------------------------------------------------------
60: -- We need to generate the line number
61: -------------------------------------------------------

Line 167: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (-)');

163: UPDATE pn_var_bkhd_defaults_all
164: SET bkpt_update_flag = 'Y'
165: WHERE bkhd_default_id = x_bkhd_default_id;
166:
167: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.INSERT_ROW (-)');
168:
169: EXCEPTION
170:
171: WHEN OTHERS THEN

Line 221: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (+)');

217: where BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID
218: for update of BKDT_DEFAULT_ID nowait;
219: begin
220:
221: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (+)');
222:
223: for tlinfo in c1 loop
224: /*
225: if ( (tlinfo.BKDT_DEFAULT_ID = X_BKDT_DEFAULT_ID)

Line 328: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (-)');

324:
325: end loop;
326: return;
327:
328: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.LOCK_ROW (-)');
329:
330: end LOCK_ROW;
331:
332: -------------------------------------------------------------------------------

Line 376: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (+)');

372: ) IS
373:
374: BEGIN
375:
376: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (+)');
377:
378: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
379: BKDT_DETAIL_NUM = X_BKDT_DETAIL_NUM,
380: BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID,

Line 421: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (-)');

417: UPDATE pn_var_bkhd_defaults_all
418: SET bkpt_update_flag = 'Y'
419: WHERE bkhd_default_id = x_bkhd_default_id;
420:
421: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.UPDATE_ROW (-)');
422:
423: END UPDATE_ROW;
424:
425: -----------------------------------------------------------------------

Line 436: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');

432: FROM pn_var_bkdt_defaults_all
433: WHERE bkdt_default_id = x_bkdt_default_id;
434: BEGIN
435:
436: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (+)');
437:
438: FOR rec IN bkhd_default LOOP
439: UPDATE pn_var_bkhd_defaults_all
440: SET bkpt_update_flag = 'Y'

Line 451: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (-)');

447: IF (SQL%NOTFOUND) THEN
448: RAISE NO_DATA_FOUND;
449: END IF;
450:
451: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.DELETE_ROW (-)');
452: END DELETE_ROW;
453:
454:
455: -------------------------------------------------------------------------------

Line 505: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (+)');

501: WHERE bkdt_default_id = x_bkdt_default_id;
502:
503: BEGIN
504:
505: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (+)');
506:
507: FOR rec IN bkdt_defaults_cur LOOP
508: UPDATE PN_VAR_BKDT_DEFAULTS_ALL SET
509: BKDT_DETAIL_NUM = NVL( x_bkdt_detail_num, rec.bkdt_detail_num),

Line 553: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (-)');

549: WHERE bkhd_default_id = x_bkhd_default_id;
550:
551: END LOOP;
552:
553: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (-)');
554:
555: END MODIFY_ROW;
556:
557: end PN_VAR_BKDT_DEFAULTS_PKG;

Line 557: end PN_VAR_BKDT_DEFAULTS_PKG;

553: PNP_DEBUG_PKG.debug ('PN_VAR_BKDT_DEFAULTS_PKG.MODIFY_ROW (-)');
554:
555: END MODIFY_ROW;
556:
557: end PN_VAR_BKDT_DEFAULTS_PKG;