APPS.PN_VAR_LINES_PKG dependencies on PN_VAR_LINES_PKG

Line 1: package body PN_VAR_LINES_PKG as

1: package body PN_VAR_LINES_PKG as
2: /* $Header: PNVRLINB.pls 120.2 2006/12/20 07:33:41 rdonthul noship $ */
3: -------------------------------------------------------------------------------
4: -- PROCDURE : INSERT_ROW
5: -- INVOKED FROM : insert_row procedure

Line 53: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.INSERT_ROW (+)');

49: WHERE LINE_ITEM_ID = X_LINE_ITEM_ID;
50:
51: BEGIN
52:
53: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.INSERT_ROW (+)');
54:
55: -------------------------------------------------------
56: -- We need to generate the line number
57: -------------------------------------------------------

Line 155: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.INSERT_ROW (-)');

151: RAISE NO_DATA_FOUND;
152: END IF;
153: CLOSE c;
154:
155: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.INSERT_ROW (-)');
156:
157: END INSERT_ROW;
158:
159: -------------------------------------------------------------------------------

Line 205: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.LOCK_ROW (+)');

201: tlinfo c1%rowtype;
202:
203: BEGIN
204:
205: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.LOCK_ROW (+)');
206:
207: OPEN c1;
208: FETCH c1 INTO tlinfo;
209: IF (c1%notfound) THEN

Line 370: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.LOCK_ROW (-)');

366: null;
367: else
368: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('VAR_RENT_ID',tlinfo.VAR_RENT_ID);
369: end if;
370: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.LOCK_ROW (-)');
371:
372: END LOCK_ROW;
373:
374: -------------------------------------------------------------------------------

Line 415: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.UPDATE_ROW (+)');

411: )
412: IS
413: BEGIN
414:
415: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.UPDATE_ROW (+)');
416:
417: UPDATE PN_VAR_LINES_ALL
418: SET
419: LINE_ITEM_NUM = X_LINE_ITEM_NUM,

Line 453: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.UPDATE_ROW (-)');

449: IF (sql%notfound) THEN
450: RAISE NO_DATA_FOUND;
451: END IF;
452:
453: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.UPDATE_ROW (-)');
454:
455: END UPDATE_ROW;
456:
457: -------------------------------------------------------------------------------

Line 474: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (+)');

470: WHERE line_item_id = x_line_item_id;
471:
472: BEGIN
473:
474: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (+)');
475:
476: /* Delete the transaction records for this line item */
477: FOR rec IN line_info_cur LOOP
478: NULL;

Line 489: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (-)');

485: IF (sql%notfound) THEN
486: RAISE NO_DATA_FOUND;
487: END IF;
488:
489: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (-)');
490:
491: END DELETE_ROW;
492:
493: END PN_VAR_LINES_PKG;

Line 493: END PN_VAR_LINES_PKG;

489: PNP_DEBUG_PKG.debug ('PN_VAR_LINES_PKG.DELETE_ROW (-)');
490:
491: END DELETE_ROW;
492:
493: END PN_VAR_LINES_PKG;