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_T_TXN_SYSTEMS

Line 37: CSI_T_TXN_SYSTEMS_MERGE(req_id, set_num, process_mode);

33: write_to_cr_log( ' Ending process for Party Accounts ' );
34:
35: error_str := '005';
36: write_to_cr_log( ' Processing CSI Transaction Systems Merge ' );
37: CSI_T_TXN_SYSTEMS_MERGE(req_id, set_num, process_mode);
38: write_to_cr_log( ' Ending process for CSI Transaction Systems Merge ' );
39: */
40:
41: arp_message.set_line('CSI_ACCT_MERGE_PKG.MERGE()-');

Line 2040: PROCEDURE csi_t_txn_systems_merge( req_id IN NUMBER,

2036: CLOSE merged_records;
2037: raise;
2038: END csi_t_party_accounts_merge;
2039:
2040: PROCEDURE csi_t_txn_systems_merge( req_id IN NUMBER,
2041: set_num IN NUMBER,
2042: process_mode IN VARCHAR2) IS
2043:
2044: error_str VARCHAR2(3);

Line 2057: CSI_T_TXN_SYSTEMS.TRANSACTION_SYSTEM_ID%TYPE

2053:
2054: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
2055:
2056: TYPE TRXN_SYSTEM_ID_LIST_TYPE IS TABLE OF
2057: CSI_T_TXN_SYSTEMS.TRANSACTION_SYSTEM_ID%TYPE
2058: INDEX BY BINARY_INTEGER;
2059:
2060: PRIMARY_KEY_ID_LIST TRXN_SYSTEM_ID_LIST_TYPE;
2061:

Line 2063: CSI_T_TXN_SYSTEMS.CUSTOMER_ID%TYPE

2059:
2060: PRIMARY_KEY_ID_LIST TRXN_SYSTEM_ID_LIST_TYPE;
2061:
2062: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
2063: CSI_T_TXN_SYSTEMS.CUSTOMER_ID%TYPE
2064: INDEX BY BINARY_INTEGER;
2065:
2066: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2067: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;

Line 2070: CSI_T_TXN_SYSTEMS.BILL_TO_SITE_USE_ID%TYPE

2066: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2067: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
2068:
2069: TYPE BILL_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
2070: CSI_T_TXN_SYSTEMS.BILL_TO_SITE_USE_ID%TYPE
2071: INDEX BY BINARY_INTEGER;
2072:
2073: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
2074: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;

Line 2077: CSI_T_TXN_SYSTEMS.SHIP_TO_SITE_USE_ID%TYPE

2073: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
2074: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
2075:
2076: TYPE SHIP_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
2077: CSI_T_TXN_SYSTEMS.SHIP_TO_SITE_USE_ID%TYPE
2078: INDEX BY BINARY_INTEGER;
2079:
2080: NUM_COL3_ORIG_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
2081: NUM_COL3_NEW_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;

Line 2084: CSI_T_TXN_SYSTEMS.INSTALL_SITE_USE_ID%TYPE

2080: NUM_COL3_ORIG_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
2081: NUM_COL3_NEW_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
2082:
2083: TYPE INSTALL_SITE_USE_ID_LIST_TYPE IS TABLE OF
2084: CSI_T_TXN_SYSTEMS.INSTALL_SITE_USE_ID%TYPE
2085: INDEX BY BINARY_INTEGER;
2086:
2087: NUM_COL4_ORIG_LIST INSTALL_SITE_USE_ID_LIST_TYPE;
2088: NUM_COL4_NEW_LIST INSTALL_SITE_USE_ID_LIST_TYPE;

Line 2097: FROM CSI_T_TXN_SYSTEMS yt,

2093: yt.CUSTOMER_ID ,
2094: yt.BILL_TO_SITE_USE_ID ,
2095: yt.SHIP_TO_SITE_USE_ID ,
2096: yt.INSTALL_SITE_USE_ID
2097: FROM CSI_T_TXN_SYSTEMS yt,
2098: RA_CUSTOMER_MERGES m
2099: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
2100: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
2101: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR

Line 2109: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');

2105: AND m.set_number = set_num;
2106:
2107: BEGIN
2108:
2109: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
2110:
2111: IF (process_mode = 'LOCK') THEN
2112: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2113:

Line 2112: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );

2108:
2109: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
2110:
2111: IF (process_mode = 'LOCK') THEN
2112: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2113:
2114: arp_message.set_name('AR','AR_LOCKING_TABLE');
2115: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2116:

Line 2115: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);

2111: IF (process_mode = 'LOCK') THEN
2112: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2113:
2114: arp_message.set_name('AR','AR_LOCKING_TABLE');
2115: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2116:
2117: OPEN merged_records;
2118: CLOSE merged_records;
2119:

Line 2120: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );

2116:
2117: OPEN merged_records;
2118: CLOSE merged_records;
2119:
2120: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2121: ELSE
2122: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2123: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2124: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 2123: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);

2119:
2120: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2121: ELSE
2122: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2123: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2124: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2125: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2126:
2127: OPEN merged_records;

Line 2178: 'CSI_T_TXN_SYSTEMS',

2174: LAST_UPDATE_DATE,
2175: LAST_UPDATED_BY)
2176: VALUES (
2177: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2178: 'CSI_T_TXN_SYSTEMS',
2179: MERGE_HEADER_ID_LIST(I),
2180: PRIMARY_KEY_ID_LIST(I),
2181: NUM_COL1_ORIG_LIST(I),
2182: NUM_COL1_NEW_LIST(I),

Line 2199: UPDATE CSI_T_TXN_SYSTEMS yt

2195: hz_utility_pub.LAST_UPDATED_BY );
2196: END IF;
2197:
2198: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2199: UPDATE CSI_T_TXN_SYSTEMS yt
2200: SET CUSTOMER_ID = NUM_COL1_NEW_LIST(I) ,
2201: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
2202: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
2203: INSTALL_SITE_USE_ID = NUM_COL4_NEW_LIST(I) ,

Line 2224: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );

2220: CLOSE merged_records;
2221:
2222: arp_message.set_name('AR','AR_ROWS_UPDATED');
2223: arp_message.set_token('NUM_ROWS',to_char(l_count));
2224: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2225:
2226: END IF;
2227:
2228: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

Line 2228: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

2224: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2225:
2226: END IF;
2227:
2228: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2229:
2230: EXCEPTION
2231: WHEN OTHERS THEN
2232: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

Line 2232: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

2228: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2229:
2230: EXCEPTION
2231: WHEN OTHERS THEN
2232: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2233: CLOSE merged_records;
2234: raise;
2235: END csi_t_txn_systems_merge;
2236:

Line 2235: END csi_t_txn_systems_merge;

2231: WHEN OTHERS THEN
2232: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2233: CLOSE merged_records;
2234: raise;
2235: END csi_t_txn_systems_merge;
2236:
2237: PROCEDURE write_to_cr_log ( p_message IN VARCHAR2) IS
2238: BEGIN
2239: IF csi_acct_merge_pkg.g_debug_on > 0 THEN