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.ARP_CMERGE_ARCUS dependencies on RA_CUST_RECEIPT_METHODS

Line 1877: | merge in RA_CUST_RECEIPT_METHODS

Line 1902: | products and RA_CUST_RECEIPT_METHODS does

1898: | Jianying Huang 12-DEC-00 Modified cursor c2. Replace 'active addresses
1899: | exist' with 'active accounts exist'
1900: | Jianying Huang 20-DEC-00 Bug 1535542: Since we need to change
1901: | the merging order, merge HZ tables before merging
1902: | products and RA_CUST_RECEIPT_METHODS does
1903: | not have status column, we need to move the delete part
1904: | to 'delete_rows' procedure.
1905: | Victoria Crisostomo 01-FEB-01
1906: | Bug 1611619 : include customer_id in where condition

Line 1914: | HZ_CUSTOMER_MERGE_LOG and updating RA_CUST_RECEIPT_METHODS

1910: | Customer_merge_header_id , Cust_receipt_method_id and
1911: | end_date are bulk collected into the pl/sql tables
1912: | header_id,receipt_id,end_date.
1913: | While inserting auditing values into the table
1914: | HZ_CUSTOMER_MERGE_LOG and updating RA_CUST_RECEIPT_METHODS
1915: | , values stored in pl/sql tables are used.
1916: | Commented the insert statement and update statements.
1917: |
1918: +===========================================================================*/

Line 1931: FROM RA_CUST_RECEIPT_METHODS ra, ra_customer_merges m

1927:
1928: --cursor c1 and c2 are used in 'inactivate' mode
1929: CURSOR c1 IS
1930: SELECT CUST_RECEIPT_METHOD_ID
1931: FROM RA_CUST_RECEIPT_METHODS ra, ra_customer_merges m
1932: WHERE ra.customer_id = m.duplicate_id
1933: AND site_use_id = m.duplicate_site_id
1934: AND m.process_flag = 'N'
1935: AND m.request_id = req_id

Line 1942: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1938: FOR UPDATE NOWAIT;
1939:
1940: CURSOR c2 IS
1941: SELECT CUST_RECEIPT_METHOD_ID
1942: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1943: WHERE yt.customer_id = m.duplicate_id
1944: AND m.process_flag = 'N'
1945: AND m.request_id = req_id
1946: AND m.set_number = set_num

Line 1957: TYPE cust_receipt_method_id_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.CUST_RECEIPT_METHOD_ID%TYPE INDEX BY BINARY_INTEGER;

1953: AND acct.status = 'A' )
1954: FOR UPDATE NOWAIT;
1955:
1956: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1957: TYPE cust_receipt_method_id_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.CUST_RECEIPT_METHOD_ID%TYPE INDEX BY BINARY_INTEGER;
1958: TYPE end_date_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.END_DATE%TYPE INDEX BY BINARY_INTEGER;
1959:
1960: header_id customer_merge_header_id_tab;
1961: receipt_id cust_receipt_method_id_tab;

Line 1958: TYPE end_date_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.END_DATE%TYPE INDEX BY BINARY_INTEGER;

1954: FOR UPDATE NOWAIT;
1955:
1956: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1957: TYPE cust_receipt_method_id_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.CUST_RECEIPT_METHOD_ID%TYPE INDEX BY BINARY_INTEGER;
1958: TYPE end_date_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.END_DATE%TYPE INDEX BY BINARY_INTEGER;
1959:
1960: header_id customer_merge_header_id_tab;
1961: receipt_id cust_receipt_method_id_tab;
1962: end_date end_date_tab;

Line 1972: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );

1968: /* locking tables by opening and closing cursors */
1969: IF process_mode = 'LOCK' THEN
1970:
1971: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1972: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
1973:
1974: OPEN c1;
1975: CLOSE c1;
1976:

Line 1985: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );

1981:
1982: /************** account site level inactivate ************/
1983:
1984: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
1985: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
1986:
1987: --- bug 3786802
1988:
1989: SELECT distinct CUSTOMER_MERGE_HEADER_ID,

