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_VARIABLE_AMOUNT_PKG dependencies on PN_VAR_VOL_HIST

Line 15: FROM pn_var_vol_hist_all vh,

11: p_period_id number,
12: p_period_date DATE) IS
13: SELECT SUM(vh.actual_amount) actual_amt,
14: vh.grp_date_id
15: FROM pn_var_vol_hist_all vh,
16: pn_var_grp_dates_all gd
17: WHERE vh.line_item_id = p_line_item_id
18: AND vh.grp_date_id = gd.grp_date_id
19: AND vh.period_id = gd.period_id

Line 35: FROM pn_var_vol_hist_all vh,

31: p_period_id number,
32: p_period_date DATE) IS
33: SELECT SUM(vh.forecasted_amount) forecasted_amt,
34: vh.grp_date_id
35: FROM pn_var_vol_hist_all vh,
36: pn_var_grp_dates_all gd
37: WHERE vh.line_item_id = p_line_item_id
38: AND vh.grp_date_id = gd.grp_date_id
39: AND vh.period_id = gd.period_id

Line 61: FROM pn_var_vol_hist_all vh,

57: p_period_date DATE) IS
58: SELECT SUM(vh.actual_amount) actual_amt,
59: vh.grp_date_id,
60: vh.line_item_id
61: FROM pn_var_vol_hist_all vh,
62: pn_var_grp_dates_all gd
63: WHERE vh.grp_date_id = gd.grp_date_id
64: AND vh.period_id = gd.period_id
65: AND gd.period_id = p_period_id

Line 84: FROM pn_var_vol_hist_all vh,

