APPS.FII_AR_TRX_ACT_HISTORY_PKG dependencies on FII_AR_UTIL_PKG

Line 22: fii_ar_util_pkg.reset_globals;

18: l_cust_all VARCHAR2(30);
19:
20: BEGIN
21: --Call to reset the parameter variables
22: fii_ar_util_pkg.reset_globals;
23:
24: --Call to get all the parameters in the report
25: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
26:

Line 25: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);

21: --Call to reset the parameter variables
22: fii_ar_util_pkg.reset_globals;
23:
24: --Call to get all the parameters in the report
25: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
26:
27: /* Changes for bug 5086091
28:
29: 1. Changed the query to use Applied_customer_trx_id and not customer_trx_id in case of Receipts

Line 40: IF fii_ar_util_pkg.g_tran_class = 'CM' THEN

36: l_drill := 'pFunctionName=FII_AR_APP_RCT_DTL&TRX_NUM=FII_AR_CUST_TRX_ID&BIS_PMV_DRILL_CODE_CUSTOMER+FII_CUSTOMERS='||l_cust_all||'&FII_AR_CASH_RECEIPT_ID=''||inline.FII_AR_CASH_RECEIPT_ID||''&pParamIds=Y';
37:
38: l_app_rec_drill := 'DECODE(inline.LOOKUP_CODE, ''RECEIPT'', '''||l_drill||''')';
39:
40: IF fii_ar_util_pkg.g_tran_class = 'CM' THEN
41: l_trx_id_join := 'customer_trx_id = :CUST_TRX_ID and';
42: ELSE
43: l_trx_id_join := 'applied_customer_trx_id = :CUST_TRX_ID and';
44: END IF;

Line 174: fii_ar_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, trx_act_history_sql, trx_act_history_output);

170: and lookup.language = userenv(''LANG'')
171:
172: &ORDER_BY_CLAUSE';
173:
174: fii_ar_util_pkg.bind_variable(sqlstmt, p_page_parameter_tbl, trx_act_history_sql, trx_act_history_output);
175:
176: END get_trx_act_history;
177:
178: END FII_AR_TRX_ACT_HISTORY_PKG;