APPS.PN_VAR_BKPTS_HEAD_PKG dependencies on PN_VAR_BKPTS_HEAD_PKG

Line 1: package body PN_VAR_BKPTS_HEAD_PKG as

1: package body PN_VAR_BKPTS_HEAD_PKG as
2: /* $Header: PNVRBKPB.pls 120.2 2006/12/20 09:24:10 pseeram noship $ */
3: -------------------------------------------------------------------------------
4: -- PROCDURE : INSERT_ROW
5: -- INVOKED FROM : insert_row procedure

Line 55: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.INSERT_ROW (+)');

51: WHERE BKPT_HEADER_ID = X_BKPT_HEADER_ID;
52:
53: BEGIN
54:
55: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.INSERT_ROW (+)');
56:
57: -------------------------------------------------------
58: -- Select the nextval for breakpoint header id
59: -------------------------------------------------------

Line 156: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.INSERT_ROW (-)');

152: SET bkpt_update_flag = 'Y'
153: WHERE line_item_id = x_line_item_id;
154: END IF;
155:
156: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.INSERT_ROW (-)');
157:
158: END INSERT_ROW;
159:
160: -------------------------------------------------------------------------------

Line 209: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.LOCK_ROW (+)');

205: tlinfo c1%rowtype;
206:
207: BEGIN
208:
209: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.LOCK_ROW (+)');
210:
211: OPEN c1;
212: FETCH c1 INTO tlinfo;
213: IF (c1%notfound) THEN

Line 373: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.LOCK_ROW (-)');

369: else
370: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
371: end if;
372:
373: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.LOCK_ROW (-)');
374:
375: END LOCK_ROW;
376:
377: -------------------------------------------------------------------------------

Line 420: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.UPDATE_ROW (+)');

416: )
417: IS
418: BEGIN
419:
420: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.UPDATE_ROW (+)');
421:
422: UPDATE PN_VAR_BKPTS_HEAD_ALL SET
423: LINE_ITEM_ID = X_LINE_ITEM_ID,
424: PERIOD_ID = X_PERIOD_ID,

Line 463: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.UPDATE_ROW (-)');

459: UPDATE pn_var_lines_all
460: SET bkpt_update_flag = 'Y'
461: WHERE line_item_id = x_line_item_id;
462:
463: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.UPDATE_ROW (-)');
464:
465: END UPDATE_ROW;
466:
467: -------------------------------------------------------------------------------

Line 490: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.DELETE_ROW (+)');

486: WHERE bkpt_header_id = x_bkpt_header_id;
487:
488: BEGIN
489:
490: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.DELETE_ROW (+)');
491:
492: -- first we need to delete the note detail rows.
493: FOR i IN C LOOP
494: PN_VAR_BKPTS_DET_PKG.DELETE_ROW ( X_BKPT_DETAIL_ID =>i.bkpt_detail_id );

Line 510: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.DELETE_ROW (-)');

506: IF (SQL%NOTFOUND) THEN
507: RAISE NO_DATA_FOUND;
508: END IF;
509:
510: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.DELETE_ROW (-)');
511:
512: END DELETE_ROW;
513:
514: END PN_VAR_BKPTS_HEAD_PKG;

Line 514: END PN_VAR_BKPTS_HEAD_PKG;

510: PNP_DEBUG_PKG.debug ('PN_VAR_BKPTS_HEAD_PKG.DELETE_ROW (-)');
511:
512: END DELETE_ROW;
513:
514: END PN_VAR_BKPTS_HEAD_PKG;