159: NULL,
160: NULL,
161: 'U',
162: p_req_id,
163: HZ_UTILITY_PUB.Created_By,
164: HZ_UTILITY_PUB.Creation_Date,
165: HZ_UTILITY_PUB.Last_Update_Login,
166: HZ_UTILITY_PUB.Last_Update_Date,
167: HZ_UTILITY_PUB.Last_Updated_By );
160: NULL,
161: 'U',
162: p_req_id,
163: HZ_UTILITY_PUB.Created_By,
164: HZ_UTILITY_PUB.Creation_Date,
165: HZ_UTILITY_PUB.Last_Update_Login,
166: HZ_UTILITY_PUB.Last_Update_Date,
167: HZ_UTILITY_PUB.Last_Updated_By );
168:
161: 'U',
162: p_req_id,
163: HZ_UTILITY_PUB.Created_By,
164: HZ_UTILITY_PUB.Creation_Date,
165: HZ_UTILITY_PUB.Last_Update_Login,
166: HZ_UTILITY_PUB.Last_Update_Date,
167: HZ_UTILITY_PUB.Last_Updated_By );
168:
169: --
162: p_req_id,
163: HZ_UTILITY_PUB.Created_By,
164: HZ_UTILITY_PUB.Creation_Date,
165: HZ_UTILITY_PUB.Last_Update_Login,
166: HZ_UTILITY_PUB.Last_Update_Date,
167: HZ_UTILITY_PUB.Last_Updated_By );
168:
169: --
170: setARMessageRowCount( 'HZ_CUSTOMER_MERGE_LOG', SQL%ROWCOUNT );
163: HZ_UTILITY_PUB.Created_By,
164: HZ_UTILITY_PUB.Creation_Date,
165: HZ_UTILITY_PUB.Last_Update_Login,
166: HZ_UTILITY_PUB.Last_Update_Date,
167: HZ_UTILITY_PUB.Last_Updated_By );
168:
169: --
170: setARMessageRowCount( 'HZ_CUSTOMER_MERGE_LOG', SQL%ROWCOUNT );
171:
3396: NUM_COL1_ORIG_LIST(I),
3397: NUM_COL1_NEW_LIST(I),
3398: 'U',
3399: req_id,
3400: hz_utility_pub.CREATED_BY,
3401: hz_utility_pub.CREATION_DATE,
3402: hz_utility_pub.LAST_UPDATE_LOGIN,
3403: hz_utility_pub.LAST_UPDATE_DATE,
3404: hz_utility_pub.LAST_UPDATED_BY
3397: NUM_COL1_NEW_LIST(I),
3398: 'U',
3399: req_id,
3400: hz_utility_pub.CREATED_BY,
3401: hz_utility_pub.CREATION_DATE,
3402: hz_utility_pub.LAST_UPDATE_LOGIN,
3403: hz_utility_pub.LAST_UPDATE_DATE,
3404: hz_utility_pub.LAST_UPDATED_BY
3405: );
3398: 'U',
3399: req_id,
3400: hz_utility_pub.CREATED_BY,
3401: hz_utility_pub.CREATION_DATE,
3402: hz_utility_pub.LAST_UPDATE_LOGIN,
3403: hz_utility_pub.LAST_UPDATE_DATE,
3404: hz_utility_pub.LAST_UPDATED_BY
3405: );
3406:
3399: req_id,
3400: hz_utility_pub.CREATED_BY,
3401: hz_utility_pub.CREATION_DATE,
3402: hz_utility_pub.LAST_UPDATE_LOGIN,
3403: hz_utility_pub.LAST_UPDATE_DATE,
3404: hz_utility_pub.LAST_UPDATED_BY
3405: );
3406:
3407: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3400: hz_utility_pub.CREATED_BY,
3401: hz_utility_pub.CREATION_DATE,
3402: hz_utility_pub.LAST_UPDATE_LOGIN,
3403: hz_utility_pub.LAST_UPDATE_DATE,
3404: hz_utility_pub.LAST_UPDATED_BY
3405: );
3406:
3407: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3408: UPDATE WSH_PICKING_BATCHES yt SET
3546: NUM_COL2_ORIG_LIST(I),
3547: NUM_COL2_NEW_LIST(I),
3548: 'U',
3549: req_id,
3550: hz_utility_pub.CREATED_BY,
3551: hz_utility_pub.CREATION_DATE,
3552: hz_utility_pub.LAST_UPDATE_LOGIN,
3553: hz_utility_pub.LAST_UPDATE_DATE,
3554: hz_utility_pub.LAST_UPDATED_BY
3547: NUM_COL2_NEW_LIST(I),
3548: 'U',
3549: req_id,
3550: hz_utility_pub.CREATED_BY,
3551: hz_utility_pub.CREATION_DATE,
3552: hz_utility_pub.LAST_UPDATE_LOGIN,
3553: hz_utility_pub.LAST_UPDATE_DATE,
3554: hz_utility_pub.LAST_UPDATED_BY
3555: );
3548: 'U',
3549: req_id,
3550: hz_utility_pub.CREATED_BY,
3551: hz_utility_pub.CREATION_DATE,
3552: hz_utility_pub.LAST_UPDATE_LOGIN,
3553: hz_utility_pub.LAST_UPDATE_DATE,
3554: hz_utility_pub.LAST_UPDATED_BY
3555: );
3556:
3549: req_id,
3550: hz_utility_pub.CREATED_BY,
3551: hz_utility_pub.CREATION_DATE,
3552: hz_utility_pub.LAST_UPDATE_LOGIN,
3553: hz_utility_pub.LAST_UPDATE_DATE,
3554: hz_utility_pub.LAST_UPDATED_BY
3555: );
3556:
3557: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3550: hz_utility_pub.CREATED_BY,
3551: hz_utility_pub.CREATION_DATE,
3552: hz_utility_pub.LAST_UPDATE_LOGIN,
3553: hz_utility_pub.LAST_UPDATE_DATE,
3554: hz_utility_pub.LAST_UPDATED_BY
3555: );
3556:
3557: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3558: UPDATE WSH_CALENDAR_ASSIGNMENTS yt SET
3689: NUM_COL1_ORIG_LIST(I),
3690: NUM_COL1_NEW_LIST(I),
3691: 'U',
3692: req_id,
3693: hz_utility_pub.CREATED_BY,
3694: hz_utility_pub.CREATION_DATE,
3695: hz_utility_pub.LAST_UPDATE_LOGIN,
3696: hz_utility_pub.LAST_UPDATE_DATE,
3697: hz_utility_pub.LAST_UPDATED_BY
3690: NUM_COL1_NEW_LIST(I),
3691: 'U',
3692: req_id,
3693: hz_utility_pub.CREATED_BY,
3694: hz_utility_pub.CREATION_DATE,
3695: hz_utility_pub.LAST_UPDATE_LOGIN,
3696: hz_utility_pub.LAST_UPDATE_DATE,
3697: hz_utility_pub.LAST_UPDATED_BY
3698: );
3691: 'U',
3692: req_id,
3693: hz_utility_pub.CREATED_BY,
3694: hz_utility_pub.CREATION_DATE,
3695: hz_utility_pub.LAST_UPDATE_LOGIN,
3696: hz_utility_pub.LAST_UPDATE_DATE,
3697: hz_utility_pub.LAST_UPDATED_BY
3698: );
3699:
3692: req_id,
3693: hz_utility_pub.CREATED_BY,
3694: hz_utility_pub.CREATION_DATE,
3695: hz_utility_pub.LAST_UPDATE_LOGIN,
3696: hz_utility_pub.LAST_UPDATE_DATE,
3697: hz_utility_pub.LAST_UPDATED_BY
3698: );
3699:
3700: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3693: hz_utility_pub.CREATED_BY,
3694: hz_utility_pub.CREATION_DATE,
3695: hz_utility_pub.LAST_UPDATE_LOGIN,
3696: hz_utility_pub.LAST_UPDATE_DATE,
3697: hz_utility_pub.LAST_UPDATED_BY
3698: );
3699:
3700: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
3701: UPDATE WSH_PICKING_RULES yt SET