61: decode(p_MERGE_BATCH_ID, FND_API.G_MISS_NUM, NULL,
62: p_MERGE_BATCH_ID),
63: decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
64: p_MERGE_BATCH_NAME),
65: hz_utility_v2pub.created_by,
66: hz_utility_v2pub.creation_date,
67: hz_utility_v2pub.last_update_login,
68: hz_utility_v2pub.last_update_date,
69: hz_utility_v2pub.last_updated_by,
62: p_MERGE_BATCH_ID),
63: decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
64: p_MERGE_BATCH_NAME),
65: hz_utility_v2pub.created_by,
66: hz_utility_v2pub.creation_date,
67: hz_utility_v2pub.last_update_login,
68: hz_utility_v2pub.last_update_date,
69: hz_utility_v2pub.last_updated_by,
70: l_dup_set_batch_id --Bug No: 4244529
63: decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,
64: p_MERGE_BATCH_NAME),
65: hz_utility_v2pub.created_by,
66: hz_utility_v2pub.creation_date,
67: hz_utility_v2pub.last_update_login,
68: hz_utility_v2pub.last_update_date,
69: hz_utility_v2pub.last_updated_by,
70: l_dup_set_batch_id --Bug No: 4244529
71: );
64: p_MERGE_BATCH_NAME),
65: hz_utility_v2pub.created_by,
66: hz_utility_v2pub.creation_date,
67: hz_utility_v2pub.last_update_login,
68: hz_utility_v2pub.last_update_date,
69: hz_utility_v2pub.last_updated_by,
70: l_dup_set_batch_id --Bug No: 4244529
71: );
72:
65: hz_utility_v2pub.created_by,
66: hz_utility_v2pub.creation_date,
67: hz_utility_v2pub.last_update_login,
68: hz_utility_v2pub.last_update_date,
69: hz_utility_v2pub.last_updated_by,
70: l_dup_set_batch_id --Bug No: 4244529
71: );
72:
73: End Insert_Row;
103: MERGE_BATCH_NAME = decode(p_MERGE_BATCH_NAME, FND_API.G_MISS_CHAR, MERGE_BATCH_NAME,
104: p_MERGE_BATCH_NAME),
105: created_by = created_by,
106: creation_date= creation_date,
107: last_update_login= hz_utility_v2pub.last_update_login,
108: last_update_date= hz_utility_v2pub.last_update_date,
109: last_updated_by= hz_utility_v2pub.last_updated_by
110: where DUP_PARTY_ID = p_DUP_PARTY_ID
111: and DUP_SET_ID = p_DUP_SET_ID;
104: p_MERGE_BATCH_NAME),
105: created_by = created_by,
106: creation_date= creation_date,
107: last_update_login= hz_utility_v2pub.last_update_login,
108: last_update_date= hz_utility_v2pub.last_update_date,
109: last_updated_by= hz_utility_v2pub.last_updated_by
110: where DUP_PARTY_ID = p_DUP_PARTY_ID
111: and DUP_SET_ID = p_DUP_SET_ID;
112:
105: created_by = created_by,
106: creation_date= creation_date,
107: last_update_login= hz_utility_v2pub.last_update_login,
108: last_update_date= hz_utility_v2pub.last_update_date,
109: last_updated_by= hz_utility_v2pub.last_updated_by
110: where DUP_PARTY_ID = p_DUP_PARTY_ID
111: and DUP_SET_ID = p_DUP_SET_ID;
112:
113: If (SQL%NOTFOUND) then