111: NUM_COL1_ORIG_LIST(I),
112: NUM_COL1_NEW_LIST(I),
113: 'U',
114: request_id,
115: hz_utility_pub.CREATED_BY,
116: hz_utility_pub.CREATION_DATE,
117: hz_utility_pub.LAST_UPDATE_LOGIN,
118: hz_utility_pub.LAST_UPDATE_DATE,
119: hz_utility_pub.LAST_UPDATED_BY
112: NUM_COL1_NEW_LIST(I),
113: 'U',
114: request_id,
115: hz_utility_pub.CREATED_BY,
116: hz_utility_pub.CREATION_DATE,
117: hz_utility_pub.LAST_UPDATE_LOGIN,
118: hz_utility_pub.LAST_UPDATE_DATE,
119: hz_utility_pub.LAST_UPDATED_BY
120: );
113: 'U',
114: request_id,
115: hz_utility_pub.CREATED_BY,
116: hz_utility_pub.CREATION_DATE,
117: hz_utility_pub.LAST_UPDATE_LOGIN,
118: hz_utility_pub.LAST_UPDATE_DATE,
119: hz_utility_pub.LAST_UPDATED_BY
120: );
121:
114: request_id,
115: hz_utility_pub.CREATED_BY,
116: hz_utility_pub.CREATION_DATE,
117: hz_utility_pub.LAST_UPDATE_LOGIN,
118: hz_utility_pub.LAST_UPDATE_DATE,
119: hz_utility_pub.LAST_UPDATED_BY
120: );
121:
122: END IF;
115: hz_utility_pub.CREATED_BY,
116: hz_utility_pub.CREATION_DATE,
117: hz_utility_pub.LAST_UPDATE_LOGIN,
118: hz_utility_pub.LAST_UPDATE_DATE,
119: hz_utility_pub.LAST_UPDATED_BY
120: );
121:
122: END IF;
123: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
189: NUM_COL1_ORIG_LIST1(I),
190: NUM_COL1_NEW_LIST1(I),
191: 'U',
192: request_id,
193: hz_utility_pub.CREATED_BY,
194: hz_utility_pub.CREATION_DATE,
195: hz_utility_pub.LAST_UPDATE_LOGIN,
196: hz_utility_pub.LAST_UPDATE_DATE,
197: hz_utility_pub.LAST_UPDATED_BY
190: NUM_COL1_NEW_LIST1(I),
191: 'U',
192: request_id,
193: hz_utility_pub.CREATED_BY,
194: hz_utility_pub.CREATION_DATE,
195: hz_utility_pub.LAST_UPDATE_LOGIN,
196: hz_utility_pub.LAST_UPDATE_DATE,
197: hz_utility_pub.LAST_UPDATED_BY
198: );
191: 'U',
192: request_id,
193: hz_utility_pub.CREATED_BY,
194: hz_utility_pub.CREATION_DATE,
195: hz_utility_pub.LAST_UPDATE_LOGIN,
196: hz_utility_pub.LAST_UPDATE_DATE,
197: hz_utility_pub.LAST_UPDATED_BY
198: );
199:
192: request_id,
193: hz_utility_pub.CREATED_BY,
194: hz_utility_pub.CREATION_DATE,
195: hz_utility_pub.LAST_UPDATE_LOGIN,
196: hz_utility_pub.LAST_UPDATE_DATE,
197: hz_utility_pub.LAST_UPDATED_BY
198: );
199:
200: END IF;
193: hz_utility_pub.CREATED_BY,
194: hz_utility_pub.CREATION_DATE,
195: hz_utility_pub.LAST_UPDATE_LOGIN,
196: hz_utility_pub.LAST_UPDATE_DATE,
197: hz_utility_pub.LAST_UPDATED_BY
198: );
199:
200: END IF;
201: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT