40: x_status),
41: DECODE(x_dss_instance_set_id,
42: FND_API.G_MISS_NUM, NULL,
43: x_dss_instance_set_id),
44: hz_utility_v2pub.last_update_date,
45: hz_utility_v2pub.last_updated_by,
46: hz_utility_v2pub.creation_date,
47: hz_utility_v2pub.created_by,
48: hz_utility_v2pub.last_update_login,
41: DECODE(x_dss_instance_set_id,
42: FND_API.G_MISS_NUM, NULL,
43: x_dss_instance_set_id),
44: hz_utility_v2pub.last_update_date,
45: hz_utility_v2pub.last_updated_by,
46: hz_utility_v2pub.creation_date,
47: hz_utility_v2pub.created_by,
48: hz_utility_v2pub.last_update_login,
49: DECODE(x_object_version_number,
42: FND_API.G_MISS_NUM, NULL,
43: x_dss_instance_set_id),
44: hz_utility_v2pub.last_update_date,
45: hz_utility_v2pub.last_updated_by,
46: hz_utility_v2pub.creation_date,
47: hz_utility_v2pub.created_by,
48: hz_utility_v2pub.last_update_login,
49: DECODE(x_object_version_number,
50: FND_API.G_MISS_NUM, NULL,
43: x_dss_instance_set_id),
44: hz_utility_v2pub.last_update_date,
45: hz_utility_v2pub.last_updated_by,
46: hz_utility_v2pub.creation_date,
47: hz_utility_v2pub.created_by,
48: hz_utility_v2pub.last_update_login,
49: DECODE(x_object_version_number,
50: FND_API.G_MISS_NUM, NULL,
51: x_object_version_number)
44: hz_utility_v2pub.last_update_date,
45: hz_utility_v2pub.last_updated_by,
46: hz_utility_v2pub.creation_date,
47: hz_utility_v2pub.created_by,
48: hz_utility_v2pub.last_update_login,
49: DECODE(x_object_version_number,
50: FND_API.G_MISS_NUM, NULL,
51: x_object_version_number)
52: ) RETURNING
86: NULL, dss_instance_set_id,
87: FND_API.G_MISS_NUM, NULL,
88: x_dss_instance_set_id),
89: */
90: last_update_date = hz_utility_v2pub.last_update_date,
91: last_updated_by = hz_utility_v2pub.last_updated_by,
92: creation_date = creation_date,
93: created_by = created_by,
94: last_update_login = hz_utility_v2pub.last_update_login,
87: FND_API.G_MISS_NUM, NULL,
88: x_dss_instance_set_id),
89: */
90: last_update_date = hz_utility_v2pub.last_update_date,
91: last_updated_by = hz_utility_v2pub.last_updated_by,
92: creation_date = creation_date,
93: created_by = created_by,
94: last_update_login = hz_utility_v2pub.last_update_login,
95: object_version_number =
90: last_update_date = hz_utility_v2pub.last_update_date,
91: last_updated_by = hz_utility_v2pub.last_updated_by,
92: creation_date = creation_date,
93: created_by = created_by,
94: last_update_login = hz_utility_v2pub.last_update_login,
95: object_version_number =
96: DECODE(x_object_version_number,
97: NULL, object_version_number,
98: FND_API.G_MISS_NUM, NULL,