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.FII_AR_UNAPP_RCT_TREND_PKG dependencies on FII_AR_UTIL_PKG

Line 28: fii_ar_util_pkg.reset_globals;

24:
25:
26: BEGIN
27: -- Call to reset the parameter variables
28: fii_ar_util_pkg.reset_globals;
29:
30: -- Call to get all the parameters in the report
31: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
32:

Line 31: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

27: -- Call to reset the parameter variables
28: fii_ar_util_pkg.reset_globals;
29:
30: -- Call to get all the parameters in the report
31: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
32:
33: -- Call to populate fii_ar_summary_gt table
34: fii_ar_util_pkg.populate_summary_gt_tables;
35:

Line 34: fii_ar_util_pkg.populate_summary_gt_tables;

30: -- Call to get all the parameters in the report
31: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
32:
33: -- Call to populate fii_ar_summary_gt table
34: fii_ar_util_pkg.populate_summary_gt_tables;
35:
36: -- Customer Dimension WHERE clause based on the report parameter
37: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
38: l_child_party_where := ' AND f.party_id = inner_time.party_id ';

Line 37: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN

33: -- Call to populate fii_ar_summary_gt table
34: fii_ar_util_pkg.populate_summary_gt_tables;
35:
36: -- Customer Dimension WHERE clause based on the report parameter
37: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
38: l_child_party_where := ' AND f.party_id = inner_time.party_id ';
39: END IF;
40:
41: -- Collector Dimension WHERE clause based on the report parameter

Line 43: IF (fii_ar_util_pkg.g_collector_id <> '-111') THEN

39: END IF;
40:
41: -- Collector Dimension WHERE clause based on the report parameter
42:
43: IF (fii_ar_util_pkg.g_collector_id <> '-111') THEN
44: l_collector_where := 'AND f.collector_id = inner_time.collector_id';
45: END IF;
46:
47: -- Getting the sequence and the last day of the month corresponding to the REPORT DATE

Line 53: WHERE fii_ar_util_pkg.g_as_of_date BETWEEN start_date AND end_date;

49:
50: SELECT NVL(MAX(sequence),0),NVL(MAX(end_date),SYSDATE)
51: INTO l_curr_per_sequence,l_curr_end_date
52: FROM fii_time_ent_period
53: WHERE fii_ar_util_pkg.g_as_of_date BETWEEN start_date AND end_date;
54:
55: -- Framing SQL statement for the current month for as of date <> end date of the month
56:
57: IF fii_ar_util_pkg.g_as_of_date <> l_curr_end_date THEN

Line 57: IF fii_ar_util_pkg.g_as_of_date <> l_curr_end_date THEN

53: WHERE fii_ar_util_pkg.g_as_of_date BETWEEN start_date AND end_date;
54:
55: -- Framing SQL statement for the current month for as of date <> end date of the month
56:
57: IF fii_ar_util_pkg.g_as_of_date <> l_curr_end_date THEN
58:
59: -- Following variable stores the SQL for Unapplied Receipt Amount
60:
61: l_curr_period_unapp_rec_sql :=

Line 70: FROM fii_ar_rct_aging_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f

66: ,NULL FII_AR_PRIOR_UNAPP_REC_AMT
67: ,NULL FII_AR_PRIOR_UNAPP_REC_COUNT
68: ,NULL FII_AR_TOTAL_REC_AMT
69: ,NULL FII_AR_TOTAL_REC_COUNT
70: FROM fii_ar_rct_aging_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f
71: ,(SELECT /*+ no_merge leading(gt) cardinality(gt 1)*/ cal.time_id time_id
72: ,cal.period_type_id period_type_id
73: ,gt.*
74: FROM fii_time_structures cal

Line 82: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '||l_child_party_where||' '||l_collector_where;

78: ) inner_time
79: WHERE inner_time.time_id = f.time_id
80: AND inner_time.period_type_id = f.period_type_id
81: AND f.org_id = inner_time.org_id
82: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '||l_child_party_where||' '||l_collector_where;
83:
84: -- Following variable stores the SQL for Total Receipt Amount
85:
86: l_curr_period_total_rec_sql :=

Line 101: FROM fii_ar_net_rec_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f

97: ,CASE WHEN f.header_filter_date > LAST_DAY(ADD_MONTHS(:ASOF_DATE,-1))
98: THEN f.total_receipt_count
99: ELSE NULL
100: END FII_AR_TOTAL_REC_COUNT
101: FROM fii_ar_net_rec_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f
102: ,(SELECT /*+no_merge leading(gt) cardinality(gt 1)*/ cal.time_id time_id
103: ,cal.period_type_id period_type_id
104: ,gt.*
105: FROM fii_time_structures cal

Line 113: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_child_party_where||' '||l_collector_where;

109: ) inner_time
110: WHERE inner_time.time_id = f.time_id
111: AND inner_time.period_type_id = f.period_type_id
112: AND f.org_id = inner_time.org_id
113: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_child_party_where||' '||l_collector_where;
114:
115: END IF;
116:
117: -- PMV SQL to display data on Unapplied Receipts Trend Report

Line 171: FROM fii_ar_rct_aging_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f

167: END FII_AR_PRIOR_UNAPP_REC_COUNT
168: ,NULL FII_AR_TOTAL_REC_AMT
169: ,NULL FII_AR_TOTAL_REC_COUNT
170: -- Since VIEWBY is always MONTH, base MV would be used
171: FROM fii_ar_rct_aging_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f
172: ,fii_time_ent_period time
173: ,(SELECT /*+ no_merge leading(gt) cardinality(gt 1)*/ cal.time_id time_id
174: ,cal.period_type_id period_type_id
175: ,cal.report_date report_date

Line 190: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '||l_child_party_where||'

186: WHERE inner_time.time_id = f.time_id
187: AND f.period_type_id = inner_time.period_type_id
188: AND f.org_id = inner_time.org_id
189: AND time.end_date = inner_time.report_date
190: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '||l_child_party_where||'
191: '||l_collector_where||'
192: UNION ALL
193: SELECT /*+ INDEX(f FII_AR_NET_REC_BASE_mv_N1)*/
194: inner_time.sequence period_sequence

Line 207: FROM fii_ar_net_rec_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f

203: ,CASE WHEN f.header_filter_date >= inner_time.start_date
204: THEN total_receipt_count
205: ELSE NULL
206: END FII_AR_TOTAL_REC_COUNT
207: FROM fii_ar_net_rec_base_mv'||fii_ar_util_pkg.g_curr_suffix||' f
208: ,(SELECT /*+no_merge leading(gt) cardinality(gt 1)*/ time.ent_period_id ent_period_id
209: ,time.sequence sequence
210: ,time.start_date start_date
211: ,gt.*

Line 220: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_child_party_where||'

216: ) inner_time
217: WHERE inner_time.ent_period_id = f.time_id
218: AND f.period_type_id = 32
219: AND f.org_id = inner_time.org_id
220: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_child_party_where||'
221: '||l_collector_where||''||l_curr_period_unapp_rec_sql||''||l_curr_period_total_rec_sql||'
222: ) inner_inline_view
223: GROUP BY inner_inline_view.period_sequence
224: ) inner_view

Line 235: fii_ar_util_pkg.bind_variable(l_sqlstmt

231: ';
232:
233: -- Call to UTIL package to bind the variables
234:
235: fii_ar_util_pkg.bind_variable(l_sqlstmt
236: ,p_page_parameter_tbl
237: ,p_unapp_rct_trend_sql
238: ,p_unapp_rct_trend_output
239: );