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.42.12020000.3 2012/07/10 00:44:11 dgaurab ship $ */
3:
4: pg_reference_column VARCHAR2(240);
5:

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

1380: BEGIN
1381: --Bug fix form 5589303, if the billing_date is not null, billing date shall be passed to calculate due date
1382:
1383: SELECT NVL(MIN(ps.due_date),
1384: arpt_sql_func_util.get_first_due_date(p_term_id, nvl(ct.billing_date, p_trx_date)))
1385: INTO l_term_due_date
1386: FROM ar_payment_schedules ps,
1387: ra_customer_trx ct
1388: WHERE ct.customer_trx_id=ps.customer_trx_id(+)

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

2879: BEGIN
2880: SELECT statement_cycle_id
2881: INTO l_cycle_id
2882: FROM hz_customer_profiles
2883: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);
2884:
2885: RETURN l_cycle_id;
2886: END;
2887:

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

2894: BEGIN
2895: SELECT nvl(send_statements ,'N')
2896: INTO l_send
2897: FROM hz_customer_profiles
2898: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);
2899:
2900: RETURN l_send;
2901: END;
2902:

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

2909: BEGIN
2910: SELECT nvl(credit_balance_statements ,'N')
2911: INTO l_cred_bal
2912: FROM hz_customer_profiles
2913: WHERE site_use_id = arpt_sql_func_util.get_bill_id(p_site_use_id);
2914:
2915: RETURN l_cred_bal;
2916: END;
2917:

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

2950: l_currency_code VARCHAR2(15);
2951: l_return_status VARCHAR2(1);
2952:
2953: BEGIN
2954: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()+');
2955: OZF_Claim_Install.get_amount_remaining (
2956: p_claim_id => p_claim_id,
2957: x_amount_remaining => l_amount_remaining,
2958: x_acctd_amount_remaining => l_acctd_amount_remaining,

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

2965: ELSE
2966: RETURN l_amount_remaining;
2967: END IF;
2968:
2969: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');
2970: EXCEPTION
2971: WHEN OTHERS THEN
2972: arp_standard.debug('Unexpected error '||sqlerrm||
2973: ' occurred in ARPT_SQL_FUNC_UTIL.get_claim_amount');

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

2969: arp_standard.debug('ARPT_SQL_FUNC_UTIL.get_claim_amount()-');
2970: EXCEPTION
2971: WHEN OTHERS THEN
2972: arp_standard.debug('Unexpected error '||sqlerrm||
2973: ' occurred in ARPT_SQL_FUNC_UTIL.get_claim_amount');
2974: RAISE;
2975: END get_claim_amount;
2976:
2977: /* Bug3820605 */

Line 3155: END ARPT_SQL_FUNC_UTIL;

3151: into l_curr from dual;
3152: return(l_curr);
3153: END GET_CURRENCY_CODE;
3154:
3155: END ARPT_SQL_FUNC_UTIL;