DBA Data[Home] [Help]

APPS.AR_DEPOSIT_LIB_PVT dependencies on ARP_TRX_DEFAULTS_3

Line 1444: l_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;

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

Line 1445: l_dft_remit_to_address_rec ARP_TRX_DEFAULTS_3.address_rec_type;

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

Line 2318: ARP_TRX_DEFAULTS_3.get_default_remit_to(l_dft_remit_to_address_id,

2314: IF p_cust_location_site_num is NULL
2315: THEN
2316: arp_util.debug('p_cust_location_site_num is null, hence defaulted');
2317: begin
2318: ARP_TRX_DEFAULTS_3.get_default_remit_to(l_dft_remit_to_address_id,
2319: l_dft_remit_to_address_rec);
2320: x_remit_to_address_id := l_dft_remit_to_address_id;
2321: exception
2322: when others then

Line 2330: ARP_TRX_DEFAULTS_3.get_remit_to_address(l_match_state,

2326: end;
2327: ELSE
2328: arp_util.debug('p_cust_location_site_num is not null, hence fetching');
2329: Begin
2330: ARP_TRX_DEFAULTS_3.get_remit_to_address(l_match_state,
2331: l_match_country,
2332: l_match_postal_code,
2333: p_cust_location_site_num,
2334: --customer location site number