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 RA_CUSTOMER_MERGE_HEADERS

Line 492: UPDATE ra_customer_merge_headers

488: WHERE request_id = p_request_id
489: AND customer_merge_header_id = p_customer_merge_header_id
490: ;
491:
492: UPDATE ra_customer_merge_headers
493: SET process_flag = 'FAILED',merge_fail_msg = p_error_text
494: WHERE request_id = p_request_id
495: AND customer_merge_header_id = p_customer_merge_header_id
496: ;

Line 1012: FROM ra_customer_merge_headers

1008: ) IS
1009:
1010: CURSOR c_requests(c_priority varchar2) IS
1011: SELECT distinct request_id, process_flag
1012: FROM ra_customer_merge_headers
1013: WHERE process_flag IN ('PROCESSING', 'N')
1014: AND priority = c_priority;
1015:
1016: l_request_id NUMBER;

Line 1027: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

1023: l_conc_dev_phase VARCHAR2(30);
1024: l_conc_dev_status VARCHAR2(30);
1025: l_message VARCHAR2(240);
1026: --3897822
1027: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1028: TYPE process_flag_tab IS TABLE OF RA_CUSTOMER_MERGE_HEADERS.PROCESS_FLAG%TYPE INDEX BY BINARY_INTEGER;
1029: l_header_id_t customer_merge_header_id_tab;
1030: l_process_flag_t process_flag_tab;
1031: BEGIN

Line 1028: TYPE process_flag_tab IS TABLE OF RA_CUSTOMER_MERGE_HEADERS.PROCESS_FLAG%TYPE INDEX BY BINARY_INTEGER;

1024: l_conc_dev_status VARCHAR2(30);
1025: l_message VARCHAR2(240);
1026: --3897822
1027: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGE_HEADERS.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1028: TYPE process_flag_tab IS TABLE OF RA_CUSTOMER_MERGE_HEADERS.PROCESS_FLAG%TYPE INDEX BY BINARY_INTEGER;
1029: l_header_id_t customer_merge_header_id_tab;
1030: l_process_flag_t process_flag_tab;
1031: BEGIN
1032:

Line 1103: UPDATE ra_customer_merge_headers

1099: ELSE
1100: l_new_process_flag := 'N';
1101: END IF;
1102: IF p_process_flag = 'PROCESSING' THEN
1103: UPDATE ra_customer_merge_headers
1104: SET process_flag = p_process_flag
1105: WHERE request_id = req_id;
1106: END IF;
1107:

Line 1112: FROM ra_customer_merge_headers mh

1108: IF p_process_flag = 'SAVED' THEN
1109: --3897822
1110: SELECT customer_merge_header_id, process_flag
1111: BULK COLLECT INTO l_header_id_t,l_process_flag_t
1112: FROM ra_customer_merge_headers mh
1113: WHERE process_flag IN ('PROCESSING', 'N')
1114: AND priority = p_priority;
1115:
1116: OPEN c_requests(p_priority);

Line 1144: UPDATE ra_customer_merge_headers

1140: l_pickup := TRUE;
1141: END IF;
1142:
1143: IF l_pickup THEN
1144: UPDATE ra_customer_merge_headers
1145: SET process_flag = l_new_process_flag
1146: WHERE request_id = l_request_id
1147: AND process_flag = l_process_flag
1148: AND priority = p_priority; --3897822

Line 1151: UPDATE ra_customer_merge_headers

1147: AND process_flag = l_process_flag
1148: AND priority = p_priority; --3897822
1149: END IF;
1150: ELSE
1151: UPDATE ra_customer_merge_headers
1152: SET process_flag = l_new_process_flag
1153: WHERE request_id IS NULL
1154: AND process_flag = l_process_flag
1155: AND priority = p_priority; --3897822

Line 1161: UPDATE ra_customer_merge_headers

1157: END LOOP;
1158: CLOSE c_requests;
1159:
1160: ELSIF p_process_flag = 'FAILED' THEN
1161: UPDATE ra_customer_merge_headers
1162: SET process_flag = l_new_process_flag
1163: WHERE process_flag LIKE 'ERROR%';
1164: END IF;
1165:

Line 1167: UPDATE ra_customer_merge_headers

1163: WHERE process_flag LIKE 'ERROR%';
1164: END IF;
1165:
1166: IF p_merge_rule = 'OLD' THEN
1167: UPDATE ra_customer_merge_headers
1168: SET process_flag = l_new_process_flag
1169: WHERE process_flag = p_process_flag;
1170: END IF;
1171:

Line 1173: UPDATE ra_customer_merge_headers mh

1169: WHERE process_flag = p_process_flag;
1170: END IF;
1171:
1172: IF p_process_flag<> 'PROCESSING' THEN
1173: UPDATE ra_customer_merge_headers mh
1174: SET request_id = req_id ,
1175: merge_fail_msg = NULL
1176: WHERE process_flag = l_new_process_flag
1177: AND customer_merge_header_id IN

Line 1181: FROM ra_customer_merge_headers mh1

1177: AND customer_merge_header_id IN
1178: (SELECT customer_merge_header_id
1179: FROM
1180: (SELECT customer_merge_header_id
1181: FROM ra_customer_merge_headers mh1
1182: WHERE mh1.priority = p_priority
1183: AND mh1.process_flag = l_new_process_flag
1184: AND NOT EXISTS (
1185: SELECT 'Y' FROM ra_customer_merges m

Line 1209: UPDATE ra_customer_merge_headers mh

1205: )
1206: WHERE ROWNUM <= p_number_of_merges);
1207:
1208: FORALL i IN 1..l_header_id_t.count
1209: UPDATE ra_customer_merge_headers mh
1210: SET process_flag = l_process_flag_t(i)
1211: WHERE request_id <> req_id
1212: AND mh.customer_merge_header_id = l_header_id_t(i);
1213: END IF;

Line 1220: UPDATE ra_customer_merge_headers mh

1216:
1217: --Bug 1725662: Set request_id from ra_customer_merges. Rewrite sql to
1218: --use index.
1219:
1220: UPDATE ra_customer_merge_headers mh
1221: SET process_flag = 'Y'
1222: WHERE request_id = req_id
1223: AND process_flag = l_new_process_flag
1224: AND priority = p_priority --3897822

Line 1236: FROM ra_customer_merge_headers mh

1232: UPDATE ra_customer_merges m
1233: SET (request_id,
1234: process_flag) = (
1235: SELECT mh.request_id, mh.process_flag
1236: FROM ra_customer_merge_headers mh
1237: WHERE mh.customer_merge_header_id = m.customer_merge_header_id
1238: AND mh.process_flag = l_new_process_flag )
1239: WHERE m.customer_merge_header_id IN (
1240: SELECT mh.customer_merge_header_id

Line 1241: FROM ra_customer_merge_headers mh

1237: WHERE mh.customer_merge_header_id = m.customer_merge_header_id
1238: AND mh.process_flag = l_new_process_flag )
1239: WHERE m.customer_merge_header_id IN (
1240: SELECT mh.customer_merge_header_id
1241: FROM ra_customer_merge_headers mh
1242: WHERE mh.process_flag = l_new_process_flag
1243: AND request_id = req_id
1244: AND mh.priority = p_priority); --3897822
1245:

Line 1381: --ra_customer_merge_headers.(request_id, process_flag);

1377: Columns will be changed correspondingly.
1378: */
1379:
1380: --Bug 1725662: rewrite query to use index on
1381: --ra_customer_merge_headers.(request_id, process_flag);
1382:
1383: SELECT su.site_use_id site_use_id,
1384: mh.duplicate_id duplicate_id
1385: FROM hz_cust_acct_sites addr,

Line 1387: ra_customer_merge_headers mh

1383: SELECT su.site_use_id site_use_id,
1384: mh.duplicate_id duplicate_id
1385: FROM hz_cust_acct_sites addr,
1386: hz_cust_site_uses su,
1387: ra_customer_merge_headers mh
1388: WHERE mh.request_id = req_id
1389: AND mh.process_flag = p_process_flag
1390: AND (mh.org_id = -1 OR (mh.org_id <> -1 AND addr.org_id = mh.org_id)) --SSUptake
1391: AND mh.duplicate_id <> mh.customer_id

Line 1459: UPDATE ra_customer_merge_headers

1455:
1456: --Bug 1725662: Add the following sql to save performance in
1457: --clear_error_merge_rows.
1458:
1459: UPDATE ra_customer_merge_headers
1460: SET process_flag = 'ERROR 1'
1461: WHERE duplicate_id = missing_sites.duplicate_id
1462: AND request_id = req_id
1463: AND process_flag = p_process_flag;

Line 1484: UPDATE ra_customer_merge_headers

1480:
1481: --Bug 1725662: Add the following sql to save performance in
1482: --clear_error_merge_rows.
1483:
1484: UPDATE ra_customer_merge_headers
1485: SET process_flag = 'ERROR 2'
1486: WHERE duplicate_id = invalid_merges.duplicate_id
1487: AND request_id = req_id
1488: AND process_flag = p_process_flag;

Line 1779: UPDATE ra_customer_merge_headers mh

1775:
1776: --Bug 1519688: Do not need to set request_id.
1777: --Bug 1725662: replace 'EXISTS' with 'IN' to use index.
1778:
1779: UPDATE ra_customer_merge_headers mh
1780: SET (process_flag,
1781: -- request_id,
1782: last_update_date,
1783: last_updated_by,

Line 1889: UPDATE ra_customer_merge_headers mh

1885: AND set_number = set_num
1886: AND process_flag = p_process_flag;
1887:
1888:
1889: UPDATE ra_customer_merge_headers mh
1890: SET (process_flag,
1891: last_update_date,
1892: last_updated_by,
1893: last_update_login,

Line 1945: UPDATE ra_customer_merge_headers mh

1941: --reset merge header table.
1942:
1943: --Bug 1725662: replace 'EXISTS' with 'IN' to use index.
1944:
1945: UPDATE ra_customer_merge_headers mh
1946: SET (process_flag,
1947: last_update_date,
1948: last_updated_by,
1949: last_update_login,

Line 2032: UPDATE ra_customer_merge_headers

2028: --to pick it up next time.
2029:
2030: --Bug 1725662: rewrite query to use new index.
2031:
2032: UPDATE ra_customer_merge_headers
2033: SET process_flag = decode(process_flag,
2034: 'ERROR 1', 'FAILED',
2035: 'ERROR 2', 'FAILED'),
2036: -- request_id = null,

Line 2062: FROM ra_customer_merge_headers mh

2058: mh.last_update_login,
2059: mh.program_application_id,
2060: mh.program_id,
2061: sysdate
2062: FROM ra_customer_merge_headers mh
2063: WHERE mh.request_id = req_id
2064: AND mh.process_flag = 'FAILED'
2065: AND mh.customer_merge_header_id =
2066: m.customer_merge_header_id

Line 2070: FROM ra_customer_merge_headers mh

2066: m.customer_merge_header_id
2067: AND ROWNUM = 1)
2068: WHERE m.customer_merge_header_id IN (
2069: SELECT mh.customer_merge_header_id
2070: FROM ra_customer_merge_headers mh
2071: WHERE mh.request_id = req_id
2072: AND mh.process_flag = 'FAILED' )
2073: AND process_flag in ('ERROR 1', 'ERROR 2');
2074:

Line 2329: UPDATE ra_customer_merge_headers

2325: AND m.set_number = set_num
2326: AND part_delete = 'N'; --5747129
2327:
2328: /*--Also unset the delete duplicate flag in merge header table --*/
2329: UPDATE ra_customer_merge_headers
2330: SET delete_duplicate_flag = 'N'
2331: WHERE customer_merge_header_id in
2332: (select customer_merge_header_id
2333: from ra_customer_merges m

Line 2523: UPDATE RA_CUSTOMER_MERGE_HEADERS

2519: /* ---Profile amts in ar_cpa are not getting Inactivated
2520: ---so delete duplicate flag in merge table can handle that */
2521:
2522: ---Updating the column MERGE_FAIL_MSG with veto reason
2523: UPDATE RA_CUSTOMER_MERGE_HEADERS
2524: SET MERGE_FAIL_MSG= veto_reason
2525: WHERE customer_merge_header_id in
2526: (select customer_merge_header_id
2527: from ra_customer_merges m

Line 2533: arp_message.set_line( SQL%ROWCOUNT || ' '|| 'Rows updated in RA_CUSTOMER_MERGE_HEADERS with veto reason :' ||' '|| veto_reason );

2529: AND m.process_flag = 'N'
2530: AND m.request_id = req_id
2531: AND m.set_number = set_num);
2532:
2533: arp_message.set_line( SQL%ROWCOUNT || ' '|| 'Rows updated in RA_CUSTOMER_MERGE_HEADERS with veto reason :' ||' '|| veto_reason );
2534:
2535: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()-' );
2536:
2537: END veto_delete;

Line 2546: FROM ra_customer_merge_headers

2542: l_list WF_PARAMETER_LIST_T;
2543: l_header_id NUMBER;
2544: CURSOR merges IS
2545: SELECT customer_merge_header_id
2546: FROM ra_customer_merge_headers
2547: WHERE request_id = p_req_id
2548: AND process_flag = 'Y';
2549: BEGIN
2550: arp_message.set_line( 'ARP_CMERGE_MASTER.raise_events() +');