APPS.PN_VAR_LINE_DEFAULTS_PKG dependencies on PN_VAR_LINE_DEFAULTS_PKG

Line 1: PACKAGE BODY PN_VAR_LINE_DEFAULTS_PKG AS

1: PACKAGE BODY PN_VAR_LINE_DEFAULTS_PKG AS
2: /* $Header: PNVRLDFB.pls 120.0 2007/10/03 14:29:08 rthumma noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

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

53:
54: begin
55:
56:
57: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW (+)');
58:
59: -------------------------------------------------------
60: -- We need to generate the line number
61: -------------------------------------------------------

Line 157: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW (-)');

153: raise no_data_found;
154: end if;
155: close c;
156:
157: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.INSERT_ROW (-)');
158: exception
159: when others then
160: /*dbms_output.put_line(sqlerrm);*/
161: null;

Line 207: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.LOCK_ROW (+)');

203: for update of LINE_DEFAULT_ID nowait;
204:
205: begin
206:
207: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.LOCK_ROW (+)');
208:
209: for tlinfo in c1 loop
210:
211: if ((tlinfo.SALES_TYPE_CODE = X_SALES_TYPE_CODE)

Line 368: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.LOCK_ROW (-)');

364: end if;
365:
366: END LOOP;
367:
368: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.LOCK_ROW (-)');
369:
370: end LOCK_ROW;
371:
372: -------------------------------------------------------------------------------

Line 413: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW (+)');

409: ) is
410:
411: begin
412:
413: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW (+)');
414:
415: update PN_VAR_LINE_DEFAULTS_ALL set
416: LINE_NUM = X_LINE_NUM,
417: VAR_RENT_ID = X_VAR_RENT_ID,

Line 464: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW (-)');

460: RAISE NO_DATA_FOUND;
461: END IF;
462: */
463:
464: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.UPDATE_ROW (-)');
465:
466: end UPDATE_ROW;
467:
468: -----------------------------------------------------------------------

Line 481: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.DELETE_ROW (+)');

477: WHERE line_default_id = x_line_default_id;
478:
479: BEGIN
480:
481: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.DELETE_ROW (+)');
482:
483: FOR rec IN line_items LOOP
484: pn_var_lines_pkg.delete_row (rec.line_item_id);
485: END LOOP;

Line 494: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.DELETE_ROW (-)');

490: IF (sql%notfound) THEN
491: RAISE NO_DATA_FOUND;
492: END IF;
493:
494: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.DELETE_ROW (-)');
495:
496: END DELETE_ROW;
497:
498: end PN_VAR_LINE_DEFAULTS_PKG;

Line 498: end PN_VAR_LINE_DEFAULTS_PKG;

494: PNP_DEBUG_PKG.debug ('PN_VAR_LINE_DEFAULTS_PKG.DELETE_ROW (-)');
495:
496: END DELETE_ROW;
497:
498: end PN_VAR_LINE_DEFAULTS_PKG;