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 1851: PROCEDURE csi_t_party_accounts_merge( req_id IN NUMBER,

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
1854:
1855: error_str VARCHAR2(3);

Line 1868: CSI_T_PARTY_ACCOUNTS.TXN_ACCOUNT_DETAIL_ID%TYPE

1864:
1865: MERGE_HEADER_ID_LIST MERGE_HEADER_ID_LIST_TYPE;
1866:
1867: TYPE TXN_ACCT_DETAIL_ID_LIST_TYPE IS TABLE OF
1868: CSI_T_PARTY_ACCOUNTS.TXN_ACCOUNT_DETAIL_ID%TYPE
1869: INDEX BY BINARY_INTEGER;
1870:
1871: PRIMARY_KEY_ID_LIST TXN_ACCT_DETAIL_ID_LIST_TYPE;
1872:

Line 1874: CSI_T_PARTY_ACCOUNTS.ACCOUNT_ID%TYPE

1870:
1871: PRIMARY_KEY_ID_LIST TXN_ACCT_DETAIL_ID_LIST_TYPE;
1872:
1873: TYPE ACCOUNT_ID_LIST_TYPE IS TABLE OF
1874: CSI_T_PARTY_ACCOUNTS.ACCOUNT_ID%TYPE
1875: INDEX BY BINARY_INTEGER;
1876:
1877: NUM_COL1_ORIG_LIST ACCOUNT_ID_LIST_TYPE;
1878: NUM_COL1_NEW_LIST ACCOUNT_ID_LIST_TYPE;

Line 1881: CSI_T_PARTY_ACCOUNTS.BILL_TO_ADDRESS_ID%TYPE

1877: NUM_COL1_ORIG_LIST ACCOUNT_ID_LIST_TYPE;
1878: NUM_COL1_NEW_LIST ACCOUNT_ID_LIST_TYPE;
1879:
1880: TYPE BILL_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
1881: CSI_T_PARTY_ACCOUNTS.BILL_TO_ADDRESS_ID%TYPE
1882: INDEX BY BINARY_INTEGER;
1883:
1884: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1885: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;

Line 1888: CSI_T_PARTY_ACCOUNTS.SHIP_TO_ADDRESS_ID%TYPE

1884: NUM_COL2_ORIG_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1885: NUM_COL2_NEW_LIST BILL_TO_ADDRESS_ID_LIST_TYPE;
1886:
1887: TYPE SHIP_TO_ADDRESS_ID_LIST_TYPE IS TABLE OF
1888: CSI_T_PARTY_ACCOUNTS.SHIP_TO_ADDRESS_ID%TYPE
1889: INDEX BY BINARY_INTEGER;
1890:
1891: NUM_COL3_ORIG_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;
1892: NUM_COL3_NEW_LIST SHIP_TO_ADDRESS_ID_LIST_TYPE;

Line 1900: FROM CSI_T_PARTY_ACCOUNTS yt,

1896: TXN_ACCOUNT_DETAIL_ID ,
1897: ACCOUNT_ID ,
1898: BILL_TO_ADDRESS_ID ,
1899: SHIP_TO_ADDRESS_ID
1900: FROM CSI_T_PARTY_ACCOUNTS yt,
1901: RA_CUSTOMER_MERGES m
1902: WHERE ( yt.ACCOUNT_ID = m.DUPLICATE_ID OR
1903: yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID OR
1904: yt.SHIP_TO_ADDRESS_ID = m.DUPLICATE_SITE_ID )

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

1907: AND m.set_number = set_num;
1908:
1909: BEGIN
1910:
1911: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');
1912:
1913: IF (process_mode = 'LOCK') THEN
1914:
1915: write_to_cr_log( 'Locking the csi_t_party_accounts' );

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

1911: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()+');
1912:
1913: IF (process_mode = 'LOCK') THEN
1914:
1915: write_to_cr_log( 'Locking the csi_t_party_accounts' );
1916:
1917: arp_message.set_name('AR','AR_LOCKING_TABLE');
1918: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1919:

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

1914:
1915: write_to_cr_log( 'Locking the csi_t_party_accounts' );
1916:
1917: arp_message.set_name('AR','AR_LOCKING_TABLE');
1918: arp_message.set_token('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1919:
1920: OPEN merged_records;
1921: CLOSE merged_records;
1922:

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

1919:
1920: OPEN merged_records;
1921: CLOSE merged_records;
1922:
1923: write_to_cr_log( 'Done Locking the csi_t_party_accounts' );
1924: ELSE
1925: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1926:
1927: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

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

1921: CLOSE merged_records;
1922:
1923: write_to_cr_log( 'Done Locking the csi_t_party_accounts' );
1924: ELSE
1925: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1926:
1927: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1928: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1929: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

1924: ELSE
1925: write_to_cr_log( 'Starting to update the csi_t_party_accounts' );
1926:
1927: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1928: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','CSI_T_PARTY_ACCOUNTS',FALSE);
1929: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1930: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1931:
1932: OPEN merged_records;

Line 1982: 'CSI_T_PARTY_ACCOUNTS' ,

1978: )
1979: VALUES
1980: (
1981: HZ_CUSTOMER_MERGE_LOG_s.nextval ,
1982: 'CSI_T_PARTY_ACCOUNTS' ,
1983: MERGE_HEADER_ID_LIST(I) ,
1984: PRIMARY_KEY_ID_LIST(I) ,
1985: NUM_COL1_ORIG_LIST(I) ,
1986: NUM_COL1_NEW_LIST(I) ,

Line 2002: UPDATE CSI_T_PARTY_ACCOUNTS yt

1998: );
1999: END IF;
2000:
2001: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2002: UPDATE CSI_T_PARTY_ACCOUNTS yt
2003: SET ACCOUNT_ID = NUM_COL1_NEW_LIST(I) ,
2004: BILL_TO_ADDRESS_ID = NUM_COL2_NEW_LIST(I) ,
2005: SHIP_TO_ADDRESS_ID = NUM_COL3_NEW_LIST(I) ,
2006: LAST_UPDATE_DATE = SYSDATE ,

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

2023: CLOSE merged_records;
2024:
2025: arp_message.set_name('AR','AR_ROWS_UPDATED');
2026: arp_message.set_token('NUM_ROWS',to_char(l_count));
2027: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
2028:
2029: END IF;
2030:
2031: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

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

2027: arp_message.set_line( 'Done with the update of csi_t_party_accounts' );
2028:
2029: END IF;
2030:
2031: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2032:
2033: EXCEPTION
2034: WHEN OTHERS THEN
2035: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');

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

2031: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2032:
2033: EXCEPTION
2034: WHEN OTHERS THEN
2035: arp_message.set_line('CSI_ACCT_MERGE_PKG.CSI_T_PARTY_ACCOUNTS_MERGE()-');
2036: CLOSE merged_records;
2037: raise;
2038: END csi_t_party_accounts_merge;
2039:

Line 2038: END csi_t_party_accounts_merge;

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