eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CMERGE_MASTER dependencies on HZ_UTILITY_V2PUB

Line 1767: last_updated_by = hz_utility_v2pub.user_id,

1763:
1764: UPDATE ra_customer_merges
1765: SET process_flag = 'Y',
1766: last_update_date = sysdate,
1767: last_updated_by = hz_utility_v2pub.user_id,
1768: last_update_login = hz_utility_v2pub.last_update_login,
1769: program_application_id = hz_utility_v2pub.program_application_id,
1770: program_id = hz_utility_v2pub.program_id,
1771: program_update_date = sysdate

Line 1768: last_update_login = hz_utility_v2pub.last_update_login,

1764: UPDATE ra_customer_merges
1765: SET process_flag = 'Y',
1766: last_update_date = sysdate,
1767: last_updated_by = hz_utility_v2pub.user_id,
1768: last_update_login = hz_utility_v2pub.last_update_login,
1769: program_application_id = hz_utility_v2pub.program_application_id,
1770: program_id = hz_utility_v2pub.program_id,
1771: program_update_date = sysdate
1772: WHERE request_id = req_id

Line 1769: program_application_id = hz_utility_v2pub.program_application_id,

1765: SET process_flag = 'Y',
1766: last_update_date = sysdate,
1767: last_updated_by = hz_utility_v2pub.user_id,
1768: last_update_login = hz_utility_v2pub.last_update_login,
1769: program_application_id = hz_utility_v2pub.program_application_id,
1770: program_id = hz_utility_v2pub.program_id,
1771: program_update_date = sysdate
1772: WHERE request_id = req_id
1773: AND set_number = set_num

Line 1770: program_id = hz_utility_v2pub.program_id,

1766: last_update_date = sysdate,
1767: last_updated_by = hz_utility_v2pub.user_id,
1768: last_update_login = hz_utility_v2pub.last_update_login,
1769: program_application_id = hz_utility_v2pub.program_application_id,
1770: program_id = hz_utility_v2pub.program_id,
1771: program_update_date = sysdate
1772: WHERE request_id = req_id
1773: AND set_number = set_num
1774: AND process_flag = 'N';

Line 1879: last_updated_by = hz_utility_v2pub.user_id,

1875: -- set_number = null,
1876: -- request_id = null,
1877: process_flag = 'SAVED',
1878: last_update_date = sysdate,
1879: last_updated_by = hz_utility_v2pub.user_id,
1880: last_update_login = hz_utility_v2pub.last_update_login,
1881: program_application_id = hz_utility_v2pub.program_application_id,
1882: program_id = hz_utility_v2pub.program_id,
1883: program_update_date = sysdate

Line 1880: last_update_login = hz_utility_v2pub.last_update_login,

1876: -- request_id = null,
1877: process_flag = 'SAVED',
1878: last_update_date = sysdate,
1879: last_updated_by = hz_utility_v2pub.user_id,
1880: last_update_login = hz_utility_v2pub.last_update_login,
1881: program_application_id = hz_utility_v2pub.program_application_id,
1882: program_id = hz_utility_v2pub.program_id,
1883: program_update_date = sysdate
1884: WHERE request_id = req_id

Line 1881: program_application_id = hz_utility_v2pub.program_application_id,

1877: process_flag = 'SAVED',
1878: last_update_date = sysdate,
1879: last_updated_by = hz_utility_v2pub.user_id,
1880: last_update_login = hz_utility_v2pub.last_update_login,
1881: program_application_id = hz_utility_v2pub.program_application_id,
1882: program_id = hz_utility_v2pub.program_id,
1883: program_update_date = sysdate
1884: WHERE request_id = req_id
1885: AND set_number = set_num

Line 1882: program_id = hz_utility_v2pub.program_id,

1878: last_update_date = sysdate,
1879: last_updated_by = hz_utility_v2pub.user_id,
1880: last_update_login = hz_utility_v2pub.last_update_login,
1881: program_application_id = hz_utility_v2pub.program_application_id,
1882: program_id = hz_utility_v2pub.program_id,
1883: program_update_date = sysdate
1884: WHERE request_id = req_id
1885: AND set_number = set_num
1886: AND process_flag = p_process_flag;

Line 1932: last_updated_by = hz_utility_v2pub.user_id,

1928: -- set_number = null,
1929: -- request_id = null,
1930: process_flag = 'FAILED',
1931: last_update_date = sysdate,
1932: last_updated_by = hz_utility_v2pub.user_id,
1933: last_update_login = hz_utility_v2pub.last_update_login,
1934: program_application_id = hz_utility_v2pub.program_application_id,
1935: program_id = hz_utility_v2pub.program_id,
1936: program_update_date = sysdate

