103: NUM_COL2_ORIG_LIST(I),
104: NUM_COL2_NEW_LIST(I),
105: 'U',
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
104: NUM_COL2_NEW_LIST(I),
105: 'U',
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
105: 'U',
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
113:
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
113:
114: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
113:
114: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
115: UPDATE AR_CORRESPONDENCES yt SET