[Home] [Help]
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: +===========================================================================*/
2010:
2011: new_date := sysdate;
2012: FORALL i IN 1..header_id.count
2013:
2014: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2015: MERGE_LOG_ID,
2016: MERGE_HEADER_ID,
2017: TABLE_NAME,
2018: PRIMARY_KEY_ID,
2032: ACTION_FLAG
2033: )
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),
2048: 'U'
2049: ) ;
2050:
2051: -- Commented for bug 3786802
2052: /* INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2053: MERGE_LOG_ID,
2054: MERGE_HEADER_ID,
2055: TABLE_NAME,
2056: PRIMARY_KEY_ID,
2069: LAST_UPDATE_LOGIN,
2070: ACTION_FLAG
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,
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
2134: AND l.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2135: AND l.PRIMARY_KEY_ID = CUST_RECEIPT_METHOD_ID
2136: )
2142: , PROGRAM_ID=arp_standard.profile.program_id
2143: , PROGRAM_UPDATE_DATE=SYSDATE
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);