APPS.ARPT_SQL_FUNC_UTIL dependencies on ARPT_SQL_FUNC_UTIL

Line 1: PACKAGE BODY ARPT_SQL_FUNC_UTIL AS

1: PACKAGE BODY ARPT_SQL_FUNC_UTIL AS
2: /* $Header: ARTUSSFB.pls 120.39 2006/10/12 23:21:51 arnkumar ship $ */
3:
4: pg_reference_column VARCHAR2(240);
5:

Line 1294: arpt_sql_func_util.get_first_due_date(p_term_id, nvl(ct.billing_date, p_trx_date)))

1290: BEGIN
1291: --Bug fix form 5589303, if the billing_date is not null, billing date shall be passed to calculate due date
1292:
1293: SELECT NVL(MIN(ps.due_date),
1294: arpt_sql_func_util.get_first_due_date(p_term_id, nvl(ct.billing_date, p_trx_date)))
1295: INTO l_term_due_date
1296: FROM ar_payment_schedules ps,
1297: ra_customer_trx ct
1298: WHERE ct.customer_trx_id=ps.customer_trx_id(+)

Line 2764: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);

2760: BEGIN
2761: SELECT statement_cycle_id
2762: INTO l_cycle_id
2763: FROM hz_customer_profiles
2764: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);
2765:
2766: RETURN l_cycle_id;
2767: END;
2768:

Line 2779: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);

2775: BEGIN
2776: SELECT nvl(send_statements ,'N')
2777: INTO l_send
2778: FROM hz_customer_profiles
2779: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);
2780:
2781: RETURN l_send;
2782: END;
2783:

Line 2794: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);

2790: BEGIN
2791: SELECT nvl(credit_balance_statements ,'N')
2792: INTO l_cred_bal
2793: FROM hz_customer_profiles
2794: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);
2795:
2796: RETURN l_cred_bal;
2797: END;
2798:

Line 2835: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()+');

2831: l_currency_code VARCHAR2(15);
2832: l_return_status VARCHAR2(1);
2833:
2834: BEGIN
2835: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()+');
2836: OZF_Claim_Install.get_amount_remaining (
2837: p_claim_id => p_claim_id,
2838: x_amount_remaining => l_amount_remaining,
2839: x_acctd_amount_remaining => l_acctd_amount_remaining,

Line 2850: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');

2846: ELSE
2847: RETURN l_amount_remaining;
2848: END IF;
2849:
2850: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: arp_standard.debug('Unexpected error '||sqlerrm||
2854: ' occurred in ARPT_SQL_FUNC_UTIL.get_claim_amount');

Line 2854: ' occurred in ARPT_SQL_FUNC_UTIL.get_claim_amount');

2850: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');
2851: EXCEPTION
2852: WHEN OTHERS THEN
2853: arp_standard.debug('Unexpected error '||sqlerrm||
2854: ' occurred in ARPT_SQL_FUNC_UTIL.get_claim_amount');
2855: RAISE;
2856: END get_claim_amount;
2857:
2858: /* Bug3820605 */

Line 3035: END ARPT_SQL_FUNC_UTIL;

3031: into l_curr from dual;
3032: return(l_curr);
3033: END GET_CURRENCY_CODE;
3034:
3035: END ARPT_SQL_FUNC_UTIL;