APPS.PN_VAR_BKHD_DEFAULTS_PKG dependencies on PN_VAR_BKHD_DEFAULTS_PKG

Line 1: PACKAGE BODY PN_VAR_BKHD_DEFAULTS_PKG AS

1: PACKAGE BODY PN_VAR_BKHD_DEFAULTS_PKG AS
2: /* $Header: PNVRBHDB.pls 120.1 2010/08/23 04:45:05 pcheruvu ship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

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

56:
57: BEGIN
58:
59:
60: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.INSERT_ROW (+)');
61: -------------------------------------------------------
62: -- We need t generate the line number
63: -------------------------------------------------------
64: SELECT nvl(max(bkhd.bkhd_detail_num),0)

Line 170: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.INSERT_ROW (-)');

166: RAISE NO_DATA_FOUND;
167: END IF;
168: CLOSE c;
169:
170: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.INSERT_ROW (-)');
171:
172: END INSERT_ROW;
173:
174: -------------------------------------------------------------------------------

Line 224: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.LOCK_ROW (+)');

220: tlinfo c1%rowtype;
221:
222: begin
223:
224: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.LOCK_ROW (+)');
225:
226: open c1;
227: fetch c1 into tlinfo;
228: if (c1%notfound) then

Line 428: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.LOCK_ROW (-)');

424: else
425: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15', to_char(tlinfo.ATTRIBUTE15));
426: end if;
427:
428: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.LOCK_ROW (-)');
429:
430: end LOCK_ROW;
431:
432: -------------------------------------------------------------------------------

Line 478: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.UPDATE_ROW (+)');

474: ) IS
475:
476: BEGIN
477:
478: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.UPDATE_ROW (+)');
479:
480: UPDATE PN_VAR_BKHD_DEFAULTS_ALL SET
481: LINE_DEFAULT_ID = X_LINE_DEFAULT_ID,
482: BKHD_DETAIL_NUM = X_BKHD_DETAIL_NUM,

Line 522: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.UPDATE_ROW (-)');

518: IF (sql%notfound) THEN
519: RAISE NO_DATA_FOUND;
520: END IF;
521:
522: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.UPDATE_ROW (-)');
523:
524: END UPDATE_ROW;
525:
526: -----------------------------------------------------------------------

Line 534: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.DELETE_ROW (+)'||X_BKHD_DEFAULT_ID);

530: IS
531:
532: BEGIN
533:
534: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.DELETE_ROW (+)'||X_BKHD_DEFAULT_ID);
535:
536: DELETE FROM PN_VAR_BKHD_DEFAULTS_ALL
537: WHERE BKHD_DEFAULT_ID = X_BKHD_DEFAULT_ID;
538:

Line 543: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.DELETE_ROW (-)');

539: IF (SQL%NOTFOUND) THEN
540: RAISE NO_DATA_FOUND;
541: END IF;
542:
543: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.DELETE_ROW (-)');
544:
545: END DELETE_ROW;
546:
547: -------------------------------------------------------------------------------

Line 599: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.MODIFY_ROW (+)');

595: WHERE bkhd_default_id = x_bkhd_default_id;
596:
597: BEGIN
598:
599: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.MODIFY_ROW (+)');
600:
601: FOR rec IN bkhd_defaults_cur LOOP
602: UPDATE pn_var_bkhd_defaults_all SET
603: line_default_id = NVL( x_line_default_id, rec.line_default_id),

Line 647: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.MODIFY_ROW (-)');

643: END LOOP;
644:
645:
646:
647: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.MODIFY_ROW (-)');
648:
649: END MODIFY_ROW;
650:
651: end PN_VAR_BKHD_DEFAULTS_PKG;

Line 651: end PN_VAR_BKHD_DEFAULTS_PKG;

647: PNP_DEBUG_PKG.debug ('PN_VAR_BKHD_DEFAULTS_PKG.MODIFY_ROW (-)');
648:
649: END MODIFY_ROW;
650:
651: end PN_VAR_BKHD_DEFAULTS_PKG;