APPS.FII_AR_TRX_ACT_DTL_PKG dependencies on FII_AR_UTIL_PKG

Line 46: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

42:
43: BEGIN
44:
45: -- Reads the parameters from the parameter portlet
46: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
47:
48: -- Defaulting the View By to OU
49: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
50:

Line 49: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';

45: -- Reads the parameters from the parameter portlet
46: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
47:
48: -- Defaulting the View By to OU
49: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
50:
51: -- Populates the security related global temporary tables (fii_ar_summary_gt)
52: fii_ar_util_pkg.populate_summary_gt_tables;
53:

Line 52: fii_ar_util_pkg.populate_summary_gt_tables;

48: -- Defaulting the View By to OU
49: fii_ar_util_pkg.g_view_by := 'ORGANIZATION+FII_OPERATING_UNITS';
50:
51: -- Populates the security related global temporary tables (fii_ar_summary_gt)
52: fii_ar_util_pkg.populate_summary_gt_tables;
53:
54: --Logic for sorting
55: l_order_by_util := fii_ar_util_pkg.g_order_by;
56:

Line 55: l_order_by_util := fii_ar_util_pkg.g_order_by;

51: -- Populates the security related global temporary tables (fii_ar_summary_gt)
52: fii_ar_util_pkg.populate_summary_gt_tables;
53:
54: --Logic for sorting
55: l_order_by_util := fii_ar_util_pkg.g_order_by;
56:
57: IF instr(substr(l_order_by_util,-3), 'ASC') <> 0 THEN
58: -- Ascending order sorting on any column
59: l_order_by := '&ORDER_BY_CLAUSE';

Line 76: l_cust_account := fii_ar_util_pkg.g_cust_account;

72: l_order_column := substr(l_order_by_util,1,instr(l_order_by_util, ' DESC'));
73: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
74: END IF;
75:
76: l_cust_account := fii_ar_util_pkg.g_cust_account;
77:
78: -- Adding filter when one or multiple customers selected but not All
79: IF fii_ar_util_pkg.g_party_id <> '-111' THEN
80: l_where_clause := l_where_clause || ' AND hzca.party_id = gt.party_id AND hzca.party_id = :PARTY_ID';

Line 79: IF fii_ar_util_pkg.g_party_id <> '-111' THEN

75:
76: l_cust_account := fii_ar_util_pkg.g_cust_account;
77:
78: -- Adding filter when one or multiple customers selected but not All
79: IF fii_ar_util_pkg.g_party_id <> '-111' THEN
80: l_where_clause := l_where_clause || ' AND hzca.party_id = gt.party_id AND hzca.party_id = :PARTY_ID';
81: END IF;
82:
83: -- Adding filter when a single collector is selected

Line 84: IF fii_ar_util_pkg.g_collector_id <> '-111' THEN

80: l_where_clause := l_where_clause || ' AND hzca.party_id = gt.party_id AND hzca.party_id = :PARTY_ID';
81: END IF;
82:
83: -- Adding filter when a single collector is selected
84: IF fii_ar_util_pkg.g_collector_id <> '-111' THEN
85: l_from_clause := ', fii_collectors coll';
86: l_where_clause := l_where_clause
87: || ' AND coll.collector_id = gt.collector_id
88: AND coll.site_use_id = f.bill_to_site_use_id

Line 93: IF fii_ar_util_pkg.g_industry_id <> '-111' THEN

89: AND coll.cust_account_id = f.bill_to_customer_id';
90: END IF;
91:
92: -- Adding filter when a single industry is selected
93: IF fii_ar_util_pkg.g_industry_id <> '-111' THEN
94: l_from_clause := l_from_clause || ' , fii_party_mkt_class ind';
95: l_where_clause := l_where_clause || ' AND ind.class_code = gt.class_code
96: AND ind.party_id = hzca.party_id
97: AND hzca.cust_account_id = f.bill_to_customer_id';

Line 106: l_function_name := fii_ar_util_pkg.g_function_name;

102: ELSE
103: l_where_clause := l_where_clause || ' AND f.bill_to_customer_id = :CUST_ACCOUNT';
104: END IF;
105:
106: l_function_name := fii_ar_util_pkg.g_function_name;
107:
108: l_col_curr_suffix := fii_ar_util_pkg.g_col_curr_suffix;
109:
110: l_balance_col := '

Line 108: l_col_curr_suffix := fii_ar_util_pkg.g_col_curr_suffix;

104: END IF;
105:
106: l_function_name := fii_ar_util_pkg.g_function_name;
107:
108: l_col_curr_suffix := fii_ar_util_pkg.g_col_curr_suffix;
109:
110: l_balance_col := '
111: sum(ag.current_bucket_1_amount' || l_col_curr_suffix || '
112: + ag.current_bucket_2_amount' || l_col_curr_suffix || '

Line 278: fii_ar_util_pkg.bind_variable(

274: AND outer_inner_query.order_ref_number = to_char(ooh.order_number(+))
275: ' || l_order_by;
276:
277: -- Calling the bind_variable API
278: fii_ar_util_pkg.bind_variable(
279: p_sqlstmt => sqlstmt,
280: p_page_parameter_tbl => p_page_parameter_tbl,
281: p_sql_output => p_trx_act_dtl_sql,
282: p_bind_output_table => p_trx_act_dtl_output