APPS.FII_AR_PAID_REC_DTL_PKG dependencies on FII_AR_UTIL_PKG

Line 40: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

36:
37: BEGIN
38:
39: -- Reads the parameters from the parameter portlet
40: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
41:
42: --Logic for sorting
43: l_order_by_util := fii_ar_util_pkg.g_order_by;
44:

Line 43: l_order_by_util := fii_ar_util_pkg.g_order_by;

39: -- Reads the parameters from the parameter portlet
40: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
41:
42: --Logic for sorting
43: l_order_by_util := fii_ar_util_pkg.g_order_by;
44:
45: IF instr(substr(l_order_by_util,-3), 'ASC') <> 0 THEN
46: -- Ascending order sorting on any column
47: l_order_by := '&ORDER_BY_CLAUSE';

Line 64: l_col_curr_suffix := fii_ar_util_pkg.g_col_curr_suffix;

60: l_order_column := substr(l_order_by_util,1,instr(l_order_by_util, ' DESC'));
61: l_order_by := 'ORDER BY NVL('|| l_order_column ||', -999999999) DESC';
62: END IF;
63:
64: l_col_curr_suffix := fii_ar_util_pkg.g_col_curr_suffix;
65:
66: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;
67:
68: -- Constructing the pmv sql query

Line 313: fii_ar_util_pkg.bind_variable(

309: AND outer_inner_query.bill_to_customer_id = hzca.cust_account_id
310: ' || l_order_by;
311:
312: -- Calling the bind_variable API
313: fii_ar_util_pkg.bind_variable(
314: p_sqlstmt => sqlstmt,
315: p_page_parameter_tbl => p_page_parameter_tbl,
316: p_sql_output => p_paid_rec_dtl_sql,
317: p_bind_output_table => p_paid_rec_dtl_output