51: decode(p_MERGE_TYPE,FND_API.G_MISS_CHAR, NULL,
52: p_MERGE_TYPE),
53: decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM, NULL,
54: p_OBJECT_VERSION_NUMBER),
55: hz_utility_v2pub.created_by,
56: hz_utility_v2pub.creation_date,
57: hz_utility_v2pub.last_update_login,
58: hz_utility_v2pub.last_update_date,
59: hz_utility_v2pub.last_updated_by
52: p_MERGE_TYPE),
53: decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM, NULL,
54: p_OBJECT_VERSION_NUMBER),
55: hz_utility_v2pub.created_by,
56: hz_utility_v2pub.creation_date,
57: hz_utility_v2pub.last_update_login,
58: hz_utility_v2pub.last_update_date,
59: hz_utility_v2pub.last_updated_by
60: );
53: decode(p_OBJECT_VERSION_NUMBER,FND_API.G_MISS_NUM, NULL,
54: p_OBJECT_VERSION_NUMBER),
55: hz_utility_v2pub.created_by,
56: hz_utility_v2pub.creation_date,
57: hz_utility_v2pub.last_update_login,
58: hz_utility_v2pub.last_update_date,
59: hz_utility_v2pub.last_updated_by
60: );
61:
54: p_OBJECT_VERSION_NUMBER),
55: hz_utility_v2pub.created_by,
56: hz_utility_v2pub.creation_date,
57: hz_utility_v2pub.last_update_login,
58: hz_utility_v2pub.last_update_date,
59: hz_utility_v2pub.last_updated_by
60: );
61:
62: End Insert_Row;
55: hz_utility_v2pub.created_by,
56: hz_utility_v2pub.creation_date,
57: hz_utility_v2pub.last_update_login,
58: hz_utility_v2pub.last_update_date,
59: hz_utility_v2pub.last_updated_by
60: );
61:
62: End Insert_Row;
63:
79: WINNER_PARTY_ID = decode(p_WINNER_PARTY_ID,FND_API.G_MISS_NUM, NULL,
80: p_WINNER_PARTY_ID),
81: created_by = created_by,
82: creation_date= creation_date,
83: last_update_login= hz_utility_v2pub.last_update_login,
84: last_update_date= hz_utility_v2pub.last_update_date,
85: last_updated_by= hz_utility_v2pub.last_updated_by
86: where DUP_SET_ID = p_DUP_SET_ID;
87:
80: p_WINNER_PARTY_ID),
81: created_by = created_by,
82: creation_date= creation_date,
83: last_update_login= hz_utility_v2pub.last_update_login,
84: last_update_date= hz_utility_v2pub.last_update_date,
85: last_updated_by= hz_utility_v2pub.last_updated_by
86: where DUP_SET_ID = p_DUP_SET_ID;
87:
88: If (SQL%NOTFOUND) then
81: created_by = created_by,
82: creation_date= creation_date,
83: last_update_login= hz_utility_v2pub.last_update_login,
84: last_update_date= hz_utility_v2pub.last_update_date,
85: last_updated_by= hz_utility_v2pub.last_updated_by
86: where DUP_SET_ID = p_DUP_SET_ID;
87:
88: If (SQL%NOTFOUND) then
89: RAISE NO_DATA_FOUND;