Line 1993: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1989: SELECT distinct CUSTOMER_MERGE_HEADER_ID,
1990: CUST_RECEIPT_METHOD_ID,
1991: END_DATE
1992: BULK COLLECT INTO header_id,receipt_id,end_date
1993: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1994: WHERE (yt.CUSTOMER_ID = m.DUPLICATE_ID
1995: AND ( ( yt.SITE_USE_ID IS NULL
1996: AND NOT EXISTS (
1997: SELECT 'active accounts exist'

Line 2038: 'RA_CUST_RECEIPT_METHODS',

2034:
2035: VALUES (
2036: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2037: header_id(i),
2038: 'RA_CUST_RECEIPT_METHODS',
2039: receipt_id(i),
2040: end_date(i),
2041: new_date,
2042: req_id,

Line 2075: 'RA_CUST_RECEIPT_METHODS',

2071:
2072:
2073: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2074: CUSTOMER_MERGE_HEADER_ID,
2075: 'RA_CUST_RECEIPT_METHODS',
2076: CUST_RECEIPT_METHOD_ID,
2077: END_DATE,
2078: SYSDATE,
2079: req_id,

Line 2091: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

2087: FROM (
2088: SELECT distinct CUSTOMER_MERGE_HEADER_ID,
2089: CUST_RECEIPT_METHOD_ID,
2090: END_DATE
2091: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
2092: WHERE (yt.CUSTOMER_ID = m.DUPLICATE_ID
2093: AND ( ( yt.SITE_USE_ID IS NULL
2094: AND NOT EXISTS (
2095: SELECT 'active accounts exist'

Line 2110: | UPDATE RA_CUST_RECEIPT_METHODS yt

2106: );*/
2107:
2108: /*
2109: | --- bug 1611619 : put customer_id in where clause to use index
2110: | UPDATE RA_CUST_RECEIPT_METHODS yt
2111: | SET end_date = sysdate,
2112: | last_update_date = sysdate,
2113: | last_updated_by = arp_standard.profile.user_id,
2114: | last_update_login = arp_standard.profile.last_update_login,

Line 2129: UPDATE RA_CUST_RECEIPT_METHODS yt SET (

2125: | AND m.delete_duplicate_flag = 'N' ); */
2126:
2127: -- Commented for bug 3786802
2128: /*
2129: UPDATE RA_CUST_RECEIPT_METHODS yt SET (
2130: END_DATE) = (
2131: SELECT DATE_COL1_NEW
2132: FROM HZ_CUSTOMER_MERGE_LOG l
2133: WHERE l.REQUEST_ID = req_id

Line 2134: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'

2130: END_DATE) = (
2131: SELECT DATE_COL1_NEW
2132: FROM HZ_CUSTOMER_MERGE_LOG l
2133: WHERE l.REQUEST_ID = req_id
2134: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2135: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2136: )
2137: , LAST_UPDATE_DATE=SYSDATE
2138: , last_updated_by=arp_standard.profile.user_id

Line 2148: AND l1.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'

2144: WHERE (CUST_RECEIPT_METHOD_ID) in (
2145: SELECT PRIMARY_KEY_ID
2146: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h
2147: WHERE h.CUSTOMER_MERGE_HEADER_ID = l1.MERGE_HEADER_ID
2148: AND l1.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2149: AND l1.REQUEST_ID = req_id
2150: AND h.set_number = set_num);
2151:
2152: */

Line 2158: UPDATE RA_CUST_RECEIPT_METHODS yt SET

2154:
2155: FORALL i in 1..receipt_id.count
2156:
2157:
2158: UPDATE RA_CUST_RECEIPT_METHODS yt SET
2159: END_DATE = new_date
2160: , LAST_UPDATE_DATE=sysdate
2161: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2162: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login

Line 2177: | arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );

2173:
2174: /************** account level inactivate ************/
2175:
2176: /* arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
2177: | arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
2178:
2179: |
2180: | UPDATE RA_CUST_RECEIPT_METHODS yt
2181: | set end_date = sysdate,

Line 2180: | UPDATE RA_CUST_RECEIPT_METHODS yt

2176: /* arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
2177: | arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
2178:
2179: |
2180: | UPDATE RA_CUST_RECEIPT_METHODS yt
2181: | set end_date = sysdate,
2182: | last_update_date = sysdate,
2183: | last_updated_by = arp_standard.profile.user_id,
2184: | last_update_login = arp_standard.profile.last_update_login,

Line 4624: | ra_cust_receipt_methods to use index.

4620: | Jianying Huang 19-DEC-00 Bug 1535542: physically delete rows in
4621: | customer tables after merging each set.
4622: | Jianying Huang 29-DEC-00 Modified 'delete_rows' for performance issue.
4623: | Jianying Huang 09-APR-01 Bug 1725662: rewrite sql statement on delete
4624: | ra_cust_receipt_methods to use index.
4625: |
4626: +===========================================================================*/
4627:
4628: PROCEDURE delete_rows(

Line 4694: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

4690: FOR UPDATE NOWAIT;
4691:
4692: CURSOR cust_receipt_methods_site IS
4693: SELECT CUST_RECEIPT_METHOD_ID
4694: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
4695: WHERE yt.customer_id = m.duplicate_id
4696: AND yt.site_use_id = m.duplicate_site_id
4697: AND m.process_flag = 'N'
4698: AND m.request_id = req_id

Line 4705: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

4701: FOR UPDATE NOWAIT;
4702:
4703: CURSOR cust_receipt_methods_acct IS
4704: SELECT CUST_RECEIPT_METHOD_ID
4705: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
4706: WHERE yt.customer_id = m.duplicate_id
4707: AND m.process_flag = 'N'
4708: AND m.request_id = req_id
4709: AND m.set_number = set_num

Line 4933: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );

4929:
4930: /************** account site level delete ************/
4931:
4932: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
4933: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
4934:
4935: OPEN cust_receipt_methods_site;
4936: CLOSE cust_receipt_methods_site;
4937:

Line 4940: DELETE FROM RA_CUST_RECEIPT_METHODS yt

4936: CLOSE cust_receipt_methods_site;
4937:
4938: --Bug 1725662: Rewrite the query to use index.
4939:
4940: DELETE FROM RA_CUST_RECEIPT_METHODS yt
4941: WHERE (customer_id, site_use_id) in (
4942: SELECT m.duplicate_id, m.duplicate_site_id
4943: FROM ra_customer_merges m
4944: WHERE m.process_flag = 'N'

Line 4957: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );

4953:
4954: /************** account level delete ************/
4955:
4956: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
4957: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
4958:
4959: OPEN cust_receipt_methods_acct;
4960: CLOSE cust_receipt_methods_acct;
4961:

Line 4962: DELETE FROM RA_CUST_RECEIPT_METHODS yt

4958:
4959: OPEN cust_receipt_methods_acct;
4960: CLOSE cust_receipt_methods_acct;
4961:
4962: DELETE FROM RA_CUST_RECEIPT_METHODS yt
4963: WHERE customer_id in (
4964: SELECT m.duplicate_id
4965: FROM ra_customer_merges m
4966: WHERE m.process_flag = 'N'

Line 5324: from RA_CUST_RECEIPT_METHODS

5320: ATTRIBUTE12,
5321: ATTRIBUTE13,
5322: ATTRIBUTE14,
5323: ATTRIBUTE15
5324: from RA_CUST_RECEIPT_METHODS
5325: WHERE CUSTOMER_ID = l_duplicate_id
5326: AND site_use_id = l_duplicate_site_id;
5327: l_row_id varchar2(240);
5328: l_Cust_Receipt_Method_Id varchar2(15);

Line 6814: update RA_CUST_RECEIPT_METHODS

6810: --the table.So the following update statement is created to
6811: --update rest of the fields.
6812:
6813: if l_row_id is not null then
6814: update RA_CUST_RECEIPT_METHODS
6815: set
6816: last_update_date = sysdate,
6817: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6818: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,