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

Line 62: fii_ar_util_pkg.reset_globals;

58: BEGIN
59:
60:
61: -- Reset all the global variables to NULL or to the default value
62: fii_ar_util_pkg.reset_globals;
63:
64: -- Get the parameters and set the global variables
65: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
66:

Line 65: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

61: -- Reset all the global variables to NULL or to the default value
62: fii_ar_util_pkg.reset_globals;
63:
64: -- Get the parameters and set the global variables
65: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
66:
67: -- Retrieve values for global variables
68: l_as_of_date := fii_ar_util_pkg.g_as_of_date;
69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;

Line 68: l_as_of_date := fii_ar_util_pkg.g_as_of_date;

64: -- Get the parameters and set the global variables
65: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
66:
67: -- Retrieve values for global variables
68: l_as_of_date := fii_ar_util_pkg.g_as_of_date;
69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;

Line 69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;

65: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
66:
67: -- Retrieve values for global variables
68: l_as_of_date := fii_ar_util_pkg.g_as_of_date;
69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;

Line 70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;

66:
67: -- Retrieve values for global variables
68: l_as_of_date := fii_ar_util_pkg.g_as_of_date;
69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;

Line 71: l_collector_id := fii_ar_util_pkg.g_collector_id;

67: -- Retrieve values for global variables
68: l_as_of_date := fii_ar_util_pkg.g_as_of_date;
69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;

Line 72: l_cust_id := fii_ar_util_pkg.g_party_id;

68: l_as_of_date := fii_ar_util_pkg.g_as_of_date;
69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;
76: l_viewby := fii_ar_util_pkg.g_view_by;

Line 73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;

69: l_cust_suffix := fii_ar_util_pkg.g_cust_suffix;
70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;
76: l_viewby := fii_ar_util_pkg.g_view_by;
77: l_self_msg := fii_ar_util_pkg.g_self_msg;

Line 74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;

70: l_curr_suffix := fii_ar_util_pkg.g_curr_suffix;
71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;
76: l_viewby := fii_ar_util_pkg.g_view_by;
77: l_self_msg := fii_ar_util_pkg.g_self_msg;
78: l_hierarchical_flag := fii_ar_util_pkg.g_is_hierarchical_flag;

Line 75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;

71: l_collector_id := fii_ar_util_pkg.g_collector_id;
72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;
76: l_viewby := fii_ar_util_pkg.g_view_by;
77: l_self_msg := fii_ar_util_pkg.g_self_msg;
78: l_hierarchical_flag := fii_ar_util_pkg.g_is_hierarchical_flag;
79:

Line 76: l_viewby := fii_ar_util_pkg.g_view_by;

72: l_cust_id := fii_ar_util_pkg.g_party_id;
73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;
76: l_viewby := fii_ar_util_pkg.g_view_by;
77: l_self_msg := fii_ar_util_pkg.g_self_msg;
78: l_hierarchical_flag := fii_ar_util_pkg.g_is_hierarchical_flag;
79:
80: -- Populate global temp table based on the parameters chosen

Line 77: l_self_msg := fii_ar_util_pkg.g_self_msg;

73: l_cust_account_id := fii_ar_util_pkg.g_cust_account_id;
74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;
76: l_viewby := fii_ar_util_pkg.g_view_by;
77: l_self_msg := fii_ar_util_pkg.g_self_msg;
78: l_hierarchical_flag := fii_ar_util_pkg.g_is_hierarchical_flag;
79:
80: -- Populate global temp table based on the parameters chosen
81: fii_ar_util_pkg.populate_summary_gt_tables;

Line 78: l_hierarchical_flag := fii_ar_util_pkg.g_is_hierarchical_flag;

74: l_itd_bitand := fii_ar_util_pkg.g_bitand_inc_todate;
75: l_r30_bitand := fii_ar_util_pkg.g_bitand_rolling_30_days;
76: l_viewby := fii_ar_util_pkg.g_view_by;
77: l_self_msg := fii_ar_util_pkg.g_self_msg;
78: l_hierarchical_flag := fii_ar_util_pkg.g_is_hierarchical_flag;
79:
80: -- Populate global temp table based on the parameters chosen
81: fii_ar_util_pkg.populate_summary_gt_tables;
82:

Line 81: fii_ar_util_pkg.populate_summary_gt_tables;

