APPS.ARP_CMERGE_MASTER dependencies on HZ_CUSTOMER_PROFILES

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

2475: AND acct.status = 'A' );
2476:
2477: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');
2478:
2479: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2480: * ---acct and site level */
2481: UPDATE hz_customer_profiles yt
2482: SET status = 'I',
2483: last_update_date = sysdate,

Line 2481: UPDATE hz_customer_profiles yt

2477: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');
2478:
2479: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2480: * ---acct and site level */
2481: UPDATE hz_customer_profiles yt
2482: SET status = 'I',
2483: last_update_date = sysdate,
2484: last_updated_by = hz_utility_v2pub.user_id,
2485: last_update_login = hz_utility_v2pub.last_update_login,

Line 2494: UPDATE hz_customer_profiles yt --5634398

2490: WHERE yt.cust_account_id = from_customer_id
2491: AND status = 'D'
2492: AND part_delete = 'N'; --5747129
2493:
2494: UPDATE hz_customer_profiles yt --5634398
2495: SET status = 'A',
2496: last_update_date = sysdate,
2497: last_updated_by = arp_standard.profile.user_id,
2498: last_update_login = arp_standard.profile.last_update_login,

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

2505: AND yt.cust_account_id = from_customer_id
2506: AND site_use_id is NULL ;
2507:
2508:
2509: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUSTOMER_PROFILES');
2510:
2511:
2512: /* ---Profile amts in ar_cpa are not getting Inactivated
2513: ---so delete duplicate flag in merge table can handle that */