Line 1933: last_update_login = hz_utility_v2pub.last_update_login,

1929: -- request_id = null,
1930: process_flag = 'FAILED',
1931: last_update_date = sysdate,
1932: last_updated_by = hz_utility_v2pub.user_id,
1933: last_update_login = hz_utility_v2pub.last_update_login,
1934: program_application_id = hz_utility_v2pub.program_application_id,
1935: program_id = hz_utility_v2pub.program_id,
1936: program_update_date = sysdate
1937: WHERE request_id = req_id

Line 1934: program_application_id = hz_utility_v2pub.program_application_id,

1930: process_flag = 'FAILED',
1931: last_update_date = sysdate,
1932: last_updated_by = hz_utility_v2pub.user_id,
1933: last_update_login = hz_utility_v2pub.last_update_login,
1934: program_application_id = hz_utility_v2pub.program_application_id,
1935: program_id = hz_utility_v2pub.program_id,
1936: program_update_date = sysdate
1937: WHERE request_id = req_id
1938: AND set_number = set_num

Line 1935: program_id = hz_utility_v2pub.program_id,

1931: last_update_date = sysdate,
1932: last_updated_by = hz_utility_v2pub.user_id,
1933: last_update_login = hz_utility_v2pub.last_update_login,
1934: program_application_id = hz_utility_v2pub.program_application_id,
1935: program_id = hz_utility_v2pub.program_id,
1936: program_update_date = sysdate
1937: WHERE request_id = req_id
1938: AND set_number = set_num
1939: AND process_flag = p_process_flag;

Line 2038: last_updated_by = hz_utility_v2pub.user_id,

2034: 'ERROR 1', 'FAILED',
2035: 'ERROR 2', 'FAILED'),
2036: -- request_id = null,
2037: last_update_date = sysdate,
2038: last_updated_by = hz_utility_v2pub.user_id,
2039: last_update_login = hz_utility_v2pub.last_update_login,
2040: program_application_id = hz_utility_v2pub.program_application_id,
2041: program_id = hz_utility_v2pub.program_id,
2042: program_update_date = sysdate

Line 2039: last_update_login = hz_utility_v2pub.last_update_login,

2035: 'ERROR 2', 'FAILED'),
2036: -- request_id = null,
2037: last_update_date = sysdate,
2038: last_updated_by = hz_utility_v2pub.user_id,
2039: last_update_login = hz_utility_v2pub.last_update_login,
2040: program_application_id = hz_utility_v2pub.program_application_id,
2041: program_id = hz_utility_v2pub.program_id,
2042: program_update_date = sysdate
2043: WHERE process_flag in ('ERROR 1', 'ERROR 2')

Line 2040: program_application_id = hz_utility_v2pub.program_application_id,

2036: -- request_id = null,
2037: last_update_date = sysdate,
2038: last_updated_by = hz_utility_v2pub.user_id,
2039: last_update_login = hz_utility_v2pub.last_update_login,
2040: program_application_id = hz_utility_v2pub.program_application_id,
2041: program_id = hz_utility_v2pub.program_id,
2042: program_update_date = sysdate
2043: WHERE process_flag in ('ERROR 1', 'ERROR 2')
2044: AND request_id = req_id;

Line 2041: program_id = hz_utility_v2pub.program_id,

2037: last_update_date = sysdate,
2038: last_updated_by = hz_utility_v2pub.user_id,
2039: last_update_login = hz_utility_v2pub.last_update_login,
2040: program_application_id = hz_utility_v2pub.program_application_id,
2041: program_id = hz_utility_v2pub.program_id,
2042: program_update_date = sysdate
2043: WHERE process_flag in ('ERROR 1', 'ERROR 2')
2044: AND request_id = req_id;
2045:

Line 2345: last_updated_by = hz_utility_v2pub.user_id,

2341: --undo
2342: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2343: SET status = 'I',
2344: last_update_date = sysdate,
2345: last_updated_by = hz_utility_v2pub.user_id,
2346: last_update_login = hz_utility_v2pub.last_update_login,
2347: request_id = req_id,
2348: program_application_id = hz_utility_v2pub.program_application_id,
2349: program_id = hz_utility_v2pub.program_id,

Line 2346: last_update_login = hz_utility_v2pub.last_update_login,

