eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VAR_VOL_HIST_PKG dependencies on PN_VAR_VOL_HIST_PKG

Line 1: package body PN_VAR_VOL_HIST_PKG as

1: package body PN_VAR_VOL_HIST_PKG as
2: /* $Header: PNVRHISB.pls 120.2 2006/12/20 07:28:41 rdonthul noship $ */
3:
4: -------------------------------------------------------------------------------
5: -- PROCDURE : INSERT_ROW

Line 69: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.INSERT_ROW (+)');

65: l_return_daily_amount NUMBER := 0;
66:
67: BEGIN
68:
69: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.INSERT_ROW (+)');
70:
71: -------------------------------------------------------
72: -- We need to generate the volume history number
73: -------------------------------------------------------

Line 93: PN_VAR_VOL_HIST_PKG.CALCULATE_DAILY_AMOUNT( l_return_daily_amount,

89:
90: -------------------------------------------------------
91: -- Calculate daily amount for change calendar function
92: ------------------------------------------------------
93: PN_VAR_VOL_HIST_PKG.CALCULATE_DAILY_AMOUNT( l_return_daily_amount,
94: X_ACTUAL_AMOUNT,
95: X_START_DATE,
96: X_END_DATE
97: );

Line 208: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.INSERT_ROW (-)');

204: UPDATE pn_var_lines_all
205: SET sales_vol_update_flag = 'Y'
206: WHERE line_item_id = x_line_item_id;
207:
208: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.INSERT_ROW (-)');
209:
210: END INSERT_ROW;
211:
212: -------------------------------------------------------------------------------

Line 271: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.LOCK_ROW (+)');

267: tlinfo c1%rowtype;
268:
269: BEGIN
270:
271: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.LOCK_ROW (+)');
272:
273: OPEN c1;
274: FETCH c1 INTO tlinfo;
275: IF (c1%notfound) THEN

Line 500: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.LOCK_ROW (-)');

496: else
497: PN_VAR_RENT_PKG.LOCK_ROW_EXCEPTION('ATTRIBUTE15',tlinfo.ATTRIBUTE15);
498: end if;
499:
500: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.LOCK_ROW (-)');
501:
502: END LOCK_ROW;
503:
504: -------------------------------------------------------------------------------

Line 561: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.UPDATE_ROW (+)');

557: l_return_daily_amount NUMBER := 0;
558:
559: BEGIN
560:
561: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.UPDATE_ROW (+)');
562:
563: -------------------------------------------------------
564: -- Calculate daily amount for change calendar function
565: ------------------------------------------------------

Line 566: PN_VAR_VOL_HIST_PKG.CALCULATE_DAILY_AMOUNT( l_return_daily_amount,

562:
563: -------------------------------------------------------
564: -- Calculate daily amount for change calendar function
565: ------------------------------------------------------
566: PN_VAR_VOL_HIST_PKG.CALCULATE_DAILY_AMOUNT( l_return_daily_amount,
567: X_ACTUAL_AMOUNT,
568: X_START_DATE,
569: X_END_DATE
570: );

Line 626: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.UPDATE_ROW (-)');

622: UPDATE pn_var_lines_all
623: SET sales_vol_update_flag = 'Y'
624: WHERE line_item_id = x_line_item_id;
625:
626: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.UPDATE_ROW (-)');
627:
628: END UPDATE_ROW;
629:
630: -------------------------------------------------------------------------------

Line 649: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.DELETE_ROW (+)');

645: WHERE vol_hist_id = x_vol_hist_id;
646:
647: BEGIN
648:
649: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.DELETE_ROW (+)');
650:
651: /* Update the sales_vol_update_flag to 'Y' for line for which volume history
652: is deleted */
653: FOR rec IN line_item_cur LOOP

Line 670: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.DELETE_ROW (-)');

666: IF (sql%notfound) THEN
667: RAISE NO_DATA_FOUND;
668: END IF;
669:
670: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.DELETE_ROW (-)');
671:
672: END DELETE_ROW;
673:
674: -----------------------------------------------------------------------

Line 760: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.MODIFY_ROW (+)');

756:
757:
758: BEGIN
759:
760: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.MODIFY_ROW (+)');
761:
762: FOR rec IN vol_his_cur LOOP
763: -------------------------------------------------------
764: -- Calculate daily amount for change calendar function

Line 766: PN_VAR_VOL_HIST_PKG.CALCULATE_DAILY_AMOUNT( l_return_daily_amount,

762: FOR rec IN vol_his_cur LOOP
763: -------------------------------------------------------
764: -- Calculate daily amount for change calendar function
765: ------------------------------------------------------
766: PN_VAR_VOL_HIST_PKG.CALCULATE_DAILY_AMOUNT( l_return_daily_amount,
767: NVL(x_actual_amount, rec.actual_amount),
768: NVL(x_start_date, rec.start_date),
769: NVL(x_end_date, rec.end_date)
770: );

Line 828: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.MODIFY_ROW (-)');

824: WHERE line_item_id = x_line_item_id;
825:
826: END LOOP;
827:
828: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.MODIFY_ROW (-)');
829:
830: END MODIFY_ROW;
831:
832: END PN_VAR_VOL_HIST_PKG;

Line 832: END PN_VAR_VOL_HIST_PKG;

828: PNP_DEBUG_PKG.debug ('PN_VAR_VOL_HIST_PKG.MODIFY_ROW (-)');
829:
830: END MODIFY_ROW;
831:
832: END PN_VAR_VOL_HIST_PKG;