APPS.ARP_CORRECT_CC_ERRORS dependencies on AR_COLLECTORS

Line 136: l_collector_name ar_collectors.name%TYPE;

132: FUNCTION get_collector_name (
133: p_customer_id IN NUMBER,
134: p_customer_site_use_id IN NUMBER)
135: RETURN VARCHAR2 IS
136: l_collector_name ar_collectors.name%TYPE;
137: l_collector_id NUMBER;
138: BEGIN
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()+' );

Line 149: FROM ar_collectors

145: prof.site_use_id = p_customer_site_use_id;
146:
147: SELECT name
148: INTO l_collector_name
149: FROM ar_collectors
150: WHERE collector_id = l_collector_id;
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );

Line 165: FROM ar_collectors

161: prof.site_use_id is NULL;
162:
163: SELECT name
164: INTO l_collector_name
165: FROM ar_collectors
166: WHERE collector_id = l_collector_id;
167: IF PG_DEBUG in ('Y', 'C') THEN
168: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.get_collector_name()-' );
169: END IF;

Line 555: l_collector ar_collectors.name%TYPE;

551: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
552: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;
553: l_payment_server_id ra_customer_trx.payment_server_order_num%TYPE;
554: l_approval_code ra_customer_trx.approval_code%TYPE;
555: l_collector ar_collectors.name%TYPE;
556: l_payment_method_name ar_receipt_methods.name%TYPE;
557: l_days_late NUMBER;
558: l_billto_contact varchar2(150);
559: l_salesrep_name ra_salesreps.name%TYPE;

Line 2139: l_collector ar_collectors.name%TYPE;

2135: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
2136: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;
2137: l_payment_server_id ar_cash_receipts.payment_server_order_num%TYPE;
2138: l_approval_code ra_customer_trx.approval_code%TYPE;
2139: l_collector ar_collectors.name%TYPE;
2140: l_payment_method_name ar_receipt_methods.name%TYPE;
2141: PAY_exception EXCEPTION;
2142:
2143: BEGIN