101: NUM_COL1_ORIG_LIST(I),
102: NUM_COL1_NEW_LIST(I),
103: 'U',
104: req_id,
105: hz_utility_pub.CREATED_BY,
106: hz_utility_pub.CREATION_DATE,
107: hz_utility_pub.LAST_UPDATE_LOGIN,
108: hz_utility_pub.LAST_UPDATE_DATE,
109: hz_utility_pub.LAST_UPDATED_BY
102: NUM_COL1_NEW_LIST(I),
103: 'U',
104: req_id,
105: hz_utility_pub.CREATED_BY,
106: hz_utility_pub.CREATION_DATE,
107: hz_utility_pub.LAST_UPDATE_LOGIN,
108: hz_utility_pub.LAST_UPDATE_DATE,
109: hz_utility_pub.LAST_UPDATED_BY
110: );
103: 'U',
104: req_id,
105: hz_utility_pub.CREATED_BY,
106: hz_utility_pub.CREATION_DATE,
107: hz_utility_pub.LAST_UPDATE_LOGIN,
108: hz_utility_pub.LAST_UPDATE_DATE,
109: hz_utility_pub.LAST_UPDATED_BY
110: );
111:
104: req_id,
105: hz_utility_pub.CREATED_BY,
106: hz_utility_pub.CREATION_DATE,
107: hz_utility_pub.LAST_UPDATE_LOGIN,
108: hz_utility_pub.LAST_UPDATE_DATE,
109: hz_utility_pub.LAST_UPDATED_BY
110: );
111:
112: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
105: hz_utility_pub.CREATED_BY,
106: hz_utility_pub.CREATION_DATE,
107: hz_utility_pub.LAST_UPDATE_LOGIN,
108: hz_utility_pub.LAST_UPDATE_DATE,
109: hz_utility_pub.LAST_UPDATED_BY
110: );
111:
112: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
113: UPDATE JTF_IH_ACTIVITIES yt SET