77: l_self_msg := fii_ar_util_pkg.g_self_msg;
78: l_hierarchical_flag := fii_ar_util_pkg.g_is_hierarchical_flag;
79:
80: -- Populate global temp table based on the parameters chosen
81: fii_ar_util_pkg.populate_summary_gt_tables;
82:
83: l_gt_hint := ' leading(gt) cardinality(gt 1) ';
84:
85: -- Find out the number of bucket ranges customized for this report

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

186: -- 3. Aging Bucket X amount will drill to Unapplied Receipts Summary
187: -- (View by Customer Account)
188: -----------------------------------------------------------------------------
189: --view by ou/collector drills
190: IF (fii_ar_util_pkg.g_party_id <> '-111') THEN
191: -- Unapplied Receipts Amount Drilldown URL
192: l_unapp_rct_amt_url_1 := 'pFunctionName=FII_AR_UNAPP_RCT_SUMMARY&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=CUSTOMER+FII_CUSTOMER_ACCOUNTS&pParamIds=Y';
193:
194: -- Open Receivables Amount Drilldown URL

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

381:
382: -----------------------------------------
383: -- Construct the order by clause
384: -----------------------------------------
385: IF(instr(fii_ar_util_pkg.g_order_by, ',') <> 0) THEN
386: /*This means no particular sort column is selected in the report. So sort on
387: the default column in descending order. NVL is added to make sure the null
388: values appear last. */
389: l_order_by_clause := 'ORDER BY NVL(FII_AR_UNAPP_RCT_AMT, -999999999) DESC';

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

387: the default column in descending order. NVL is added to make sure the null
388: values appear last. */
389: l_order_by_clause := 'ORDER BY NVL(FII_AR_UNAPP_RCT_AMT, -999999999) DESC';
390:
391: ELSIF(instr(fii_ar_util_pkg.g_order_by, 'DESC') <> 0)THEN
392: /*This means a particular sort column is clicked to have descending order in which
393: case we would want all the null values to appear last in the report so add an
394: NVL to that column.*/
395: l_order_column := substr(fii_ar_util_pkg.g_order_by, 1,

Line 395: l_order_column := substr(fii_ar_util_pkg.g_order_by, 1,

391: ELSIF(instr(fii_ar_util_pkg.g_order_by, 'DESC') <> 0)THEN
392: /*This means a particular sort column is clicked to have descending order in which
393: case we would want all the null values to appear last in the report so add an
394: NVL to that column.*/
395: l_order_column := substr(fii_ar_util_pkg.g_order_by, 1,
396: instr(fii_ar_util_pkg.g_order_by, ' DESC'));
397: l_order_by_clause := 'ORDER BY NVL('||l_order_column ||', -999999999) DESC';
398: ELSE
399: /*This is the case when user has asked for an ascending order sort. Use PMV's

Line 396: instr(fii_ar_util_pkg.g_order_by, ' DESC'));

392: /*This means a particular sort column is clicked to have descending order in which
393: case we would want all the null values to appear last in the report so add an
394: NVL to that column.*/
395: l_order_column := substr(fii_ar_util_pkg.g_order_by, 1,
396: instr(fii_ar_util_pkg.g_order_by, ' DESC'));
397: l_order_by_clause := 'ORDER BY NVL('||l_order_column ||', -999999999) DESC';
398: ELSE
399: /*This is the case when user has asked for an ascending order sort. Use PMV's
400: order by clause*/

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

538: || ', NULL FII_AR_UR_BKT_AMT_DRILL_B' || i;
539: END LOOP;
540:
541: l_sqlstmt := l_sqlstmt || ' FROM (
542: SELECT /*+ INDEX(f FII_AR_NET_REC'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/
543: v.viewby VIEWBY,
544: v.viewby_code VIEWBYID,
545: NULL FII_AR_UNAPP_RCT_AMT,
546: NULL UNID_AMOUNT,

Line 560: fii_ar_util_pkg.get_from_statement ||

556: l_net_rec_bucket_sql || l_cust_clause || '
557: FROM fii_ar_net_rec'||l_cust_suffix||'_mv'||l_curr_suffix||' f,
558: (SELECT /*+ no_merge '||l_gt_hint|| ' */ *
559: FROM fii_time_structures cal, '||
560: fii_ar_util_pkg.get_from_statement ||
561: ' gt WHERE cal.report_date = :ASOF_DATE
562: AND (bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
563: OR bitand(cal.record_type_id, :BITAND_ROLLING_30_DAYS) = :BITAND_ROLLING_30_DAYS)
564: AND '|| fii_ar_util_pkg.get_where_statement || ') v

Line 564: AND '|| fii_ar_util_pkg.get_where_statement || ') v

