126: NUM_COL2_ORIG_LIST(I),
127: NUM_COL2_NEW_LIST(I),
128: 'U',
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
127: NUM_COL2_NEW_LIST(I),
128: 'U',
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
128: 'U',
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
136:
129: req_id,
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
136:
137: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
130: hz_utility_pub.CREATED_BY,
131: hz_utility_pub.CREATION_DATE,
132: hz_utility_pub.LAST_UPDATE_LOGIN,
133: hz_utility_pub.LAST_UPDATE_DATE,
134: hz_utility_pub.LAST_UPDATED_BY
135: );
136:
137: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
138: UPDATE OE_AGREEMENTS_B yt SET
386: VCHAR_COL2_ORIG_LIST(I),
387: VCHAR_COL2_NEW_LIST(I),
388: 'U',
389: req_id,
390: hz_utility_pub.CREATED_BY,
391: hz_utility_pub.CREATION_DATE,
392: hz_utility_pub.LAST_UPDATE_LOGIN,
393: hz_utility_pub.LAST_UPDATE_DATE,
394: hz_utility_pub.LAST_UPDATED_BY
387: VCHAR_COL2_NEW_LIST(I),
388: 'U',
389: req_id,
390: hz_utility_pub.CREATED_BY,
391: hz_utility_pub.CREATION_DATE,
392: hz_utility_pub.LAST_UPDATE_LOGIN,
393: hz_utility_pub.LAST_UPDATE_DATE,
394: hz_utility_pub.LAST_UPDATED_BY
395: );
388: 'U',
389: req_id,
390: hz_utility_pub.CREATED_BY,
391: hz_utility_pub.CREATION_DATE,
392: hz_utility_pub.LAST_UPDATE_LOGIN,
393: hz_utility_pub.LAST_UPDATE_DATE,
394: hz_utility_pub.LAST_UPDATED_BY
395: );
396:
389: req_id,
390: hz_utility_pub.CREATED_BY,
391: hz_utility_pub.CREATION_DATE,
392: hz_utility_pub.LAST_UPDATE_LOGIN,
393: hz_utility_pub.LAST_UPDATE_DATE,
394: hz_utility_pub.LAST_UPDATED_BY
395: );
396:
397: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
390: hz_utility_pub.CREATED_BY,
391: hz_utility_pub.CREATION_DATE,
392: hz_utility_pub.LAST_UPDATE_LOGIN,
393: hz_utility_pub.LAST_UPDATE_DATE,
394: hz_utility_pub.LAST_UPDATED_BY
395: );
396:
397: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
398: UPDATE QP_QUALIFIERS yt SET