DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on ARP_TRX_DEFAULTS_3

Line 1446: l_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;

1442: l_get_x_val_return_status VARCHAR2(1);
1443: l_dummy_return_status VARCHAR2(1);
1444: l_site_use_return_status VARCHAR2(1);
1445: l_contact_return_status VARCHAR2(1);
1446: l_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;
1447: l_dft_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;
1448: l_dft_remit_to_address_id NUMBER ;
1449: l_remit_to_address_id NUMBER;
1450: l_match_state hz_locations.state%type;

Line 1447: l_dft_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;

1443: l_dummy_return_status VARCHAR2(1);
1444: l_site_use_return_status VARCHAR2(1);
1445: l_contact_return_status VARCHAR2(1);
1446: l_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;
1447: l_dft_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;
1448: l_dft_remit_to_address_id NUMBER ;
1449: l_remit_to_address_id NUMBER;
1450: l_match_state hz_locations.state%type;
1451: l_match_country hz_locations.country%type;

Line 2344: ARP_TRX_DEFAULTS_3.get_default_remit_to(l_dft_remit_to_address_id,

2340: IF p_cust_location_site_num is NULL AND l_match_site_use_id is NULL
2341: THEN
2342: arp_util.debug('p_cust_location_site_num is null, hence defaulted');
2343: begin
2344: ARP_TRX_DEFAULTS_3.get_default_remit_to(l_dft_remit_to_address_id,
2345: l_dft_remit_to_address_rec);
2346: x_remit_to_address_id := l_dft_remit_to_address_id;
2347: exception
2348: when others then

Line 2356: ARP_TRX_DEFAULTS_3.get_remit_to_address(l_match_state,

2352: end;
2353: ELSE
2354: arp_util.debug('p_cust_location_site_num is not null, hence fetching');
2355: Begin
2356: ARP_TRX_DEFAULTS_3.get_remit_to_address(l_match_state,
2357: l_match_country,
2358: l_match_postal_code,
2359: p_cust_location_site_num,
2360: --customer location site number