2342: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2343: SET status = 'I',
2344: last_update_date = sysdate,
2345: last_updated_by = hz_utility_v2pub.user_id,
2346: last_update_login = hz_utility_v2pub.last_update_login,
2347: request_id = req_id,
2348: program_application_id = hz_utility_v2pub.program_application_id,
2349: program_id = hz_utility_v2pub.program_id,
2350: program_update_date = sysdate

Line 2348: program_application_id = hz_utility_v2pub.program_application_id,

2344: last_update_date = sysdate,
2345: last_updated_by = hz_utility_v2pub.user_id,
2346: last_update_login = hz_utility_v2pub.last_update_login,
2347: request_id = req_id,
2348: program_application_id = hz_utility_v2pub.program_application_id,
2349: program_id = hz_utility_v2pub.program_id,
2350: program_update_date = sysdate
2351: WHERE EXISTS
2352: ( select 'Y'

Line 2349: program_id = hz_utility_v2pub.program_id,

2345: last_updated_by = hz_utility_v2pub.user_id,
2346: last_update_login = hz_utility_v2pub.last_update_login,
2347: request_id = req_id,
2348: program_application_id = hz_utility_v2pub.program_application_id,
2349: program_id = hz_utility_v2pub.program_id,
2350: program_update_date = sysdate
2351: WHERE EXISTS
2352: ( select 'Y'
2353: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake

Line 2374: last_updated_by = hz_utility_v2pub.user_id,

2370: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2372: set status = 'I',
2373: last_update_date = sysdate,
2374: last_updated_by = hz_utility_v2pub.user_id,
2375: last_update_login = hz_utility_v2pub.last_update_login,
2376: request_id = req_id,
2377: program_application_id = hz_utility_v2pub.program_application_id,
2378: program_id = hz_utility_v2pub.program_id,

Line 2375: last_update_login = hz_utility_v2pub.last_update_login,

2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2372: set status = 'I',
2373: last_update_date = sysdate,
2374: last_updated_by = hz_utility_v2pub.user_id,
2375: last_update_login = hz_utility_v2pub.last_update_login,
2376: request_id = req_id,
2377: program_application_id = hz_utility_v2pub.program_application_id,
2378: program_id = hz_utility_v2pub.program_id,
2379: program_update_date = sysdate

Line 2377: program_application_id = hz_utility_v2pub.program_application_id,

2373: last_update_date = sysdate,
2374: last_updated_by = hz_utility_v2pub.user_id,
2375: last_update_login = hz_utility_v2pub.last_update_login,
2376: request_id = req_id,
2377: program_application_id = hz_utility_v2pub.program_application_id,
2378: program_id = hz_utility_v2pub.program_id,
2379: program_update_date = sysdate
2380: where addr.cust_account_id = from_customer_id
2381: AND EXISTS (select 'Y' from ra_customer_merges m

Line 2378: program_id = hz_utility_v2pub.program_id,

2374: last_updated_by = hz_utility_v2pub.user_id,
2375: last_update_login = hz_utility_v2pub.last_update_login,
2376: request_id = req_id,
2377: program_application_id = hz_utility_v2pub.program_application_id,
2378: program_id = hz_utility_v2pub.program_id,
2379: program_update_date = sysdate
2380: where addr.cust_account_id = from_customer_id
2381: AND EXISTS (select 'Y' from ra_customer_merges m
2382: where m.request_id = req_id

Line 2398: last_updated_by = hz_utility_v2pub.user_id,

2394: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2395: UPDATE HZ_CUST_ACCOUNTS acct
2396: set status = decode(part_delete,'N','I','A'),
2397: last_update_date = sysdate,
2398: last_updated_by = hz_utility_v2pub.user_id,
2399: last_update_login = hz_utility_v2pub.last_update_login,
2400: request_id = req_id,
2401: program_application_id = hz_utility_v2pub.program_application_id,
2402: program_id = hz_utility_v2pub.program_id,

Line 2399: last_update_login = hz_utility_v2pub.last_update_login,

2395: UPDATE HZ_CUST_ACCOUNTS acct
2396: set status = decode(part_delete,'N','I','A'),
2397: last_update_date = sysdate,
2398: last_updated_by = hz_utility_v2pub.user_id,
2399: last_update_login = hz_utility_v2pub.last_update_login,
2400: request_id = req_id,
2401: program_application_id = hz_utility_v2pub.program_application_id,
2402: program_id = hz_utility_v2pub.program_id,
2403: program_update_date = sysdate

Line 2401: program_application_id = hz_utility_v2pub.program_application_id,

2397: last_update_date = sysdate,
2398: last_updated_by = hz_utility_v2pub.user_id,
2399: last_update_login = hz_utility_v2pub.last_update_login,
2400: request_id = req_id,
2401: program_application_id = hz_utility_v2pub.program_application_id,
2402: program_id = hz_utility_v2pub.program_id,
2403: program_update_date = sysdate
2404: where acct.cust_account_id = from_customer_id
2405: and status ='D';

Line 2402: program_id = hz_utility_v2pub.program_id,

2398: last_updated_by = hz_utility_v2pub.user_id,
2399: last_update_login = hz_utility_v2pub.last_update_login,
2400: request_id = req_id,
2401: program_application_id = hz_utility_v2pub.program_application_id,
2402: program_id = hz_utility_v2pub.program_id,
2403: program_update_date = sysdate
2404: where acct.cust_account_id = from_customer_id
2405: and status ='D';
2406:

Line 2413: last_updated_by = hz_utility_v2pub.user_id,

2409: /*--Unset the status to 'I' for HZ_CUST_ACCT_RELATE cust_account_id */
2410: UPDATE HZ_CUST_ACCT_RELATE_ALL rel
2411: SET status = 'I',
2412: last_update_date = sysdate,
2413: last_updated_by = hz_utility_v2pub.user_id,
2414: last_update_login = hz_utility_v2pub.last_update_login,
2415: request_id = req_id,
2416: program_application_id =hz_utility_v2pub.program_application_id,
2417: program_id = hz_utility_v2pub.program_id,

Line 2414: last_update_login = hz_utility_v2pub.last_update_login,

2410: UPDATE HZ_CUST_ACCT_RELATE_ALL rel
2411: SET status = 'I',
2412: last_update_date = sysdate,
2413: last_updated_by = hz_utility_v2pub.user_id,
2414: last_update_login = hz_utility_v2pub.last_update_login,
2415: request_id = req_id,
2416: program_application_id =hz_utility_v2pub.program_application_id,
2417: program_id = hz_utility_v2pub.program_id,
2418: program_update_date = sysdate

Line 2416: program_application_id =hz_utility_v2pub.program_application_id,

2412: last_update_date = sysdate,
2413: last_updated_by = hz_utility_v2pub.user_id,
2414: last_update_login = hz_utility_v2pub.last_update_login,
2415: request_id = req_id,
2416: program_application_id =hz_utility_v2pub.program_application_id,
2417: program_id = hz_utility_v2pub.program_id,
2418: program_update_date = sysdate
2419: WHERE rel.cust_account_id = from_customer_id
2420: AND EXISTS (select 'Y' from ra_customer_merges m

Line 2417: program_id = hz_utility_v2pub.program_id,

2413: last_updated_by = hz_utility_v2pub.user_id,
2414: last_update_login = hz_utility_v2pub.last_update_login,
2415: request_id = req_id,
2416: program_application_id =hz_utility_v2pub.program_application_id,
2417: program_id = hz_utility_v2pub.program_id,
2418: program_update_date = sysdate
2419: WHERE rel.cust_account_id = from_customer_id
2420: AND EXISTS (select 'Y' from ra_customer_merges m
2421: where m.request_id = req_id

Line 2437: last_updated_by = hz_utility_v2pub.user_id,

2433: --related_cust_account_id*/
2434: UPDATE HZ_CUST_ACCT_RELATE_ALL rel2 --SSUptake
2435: SET status = 'I',
2436: last_update_date = sysdate,
2437: last_updated_by = hz_utility_v2pub.user_id,
2438: last_update_login = hz_utility_v2pub.last_update_login,
2439: request_id = req_id,
2440: program_application_id =hz_utility_v2pub.program_application_id,
2441: program_id = hz_utility_v2pub.program_id,

Line 2438: last_update_login = hz_utility_v2pub.last_update_login,

2434: UPDATE HZ_CUST_ACCT_RELATE_ALL rel2 --SSUptake
2435: SET status = 'I',
2436: last_update_date = sysdate,
2437: last_updated_by = hz_utility_v2pub.user_id,
2438: last_update_login = hz_utility_v2pub.last_update_login,
2439: request_id = req_id,
2440: program_application_id =hz_utility_v2pub.program_application_id,
2441: program_id = hz_utility_v2pub.program_id,
2442: program_update_date = sysdate

Line 2440: program_application_id =hz_utility_v2pub.program_application_id,

2436: last_update_date = sysdate,
2437: last_updated_by = hz_utility_v2pub.user_id,
2438: last_update_login = hz_utility_v2pub.last_update_login,
2439: request_id = req_id,
2440: program_application_id =hz_utility_v2pub.program_application_id,
2441: program_id = hz_utility_v2pub.program_id,
2442: program_update_date = sysdate
2443: WHERE related_cust_account_id = from_customer_id
2444: AND EXISTS (select 'Y' from ra_customer_merges m

Line 2441: program_id = hz_utility_v2pub.program_id,

2437: last_updated_by = hz_utility_v2pub.user_id,
2438: last_update_login = hz_utility_v2pub.last_update_login,
2439: request_id = req_id,
2440: program_application_id =hz_utility_v2pub.program_application_id,
2441: program_id = hz_utility_v2pub.program_id,
2442: program_update_date = sysdate
2443: WHERE related_cust_account_id = from_customer_id
2444: AND EXISTS (select 'Y' from ra_customer_merges m
2445: where m.request_id = req_id

Line 2463: last_updated_by = hz_utility_v2pub.user_id,

2459:
2460: UPDATE RA_CUST_RECEIPT_METHODS yt
2461: set end_date = null,
2462: last_update_date = sysdate,
2463: last_updated_by = hz_utility_v2pub.user_id,
2464: last_update_login = hz_utility_v2pub.last_update_login,
2465: request_id = req_id,
2466: program_application_id = hz_utility_v2pub.program_application_id,
2467: program_id = hz_utility_v2pub.program_id,

Line 2464: last_update_login = hz_utility_v2pub.last_update_login,

2460: UPDATE RA_CUST_RECEIPT_METHODS yt
2461: set end_date = null,
2462: last_update_date = sysdate,
2463: last_updated_by = hz_utility_v2pub.user_id,
2464: last_update_login = hz_utility_v2pub.last_update_login,
2465: request_id = req_id,
2466: program_application_id = hz_utility_v2pub.program_application_id,
2467: program_id = hz_utility_v2pub.program_id,
2468: program_update_date = sysdate

Line 2466: program_application_id = hz_utility_v2pub.program_application_id,

2462: last_update_date = sysdate,
2463: last_updated_by = hz_utility_v2pub.user_id,
2464: last_update_login = hz_utility_v2pub.last_update_login,
2465: request_id = req_id,
2466: program_application_id = hz_utility_v2pub.program_application_id,
2467: program_id = hz_utility_v2pub.program_id,
2468: program_update_date = sysdate
2469: WHERE customer_id = from_customer_id
2470: AND customer_id IN (

Line 2467: program_id = hz_utility_v2pub.program_id,

2463: last_updated_by = hz_utility_v2pub.user_id,
2464: last_update_login = hz_utility_v2pub.last_update_login,
2465: request_id = req_id,
2466: program_application_id = hz_utility_v2pub.program_application_id,
2467: program_id = hz_utility_v2pub.program_id,
2468: program_update_date = sysdate
2469: WHERE customer_id = from_customer_id
2470: AND customer_id IN (
2471: SELECT m.duplicate_id

Line 2491: last_updated_by = hz_utility_v2pub.user_id,

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,
2493: request_id = req_id,
2494: program_application_id = hz_utility_v2pub.program_application_id,
2495: program_id = hz_utility_v2pub.program_id,

Line 2492: last_update_login = hz_utility_v2pub.last_update_login,

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,
2493: request_id = req_id,
2494: program_application_id = hz_utility_v2pub.program_application_id,
2495: program_id = hz_utility_v2pub.program_id,
2496: program_update_date = sysdate

Line 2494: program_application_id = hz_utility_v2pub.program_application_id,

2490: last_update_date = sysdate,
2491: last_updated_by = hz_utility_v2pub.user_id,
2492: last_update_login = hz_utility_v2pub.last_update_login,
2493: request_id = req_id,
2494: program_application_id = hz_utility_v2pub.program_application_id,
2495: program_id = hz_utility_v2pub.program_id,
2496: program_update_date = sysdate
2497: WHERE yt.cust_account_id = from_customer_id
2498: AND status = 'D'

Line 2495: program_id = hz_utility_v2pub.program_id,

2491: last_updated_by = hz_utility_v2pub.user_id,
2492: last_update_login = hz_utility_v2pub.last_update_login,
2493: request_id = req_id,
2494: program_application_id = hz_utility_v2pub.program_application_id,
2495: program_id = hz_utility_v2pub.program_id,
2496: program_update_date = sysdate
2497: WHERE yt.cust_account_id = from_customer_id
2498: AND status = 'D'
2499: AND part_delete = 'N'; --5747129