41: DECODE(x_status,
42: FND_API.G_MISS_CHAR, 'A',
43: NULL, 'A',
44: x_status),
45: hz_utility_v2pub.last_update_date,
46: hz_utility_v2pub.last_updated_by,
47: hz_utility_v2pub.creation_date,
48: hz_utility_v2pub.created_by,
49: hz_utility_v2pub.last_update_login,
42: FND_API.G_MISS_CHAR, 'A',
43: NULL, 'A',
44: x_status),
45: hz_utility_v2pub.last_update_date,
46: hz_utility_v2pub.last_updated_by,
47: hz_utility_v2pub.creation_date,
48: hz_utility_v2pub.created_by,
49: hz_utility_v2pub.last_update_login,
50: DECODE(x_object_version_number,
43: NULL, 'A',
44: x_status),
45: hz_utility_v2pub.last_update_date,
46: hz_utility_v2pub.last_updated_by,
47: hz_utility_v2pub.creation_date,
48: hz_utility_v2pub.created_by,
49: hz_utility_v2pub.last_update_login,
50: DECODE(x_object_version_number,
51: FND_API.G_MISS_NUM, NULL,
44: x_status),
45: hz_utility_v2pub.last_update_date,
46: hz_utility_v2pub.last_updated_by,
47: hz_utility_v2pub.creation_date,
48: hz_utility_v2pub.created_by,
49: hz_utility_v2pub.last_update_login,
50: DECODE(x_object_version_number,
51: FND_API.G_MISS_NUM, NULL,
52: x_object_version_number)
45: hz_utility_v2pub.last_update_date,
46: hz_utility_v2pub.last_updated_by,
47: hz_utility_v2pub.creation_date,
48: hz_utility_v2pub.created_by,
49: hz_utility_v2pub.last_update_login,
50: DECODE(x_object_version_number,
51: FND_API.G_MISS_NUM, NULL,
52: x_object_version_number)
53: ) RETURNING
96: DECODE(x_status,
97: NULL, status,
98: FND_API.G_MISS_CHAR, NULL,
99: x_status),
100: last_update_date = hz_utility_v2pub.last_update_date,
101: last_updated_by = hz_utility_v2pub.last_updated_by,
102: creation_date = creation_date,
103: created_by = created_by,
104: last_update_login = hz_utility_v2pub.last_update_login,
97: NULL, status,
98: FND_API.G_MISS_CHAR, NULL,
99: x_status),
100: last_update_date = hz_utility_v2pub.last_update_date,
101: last_updated_by = hz_utility_v2pub.last_updated_by,
102: creation_date = creation_date,
103: created_by = created_by,
104: last_update_login = hz_utility_v2pub.last_update_login,
105: object_version_number =
100: last_update_date = hz_utility_v2pub.last_update_date,
101: last_updated_by = hz_utility_v2pub.last_updated_by,
102: creation_date = creation_date,
103: created_by = created_by,
104: last_update_login = hz_utility_v2pub.last_update_login,
105: object_version_number =
106: DECODE(x_object_version_number,
107: NULL, object_version_number,
108: FND_API.G_MISS_NUM, NULL,