45: decode(p_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
46: p_APPLICATION_ID),
47: decode(p_REQUEST_TYPE, FND_API.G_MISS_CHAR, NULL,
48: p_REQUEST_TYPE),
49: HZ_UTILITY_V2PUB.CREATED_BY,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
52: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
53: HZ_UTILITY_V2PUB.LAST_UPDATED_BY
46: p_APPLICATION_ID),
47: decode(p_REQUEST_TYPE, FND_API.G_MISS_CHAR, NULL,
48: p_REQUEST_TYPE),
49: HZ_UTILITY_V2PUB.CREATED_BY,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
52: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
53: HZ_UTILITY_V2PUB.LAST_UPDATED_BY
54: );
47: decode(p_REQUEST_TYPE, FND_API.G_MISS_CHAR, NULL,
48: p_REQUEST_TYPE),
49: HZ_UTILITY_V2PUB.CREATED_BY,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
52: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
53: HZ_UTILITY_V2PUB.LAST_UPDATED_BY
54: );
55:
48: p_REQUEST_TYPE),
49: HZ_UTILITY_V2PUB.CREATED_BY,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
52: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
53: HZ_UTILITY_V2PUB.LAST_UPDATED_BY
54: );
55:
56: End Insert_Row;
49: HZ_UTILITY_V2PUB.CREATED_BY,
50: HZ_UTILITY_V2PUB.CREATION_DATE,
51: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
52: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
53: HZ_UTILITY_V2PUB.LAST_UPDATED_BY
54: );
55:
56: End Insert_Row;
57:
70: DUP_BATCH_NAME = decode(p_DUP_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
71: p_DUP_BATCH_NAME),
72: CREATED_BY = CREATED_BY,
73: CREATION_DATE = CREATION_DATE,
74: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
75: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
76: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
77: where DUP_batch_id = p_DUP_batch_id;
78:
71: p_DUP_BATCH_NAME),
72: CREATED_BY = CREATED_BY,
73: CREATION_DATE = CREATION_DATE,
74: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
75: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
76: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
77: where DUP_batch_id = p_DUP_batch_id;
78:
79:
72: CREATED_BY = CREATED_BY,
73: CREATION_DATE = CREATION_DATE,
74: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
75: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
76: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY
77: where DUP_batch_id = p_DUP_batch_id;
78:
79:
80: If (SQL%NOTFOUND) then