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_NET_REC_SUM_PKG dependencies on FII_AR_UTIL_PKG

Line 40: fii_ar_util_pkg.reset_globals;

36: BEGIN
37:
38: -- Clear global parameters AND read the new parameters
39: -- Sets all g_% variables to its default values
40: fii_ar_util_pkg.reset_globals;
41:
42: -- Reads the parameters from the parameter portlet
43: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
44: l_gt_hint := ' leading(gt) cardinality(gt 1) ';

Line 43: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

39: -- Sets all g_% variables to its default values
40: fii_ar_util_pkg.reset_globals;
41:
42: -- Reads the parameters from the parameter portlet
43: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
44: l_gt_hint := ' leading(gt) cardinality(gt 1) ';
45: -- Populates the security related global temporary tables (fii_ar_summary_gt)
46: fii_ar_util_pkg.populate_summary_gt_tables;
47:

Line 46: fii_ar_util_pkg.populate_summary_gt_tables;

42: -- Reads the parameters from the parameter portlet
43: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
44: l_gt_hint := ' leading(gt) cardinality(gt 1) ';
45: -- Populates the security related global temporary tables (fii_ar_summary_gt)
46: fii_ar_util_pkg.populate_summary_gt_tables;
47:
48: l_view_by := fii_ar_util_pkg.g_view_by;
49:
50: -- Adding Filter on collector_id only if Collector is 'All'

Line 48: l_view_by := fii_ar_util_pkg.g_view_by;

44: l_gt_hint := ' leading(gt) cardinality(gt 1) ';
45: -- Populates the security related global temporary tables (fii_ar_summary_gt)
46: fii_ar_util_pkg.populate_summary_gt_tables;
47:
48: l_view_by := fii_ar_util_pkg.g_view_by;
49:
50: -- Adding Filter on collector_id only if Collector is 'All'
51: IF fii_ar_util_pkg.g_collector_id <> '-111' OR l_view_by = 'FII_COLLECTOR+FII_COLLECTOR' THEN
52: l_collector_where := ' AND f.collector_id = v.collector_id';

Line 51: IF fii_ar_util_pkg.g_collector_id <> '-111' OR l_view_by = 'FII_COLLECTOR+FII_COLLECTOR' THEN

47:
48: l_view_by := fii_ar_util_pkg.g_view_by;
49:
50: -- Adding Filter on collector_id only if Collector is 'All'
51: IF fii_ar_util_pkg.g_collector_id <> '-111' OR l_view_by = 'FII_COLLECTOR+FII_COLLECTOR' THEN
52: l_collector_where := ' AND f.collector_id = v.collector_id';
53: ELSE
54: l_collector_where := '';
55: END IF;

Line 58: IF (fii_ar_util_pkg.g_party_id <> '-111' OR fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN

54: l_collector_where := '';
55: END IF;
56:
57: -- Adding Filter on party_id
58: IF (fii_ar_util_pkg.g_party_id <> '-111' OR fii_ar_util_pkg.g_view_by = 'CUSTOMER+FII_CUSTOMERS') THEN
59: l_child_party_where := ' AND f.party_id = v.party_id ';
60: ELSE
61: l_child_party_where := '';
62: END IF;

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

74: l_self_flag_where_d := ', NULL is_self_flag';
75:
76: IF l_view_by = 'ORGANIZATION+FII_OPERATING_UNITS' OR l_view_by = 'FII_COLLECTOR+FII_COLLECTOR' THEN
77: l_viewby_drill := '''''';
78: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
79: l_cust_acc_drill := '''pFunctionName=FII_AR_NET_REC_SUM&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID''';
80: l_unapp_sum_drill := '''pFunctionName=FII_AR_UNAPP_RCT_SUMMARY&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID''';
81: ELSE
82: l_cust_acc_drill := '''pFunctionName=FII_AR_NET_REC_SUM&pParamIds=Y&VIEW_BY_NAME=VIEW_BY_ID''';

Line 115: IF instr(fii_ar_util_pkg.g_order_by,',') <> 0 THEN

111: l_customer_where := ' AND f.parent_party_id = v.parent_party_id';
112: END IF;
113:
114: -- Constructing the ORDER BY clause
115: IF instr(fii_ar_util_pkg.g_order_by,',') <> 0 THEN
116: l_order_by := ' ORDER BY NVL(FII_AR_NET_REC_AMT, -999999999) DESC';
117: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
118: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
119: l_order_by := ' ORDER BY NVL(' || l_order_column || ', -999999999) DESC';

Line 117: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN

113:
114: -- Constructing the ORDER BY clause
115: IF instr(fii_ar_util_pkg.g_order_by,',') <> 0 THEN
116: l_order_by := ' ORDER BY NVL(FII_AR_NET_REC_AMT, -999999999) DESC';
117: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
118: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
119: l_order_by := ' ORDER BY NVL(' || l_order_column || ', -999999999) DESC';
120: ELSE
121: l_order_by := ' &ORDER_BY_CLAUSE';

Line 118: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));

114: -- Constructing the ORDER BY clause
115: IF instr(fii_ar_util_pkg.g_order_by,',') <> 0 THEN
116: l_order_by := ' ORDER BY NVL(FII_AR_NET_REC_AMT, -999999999) DESC';
117: ELSIF instr(fii_ar_util_pkg.g_order_by, ' DESC') <> 0 THEN
118: l_order_column := substr(fii_ar_util_pkg.g_order_by,1,instr(fii_ar_util_pkg.g_order_by, ' DESC'));
119: l_order_by := ' ORDER BY NVL(' || l_order_column || ', -999999999) DESC';
120: ELSE
121: l_order_by := ' &ORDER_BY_CLAUSE';
122: END IF;

Line 168: SELECT /+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)/

164: sum(sum(inline_query.claim_amount)) over() FII_AR_GT_CLAIMS_AMT,
165: sum(sum(inline_query.prepayment_amount)) over() FII_AR_GT_PREPAYMENT_AMT
166: FROM
167: (
168: SELECT /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/
169: v.viewby, v.viewby_code,
170: f.inv_amount, f.dm_amount, f.cb_amount, f.br_amount, f.dep_amount,
171: f.on_account_credit_amount, f.unapp_dep_amount, NULL unapp_amount,
172: f.on_account_cash_amount, f.claim_amount, f.prepayment_amount

Line 175: fii_ar_net_rec' || fii_ar_util_pkg.g_cust_suffix || '_mv' || fii_ar_util_pkg.g_curr_suffix || ' f,

171: f.on_account_credit_amount, f.unapp_dep_amount, NULL unapp_amount,
172: f.on_account_cash_amount, f.claim_amount, f.prepayment_amount
173: ' || l_self_flag_where || ', v.is_leaf_flag, f.party_id
174: FROM
175: fii_ar_net_rec' || fii_ar_util_pkg.g_cust_suffix || '_mv' || fii_ar_util_pkg.g_curr_suffix || ' f,
176: (
177: SELECT /*+ no_merge '||l_gt_hint|| ' */ *
178: FROM fii_time_structures cal,
179: ' || fii_ar_util_pkg.get_from_statement || ' gt

Line 179: ' || fii_ar_util_pkg.get_from_statement || ' gt

175: fii_ar_net_rec' || fii_ar_util_pkg.g_cust_suffix || '_mv' || fii_ar_util_pkg.g_curr_suffix || ' f,
176: (
177: SELECT /*+ no_merge '||l_gt_hint|| ' */ *
178: FROM fii_time_structures cal,
179: ' || fii_ar_util_pkg.get_from_statement || ' gt
180: WHERE cal.report_date = :ASOF_DATE
181: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
182: AND ' || fii_ar_util_pkg.get_where_statement || '
183: ) v

Line 182: AND ' || fii_ar_util_pkg.get_where_statement || '

178: FROM fii_time_structures cal,
179: ' || fii_ar_util_pkg.get_from_statement || ' gt
180: WHERE cal.report_date = :ASOF_DATE
181: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
182: AND ' || fii_ar_util_pkg.get_where_statement || '
183: ) v
184: WHERE
185: f.time_id = v.time_id
186: AND f.period_type_id = v.period_type_id

Line 188: AND '||fii_ar_util_pkg.get_mv_where_statement||' '|| l_collector_where

184: WHERE
185: f.time_id = v.time_id
186: AND f.period_type_id = v.period_type_id
187: AND f.org_id = v.org_id
188: AND '||fii_ar_util_pkg.get_mv_where_statement||' '|| l_collector_where
189: || l_customer_where
190: || l_child_party_where
191: || l_customer_acc_where || '
192: UNION ALL

Line 193: SELECT /+ INDEX(f FII_AR_RCT_AGING'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)/

189: || l_customer_where
190: || l_child_party_where
191: || l_customer_acc_where || '
192: UNION ALL
193: SELECT /*+ INDEX(f FII_AR_RCT_AGING'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/
194: v.viewby, v.viewby_code,
195: NULL inv_amount, NULL dm_amount, NULL cb_amount, NULL br_amount, NULL dep_amount,
196: NULL on_account_credit_amount, NULL unapp_dep_amount, f.unapp_amount,
197: NULL on_account_cash_amount, NULL claim_amount, NULL prepayment_amount

Line 200: fii_ar_rct_aging' || fii_ar_util_pkg.g_cust_suffix || '_mv' || fii_ar_util_pkg.g_curr_suffix || ' f,

196: NULL on_account_credit_amount, NULL unapp_dep_amount, f.unapp_amount,
197: NULL on_account_cash_amount, NULL claim_amount, NULL prepayment_amount
198: ' || l_self_flag_where_d || ', NULL is_leaf_flag, NULL party_id
199: FROM
200: fii_ar_rct_aging' || fii_ar_util_pkg.g_cust_suffix || '_mv' || fii_ar_util_pkg.g_curr_suffix || ' f,
201: (
202: SELECT /*+ no_merge '||l_gt_hint|| ' */ *
203: FROM fii_time_structures cal,
204: ' || fii_ar_util_pkg.get_from_statement || ' gt

Line 204: ' || fii_ar_util_pkg.get_from_statement || ' gt

200: fii_ar_rct_aging' || fii_ar_util_pkg.g_cust_suffix || '_mv' || fii_ar_util_pkg.g_curr_suffix || ' f,
201: (
202: SELECT /*+ no_merge '||l_gt_hint|| ' */ *
203: FROM fii_time_structures cal,
204: ' || fii_ar_util_pkg.get_from_statement || ' gt
205: WHERE cal.report_date = :ASOF_DATE
206: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
207: AND ' || fii_ar_util_pkg.get_where_statement || '
208: ) v

Line 207: AND ' || fii_ar_util_pkg.get_where_statement || '

203: FROM fii_time_structures cal,
204: ' || fii_ar_util_pkg.get_from_statement || ' gt
205: WHERE cal.report_date = :ASOF_DATE
206: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
207: AND ' || fii_ar_util_pkg.get_where_statement || '
208: ) v
209: WHERE
210: f.time_id = v.time_id
211: AND f.period_type_id = v.period_type_id

Line 213: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '

209: WHERE
210: f.time_id = v.time_id
211: AND f.period_type_id = v.period_type_id
212: AND f.org_id = v.org_id
213: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' '
214: || l_collector_where
215: || l_customer_where
216: || l_child_party_where
217: || l_customer_acc_where || '

Line 223: fii_ar_util_pkg.bind_variable(

219: GROUP BY inline_query.viewby_code, inline_query.viewby'
220: || l_order_by;
221:
222: -- Calling the bind_variable API
223: fii_ar_util_pkg.bind_variable(
224: p_sqlstmt => sqlstmt,
225: p_page_parameter_tbl => p_page_parameter_tbl,
226: p_sql_output => p_net_rec_sum_sql,
227: p_bind_output_table => p_net_rec_sum_output