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 1742: | merge in RA_CUST_RECEIPT_METHODS

Line 1767: | products and RA_CUST_RECEIPT_METHODS does

1763: | Jianying Huang 12-DEC-00 Modified cursor c2. Replace 'active addresses
1764: | exist' with 'active accounts exist'
1765: | Jianying Huang 20-DEC-00 Bug 1535542: Since we need to change
1766: | the merging order, merge HZ tables before merging
1767: | products and RA_CUST_RECEIPT_METHODS does
1768: | not have status column, we need to move the delete part
1769: | to 'delete_rows' procedure.
1770: | Victoria Crisostomo 01-FEB-01
1771: | Bug 1611619 : include customer_id in where condition

Line 1779: | HZ_CUSTOMER_MERGE_LOG and updating RA_CUST_RECEIPT_METHODS

1775: | Customer_merge_header_id , Cust_receipt_method_id and
1776: | end_date are bulk collected into the pl/sql tables
1777: | header_id,receipt_id,end_date.
1778: | While inserting auditing values into the table
1779: | HZ_CUSTOMER_MERGE_LOG and updating RA_CUST_RECEIPT_METHODS
1780: | , values stored in pl/sql tables are used.
1781: | Commented the insert statement and update statements.
1782: |
1783: +===========================================================================*/

Line 1796: FROM RA_CUST_RECEIPT_METHODS ra, ra_customer_merges m

1792:
1793: --cursor c1 and c2 are used in 'inactivate' mode
1794: CURSOR c1 IS
1795: SELECT CUST_RECEIPT_METHOD_ID
1796: FROM RA_CUST_RECEIPT_METHODS ra, ra_customer_merges m
1797: WHERE ra.customer_id = m.duplicate_id
1798: AND site_use_id = m.duplicate_site_id
1799: AND m.process_flag = 'N'
1800: AND m.request_id = req_id

Line 1807: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1803: FOR UPDATE NOWAIT;
1804:
1805: CURSOR c2 IS
1806: SELECT CUST_RECEIPT_METHOD_ID
1807: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1808: WHERE yt.customer_id = m.duplicate_id
1809: AND m.process_flag = 'N'
1810: AND m.request_id = req_id
1811: AND m.set_number = set_num

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

1818: AND acct.status = 'A' )
1819: FOR UPDATE NOWAIT;
1820:
1821: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1822: TYPE cust_receipt_method_id_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.CUST_RECEIPT_METHOD_ID%TYPE INDEX BY BINARY_INTEGER;
1823: TYPE end_date_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.END_DATE%TYPE INDEX BY BINARY_INTEGER;
1824:
1825: header_id customer_merge_header_id_tab;
1826: receipt_id cust_receipt_method_id_tab;

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

1819: FOR UPDATE NOWAIT;
1820:
1821: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1822: TYPE cust_receipt_method_id_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.CUST_RECEIPT_METHOD_ID%TYPE INDEX BY BINARY_INTEGER;
1823: TYPE end_date_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.END_DATE%TYPE INDEX BY BINARY_INTEGER;
1824:
1825: header_id customer_merge_header_id_tab;
1826: receipt_id cust_receipt_method_id_tab;
1827: end_date end_date_tab;

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

1833: /* locking tables by opening and closing cursors */
1834: IF process_mode = 'LOCK' THEN
1835:
1836: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1837: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
1838:
1839: OPEN c1;
1840: CLOSE c1;
1841:

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

1846:
1847: /************** account site level inactivate ************/
1848:
1849: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
1850: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
1851:
1852: --- bug 3786802
1853:
1854: SELECT distinct CUSTOMER_MERGE_HEADER_ID,