80: p_min_group_date date) IS
81: SELECT SUM(vh.actual_amount) actual_amt,
82: vh.grp_date_id,
83: vh.line_item_id
84: FROM pn_var_vol_hist_all vh,
85: pn_var_grp_dates_all gd
86: WHERE vh.grp_date_id = gd.grp_date_id
87: AND vh.period_id = gd.period_id
88: AND DECODE(p_invoice_on,'ACTUAL',NVL(gd.actual_exp_code,'N'),

Line 123: FROM pn_var_vol_hist_all

119: SUM(forecasted_amount) cum_for_vol,
120: line_item_id,
121: grp_date_id,
122: group_date
123: FROM pn_var_vol_hist_all
124: WHERE line_item_id = p_line_item_id
125: GROUP BY line_item_id,grp_date_id,group_date
126: ORDER BY line_item_id,group_date;
127:

Line 157: RECORD (cum_actual_vol pn_var_vol_hist.actual_amount%TYPE,

153: TABLE OF csr_bkpt_range%ROWTYPE
154: INDEX BY BINARY_INTEGER;
155:
156: TYPE cumulative_vol_rec IS
157: RECORD (cum_actual_vol pn_var_vol_hist.actual_amount%TYPE,
158: cum_for_vol pn_var_vol_hist.forecasted_amount%TYPE,
159: line_item_id pn_var_vol_hist.line_item_id%TYPE,
160: grp_date_id pn_var_vol_hist.grp_date_id%TYPE,
161: cum_ded pn_var_deductions.deduction_amount%TYPE);

Line 158: cum_for_vol pn_var_vol_hist.forecasted_amount%TYPE,

154: INDEX BY BINARY_INTEGER;
155:
156: TYPE cumulative_vol_rec IS
157: RECORD (cum_actual_vol pn_var_vol_hist.actual_amount%TYPE,
158: cum_for_vol pn_var_vol_hist.forecasted_amount%TYPE,
159: line_item_id pn_var_vol_hist.line_item_id%TYPE,
160: grp_date_id pn_var_vol_hist.grp_date_id%TYPE,
161: cum_ded pn_var_deductions.deduction_amount%TYPE);
162:

Line 159: line_item_id pn_var_vol_hist.line_item_id%TYPE,

155:
156: TYPE cumulative_vol_rec IS
157: RECORD (cum_actual_vol pn_var_vol_hist.actual_amount%TYPE,
158: cum_for_vol pn_var_vol_hist.forecasted_amount%TYPE,
159: line_item_id pn_var_vol_hist.line_item_id%TYPE,
160: grp_date_id pn_var_vol_hist.grp_date_id%TYPE,
161: cum_ded pn_var_deductions.deduction_amount%TYPE);
162:
163: TYPE cumulative_vol_TYPE IS

Line 160: grp_date_id pn_var_vol_hist.grp_date_id%TYPE,

156: TYPE cumulative_vol_rec IS
157: RECORD (cum_actual_vol pn_var_vol_hist.actual_amount%TYPE,
158: cum_for_vol pn_var_vol_hist.forecasted_amount%TYPE,
159: line_item_id pn_var_vol_hist.line_item_id%TYPE,
160: grp_date_id pn_var_vol_hist.grp_date_id%TYPE,
161: cum_ded pn_var_deductions.deduction_amount%TYPE);
162:
163: TYPE cumulative_vol_TYPE IS
164: TABLE OF cumulative_vol_rec

Line 333: FROM pn_var_vol_hist_all vh,

329: CURSOR csr_min_group_date_adj (p_period_id number,
330: p_line_item_id number,
331: p_invoice_on varchar2) IS
332: SELECT MIN(gd.group_date) min_group_date
333: FROM pn_var_vol_hist_all vh,
334: pn_var_grp_dates_all gd
335: WHERE vh.grp_date_id = gd.grp_date_id
336: AND vh.period_id = gd.period_id
337: AND DECODE(p_invoice_on,'ACTUAL',NVL(gd.actual_exp_code,'N'),

Line 342: FROM pn_var_vol_hist_all vh1

338: 'FORECASTED',NVL(gd.variance_exp_code,'N')) = 'Y'
339: AND gd.period_id = p_period_id
340: AND vh.line_item_id = p_line_item_id
341: AND exists (SELECT null
342: FROM pn_var_vol_hist_all vh1
343: WHERE vh1.period_id = gd.period_id
344: AND vh1.grp_date_id = gd.grp_date_id
345: AND DECODE(p_invoice_on,'ACTUAL' ,NVL( vh1.actual_exp_code,'N'),
346: 'FORECASTED',NVL( vh1.variance_exp_code,'N')

Line 2586: FROM pn_var_vol_hist_all

2582: ip_grp_date_id NUMBER) IS
2583: SELECT 'Y'
2584: FROM dual
2585: WHERE exists (SELECT null
2586: FROM pn_var_vol_hist_all
2587: WHERE line_item_id = ip_line_item_id
2588: AND grp_date_id = ip_grp_date_id);
2589:
2590: /* Cursor to chk if volume history exists for a period AND invoice date */

Line 2597: FROM pn_var_vol_hist_all vh,

2593: ip_rent_TYPE VARCHAR2) IS
2594: SELECT 'Y'
2595: FROM dual
2596: WHERE exists (SELECT null
2597: FROM pn_var_vol_hist_all vh,
2598: pn_var_grp_dates_all gd
2599: WHERE vh.period_id = gd.period_id
2600: AND vh.grp_date_id = gd.grp_date_id
2601: AND gd.period_id = ip_period_id

Line 2645: /* Does a row exist in pn_var_vol_hist for grp_date_id AND line_item_id */

2641: l_varrent_exists := find_varrent_exists(
2642: p_line_item_id => p_line_item_id,
2643: p_grp_date_id => p_grp_date_id);
2644:
2645: /* Does a row exist in pn_var_vol_hist for grp_date_id AND line_item_id */
2646: OPEN csr_any_vol_exists (p_line_item_id,p_grp_date_id);
2647: FETCH csr_any_vol_exists into l_any_vol_exists;
2648: CLOSE csr_any_vol_exists;
2649: