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.CSI_ACCT_MERGE_PKG dependencies on CSI_SYSTEMS_B

Line 22: CSI_SYSTEMS_B_MERGE(req_id, set_num, process_mode);

18: write_to_cr_log( ' Ending process for Item Instances All ' );
19:
20: error_str := '002';
21: write_to_cr_log( ' Processing Systems All Merge ' );
22: CSI_SYSTEMS_B_MERGE(req_id, set_num, process_mode);
23: write_to_cr_log( ' Ending process for Systems All ' );
24:
25: error_str := '003';
26: write_to_cr_log( ' Processing IP Accounts Merge ' );

Line 1415: PROCEDURE csi_systems_b_merge(req_id IN NUMBER,

1411: arp_message.set_error('CRM_MERGE.CUSTOMER_PRODUCTS_MERGE', l_msg_data);
1412: RAISE;
1413: END csi_ip_accounts_merge; -- } 1
1414:
1415: PROCEDURE csi_systems_b_merge(req_id IN NUMBER,
1416: set_num IN NUMBER,
1417: process_mode IN VARCHAR2) IS
1418:
1419: error_str VARCHAR2(3);

Line 1440: CSI_SYSTEMS_B.SYSTEM_ID%TYPE

1436:
1437: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1438:
1439: TYPE SYSTEM_ID_LIST_TYPE IS TABLE OF
1440: CSI_SYSTEMS_B.SYSTEM_ID%TYPE
1441: INDEX BY BINARY_INTEGER;
1442:
1443: PRIMARY_KEY_ID_LIST SYSTEM_ID_LIST_TYPE;
1444:

Line 1446: CSI_SYSTEMS_B.CUSTOMER_ID%TYPE

1442:
1443: PRIMARY_KEY_ID_LIST SYSTEM_ID_LIST_TYPE;
1444:
1445: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
1446: CSI_SYSTEMS_B.CUSTOMER_ID%TYPE
1447: INDEX BY BINARY_INTEGER;
1448:
1449: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1450: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;

Line 1453: CSI_SYSTEMS_B.BILL_TO_SITE_USE_ID%TYPE

1449: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1450: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1451:
1452: TYPE BILL_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
1453: CSI_SYSTEMS_B.BILL_TO_SITE_USE_ID%TYPE
1454: INDEX BY BINARY_INTEGER;
1455:
1456: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
1457: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;

Line 1460: CSI_SYSTEMS_B.SHIP_TO_SITE_USE_ID%TYPE

1456: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
1457: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
1458:
1459: TYPE SHIP_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
1460: CSI_SYSTEMS_B.SHIP_TO_SITE_USE_ID%TYPE
1461: INDEX BY BINARY_INTEGER;
1462:
1463: NUM_COL3_ORIG_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
1464: NUM_COL3_NEW_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;

Line 1473: FROM CSI_SYSTEMS_B yt,

1469: yt.SYSTEM_ID ,
1470: yt.CUSTOMER_ID ,
1471: yt.BILL_TO_SITE_USE_ID ,
1472: yt.SHIP_TO_SITE_USE_ID
1473: FROM CSI_SYSTEMS_B yt,
1474: RA_CUSTOMER_MERGES m
1475: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
1476: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
1477: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID )

Line 1486: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');

1482: I NUMBER;
1483: v_system_history_id NUMBER;
1484: BEGIN
1485:
1486: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
1487:
1488: IF (process_mode = 'LOCK') THEN
1489:
1490: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;

Line 1490: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;

1486: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
1487:
1488: IF (process_mode = 'LOCK') THEN
1489:
1490: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1491:
1492: write_to_cr_log( 'Locking the csi_systems_b table' );
1493: arp_message.set_name('AR','AR_LOCKING_TABLE');
1494: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);

Line 1492: write_to_cr_log( 'Locking the csi_systems_b table' );

1488: IF (process_mode = 'LOCK') THEN
1489:
1490: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1491:
1492: write_to_cr_log( 'Locking the csi_systems_b table' );
1493: arp_message.set_name('AR','AR_LOCKING_TABLE');
1494: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1495:
1496: OPEN merged_records;

Line 1494: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);

1490: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1491:
1492: write_to_cr_log( 'Locking the csi_systems_b table' );
1493: arp_message.set_name('AR','AR_LOCKING_TABLE');
1494: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1495:
1496: OPEN merged_records;
1497: CLOSE merged_records;
1498:

Line 1499: write_to_cr_log( 'Done Locking the csi_systems_b table' );

1495:
1496: OPEN merged_records;
1497: CLOSE merged_records;
1498:
1499: write_to_cr_log( 'Done Locking the csi_systems_b table' );
1500:
1501: ELSE
1502:
1503: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );

Line 1503: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );

1499: write_to_cr_log( 'Done Locking the csi_systems_b table' );
1500:
1501: ELSE
1502:
1503: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1504:
1505: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1506: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1507: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 1506: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);

1502:
1503: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1504:
1505: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1506: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1507: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1508: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1509:
1510: OPEN merged_records;

Line 1576: 'CSI_SYSTEMS_B' ,

1572: )
1573: VALUES
1574: (
1575: HZ_CUSTOMER_MERGE_LOG_s.nextval ,
1576: 'CSI_SYSTEMS_B' ,
1577: MERGE_HEADER_ID_LIST(I) ,
1578: PRIMARY_KEY_ID_LIST(I) ,
1579: NUM_COL1_ORIG_LIST(I) ,
1580: NUM_COL1_NEW_LIST(I) ,

Line 1599: UPDATE CSI_SYSTEMS_B yt

1595:
1596: write_to_cr_log( 'CSI : Before Update Loop check ');
1597:
1598: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP -- { I Loop
1599: UPDATE CSI_SYSTEMS_B yt
1600: SET CUSTOMER_ID = NUM_COL1_NEW_LIST(I) ,
1601: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
1602: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
1603: LAST_UPDATE_DATE = SYSDATE ,

Line 1810: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

1806: CLOSE merged_records;
1807:
1808: END IF;
1809:
1810: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1811:
1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

Line 1814: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

1810: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1811:
1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1815: CLOSE merged_records;
1816: raise;
1817: END csi_systems_b_merge;
1818:

Line 1817: END csi_systems_b_merge;

1813: WHEN OTHERS THEN
1814: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1815: CLOSE merged_records;
1816: raise;
1817: END csi_systems_b_merge;
1818:
1819: PROCEDURE csi_t_party_accounts_merge( req_id IN NUMBER,
1820: set_num IN NUMBER,
1821: process_mode IN VARCHAR2 ) IS