DBA Data[Home] [Help]

APPS.WSH_CUST_MERGE dependencies on HZ_UTILITY_PUB

Line 163: HZ_UTILITY_PUB.Created_By,

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 );

Line 164: HZ_UTILITY_PUB.Creation_Date,

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:

Line 165: HZ_UTILITY_PUB.Last_Update_Login,

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: --

Line 166: HZ_UTILITY_PUB.Last_Update_Date,

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 );

Line 167: HZ_UTILITY_PUB.Last_Updated_By );

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:

Line 3400: hz_utility_pub.CREATED_BY,

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

Line 3401: hz_utility_pub.CREATION_DATE,

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: );

Line 3402: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 3403: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 3404: hz_utility_pub.LAST_UPDATED_BY

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

Line 3550: hz_utility_pub.CREATED_BY,

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

Line 3551: hz_utility_pub.CREATION_DATE,

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: );

Line 3552: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 3553: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 3554: hz_utility_pub.LAST_UPDATED_BY

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

Line 3693: hz_utility_pub.CREATED_BY,

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

Line 3694: hz_utility_pub.CREATION_DATE,

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: );

Line 3695: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 3696: hz_utility_pub.LAST_UPDATE_DATE,

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

Line 3697: hz_utility_pub.LAST_UPDATED_BY

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