[Home] [Help]
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: +===========================================================================*/
1875:
1876: new_date := sysdate;
1877: FORALL i IN 1..header_id.count
1878:
1879: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1880: MERGE_LOG_ID,
1881: MERGE_HEADER_ID,
1882: TABLE_NAME,
1883: PRIMARY_KEY_ID,
1897: ACTION_FLAG
1898: )
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),
1913: 'U'
1914: ) ;
1915:
1916: -- Commented for bug 3786802
1917: /* INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1918: MERGE_LOG_ID,
1919: MERGE_HEADER_ID,
1920: TABLE_NAME,
1921: PRIMARY_KEY_ID,
1934: LAST_UPDATE_LOGIN,
1935: ACTION_FLAG
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,
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
1999: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2000: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2001: )
2007: , PROGRAM_ID=arp_standard.profile.program_id
2008: , PROGRAM_UPDATE_DATE=SYSDATE
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);