464: NUM_COL3_ORIG_LIST(I) ,
465: NUM_COL3_NEW_LIST(I) ,
466: 'U' ,
467: req_id ,
468: hz_utility_pub.CREATED_BY ,
469: hz_utility_pub.CREATION_DATE ,
470: hz_utility_pub.LAST_UPDATE_LOGIN ,
471: hz_utility_pub.LAST_UPDATE_DATE ,
472: hz_utility_pub.LAST_UPDATED_BY
465: NUM_COL3_NEW_LIST(I) ,
466: 'U' ,
467: req_id ,
468: hz_utility_pub.CREATED_BY ,
469: hz_utility_pub.CREATION_DATE ,
470: hz_utility_pub.LAST_UPDATE_LOGIN ,
471: hz_utility_pub.LAST_UPDATE_DATE ,
472: hz_utility_pub.LAST_UPDATED_BY
473: );
466: 'U' ,
467: req_id ,
468: hz_utility_pub.CREATED_BY ,
469: hz_utility_pub.CREATION_DATE ,
470: hz_utility_pub.LAST_UPDATE_LOGIN ,
471: hz_utility_pub.LAST_UPDATE_DATE ,
472: hz_utility_pub.LAST_UPDATED_BY
473: );
474: END IF; -- } 7
467: req_id ,
468: hz_utility_pub.CREATED_BY ,
469: hz_utility_pub.CREATION_DATE ,
470: hz_utility_pub.LAST_UPDATE_LOGIN ,
471: hz_utility_pub.LAST_UPDATE_DATE ,
472: hz_utility_pub.LAST_UPDATED_BY
473: );
474: END IF; -- } 7
475:
468: hz_utility_pub.CREATED_BY ,
469: hz_utility_pub.CREATION_DATE ,
470: hz_utility_pub.LAST_UPDATE_LOGIN ,
471: hz_utility_pub.LAST_UPDATE_DATE ,
472: hz_utility_pub.LAST_UPDATED_BY
473: );
474: END IF; -- } 7
475:
476: -- build the transaction record, if this is the first time
1583: NUM_COL3_ORIG_LIST(I) ,
1584: NUM_COL3_NEW_LIST(I) ,
1585: 'U' ,
1586: req_id ,
1587: hz_utility_pub.CREATED_BY ,
1588: hz_utility_pub.CREATION_DATE ,
1589: hz_utility_pub.LAST_UPDATE_LOGIN ,
1590: hz_utility_pub.LAST_UPDATE_DATE ,
1591: hz_utility_pub.LAST_UPDATED_BY
1584: NUM_COL3_NEW_LIST(I) ,
1585: 'U' ,
1586: req_id ,
1587: hz_utility_pub.CREATED_BY ,
1588: hz_utility_pub.CREATION_DATE ,
1589: hz_utility_pub.LAST_UPDATE_LOGIN ,
1590: hz_utility_pub.LAST_UPDATE_DATE ,
1591: hz_utility_pub.LAST_UPDATED_BY
1592: );
1585: 'U' ,
1586: req_id ,
1587: hz_utility_pub.CREATED_BY ,
1588: hz_utility_pub.CREATION_DATE ,
1589: hz_utility_pub.LAST_UPDATE_LOGIN ,
1590: hz_utility_pub.LAST_UPDATE_DATE ,
1591: hz_utility_pub.LAST_UPDATED_BY
1592: );
1593:
1586: req_id ,
1587: hz_utility_pub.CREATED_BY ,
1588: hz_utility_pub.CREATION_DATE ,
1589: hz_utility_pub.LAST_UPDATE_LOGIN ,
1590: hz_utility_pub.LAST_UPDATE_DATE ,
1591: hz_utility_pub.LAST_UPDATED_BY
1592: );
1593:
1594: END IF; -- } profile value if
1587: hz_utility_pub.CREATED_BY ,
1588: hz_utility_pub.CREATION_DATE ,
1589: hz_utility_pub.LAST_UPDATE_LOGIN ,
1590: hz_utility_pub.LAST_UPDATE_DATE ,
1591: hz_utility_pub.LAST_UPDATED_BY
1592: );
1593:
1594: END IF; -- } profile value if
1595:
1957: NUM_COL3_ORIG_LIST(I) ,
1958: NUM_COL3_NEW_LIST(I) ,
1959: 'U' ,
1960: req_id ,
1961: hz_utility_pub.CREATED_BY ,
1962: hz_utility_pub.CREATION_DATE ,
1963: hz_utility_pub.LAST_UPDATE_LOGIN ,
1964: hz_utility_pub.LAST_UPDATE_DATE ,
1965: hz_utility_pub.LAST_UPDATED_BY
1958: NUM_COL3_NEW_LIST(I) ,
1959: 'U' ,
1960: req_id ,
1961: hz_utility_pub.CREATED_BY ,
1962: hz_utility_pub.CREATION_DATE ,
1963: hz_utility_pub.LAST_UPDATE_LOGIN ,
1964: hz_utility_pub.LAST_UPDATE_DATE ,
1965: hz_utility_pub.LAST_UPDATED_BY
1966: );
1959: 'U' ,
1960: req_id ,
1961: hz_utility_pub.CREATED_BY ,
1962: hz_utility_pub.CREATION_DATE ,
1963: hz_utility_pub.LAST_UPDATE_LOGIN ,
1964: hz_utility_pub.LAST_UPDATE_DATE ,
1965: hz_utility_pub.LAST_UPDATED_BY
1966: );
1967: END IF;
1960: req_id ,
1961: hz_utility_pub.CREATED_BY ,
1962: hz_utility_pub.CREATION_DATE ,
1963: hz_utility_pub.LAST_UPDATE_LOGIN ,
1964: hz_utility_pub.LAST_UPDATE_DATE ,
1965: hz_utility_pub.LAST_UPDATED_BY
1966: );
1967: END IF;
1968:
1961: hz_utility_pub.CREATED_BY ,
1962: hz_utility_pub.CREATION_DATE ,
1963: hz_utility_pub.LAST_UPDATE_LOGIN ,
1964: hz_utility_pub.LAST_UPDATE_DATE ,
1965: hz_utility_pub.LAST_UPDATED_BY
1966: );
1967: END IF;
1968:
1969: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2155: NUM_COL4_ORIG_LIST(I),
2156: NUM_COL4_NEW_LIST(I),
2157: 'U',
2158: req_id,
2159: hz_utility_pub.CREATED_BY,
2160: hz_utility_pub.CREATION_DATE,
2161: hz_utility_pub.LAST_UPDATE_LOGIN,
2162: hz_utility_pub.LAST_UPDATE_DATE,
2163: hz_utility_pub.LAST_UPDATED_BY );
2156: NUM_COL4_NEW_LIST(I),
2157: 'U',
2158: req_id,
2159: hz_utility_pub.CREATED_BY,
2160: hz_utility_pub.CREATION_DATE,
2161: hz_utility_pub.LAST_UPDATE_LOGIN,
2162: hz_utility_pub.LAST_UPDATE_DATE,
2163: hz_utility_pub.LAST_UPDATED_BY );
2164: END IF;
2157: 'U',
2158: req_id,
2159: hz_utility_pub.CREATED_BY,
2160: hz_utility_pub.CREATION_DATE,
2161: hz_utility_pub.LAST_UPDATE_LOGIN,
2162: hz_utility_pub.LAST_UPDATE_DATE,
2163: hz_utility_pub.LAST_UPDATED_BY );
2164: END IF;
2165:
2158: req_id,
2159: hz_utility_pub.CREATED_BY,
2160: hz_utility_pub.CREATION_DATE,
2161: hz_utility_pub.LAST_UPDATE_LOGIN,
2162: hz_utility_pub.LAST_UPDATE_DATE,
2163: hz_utility_pub.LAST_UPDATED_BY );
2164: END IF;
2165:
2166: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2159: hz_utility_pub.CREATED_BY,
2160: hz_utility_pub.CREATION_DATE,
2161: hz_utility_pub.LAST_UPDATE_LOGIN,
2162: hz_utility_pub.LAST_UPDATE_DATE,
2163: hz_utility_pub.LAST_UPDATED_BY );
2164: END IF;
2165:
2166: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2167: UPDATE CSI_T_TXN_SYSTEMS yt