APPS.PN_VAR_BKPTS_DET_PKG dependencies on PN_VAR_BKPTS_DET_PKG

Line 1: package body PN_VAR_BKPTS_DET_PKG as

1: package body PN_VAR_BKPTS_DET_PKG as
2: /* $Header: PNVRBKDB.pls 120.2 2006/12/20 09:21:26 pseeram noship $ */
3: -------------------------------------------------------------------------------
4: -- PROCDURE : INSERT_ROW
5: -- INVOKED FROM : insert_row procedure

Line 10: -- PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START

6: -- PURPOSE : inserts the row
7: -- HISTORY :
8: -- 21-JUN-05 piagrawa o Bug 4284035 - Replaced PN_VAR_BKPTS_DET with _ALL table.
9: -- 29-SEP-06 pikhar o Bug 5573913 - Commented call to
10: -- PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START
11: -------------------------------------------------------------------------------
12: procedure INSERT_ROW (
13: X_ROWID in out NOCOPY VARCHAR2,
14: X_BKPT_DETAIL_ID in out NOCOPY NUMBER,

Line 63: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (+)');

59: l_return_status VARCHAR2(30) := NULL;
60:
61: BEGIN
62:
63: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (+)');
64:
65: -------------------------------------------------------
66: -- We need to generate the breakpoints details number
67: -------------------------------------------------------

Line 86: PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START

82: END IF;
83:
84: -- Check for breakpoint volume ranges
85: /* l_return_status := NULL;
86: PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START
87: (
88: l_return_status,
89: x_bkpt_header_id,
90: x_bkpt_detail_id,

Line 193: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (-)');

189: FROM pn_var_bkpts_head_all
190: WHERE bkpt_header_id = x_bkpt_header_id);
191: END IF;
192:
193: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.INSERT_ROW (-)');
194:
195: END INSERT_ROW;
196:
197: -------------------------------------------------------------------------------

Line 248: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (+)');

244: tlinfo c1%rowtype;
245:
246: BEGIN
247:
248: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (+)');
249:
250: OPEN c1;
251: FETCH c1 into tlinfo;
252: IF (c1%notfound) then

Line 437: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (-)');

433: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ANNUAL_BASIS_AMOUNT',tlinfo.ANNUAL_BASIS_AMOUNT);
434: end if;
435: --03-NOV-2003 End
436:
437: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.LOCK_ROW (-)');
438:
439: END LOCK_ROW;
440:
441: -------------------------------------------------------------------------------

Line 489: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');

485: l_return_status VARCHAR2(30) := NULL;
486:
487: BEGIN
488:
489: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');
490:
491: -- Check for breakpoint volume ranges
492: l_return_status := NULL;
493: /*PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START

Line 493: /*PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START

489: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');
490:
491: -- Check for breakpoint volume ranges
492: l_return_status := NULL;
493: /*PN_VAR_BKPTS_DET_PKG.CHECK_VOL_START
494: (
495: l_return_status,
496: x_bkpt_header_id,
497: x_bkpt_detail_id,

Line 550: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');

546: WHERE line_item_id IN (SELECT line_item_id
547: FROM pn_var_bkpts_head_all
548: WHERE bkpt_header_id = x_bkpt_header_id);
549:
550: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_DET_PKG.UPDATE_ROW (+)');
551:
552: END UPDATE_ROW;
553:
554: -------------------------------------------------------------------------------

Line 634: END PN_VAR_BKPTS_DET_PKG;

630: --x_rent_num);
631: x_return_status := 'E';
632: END CHECK_VOL_START;
633:
634: END PN_VAR_BKPTS_DET_PKG;