APPS.ARP_CMERGE_MASTER dependencies on HZ_CUSTOMER_PROFILES

Line 2486: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both

2482: AND acct.status = 'A' );
2483:
2484: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');
2485:
2486: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2487: * ---acct and site level */
2488: UPDATE hz_customer_profiles yt
2489: SET status = 'I',
2490: last_update_date = sysdate,

Line 2488: UPDATE hz_customer_profiles yt

2484: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');
2485:
2486: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2487: * ---acct and site level */
2488: UPDATE hz_customer_profiles yt
2489: SET status = 'I',
2490: last_update_date = sysdate,
2491: last_updated_by = hz_utility_v2pub.user_id,
2492: last_update_login = hz_utility_v2pub.last_update_login,

Line 2501: UPDATE hz_customer_profiles yt --5634398

2497: WHERE yt.cust_account_id = from_customer_id
2498: AND status = 'D'
2499: AND part_delete = 'N'; --5747129
2500:
2501: UPDATE hz_customer_profiles yt --5634398
2502: SET status = 'A',
2503: last_update_date = sysdate,
2504: last_updated_by = arp_standard.profile.user_id,
2505: last_update_login = arp_standard.profile.last_update_login,

Line 2516: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUSTOMER_PROFILES');

2512: AND yt.cust_account_id = from_customer_id
2513: AND site_use_id is NULL ;
2514:
2515:
2516: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUSTOMER_PROFILES');
2517:
2518:
2519: /* ---Profile amts in ar_cpa are not getting Inactivated
2520: ---so delete duplicate flag in merge table can handle that */