Line 1858: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1854: SELECT distinct CUSTOMER_MERGE_HEADER_ID,
1855: CUST_RECEIPT_METHOD_ID,
1856: END_DATE
1857: BULK COLLECT INTO header_id,receipt_id,end_date
1858: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1859: WHERE (yt.CUSTOMER_ID = m.DUPLICATE_ID
1860: AND ( ( yt.SITE_USE_ID IS NULL
1861: AND NOT EXISTS (
1862: SELECT 'active accounts exist'

Line 1903: 'RA_CUST_RECEIPT_METHODS',

1899:
1900: VALUES (
1901: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1902: header_id(i),
1903: 'RA_CUST_RECEIPT_METHODS',
1904: receipt_id(i),
1905: end_date(i),
1906: new_date,
1907: req_id,

Line 1940: 'RA_CUST_RECEIPT_METHODS',

1936:
1937:
1938: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1939: CUSTOMER_MERGE_HEADER_ID,
1940: 'RA_CUST_RECEIPT_METHODS',
1941: CUST_RECEIPT_METHOD_ID,
1942: END_DATE,
1943: SYSDATE,
1944: req_id,

Line 1956: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1952: FROM (
1953: SELECT distinct CUSTOMER_MERGE_HEADER_ID,
1954: CUST_RECEIPT_METHOD_ID,
1955: END_DATE
1956: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1957: WHERE (yt.CUSTOMER_ID = m.DUPLICATE_ID
1958: AND ( ( yt.SITE_USE_ID IS NULL
1959: AND NOT EXISTS (
1960: SELECT 'active accounts exist'

Line 1975: | UPDATE RA_CUST_RECEIPT_METHODS yt

1971: );*/
1972:
1973: /*
1974: | --- bug 1611619 : put customer_id in where clause to use index
1975: | UPDATE RA_CUST_RECEIPT_METHODS yt
1976: | SET end_date = sysdate,
1977: | last_update_date = sysdate,
1978: | last_updated_by = arp_standard.profile.user_id,
1979: | last_update_login = arp_standard.profile.last_update_login,

Line 1994: UPDATE RA_CUST_RECEIPT_METHODS yt SET (

1990: | AND m.delete_duplicate_flag = 'N' ); */
1991:
1992: -- Commented for bug 3786802
1993: /*
1994: UPDATE RA_CUST_RECEIPT_METHODS yt SET (
1995: END_DATE) = (
1996: SELECT DATE_COL1_NEW
1997: FROM HZ_CUSTOMER_MERGE_LOG l
1998: WHERE l.REQUEST_ID = req_id

Line 1999: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'

1995: END_DATE) = (
1996: SELECT DATE_COL1_NEW
1997: FROM HZ_CUSTOMER_MERGE_LOG l
1998: WHERE l.REQUEST_ID = req_id
1999: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2000: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2001: )
2002: , LAST_UPDATE_DATE=SYSDATE
2003: , last_updated_by=arp_standard.profile.user_id

Line 2013: AND l1.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'

2009: WHERE (CUST_RECEIPT_METHOD_ID) in (
2010: SELECT PRIMARY_KEY_ID
2011: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h
2012: WHERE h.CUSTOMER_MERGE_HEADER_ID = l1.MERGE_HEADER_ID
2013: AND l1.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2014: AND l1.REQUEST_ID = req_id
2015: AND h.set_number = set_num);
2016:
2017: */

Line 2023: UPDATE RA_CUST_RECEIPT_METHODS yt SET

2019:
2020: FORALL i in 1..receipt_id.count
2021:
2022:
2023: UPDATE RA_CUST_RECEIPT_METHODS yt SET
2024: END_DATE = new_date
2025: , LAST_UPDATE_DATE=sysdate
2026: , last_updated_by=hz_utility_v2pub.user_id--arp_standard.profile.user_id
2027: , last_update_login=hz_utility_v2pub.last_update_login--arp_standard.profile.last_update_login

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

2038:
2039: /************** account level inactivate ************/
2040:
2041: /* arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
2042: | arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
2043:
2044: |
2045: | UPDATE RA_CUST_RECEIPT_METHODS yt
2046: | set end_date = sysdate,

Line 2045: | UPDATE RA_CUST_RECEIPT_METHODS yt

2041: /* arp_message.set_name( 'AR', 'AR_UPDATING_TABLE' );
2042: | arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
2043:
2044: |
2045: | UPDATE RA_CUST_RECEIPT_METHODS yt
2046: | set end_date = sysdate,
2047: | last_update_date = sysdate,
2048: | last_updated_by = arp_standard.profile.user_id,
2049: | last_update_login = arp_standard.profile.last_update_login,

Line 4314: | ra_cust_receipt_methods to use index.

4310: | Jianying Huang 19-DEC-00 Bug 1535542: physically delete rows in
4311: | customer tables after merging each set.
4312: | Jianying Huang 29-DEC-00 Modified 'delete_rows' for performance issue.
4313: | Jianying Huang 09-APR-01 Bug 1725662: rewrite sql statement on delete
4314: | ra_cust_receipt_methods to use index.
4315: |
4316: +===========================================================================*/
4317:
4318: PROCEDURE delete_rows(

Line 4384: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

4380: FOR UPDATE NOWAIT;
4381:
4382: CURSOR cust_receipt_methods_site IS
4383: SELECT CUST_RECEIPT_METHOD_ID
4384: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
4385: WHERE yt.customer_id = m.duplicate_id
4386: AND yt.site_use_id = m.duplicate_site_id
4387: AND m.process_flag = 'N'
4388: AND m.request_id = req_id

Line 4395: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

4391: FOR UPDATE NOWAIT;
4392:
4393: CURSOR cust_receipt_methods_acct IS
4394: SELECT CUST_RECEIPT_METHOD_ID
4395: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
4396: WHERE yt.customer_id = m.duplicate_id
4397: AND m.process_flag = 'N'
4398: AND m.request_id = req_id
4399: AND m.set_number = set_num

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

4619:
4620: /************** account site level delete ************/
4621:
4622: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
4623: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
4624:
4625: OPEN cust_receipt_methods_site;
4626: CLOSE cust_receipt_methods_site;
4627:

Line 4630: DELETE FROM RA_CUST_RECEIPT_METHODS yt

4626: CLOSE cust_receipt_methods_site;
4627:
4628: --Bug 1725662: Rewrite the query to use index.
4629:
4630: DELETE FROM RA_CUST_RECEIPT_METHODS yt
4631: WHERE (customer_id, site_use_id) in (
4632: SELECT m.duplicate_id, m.duplicate_site_id
4633: FROM ra_customer_merges m
4634: WHERE m.process_flag = 'N'

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

4643:
4644: /************** account level delete ************/
4645:
4646: arp_message.set_name( 'AR', 'AR_DELETING_TABLE' );
4647: arp_message.set_token( 'TABLE_NAME', 'RA_CUST_RECEIPT_METHODS', FALSE );
4648:
4649: OPEN cust_receipt_methods_acct;
4650: CLOSE cust_receipt_methods_acct;
4651:

Line 4652: DELETE FROM RA_CUST_RECEIPT_METHODS yt

4648:
4649: OPEN cust_receipt_methods_acct;
4650: CLOSE cust_receipt_methods_acct;
4651:
4652: DELETE FROM RA_CUST_RECEIPT_METHODS yt
4653: WHERE customer_id in (
4654: SELECT m.duplicate_id
4655: FROM ra_customer_merges m
4656: WHERE m.process_flag = 'N'

Line 5012: from RA_CUST_RECEIPT_METHODS

5008: ATTRIBUTE12,
5009: ATTRIBUTE13,
5010: ATTRIBUTE14,
5011: ATTRIBUTE15
5012: from RA_CUST_RECEIPT_METHODS
5013: WHERE CUSTOMER_ID = l_duplicate_id
5014: AND site_use_id = l_duplicate_site_id;
5015: l_row_id varchar2(240);
5016: l_Cust_Receipt_Method_Id varchar2(15);

Line 6479: update RA_CUST_RECEIPT_METHODS

6475: --the table.So the following update statement is created to
6476: --update rest of the fields.
6477:
6478: if l_row_id is not null then
6479: update RA_CUST_RECEIPT_METHODS
6480: set
6481: last_update_date = sysdate,
6482: last_updated_by =hz_utility_v2pub.user_id,--arp_standard.profile.user_id,
6483: last_update_login =hz_utility_v2pub.last_update_login,-- arp_standard.profile.last_update_login,