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_SOI_VOL_IMPORT dependencies on PN_VAR_VOL_HIST_ALL

Line 13: -- reporttype and insert into pn_var_vol_hist_all

9: -- 14-JUL-05 Hrodda o Bug 4284035 - Replaced pn_var_rents,pn_leases with _ALL
10: -- 25-NOV-05 pikhar o in cursor c_var_rent replaced var_rent_id with
11: -- rents.var_rent_id in where clause
12: -- 22-MAR-06 Hareesha o Bug 4731212 Modified import_vol_hist to get
13: -- reporttype and insert into pn_var_vol_hist_all
14: -- 15-JAN-07 Prabhakar o Modified the import_vol_hist procedure to update the
15: -- records in the pn_var_vol_hist_all and pn_var_deductions_all.
16: -- Before updating, the old records will be inserted into
17: -- pn_var_vol_arch_all and pn_var_deduct_arch_all.

Line 15: -- records in the pn_var_vol_hist_all and pn_var_deductions_all.

11: -- rents.var_rent_id in where clause
12: -- 22-MAR-06 Hareesha o Bug 4731212 Modified import_vol_hist to get
13: -- reporttype and insert into pn_var_vol_hist_all
14: -- 15-JAN-07 Prabhakar o Modified the import_vol_hist procedure to update the
15: -- records in the pn_var_vol_hist_all and pn_var_deductions_all.
16: -- Before updating, the old records will be inserted into
17: -- pn_var_vol_arch_all and pn_var_deduct_arch_all.
18: -- 12-mar-07 Shabda o After we have updated volume history. We set the
19: -- pn_var_lines_all.sales-Vol_update_flag to Y for

Line 119: pn_var_vol_hist_all

115: forecasted_amount ,
116: actual_exp_code,
117: forecasted_exp_code
118: FROM
119: pn_var_vol_hist_all
120: WHERE
121: LINE_ITEM_ID = p_line_item_id
122: AND PERIOD_ID = p_period_id
123: AND GRP_DATE_ID = p_group_DATE_id

Line 138: FROM pn_var_vol_hist_all

134: VOL_HIST_STATUS_CODE,
135: FORECASTED_AMOUNT,
136: REPORT_TYPE_CODE,
137: REPORTING_DATE
138: FROM pn_var_vol_hist_all
139: WHERE vol_hist_id = p_vol_hist_id;
140:
141: CURSOR c_ded_hist_data(p_deduction_id NUMBER) IS
142: SELECT LINE_ITEM_ID,

Line 361: FROM pn_var_vol_hist_all

357:
358:
359: IF c_vol_line_exist%NOTFOUND THEN
360: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
361: FROM pn_var_vol_hist_all
362: WHERE line_item_id = v_lines.line_item_id;
363:
364: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
365: ,VOL_HIST_NUM

Line 364: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID

360: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
361: FROM pn_var_vol_hist_all
362: WHERE line_item_id = v_lines.line_item_id;
363:
364: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
365: ,VOL_HIST_NUM
366: ,LAST_UPDATE_DATE
367: ,LAST_UPDATED_BY
368: ,CREATION_DATE

Line 438: FROM pn_var_vol_hist_all

434:
435: ELSIF (NVL(v_actual_amt_exist,0) <> 0) THEN
436:
437: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
438: FROM pn_var_vol_hist_all
439: WHERE line_item_id = v_lines.line_item_id;
440:
441: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
442: ,VOL_HIST_NUM

Line 441: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID

437: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
438: FROM pn_var_vol_hist_all
439: WHERE line_item_id = v_lines.line_item_id;
440:
441: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
442: ,VOL_HIST_NUM
443: ,LAST_UPDATE_DATE
444: ,LAST_UPDATED_BY
445: ,CREATION_DATE

Line 496: UPDATE PN_VAR_VOL_HIST_ALL

492: ELSIF (NVL(v_actual_amt_exist,0) = 0) THEN
493:
494: IF v_actual_exp_code_exist ='N' THEN
495:
496: UPDATE PN_VAR_VOL_HIST_ALL
497: SET ACTUAL_AMOUNT = v_act_amount
498: ,LAST_UPDATE_DATE =sysDATE
499: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
500: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)

Line 513: FROM pn_var_vol_hist_all

509:
510: ELSIF (v_actual_exp_code_exist ='Y') THEN
511:
512: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
513: FROM pn_var_vol_hist_all
514: WHERE line_item_id = v_lines.line_item_id;
515:
516: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
517: ,VOL_HIST_NUM

Line 516: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID

512: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
513: FROM pn_var_vol_hist_all
514: WHERE line_item_id = v_lines.line_item_id;
515:
516: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
517: ,VOL_HIST_NUM
518: ,LAST_UPDATE_DATE
519: ,LAST_UPDATED_BY
520: ,CREATION_DATE

Line 593: FROM pn_var_vol_hist_all

589:
590: ELSIF NVL(v_forecasted_amt_exist,0) <> 0 THEN
591:
592: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
593: FROM pn_var_vol_hist_all
594: WHERE line_item_id = v_lines.line_item_id;
595:
596: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
597: ,VOL_HIST_NUM

Line 596: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID

592: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
593: FROM pn_var_vol_hist_all
594: WHERE line_item_id = v_lines.line_item_id;
595:
596: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
597: ,VOL_HIST_NUM
598: ,LAST_UPDATE_DATE
599: ,LAST_UPDATED_BY
600: ,CREATION_DATE

Line 651: UPDATE PN_VAR_VOL_HIST_ALl

647: ELSIF (NVL(v_forecasted_amt_exist,0) = 0) THEN
648:
649: IF v_forecasted_exp_code_exist ='N' THEN
650:
651: UPDATE PN_VAR_VOL_HIST_ALl
652: SET FORECASTED_AMOUNT = v_frc_amount
653: ,LAST_UPDATE_DATE =sysDATE
654: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
655: ,LAST_UPDATE_LOGIN =NVL(fnd_profile.value('USER_ID'), 0)

Line 667: FROM pn_var_vol_hist_all

663:
664: ELSIF (v_forecasted_exp_code_exist ='Y') THEN
665:
666: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
667: FROM pn_var_vol_hist_all
668: WHERE line_item_id = v_lines.line_item_id;
669:
670: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
671: ,VOL_HIST_NUM

Line 670: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID

666: SELECT NVL(MAX(vol_hist_num), 0)+1 INTO v_vol_hist_num
667: FROM pn_var_vol_hist_all
668: WHERE line_item_id = v_lines.line_item_id;
669:
670: INSERT INTO pn_var_vol_hist_all (VOL_HIST_ID
671: ,VOL_HIST_NUM
672: ,LAST_UPDATE_DATE
673: ,LAST_UPDATED_BY
674: ,CREATION_DATE

Line 860: FROM PN_VAR_VOL_HIST_ALL

856: ,ATTRIBUTE14
857: ,ATTRIBUTE15
858: ,ORG_ID
859: ,DAILY_ACTUAL_AMOUNT
860: FROM PN_VAR_VOL_HIST_ALL
861: WHERE VOL_HIST_ID = v_lines.vol_deduct_id;
862:
863: UPDATE PN_VAR_VOL_HIST_ALL
864: SET LAST_UPDATE_DATE = sysDATE

Line 863: UPDATE PN_VAR_VOL_HIST_ALL

859: ,DAILY_ACTUAL_AMOUNT
860: FROM PN_VAR_VOL_HIST_ALL
861: WHERE VOL_HIST_ID = v_lines.vol_deduct_id;
862:
863: UPDATE PN_VAR_VOL_HIST_ALL
864: SET LAST_UPDATE_DATE = sysDATE
865: ,LAST_UPDATED_BY = NVL(fnd_profile.value('USER_ID'), 0)
866: ,LAST_UPDATE_LOGIN = NVL(fnd_profile.value('USER_ID'), 0)
867: ,LINE_ITEM_ID = v_lines.line_item_id

Line 878: UPDATE PN_VAR_VOL_HIST_ALL

874: WHERE vol_hist_id = v_lines.vol_deduct_id;
875:
876: IF v_lines.volume_type = 'ACTUAL' THEN
877:
878: UPDATE PN_VAR_VOL_HIST_ALL
879: SET ACTUAL_AMOUNT = NVL(v_act_amount,0)
880: WHERE vol_hist_id = v_lines.vol_deduct_id;
881:
882: ELSIF v_lines.volume_type = 'FORECASTED' THEN

Line 884: UPDATE PN_VAR_VOL_HIST_ALL

880: WHERE vol_hist_id = v_lines.vol_deduct_id;
881:
882: ELSIF v_lines.volume_type = 'FORECASTED' THEN
883:
884: UPDATE PN_VAR_VOL_HIST_ALL
885: SET FORECASTED_AMOUNT = NVL(v_frc_amount,0)
886: WHERE vol_hist_id = v_lines.vol_deduct_id;
887:
888: END IF;