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_PARTY_ACCOUNTS

Line 32: CSI_T_PARTY_ACCOUNTS_MERGE(req_id, set_num, process_mode);

28: write_to_cr_log( ' Ending process for IP Accounts Merge ' );
29:
30: error_str := '004';
31: write_to_cr_log( ' Processing Party Accounts Merge ' );
32: CSI_T_PARTY_ACCOUNTS_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 ' );

Line 1819: PROCEDURE csi_t_party_accounts_merge( req_id IN NUMBER,

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
1822:
1823: error_str VARCHAR2(3);

Line 1836: CSI_T_PARTY_ACCOUNTS.TXN_ACCOUNT_DETAIL_ID%TYPE

1832:
1833: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1834:
1835: TYPE TXN_ACCT_DETAIL_ID_LIST_TYPE IS TABLE OF
1836: CSI_T_PARTY_ACCOUNTS.TXN_ACCOUNT_DETAIL_ID%TYPE
1837: INDEX BY BINARY_INTEGER;
1838:
1839: PRIMARY_KEY_ID_LIST TXN_ACCT_DETAIL_ID_LIST_TYPE;
1840:

Line 1842: CSI_T_PARTY_ACCOUNTS.ACCOUNT_ID%TYPE

1838:
1839: PRIMARY_KEY_ID_LIST TXN_ACCT_DETAIL_ID_LIST_TYPE;
1840:
1841: TYPE ACCOUNT_ID_LIST_TYPE IS TABLE OF
1842: CSI_T_PARTY_ACCOUNTS.ACCOUNT_ID%TYPE
1843: INDEX BY BINARY_INTEGER;
1844:
1845: NUM_COL1_ORIG_LIST ACCOUNT_ID_LIST_TYPE;
1846: NUM_COL1_NEW_LIST ACCOUNT_ID_LIST_TYPE;

Line 1849: CSI_T_PARTY_ACCOUNTS.BILL_TO_ADDRESS_ID%TYPE

1845: NUM_COL1_ORIG_LIST ACCOUNT_ID_LIST_TYPE;
1846: NUM_COL1_NEW_LIST ACCOUNT_ID_LIST_TYPE;
1847:
1848: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
1849: CSI_T_PARTY_ACCOUNTS.BILL_TO_ADDRESS_ID%TYPE
1850: INDEX BY BINARY_INTEGER;
1851:
1852: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1853: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;

Line 1856: CSI_T_PARTY_ACCOUNTS.SHIP_TO_ADDRESS_ID%TYPE

1852: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1853: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1854:
1855: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
1856: CSI_T_PARTY_ACCOUNTS.SHIP_TO_ADDRESS_ID%TYPE
1857: INDEX BY BINARY_INTEGER;
1858:
1859: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
1860: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;

Line 1868: FROM CSI_T_PARTY_ACCOUNTS yt,

1864: TXN_ACCOUNT_DETAIL_ID ,
1865: ACCOUNT_ID ,
1866: BILL_TO_ADDRESS_ID ,
1867: SHIP_TO_ADDRESS_ID
1868: FROM CSI_T_PARTY_ACCOUNTS yt,
1869: RA_CUSTOMER_MERGES m
1870: WHERE ( yt.ACCOUNT_ID = m.DUPLICATE_ID OR
1871: yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID OR
1872: yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID )

Line 1879: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');

1875: AND m.set_number = set_num;
1876:
1877: BEGIN
1878:
1879: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');
1880:
1881: IF (process_mode = 'LOCK') THEN
1882:
1883: write_to_cr_log( 'Locking the csi_t_party_accounts' );

Line 1883: write_to_cr_log( 'Locking the csi_t_party_accounts' );

1879: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');
1880:
1881: IF (process_mode = 'LOCK') THEN
1882:
1883: write_to_cr_log( 'Locking the csi_t_party_accounts' );
1884:
1885: arp_message.set_name('AR','AR_LOCKING_TABLE');
1886: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1887:

Line 1886: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);

1882:
1883: write_to_cr_log( 'Locking the csi_t_party_accounts' );
1884:
1885: arp_message.set_name('AR','AR_LOCKING_TABLE');
1886: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1887:
1888: OPEN merged_records;
1889: CLOSE merged_records;
1890:

Line 1891: write_to_cr_log( 'Done Locking the csi_t_party_accounts' );

1887:
1888: OPEN merged_records;
1889: CLOSE merged_records;
1890:
1891: write_to_cr_log( 'Done Locking the csi_t_party_accounts' );
1892: ELSE
1893: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1894:
1895: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

Line 1893: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );

1889: CLOSE merged_records;
1890:
1891: write_to_cr_log( 'Done Locking the csi_t_party_accounts' );
1892: ELSE
1893: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1894:
1895: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1896: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1897: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

Line 1896: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);

1892: ELSE
1893: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1894:
1895: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1896: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1897: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1898: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1899:
1900: OPEN merged_records;

Line 1950: 'CSI_T_PARTY_ACCOUNTS' ,

1946: )
1947: VALUES
1948: (
1949: HZ_CUSTOMER_MERGE_LOG_s.nextval ,
1950: 'CSI_T_PARTY_ACCOUNTS' ,
1951: MERGE_HEADER_ID_LIST(I) ,
1952: PRIMARY_KEY_ID_LIST(I) ,
1953: NUM_COL1_ORIG_LIST(I) ,
1954: NUM_COL1_NEW_LIST(I) ,

Line 1970: UPDATE CSI_T_PARTY_ACCOUNTS yt

1966: );
1967: END IF;
1968:
1969: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1970: UPDATE CSI_T_PARTY_ACCOUNTS yt
1971: SET ACCOUNT_ID = NUM_COL1_NEW_LIST(I) ,
1972: BILL_TO_ADDRESS_ID = NUM_COL2_NEW_LIST(I) ,
1973: SHIP_TO_ADDRESS_ID = NUM_COL3_NEW_LIST(I) ,
1974: LAST_UPDATE_DATE = SYSDATE ,

Line 1995: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );

1991: CLOSE merged_records;
1992:
1993: arp_message.set_name('AR','AR_ROWS_UPDATED');
1994: arp_message.set_token('NUM_ROWS',to_char(l_count));
1995: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
1996:
1997: END IF;
1998:
1999: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

Line 1999: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

1995: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
1996:
1997: END IF;
1998:
1999: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

Line 2003: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

1999: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2004: CLOSE merged_records;
2005: raise;
2006: END csi_t_party_accounts_merge;
2007:

Line 2006: END csi_t_party_accounts_merge;

2002: WHEN OTHERS THEN
2003: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
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