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 1760: last_updated_by = hz_utility_v2pub.user_id,

1756:
1757: UPDATE ra_customer_merges
1758: SET process_flag = 'Y',
1759: last_update_date = sysdate,
1760: last_updated_by = hz_utility_v2pub.user_id,
1761: last_update_login = hz_utility_v2pub.last_update_login,
1762: program_application_id = hz_utility_v2pub.program_application_id,
1763: program_id = hz_utility_v2pub.program_id,
1764: program_update_date = sysdate

Line 1761: last_update_login = hz_utility_v2pub.last_update_login,

1757: UPDATE ra_customer_merges
1758: SET process_flag = 'Y',
1759: last_update_date = sysdate,
1760: last_updated_by = hz_utility_v2pub.user_id,
1761: last_update_login = hz_utility_v2pub.last_update_login,
1762: program_application_id = hz_utility_v2pub.program_application_id,
1763: program_id = hz_utility_v2pub.program_id,
1764: program_update_date = sysdate
1765: WHERE request_id = req_id

Line 1762: program_application_id = hz_utility_v2pub.program_application_id,

1758: SET process_flag = 'Y',
1759: last_update_date = sysdate,
1760: last_updated_by = hz_utility_v2pub.user_id,
1761: last_update_login = hz_utility_v2pub.last_update_login,
1762: program_application_id = hz_utility_v2pub.program_application_id,
1763: program_id = hz_utility_v2pub.program_id,
1764: program_update_date = sysdate
1765: WHERE request_id = req_id
1766: AND set_number = set_num

Line 1763: program_id = hz_utility_v2pub.program_id,

1759: last_update_date = sysdate,
1760: last_updated_by = hz_utility_v2pub.user_id,
1761: last_update_login = hz_utility_v2pub.last_update_login,
1762: program_application_id = hz_utility_v2pub.program_application_id,
1763: program_id = hz_utility_v2pub.program_id,
1764: program_update_date = sysdate
1765: WHERE request_id = req_id
1766: AND set_number = set_num
1767: AND process_flag = 'N';

Line 1872: last_updated_by = hz_utility_v2pub.user_id,

1868: -- set_number = null,
1869: -- request_id = null,
1870: process_flag = 'SAVED',
1871: last_update_date = sysdate,
1872: last_updated_by = hz_utility_v2pub.user_id,
1873: last_update_login = hz_utility_v2pub.last_update_login,
1874: program_application_id = hz_utility_v2pub.program_application_id,
1875: program_id = hz_utility_v2pub.program_id,
1876: program_update_date = sysdate

Line 1873: last_update_login = hz_utility_v2pub.last_update_login,

1869: -- request_id = null,
1870: process_flag = 'SAVED',
1871: last_update_date = sysdate,
1872: last_updated_by = hz_utility_v2pub.user_id,
1873: last_update_login = hz_utility_v2pub.last_update_login,
1874: program_application_id = hz_utility_v2pub.program_application_id,
1875: program_id = hz_utility_v2pub.program_id,
1876: program_update_date = sysdate
1877: WHERE request_id = req_id

Line 1874: program_application_id = hz_utility_v2pub.program_application_id,

1870: process_flag = 'SAVED',
1871: last_update_date = sysdate,
1872: last_updated_by = hz_utility_v2pub.user_id,
1873: last_update_login = hz_utility_v2pub.last_update_login,
1874: program_application_id = hz_utility_v2pub.program_application_id,
1875: program_id = hz_utility_v2pub.program_id,
1876: program_update_date = sysdate
1877: WHERE request_id = req_id
1878: AND set_number = set_num

Line 1875: program_id = hz_utility_v2pub.program_id,

1871: last_update_date = sysdate,
1872: last_updated_by = hz_utility_v2pub.user_id,
1873: last_update_login = hz_utility_v2pub.last_update_login,
1874: program_application_id = hz_utility_v2pub.program_application_id,
1875: program_id = hz_utility_v2pub.program_id,
1876: program_update_date = sysdate
1877: WHERE request_id = req_id
1878: AND set_number = set_num
1879: AND process_flag = p_process_flag;

Line 1925: last_updated_by = hz_utility_v2pub.user_id,

1921: -- set_number = null,
1922: -- request_id = null,
1923: process_flag = 'FAILED',
1924: last_update_date = sysdate,
1925: last_updated_by = hz_utility_v2pub.user_id,
1926: last_update_login = hz_utility_v2pub.last_update_login,
1927: program_application_id = hz_utility_v2pub.program_application_id,
1928: program_id = hz_utility_v2pub.program_id,
1929: program_update_date = sysdate

Line 1926: last_update_login = hz_utility_v2pub.last_update_login,

1922: -- request_id = null,
1923: process_flag = 'FAILED',
1924: last_update_date = sysdate,
1925: last_updated_by = hz_utility_v2pub.user_id,
1926: last_update_login = hz_utility_v2pub.last_update_login,
1927: program_application_id = hz_utility_v2pub.program_application_id,
1928: program_id = hz_utility_v2pub.program_id,
1929: program_update_date = sysdate
1930: WHERE request_id = req_id

Line 1927: program_application_id = hz_utility_v2pub.program_application_id,

1923: process_flag = 'FAILED',
1924: last_update_date = sysdate,
1925: last_updated_by = hz_utility_v2pub.user_id,
1926: last_update_login = hz_utility_v2pub.last_update_login,
1927: program_application_id = hz_utility_v2pub.program_application_id,
1928: program_id = hz_utility_v2pub.program_id,
1929: program_update_date = sysdate
1930: WHERE request_id = req_id
1931: AND set_number = set_num

Line 1928: program_id = hz_utility_v2pub.program_id,

1924: last_update_date = sysdate,
1925: last_updated_by = hz_utility_v2pub.user_id,
1926: last_update_login = hz_utility_v2pub.last_update_login,
1927: program_application_id = hz_utility_v2pub.program_application_id,
1928: program_id = hz_utility_v2pub.program_id,
1929: program_update_date = sysdate
1930: WHERE request_id = req_id
1931: AND set_number = set_num
1932: AND process_flag = p_process_flag;

Line 2031: last_updated_by = hz_utility_v2pub.user_id,

2027: 'ERROR 1', 'FAILED',
2028: 'ERROR 2', 'FAILED'),
2029: -- request_id = null,
2030: last_update_date = sysdate,
2031: last_updated_by = hz_utility_v2pub.user_id,
2032: last_update_login = hz_utility_v2pub.last_update_login,
2033: program_application_id = hz_utility_v2pub.program_application_id,
2034: program_id = hz_utility_v2pub.program_id,
2035: program_update_date = sysdate

Line 2032: last_update_login = hz_utility_v2pub.last_update_login,

2028: 'ERROR 2', 'FAILED'),
2029: -- request_id = null,
2030: last_update_date = sysdate,
2031: last_updated_by = hz_utility_v2pub.user_id,
2032: last_update_login = hz_utility_v2pub.last_update_login,
2033: program_application_id = hz_utility_v2pub.program_application_id,
2034: program_id = hz_utility_v2pub.program_id,
2035: program_update_date = sysdate
2036: WHERE process_flag in ('ERROR 1', 'ERROR 2')

Line 2033: program_application_id = hz_utility_v2pub.program_application_id,

2029: -- request_id = null,
2030: last_update_date = sysdate,
2031: last_updated_by = hz_utility_v2pub.user_id,
2032: last_update_login = hz_utility_v2pub.last_update_login,
2033: program_application_id = hz_utility_v2pub.program_application_id,
2034: program_id = hz_utility_v2pub.program_id,
2035: program_update_date = sysdate
2036: WHERE process_flag in ('ERROR 1', 'ERROR 2')
2037: AND request_id = req_id;

Line 2034: program_id = hz_utility_v2pub.program_id,

2030: last_update_date = sysdate,
2031: last_updated_by = hz_utility_v2pub.user_id,
2032: last_update_login = hz_utility_v2pub.last_update_login,
2033: program_application_id = hz_utility_v2pub.program_application_id,
2034: program_id = hz_utility_v2pub.program_id,
2035: program_update_date = sysdate
2036: WHERE process_flag in ('ERROR 1', 'ERROR 2')
2037: AND request_id = req_id;
2038:

Line 2338: last_updated_by = hz_utility_v2pub.user_id,

2334: --undo
2335: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2336: SET status = 'I',
2337: last_update_date = sysdate,
2338: last_updated_by = hz_utility_v2pub.user_id,
2339: last_update_login = hz_utility_v2pub.last_update_login,
2340: request_id = req_id,
2341: program_application_id = hz_utility_v2pub.program_application_id,
2342: program_id = hz_utility_v2pub.program_id,

Line 2339: last_update_login = hz_utility_v2pub.last_update_login,

2335: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2336: SET status = 'I',
2337: last_update_date = sysdate,
2338: last_updated_by = hz_utility_v2pub.user_id,
2339: last_update_login = hz_utility_v2pub.last_update_login,
2340: request_id = req_id,
2341: program_application_id = hz_utility_v2pub.program_application_id,
2342: program_id = hz_utility_v2pub.program_id,
2343: program_update_date = sysdate

Line 2341: program_application_id = hz_utility_v2pub.program_application_id,

2337: last_update_date = sysdate,
2338: last_updated_by = hz_utility_v2pub.user_id,
2339: last_update_login = hz_utility_v2pub.last_update_login,
2340: request_id = req_id,
2341: program_application_id = hz_utility_v2pub.program_application_id,
2342: program_id = hz_utility_v2pub.program_id,
2343: program_update_date = sysdate
2344: WHERE EXISTS
2345: ( select 'Y'

Line 2342: program_id = hz_utility_v2pub.program_id,

2338: last_updated_by = hz_utility_v2pub.user_id,
2339: last_update_login = hz_utility_v2pub.last_update_login,
2340: request_id = req_id,
2341: program_application_id = hz_utility_v2pub.program_application_id,
2342: program_id = hz_utility_v2pub.program_id,
2343: program_update_date = sysdate
2344: WHERE EXISTS
2345: ( select 'Y'
2346: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake

Line 2367: last_updated_by = hz_utility_v2pub.user_id,

2363: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2364: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2365: set status = 'I',
2366: last_update_date = sysdate,
2367: last_updated_by = hz_utility_v2pub.user_id,
2368: last_update_login = hz_utility_v2pub.last_update_login,
2369: request_id = req_id,
2370: program_application_id = hz_utility_v2pub.program_application_id,
2371: program_id = hz_utility_v2pub.program_id,

Line 2368: last_update_login = hz_utility_v2pub.last_update_login,

2364: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2365: set status = 'I',
2366: last_update_date = sysdate,
2367: last_updated_by = hz_utility_v2pub.user_id,
2368: last_update_login = hz_utility_v2pub.last_update_login,
2369: request_id = req_id,
2370: program_application_id = hz_utility_v2pub.program_application_id,
2371: program_id = hz_utility_v2pub.program_id,
2372: program_update_date = sysdate

Line 2370: program_application_id = hz_utility_v2pub.program_application_id,

2366: last_update_date = sysdate,
2367: last_updated_by = hz_utility_v2pub.user_id,
2368: last_update_login = hz_utility_v2pub.last_update_login,
2369: request_id = req_id,
2370: program_application_id = hz_utility_v2pub.program_application_id,
2371: program_id = hz_utility_v2pub.program_id,
2372: program_update_date = sysdate
2373: where addr.cust_account_id = from_customer_id
2374: AND EXISTS (select 'Y' from ra_customer_merges m

Line 2371: program_id = hz_utility_v2pub.program_id,

2367: last_updated_by = hz_utility_v2pub.user_id,
2368: last_update_login = hz_utility_v2pub.last_update_login,
2369: request_id = req_id,
2370: program_application_id = hz_utility_v2pub.program_application_id,
2371: program_id = hz_utility_v2pub.program_id,
2372: program_update_date = sysdate
2373: where addr.cust_account_id = from_customer_id
2374: AND EXISTS (select 'Y' from ra_customer_merges m
2375: where m.request_id = req_id

Line 2391: last_updated_by = hz_utility_v2pub.user_id,

2387: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2388: UPDATE HZ_CUST_ACCOUNTS acct
2389: set status = decode(part_delete,'N','I','A'),
2390: last_update_date = sysdate,
2391: last_updated_by = hz_utility_v2pub.user_id,
2392: last_update_login = hz_utility_v2pub.last_update_login,
2393: request_id = req_id,
2394: program_application_id = hz_utility_v2pub.program_application_id,
2395: program_id = hz_utility_v2pub.program_id,

Line 2392: last_update_login = hz_utility_v2pub.last_update_login,

2388: UPDATE HZ_CUST_ACCOUNTS acct
2389: set status = decode(part_delete,'N','I','A'),
2390: last_update_date = sysdate,
2391: last_updated_by = hz_utility_v2pub.user_id,
2392: last_update_login = hz_utility_v2pub.last_update_login,
2393: request_id = req_id,
2394: program_application_id = hz_utility_v2pub.program_application_id,
2395: program_id = hz_utility_v2pub.program_id,
2396: program_update_date = sysdate

Line 2394: program_application_id = hz_utility_v2pub.program_application_id,

2390: last_update_date = sysdate,
2391: last_updated_by = hz_utility_v2pub.user_id,
2392: last_update_login = hz_utility_v2pub.last_update_login,
2393: request_id = req_id,
2394: program_application_id = hz_utility_v2pub.program_application_id,
2395: program_id = hz_utility_v2pub.program_id,
2396: program_update_date = sysdate
2397: where acct.cust_account_id = from_customer_id
2398: and status ='D';

Line 2395: program_id = hz_utility_v2pub.program_id,

2391: last_updated_by = hz_utility_v2pub.user_id,
2392: last_update_login = hz_utility_v2pub.last_update_login,
2393: request_id = req_id,
2394: program_application_id = hz_utility_v2pub.program_application_id,
2395: program_id = hz_utility_v2pub.program_id,
2396: program_update_date = sysdate
2397: where acct.cust_account_id = from_customer_id
2398: and status ='D';
2399:

Line 2406: last_updated_by = hz_utility_v2pub.user_id,

2402: /*--Unset the status to 'I' for HZ_CUST_ACCT_RELATE cust_account_id */
2403: UPDATE HZ_CUST_ACCT_RELATE_ALL rel
2404: SET status = 'I',
2405: last_update_date = sysdate,
2406: last_updated_by = hz_utility_v2pub.user_id,
2407: last_update_login = hz_utility_v2pub.last_update_login,
2408: request_id = req_id,
2409: program_application_id =hz_utility_v2pub.program_application_id,
2410: program_id = hz_utility_v2pub.program_id,

Line 2407: last_update_login = hz_utility_v2pub.last_update_login,

2403: UPDATE HZ_CUST_ACCT_RELATE_ALL rel
2404: SET status = 'I',
2405: last_update_date = sysdate,
2406: last_updated_by = hz_utility_v2pub.user_id,
2407: last_update_login = hz_utility_v2pub.last_update_login,
2408: request_id = req_id,
2409: program_application_id =hz_utility_v2pub.program_application_id,
2410: program_id = hz_utility_v2pub.program_id,
2411: program_update_date = sysdate

Line 2409: program_application_id =hz_utility_v2pub.program_application_id,

2405: last_update_date = sysdate,
2406: last_updated_by = hz_utility_v2pub.user_id,
2407: last_update_login = hz_utility_v2pub.last_update_login,
2408: request_id = req_id,
2409: program_application_id =hz_utility_v2pub.program_application_id,
2410: program_id = hz_utility_v2pub.program_id,
2411: program_update_date = sysdate
2412: WHERE rel.cust_account_id = from_customer_id
2413: AND EXISTS (select 'Y' from ra_customer_merges m

Line 2410: program_id = hz_utility_v2pub.program_id,

2406: last_updated_by = hz_utility_v2pub.user_id,
2407: last_update_login = hz_utility_v2pub.last_update_login,
2408: request_id = req_id,
2409: program_application_id =hz_utility_v2pub.program_application_id,
2410: program_id = hz_utility_v2pub.program_id,
2411: program_update_date = sysdate
2412: WHERE rel.cust_account_id = from_customer_id
2413: AND EXISTS (select 'Y' from ra_customer_merges m
2414: where m.request_id = req_id

Line 2430: last_updated_by = hz_utility_v2pub.user_id,

2426: --related_cust_account_id*/
2427: UPDATE HZ_CUST_ACCT_RELATE_ALL rel2 --SSUptake
2428: SET status = 'I',
2429: last_update_date = sysdate,
2430: last_updated_by = hz_utility_v2pub.user_id,
2431: last_update_login = hz_utility_v2pub.last_update_login,
2432: request_id = req_id,
2433: program_application_id =hz_utility_v2pub.program_application_id,
2434: program_id = hz_utility_v2pub.program_id,

Line 2431: last_update_login = hz_utility_v2pub.last_update_login,

2427: UPDATE HZ_CUST_ACCT_RELATE_ALL rel2 --SSUptake
2428: SET status = 'I',
2429: last_update_date = sysdate,
2430: last_updated_by = hz_utility_v2pub.user_id,
2431: last_update_login = hz_utility_v2pub.last_update_login,
2432: request_id = req_id,
2433: program_application_id =hz_utility_v2pub.program_application_id,
2434: program_id = hz_utility_v2pub.program_id,
2435: program_update_date = sysdate

Line 2433: program_application_id =hz_utility_v2pub.program_application_id,

2429: last_update_date = sysdate,
2430: last_updated_by = hz_utility_v2pub.user_id,
2431: last_update_login = hz_utility_v2pub.last_update_login,
2432: request_id = req_id,
2433: program_application_id =hz_utility_v2pub.program_application_id,
2434: program_id = hz_utility_v2pub.program_id,
2435: program_update_date = sysdate
2436: WHERE related_cust_account_id = from_customer_id
2437: AND EXISTS (select 'Y' from ra_customer_merges m

Line 2434: program_id = hz_utility_v2pub.program_id,

2430: last_updated_by = hz_utility_v2pub.user_id,
2431: last_update_login = hz_utility_v2pub.last_update_login,
2432: request_id = req_id,
2433: program_application_id =hz_utility_v2pub.program_application_id,
2434: program_id = hz_utility_v2pub.program_id,
2435: program_update_date = sysdate
2436: WHERE related_cust_account_id = from_customer_id
2437: AND EXISTS (select 'Y' from ra_customer_merges m
2438: where m.request_id = req_id

Line 2456: last_updated_by = hz_utility_v2pub.user_id,

2452:
2453: UPDATE RA_CUST_RECEIPT_METHODS yt
2454: set end_date = null,
2455: last_update_date = sysdate,
2456: last_updated_by = hz_utility_v2pub.user_id,
2457: last_update_login = hz_utility_v2pub.last_update_login,
2458: request_id = req_id,
2459: program_application_id = hz_utility_v2pub.program_application_id,
2460: program_id = hz_utility_v2pub.program_id,

Line 2457: last_update_login = hz_utility_v2pub.last_update_login,

2453: UPDATE RA_CUST_RECEIPT_METHODS yt
2454: set end_date = null,
2455: last_update_date = sysdate,
2456: last_updated_by = hz_utility_v2pub.user_id,
2457: last_update_login = hz_utility_v2pub.last_update_login,
2458: request_id = req_id,
2459: program_application_id = hz_utility_v2pub.program_application_id,
2460: program_id = hz_utility_v2pub.program_id,
2461: program_update_date = sysdate

Line 2459: program_application_id = hz_utility_v2pub.program_application_id,

2455: last_update_date = sysdate,
2456: last_updated_by = hz_utility_v2pub.user_id,
2457: last_update_login = hz_utility_v2pub.last_update_login,
2458: request_id = req_id,
2459: program_application_id = hz_utility_v2pub.program_application_id,
2460: program_id = hz_utility_v2pub.program_id,
2461: program_update_date = sysdate
2462: WHERE customer_id = from_customer_id
2463: AND customer_id IN (

Line 2460: program_id = hz_utility_v2pub.program_id,

2456: last_updated_by = hz_utility_v2pub.user_id,
2457: last_update_login = hz_utility_v2pub.last_update_login,
2458: request_id = req_id,
2459: program_application_id = hz_utility_v2pub.program_application_id,
2460: program_id = hz_utility_v2pub.program_id,
2461: program_update_date = sysdate
2462: WHERE customer_id = from_customer_id
2463: AND customer_id IN (
2464: SELECT m.duplicate_id

Line 2484: last_updated_by = hz_utility_v2pub.user_id,

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,
2486: request_id = req_id,
2487: program_application_id = hz_utility_v2pub.program_application_id,
2488: program_id = hz_utility_v2pub.program_id,

Line 2485: last_update_login = hz_utility_v2pub.last_update_login,

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,
2486: request_id = req_id,
2487: program_application_id = hz_utility_v2pub.program_application_id,
2488: program_id = hz_utility_v2pub.program_id,
2489: program_update_date = sysdate

Line 2487: program_application_id = hz_utility_v2pub.program_application_id,

2483: last_update_date = sysdate,
2484: last_updated_by = hz_utility_v2pub.user_id,
2485: last_update_login = hz_utility_v2pub.last_update_login,
2486: request_id = req_id,
2487: program_application_id = hz_utility_v2pub.program_application_id,
2488: program_id = hz_utility_v2pub.program_id,
2489: program_update_date = sysdate
2490: WHERE yt.cust_account_id = from_customer_id
2491: AND status = 'D'

Line 2488: program_id = hz_utility_v2pub.program_id,

2484: last_updated_by = hz_utility_v2pub.user_id,
2485: last_update_login = hz_utility_v2pub.last_update_login,
2486: request_id = req_id,
2487: program_application_id = hz_utility_v2pub.program_application_id,
2488: program_id = hz_utility_v2pub.program_id,
2489: program_update_date = sysdate
2490: WHERE yt.cust_account_id = from_customer_id
2491: AND status = 'D'
2492: AND part_delete = 'N'; --5747129