[Home] [Help]
1: PACKAGE BODY hz_customer_int AS
2: /*$Header: ARHCUSIB.pls 120.28.12020000.5 2013/03/28 23:25:16 awu ship $*/
3:
4: -- The following varibles and types are added for bug 2460837.
5:
3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID
3507: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3508: from ra_customers_interface_all rci, -- Bug 4956131
3509: hz_parties hzp
3510: WHERE hzp.party_id = HZ_CUSTOMER_INT.get_account_party_id(rci.orig_system_party_ref,rci.person_flag,'P')
3511: AND rci.request_id = p_request_id
3512: AND rci.interface_status is null
3513: AND rci.insert_update_flag = 'I'
3514: AND ( rci.rowid = (SELECT min(i2.rowid)
3613: EXCEPTION
3614: WHEN OTHERS THEN
3615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3616: x_msg_data := SQLERRM;
3617: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in HZ_CUSTOMER_INT.sync_tax_reference : ' || SQLERRM);
3618:
3619:
3620: END sync_tax_reference;
3621:
4032:
4033: PROCEDURE delete_success_records IS
4034: BEGIN
4035:
4036: FND_FILE.put_line(fnd_file.log,'HZ_CUSTOMER_INT.delete_success_records +');
4037:
4038: DELETE FROM ra_customers_interface
4039: WHERE interface_status is NULL;
4040:
4066:
4067: UPDATE ra_customer_banks_interface
4068: SET request_id = NULL;
4069:
4070: FND_FILE.put_line(fnd_file.log,'HZ_CUSTOMER_INT.delete_success_records -');
4071:
4072: END delete_success_records;
4073:
4074: -- enh 14181243
4232: where instrument_payment_use_id = s_instrument_payment_use_id(i);
4233:
4234: END update_bank_priority;
4235:
4236: END hz_customer_int;