39: DECODE(x_status,
40: FND_API.G_MISS_CHAR, 'A',
41: NULL, 'A',
42: x_status),
43: hz_utility_v2pub.last_update_date,
44: hz_utility_v2pub.last_updated_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_login,
40: FND_API.G_MISS_CHAR, 'A',
41: NULL, 'A',
42: x_status),
43: hz_utility_v2pub.last_update_date,
44: hz_utility_v2pub.last_updated_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_login,
48: DECODE(x_bes_enable_flag,
41: NULL, 'A',
42: x_status),
43: hz_utility_v2pub.last_update_date,
44: hz_utility_v2pub.last_updated_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_login,
48: DECODE(x_bes_enable_flag,
49: FND_API.G_MISS_CHAR, NULL,
42: x_status),
43: hz_utility_v2pub.last_update_date,
44: hz_utility_v2pub.last_updated_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_login,
48: DECODE(x_bes_enable_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_bes_enable_flag),
43: hz_utility_v2pub.last_update_date,
44: hz_utility_v2pub.last_updated_by,
45: hz_utility_v2pub.creation_date,
46: hz_utility_v2pub.created_by,
47: hz_utility_v2pub.last_update_login,
48: DECODE(x_bes_enable_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_bes_enable_flag),
51: DECODE(x_object_version_number,
73: L.LANGUAGE_CODE,
74: B.LANGUAGE_CODE,
75: x_dss_group_name,
76: x_description,
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login
74: B.LANGUAGE_CODE,
75: x_dss_group_name,
76: x_description,
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login
82: FROM
75: x_dss_group_name,
76: x_description,
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login
82: FROM
83: FND_LANGUAGES L, FND_LANGUAGES B
76: x_description,
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login
82: FROM
83: FND_LANGUAGES L, FND_LANGUAGES B
84: WHERE L.INSTALLED_FLAG in ('I', 'B')
77: hz_utility_v2pub.last_update_date,
78: hz_utility_v2pub.last_updated_by,
79: hz_utility_v2pub.creation_date,
80: hz_utility_v2pub.created_by,
81: hz_utility_v2pub.last_update_login
82: FROM
83: FND_LANGUAGES L, FND_LANGUAGES B
84: WHERE L.INSTALLED_FLAG in ('I', 'B')
85: and B.INSTALLED_FLAG = 'B'
122: DECODE(x_status,
123: NULL, status,
124: FND_API.G_MISS_CHAR, NULL,
125: x_status),
126: last_update_date = hz_utility_v2pub.last_update_date,
127: last_updated_by = hz_utility_v2pub.last_updated_by,
128: creation_date = creation_date,
129: created_by = created_by,
130: last_update_login = hz_utility_v2pub.last_update_login,
123: NULL, status,
124: FND_API.G_MISS_CHAR, NULL,
125: x_status),
126: last_update_date = hz_utility_v2pub.last_update_date,
127: last_updated_by = hz_utility_v2pub.last_updated_by,
128: creation_date = creation_date,
129: created_by = created_by,
130: last_update_login = hz_utility_v2pub.last_update_login,
131: bes_enable_flag =
126: last_update_date = hz_utility_v2pub.last_update_date,
127: last_updated_by = hz_utility_v2pub.last_updated_by,
128: creation_date = creation_date,
129: created_by = created_by,
130: last_update_login = hz_utility_v2pub.last_update_login,
131: bes_enable_flag =
132: DECODE(x_bes_enable_flag,
133: NULL, bes_enable_flag,
134: FND_API.G_MISS_CHAR, NULL,
160: DECODE(x_description,
161: NULL, description,
162: FND_API.G_MISS_CHAR, NULL,
163: x_description),
164: last_update_date = hz_utility_v2pub.last_update_date,
165: last_updated_by = hz_utility_v2pub.last_updated_by,
166: last_update_login = hz_utility_v2pub.last_update_login
167:
168: WHERE dss_group_code = l_dss_group_code AND
161: NULL, description,
162: FND_API.G_MISS_CHAR, NULL,
163: x_description),
164: last_update_date = hz_utility_v2pub.last_update_date,
165: last_updated_by = hz_utility_v2pub.last_updated_by,
166: last_update_login = hz_utility_v2pub.last_update_login
167:
168: WHERE dss_group_code = l_dss_group_code AND
169: USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
162: FND_API.G_MISS_CHAR, NULL,
163: x_description),
164: last_update_date = hz_utility_v2pub.last_update_date,
165: last_updated_by = hz_utility_v2pub.last_updated_by,
166: last_update_login = hz_utility_v2pub.last_update_login
167:
168: WHERE dss_group_code = l_dss_group_code AND
169: USERENV('LANG') IN (LANGUAGE, SOURCE_LANG);
170: