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 1447: PROCEDURE csi_systems_b_merge(req_id IN NUMBER,

1443: csi_t_gen_utility_pvt.add('In others :'||l_msg_data||'-'||SQLERRM );
1444: RAISE;
1445: END csi_ip_accounts_merge; -- } 1
1446:
1447: PROCEDURE csi_systems_b_merge(req_id IN NUMBER,
1448: set_num IN NUMBER,
1449: process_mode IN VARCHAR2) IS
1450:
1451: error_str VARCHAR2(3);

Line 1472: CSI_SYSTEMS_B.SYSTEM_ID%TYPE

1468:
1469: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1470:
1471: TYPE SYSTEM_ID_LIST_TYPE IS TABLE OF
1472: CSI_SYSTEMS_B.SYSTEM_ID%TYPE
1473: INDEX BY BINARY_INTEGER;
1474:
1475: PRIMARY_KEY_ID_LIST SYSTEM_ID_LIST_TYPE;
1476:

Line 1478: CSI_SYSTEMS_B.CUSTOMER_ID%TYPE

1474:
1475: PRIMARY_KEY_ID_LIST SYSTEM_ID_LIST_TYPE;
1476:
1477: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
1478: CSI_SYSTEMS_B.CUSTOMER_ID%TYPE
1479: INDEX BY BINARY_INTEGER;
1480:
1481: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1482: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;

Line 1485: CSI_SYSTEMS_B.BILL_TO_SITE_USE_ID%TYPE

1481: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
1482: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
1483:
1484: TYPE BILL_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
1485: CSI_SYSTEMS_B.BILL_TO_SITE_USE_ID%TYPE
1486: INDEX BY BINARY_INTEGER;
1487:
1488: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
1489: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;

Line 1492: CSI_SYSTEMS_B.SHIP_TO_SITE_USE_ID%TYPE

1488: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
1489: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
1490:
1491: TYPE SHIP_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
1492: CSI_SYSTEMS_B.SHIP_TO_SITE_USE_ID%TYPE
1493: INDEX BY BINARY_INTEGER;
1494:
1495: NUM_COL3_ORIG_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
1496: NUM_COL3_NEW_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;

Line 1505: FROM CSI_SYSTEMS_B yt,

1501: yt.SYSTEM_ID ,
1502: yt.CUSTOMER_ID ,
1503: yt.BILL_TO_SITE_USE_ID ,
1504: yt.SHIP_TO_SITE_USE_ID
1505: FROM CSI_SYSTEMS_B yt,
1506: RA_CUSTOMER_MERGES m
1507: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
1508: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
1509: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID )

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

1514: I NUMBER;
1515: v_system_history_id NUMBER;
1516: BEGIN
1517:
1518: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
1519:
1520: IF (process_mode = 'LOCK') THEN
1521:
1522: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;

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

1518: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()+');
1519:
1520: IF (process_mode = 'LOCK') THEN
1521:
1522: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1523:
1524: write_to_cr_log( 'Locking the csi_systems_b table' );
1525: arp_message.set_name('AR','AR_LOCKING_TABLE');
1526: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);

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

1520: IF (process_mode = 'LOCK') THEN
1521:
1522: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1523:
1524: write_to_cr_log( 'Locking the csi_systems_b table' );
1525: arp_message.set_name('AR','AR_LOCKING_TABLE');
1526: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1527:
1528: OPEN merged_records;

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

1522: write_to_cr_log( 'CSI : csi_systems_b_merge...' || process_mode ) ;
1523:
1524: write_to_cr_log( 'Locking the csi_systems_b table' );
1525: arp_message.set_name('AR','AR_LOCKING_TABLE');
1526: arp_message.set_token('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1527:
1528: OPEN merged_records;
1529: CLOSE merged_records;
1530:

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

1527:
1528: OPEN merged_records;
1529: CLOSE merged_records;
1530:
1531: write_to_cr_log( 'Done Locking the csi_systems_b table' );
1532:
1533: ELSE
1534:
1535: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );

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

1531: write_to_cr_log( 'Done Locking the csi_systems_b table' );
1532:
1533: ELSE
1534:
1535: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1536:
1537: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1538: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1539: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

1534:
1535: write_to_cr_log( 'CSI : csi_systems_b_merge.....' || process_mode );
1536:
1537: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1538: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_SYSTEMS_B',FALSE);
1539: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1540: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1541:
1542: OPEN merged_records;

Line 1608: 'CSI_SYSTEMS_B' ,

1604: )
1605: VALUES
1606: (
1607: HZ_CUSTOMER_MERGE_LOG_s.nextval ,
1608: 'CSI_SYSTEMS_B' ,
1609: MERGE_HEADER_ID_LIST(I) ,
1610: PRIMARY_KEY_ID_LIST(I) ,
1611: NUM_COL1_ORIG_LIST(I) ,
1612: NUM_COL1_NEW_LIST(I) ,

Line 1631: UPDATE CSI_SYSTEMS_B yt

1627:
1628: write_to_cr_log( 'CSI : Before Update Loop check ');
1629:
1630: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP -- { I Loop
1631: UPDATE CSI_SYSTEMS_B yt
1632: SET CUSTOMER_ID = NUM_COL1_NEW_LIST(I) ,
1633: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
1634: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
1635: LAST_UPDATE_DATE = SYSDATE ,

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

1838: CLOSE merged_records;
1839:
1840: END IF;
1841:
1842: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1843:
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');

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

1842: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1843:
1844: EXCEPTION
1845: WHEN OTHERS THEN
1846: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1847: CLOSE merged_records;
1848: raise;
1849: END csi_systems_b_merge;
1850:

Line 1849: END csi_systems_b_merge;

1845: WHEN OTHERS THEN
1846: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_SYSTEMS_B_MERGE()-');
1847: CLOSE merged_records;
1848: raise;
1849: END csi_systems_b_merge;
1850:
1851: PROCEDURE csi_t_party_accounts_merge( req_id IN NUMBER,
1852: set_num IN NUMBER,
1853: process_mode IN VARCHAR2 ) IS