560: fii_ar_util_pkg.get_from_statement ||
561: ' gt WHERE cal.report_date = :ASOF_DATE
562: AND (bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
563: OR bitand(cal.record_type_id, :BITAND_ROLLING_30_DAYS) = :BITAND_ROLLING_30_DAYS)
564: AND '|| fii_ar_util_pkg.get_where_statement || ') v
565: WHERE f.time_id = v.time_id
566: AND f.period_type_id = v.period_type_id
567: AND f.org_id = v.org_id
568: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_where_clause ||

Line 568: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_where_clause ||

564: AND '|| fii_ar_util_pkg.get_where_statement || ') v
565: WHERE f.time_id = v.time_id
566: AND f.period_type_id = v.period_type_id
567: AND f.org_id = v.org_id
568: AND '||fii_ar_util_pkg.get_mv_where_statement||' '||l_where_clause ||
569: ' GROUP BY v.viewby, v.viewby_code ' || l_cust_clause;
570:
571:
572: l_sqlstmt :=

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

570:
571:
572: l_sqlstmt :=
573: l_sqlstmt || ' union all '||
574: 'SELECT /*+ INDEX(f FII_AR_RCT_AGING'|| fii_ar_util_pkg.g_cust_suffix ||'_mv_N1)*/
575: v.viewby VIEWBY,
576: v.viewby_code VIEWBYID,
577: sum(f.total_unapplied_amount) FII_AR_UNAPP_RCT_AMT,
578: sum(f.unid_amount) UNID_AMOUNT,

Line 588: fii_ar_util_pkg.get_from_statement ||

584: l_bucket_sql || l_cust_clause || '
585: FROM fii_ar_rct_aging'||l_cust_suffix||'_mv'||l_curr_suffix||' f,
586: ( SELECT /*+ no_merge '||l_gt_hint|| ' */ *
587: FROM fii_time_structures cal, '||
588: fii_ar_util_pkg.get_from_statement ||
589: ' gt WHERE cal.report_date = :ASOF_DATE
590: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
591: AND '|| fii_ar_util_pkg.get_where_statement || ') v
592: WHERE f.time_id = v.time_id

Line 591: AND '|| fii_ar_util_pkg.get_where_statement || ') v

587: FROM fii_time_structures cal, '||
588: fii_ar_util_pkg.get_from_statement ||
589: ' gt WHERE cal.report_date = :ASOF_DATE
590: AND bitand(cal.record_type_id, :BITAND_INC_TODATE) = :BITAND_INC_TODATE
591: AND '|| fii_ar_util_pkg.get_where_statement || ') v
592: WHERE f.time_id = v.time_id
593: AND f.period_type_id = v.period_type_id
594: AND f.org_id = v.org_id
595: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' ' || l_where_clause ||

Line 595: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' ' || l_where_clause ||

591: AND '|| fii_ar_util_pkg.get_where_statement || ') v
592: WHERE f.time_id = v.time_id
593: AND f.period_type_id = v.period_type_id
594: AND f.org_id = v.org_id
595: AND '||fii_ar_util_pkg.get_rct_mv_where_statement||' ' || l_where_clause ||
596: ' GROUP BY v.viewby, v.viewby_code ' || l_cust_clause || ') inner_view
597: GROUP BY viewby, viewbyid ' || l_cust_clause2
598: || l_order_by_clause;
599:

Line 600: FII_AR_UTIL_PKG.Bind_Variable(

596: ' GROUP BY v.viewby, v.viewby_code ' || l_cust_clause || ') inner_view
597: GROUP BY viewby, viewbyid ' || l_cust_clause2
598: || l_order_by_clause;
599:
600: FII_AR_UTIL_PKG.Bind_Variable(
601: p_sqlstmt => l_sqlstmt,
602: p_page_parameter_tbl => p_page_parameter_tbl,
603: p_sql_output => unapp_rct_sql,
604: p_bind_output_table => unapp_rct_output);