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 2008: PROCEDURE csi_t_txn_systems_merge( req_id IN NUMBER,

2004: CLOSE merged_records;
2005: raise;
2006: END csi_t_party_accounts_merge;
2007:
2008: PROCEDURE csi_t_txn_systems_merge( req_id IN NUMBER,
2009: set_num IN NUMBER,
2010: process_mode IN VARCHAR2) IS
2011:
2012: error_str VARCHAR2(3);

Line 2025: CSI_T_TXN_SYSTEMS.TRANSACTION_SYSTEM_ID%TYPE

2021:
2022: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
2023:
2024: TYPE TRXN_SYSTEM_ID_LIST_TYPE IS TABLE OF
2025: CSI_T_TXN_SYSTEMS.TRANSACTION_SYSTEM_ID%TYPE
2026: INDEX BY BINARY_INTEGER;
2027:
2028: PRIMARY_KEY_ID_LIST TRXN_SYSTEM_ID_LIST_TYPE;
2029:

Line 2031: CSI_T_TXN_SYSTEMS.CUSTOMER_ID%TYPE

2027:
2028: PRIMARY_KEY_ID_LIST TRXN_SYSTEM_ID_LIST_TYPE;
2029:
2030: TYPE CUSTOMER_ID_LIST_TYPE IS TABLE OF
2031: CSI_T_TXN_SYSTEMS.CUSTOMER_ID%TYPE
2032: INDEX BY BINARY_INTEGER;
2033:
2034: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2035: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;

Line 2038: CSI_T_TXN_SYSTEMS.BILL_TO_SITE_USE_ID%TYPE

2034: NUM_COL1_ORIG_LIST CUSTOMER_ID_LIST_TYPE;
2035: NUM_COL1_NEW_LIST CUSTOMER_ID_LIST_TYPE;
2036:
2037: TYPE BILL_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
2038: CSI_T_TXN_SYSTEMS.BILL_TO_SITE_USE_ID%TYPE
2039: INDEX BY BINARY_INTEGER;
2040:
2041: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
2042: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;

Line 2045: CSI_T_TXN_SYSTEMS.SHIP_TO_SITE_USE_ID%TYPE

2041: NUM_COL2_ORIG_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
2042: NUM_COL2_NEW_LIST BILL_TO_SITE_USE_ID_LIST_TYPE;
2043:
2044: TYPE SHIP_TO_SITE_USE_ID_LIST_TYPE IS TABLE OF
2045: CSI_T_TXN_SYSTEMS.SHIP_TO_SITE_USE_ID%TYPE
2046: INDEX BY BINARY_INTEGER;
2047:
2048: NUM_COL3_ORIG_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
2049: NUM_COL3_NEW_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;

Line 2052: CSI_T_TXN_SYSTEMS.INSTALL_SITE_USE_ID%TYPE

2048: NUM_COL3_ORIG_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
2049: NUM_COL3_NEW_LIST SHIP_TO_SITE_USE_ID_LIST_TYPE;
2050:
2051: TYPE INSTALL_SITE_USE_ID_LIST_TYPE IS TABLE OF
2052: CSI_T_TXN_SYSTEMS.INSTALL_SITE_USE_ID%TYPE
2053: INDEX BY BINARY_INTEGER;
2054:
2055: NUM_COL4_ORIG_LIST INSTALL_SITE_USE_ID_LIST_TYPE;
2056: NUM_COL4_NEW_LIST INSTALL_SITE_USE_ID_LIST_TYPE;

Line 2065: FROM CSI_T_TXN_SYSTEMS yt,

2061: yt.CUSTOMER_ID ,
2062: yt.BILL_TO_SITE_USE_ID ,
2063: yt.SHIP_TO_SITE_USE_ID ,
2064: yt.INSTALL_SITE_USE_ID
2065: FROM CSI_T_TXN_SYSTEMS yt,
2066: RA_CUSTOMER_MERGES m
2067: WHERE ( yt.CUSTOMER_ID = m.DUPLICATE_ID OR
2068: yt.BILL_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR
2069: yt.SHIP_TO_SITE_USE_ID = m.DUPLICATE_SITE_ID OR

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

2073: AND m.set_number = set_num;
2074:
2075: BEGIN
2076:
2077: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
2078:
2079: IF (process_mode = 'LOCK') THEN
2080: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2081:

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

2076:
2077: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()+');
2078:
2079: IF (process_mode = 'LOCK') THEN
2080: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2081:
2082: arp_message.set_name('AR','AR_LOCKING_TABLE');
2083: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2084:

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

2079: IF (process_mode = 'LOCK') THEN
2080: write_to_cr_log( 'Locking the CSI_T_TXN_SYSTEMS table' );
2081:
2082: arp_message.set_name('AR','AR_LOCKING_TABLE');
2083: arp_message.set_token('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2084:
2085: OPEN merged_records;
2086: CLOSE merged_records;
2087:

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

2084:
2085: OPEN merged_records;
2086: CLOSE merged_records;
2087:
2088: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2089: ELSE
2090: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2091: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2092: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

2087:
2088: write_to_cr_log( 'Done Locking the CSI_T_TXN_SYSTEMS table' );
2089: ELSE
2090: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
2091: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_TXN_SYSTEMS',FALSE);
2092: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2093: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2094:
2095: OPEN merged_records;

Line 2146: 'CSI_T_TXN_SYSTEMS',

2142: LAST_UPDATE_DATE,
2143: LAST_UPDATED_BY)
2144: VALUES (
2145: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2146: 'CSI_T_TXN_SYSTEMS',
2147: MERGE_HEADER_ID_LIST(I),
2148: PRIMARY_KEY_ID_LIST(I),
2149: NUM_COL1_ORIG_LIST(I),
2150: NUM_COL1_NEW_LIST(I),

Line 2167: UPDATE CSI_T_TXN_SYSTEMS yt

2163: hz_utility_pub.LAST_UPDATED_BY );
2164: END IF;
2165:
2166: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2167: UPDATE CSI_T_TXN_SYSTEMS yt
2168: SET CUSTOMER_ID = NUM_COL1_NEW_LIST(I) ,
2169: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I) ,
2170: SHIP_TO_SITE_USE_ID = NUM_COL3_NEW_LIST(I) ,
2171: INSTALL_SITE_USE_ID = NUM_COL4_NEW_LIST(I) ,

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

2188: CLOSE merged_records;
2189:
2190: arp_message.set_name('AR','AR_ROWS_UPDATED');
2191: arp_message.set_token('NUM_ROWS',to_char(l_count));
2192: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2193:
2194: END IF;
2195:
2196: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

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

2192: arp_message.set_line( 'Done with the update of CSI_T_TXN_SYSTEMS' );
2193:
2194: END IF;
2195:
2196: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2197:
2198: EXCEPTION
2199: WHEN OTHERS THEN
2200: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');

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

2196: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2197:
2198: EXCEPTION
2199: WHEN OTHERS THEN
2200: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2201: CLOSE merged_records;
2202: raise;
2203: END csi_t_txn_systems_merge;
2204:

Line 2203: END csi_t_txn_systems_merge;

2199: WHEN OTHERS THEN
2200: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_TXN_SYSTEMS_MERGE()-');
2201: CLOSE merged_records;
2202: raise;
2203: END csi_t_txn_systems_merge;
2204:
2205: PROCEDURE write_to_cr_log ( p_message IN VARCHAR2) IS
2206: BEGIN
2207: IF csi_acct_merge_pkg.g_debug_on > 0 THEN