APPS.HZ_WORD_RPL_CONDS_PKG dependencies on HZ_UTILITY_V2PUB

Line 51: hz_utility_v2pub.last_update_date,

47: x_condition_function),
48: DECODE(x_condition_val_fmt_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_condition_val_fmt_flag),
51: hz_utility_v2pub.last_update_date,
52: hz_utility_v2pub.last_updated_by,
53: hz_utility_v2pub.creation_date,
54: hz_utility_v2pub.created_by,
55: hz_utility_v2pub.last_update_login,

Line 52: hz_utility_v2pub.last_updated_by,

48: DECODE(x_condition_val_fmt_flag,
49: FND_API.G_MISS_CHAR, NULL,
50: x_condition_val_fmt_flag),
51: hz_utility_v2pub.last_update_date,
52: hz_utility_v2pub.last_updated_by,
53: hz_utility_v2pub.creation_date,
54: hz_utility_v2pub.created_by,
55: hz_utility_v2pub.last_update_login,
56: DECODE(x_object_version_number,

Line 53: hz_utility_v2pub.creation_date,

49: FND_API.G_MISS_CHAR, NULL,
50: x_condition_val_fmt_flag),
51: hz_utility_v2pub.last_update_date,
52: hz_utility_v2pub.last_updated_by,
53: hz_utility_v2pub.creation_date,
54: hz_utility_v2pub.created_by,
55: hz_utility_v2pub.last_update_login,
56: DECODE(x_object_version_number,
57: FND_API.G_MISS_NUM, NULL,

Line 54: hz_utility_v2pub.created_by,

50: x_condition_val_fmt_flag),
51: hz_utility_v2pub.last_update_date,
52: hz_utility_v2pub.last_updated_by,
53: hz_utility_v2pub.creation_date,
54: hz_utility_v2pub.created_by,
55: hz_utility_v2pub.last_update_login,
56: DECODE(x_object_version_number,
57: FND_API.G_MISS_NUM, NULL,
58: x_object_version_number)

Line 55: hz_utility_v2pub.last_update_login,

51: hz_utility_v2pub.last_update_date,
52: hz_utility_v2pub.last_updated_by,
53: hz_utility_v2pub.creation_date,
54: hz_utility_v2pub.created_by,
55: hz_utility_v2pub.last_update_login,
56: DECODE(x_object_version_number,
57: FND_API.G_MISS_NUM, NULL,
58: x_object_version_number)
59: ) ;

Line 78: hz_utility_v2pub.last_update_date,

74: SELECT
75: x_condition_id,
76: x_condition_name,
77: x_condition_description,
78: hz_utility_v2pub.last_update_date,
79: hz_utility_v2pub.last_updated_by,
80: hz_utility_v2pub.creation_date,
81: hz_utility_v2pub.created_by,
82: hz_utility_v2pub.last_update_login,

Line 79: hz_utility_v2pub.last_updated_by,

75: x_condition_id,
76: x_condition_name,
77: x_condition_description,
78: hz_utility_v2pub.last_update_date,
79: hz_utility_v2pub.last_updated_by,
80: hz_utility_v2pub.creation_date,
81: hz_utility_v2pub.created_by,
82: hz_utility_v2pub.last_update_login,
83: L.LANGUAGE_CODE,

Line 80: hz_utility_v2pub.creation_date,

76: x_condition_name,
77: x_condition_description,
78: hz_utility_v2pub.last_update_date,
79: hz_utility_v2pub.last_updated_by,
80: hz_utility_v2pub.creation_date,
81: hz_utility_v2pub.created_by,
82: hz_utility_v2pub.last_update_login,
83: L.LANGUAGE_CODE,
84: userenv('LANG'),

Line 81: hz_utility_v2pub.created_by,

77: x_condition_description,
78: hz_utility_v2pub.last_update_date,
79: hz_utility_v2pub.last_updated_by,
80: hz_utility_v2pub.creation_date,
81: hz_utility_v2pub.created_by,
82: hz_utility_v2pub.last_update_login,
83: L.LANGUAGE_CODE,
84: userenv('LANG'),
85: x_object_version_number

Line 82: hz_utility_v2pub.last_update_login,

78: hz_utility_v2pub.last_update_date,
79: hz_utility_v2pub.last_updated_by,
80: hz_utility_v2pub.creation_date,
81: hz_utility_v2pub.created_by,
82: hz_utility_v2pub.last_update_login,
83: L.LANGUAGE_CODE,
84: userenv('LANG'),
85: x_object_version_number
86: FROM FND_LANGUAGES L

Line 120: last_update_date = hz_utility_v2pub.last_update_date,

116: entity = x_entity,
117: condition_function = x_condition_function,
118: condition_val_fmt_flag = x_condition_val_fmt_flag,
119: object_version_number = p_object_version_number,
120: last_update_date = hz_utility_v2pub.last_update_date,
121: last_updated_by = hz_utility_v2pub.last_updated_by,
122: last_update_login = hz_utility_v2pub.last_update_login
123: where condition_id = x_condition_id ;
124:

Line 121: last_updated_by = hz_utility_v2pub.last_updated_by,

117: condition_function = x_condition_function,
118: condition_val_fmt_flag = x_condition_val_fmt_flag,
119: object_version_number = p_object_version_number,
120: last_update_date = hz_utility_v2pub.last_update_date,
121: last_updated_by = hz_utility_v2pub.last_updated_by,
122: last_update_login = hz_utility_v2pub.last_update_login
123: where condition_id = x_condition_id ;
124:
125: if (sql%notfound) then

Line 122: last_update_login = hz_utility_v2pub.last_update_login

118: condition_val_fmt_flag = x_condition_val_fmt_flag,
119: object_version_number = p_object_version_number,
120: last_update_date = hz_utility_v2pub.last_update_date,
121: last_updated_by = hz_utility_v2pub.last_updated_by,
122: last_update_login = hz_utility_v2pub.last_update_login
123: where condition_id = x_condition_id ;
124:
125: if (sql%notfound) then
126: raise no_data_found;

Line 133: last_update_date = hz_utility_v2pub.last_update_date,

129: update HZ_WORD_RPL_CONDS_TL set
130: condition_name = x_condition_name,
131: condition_description = x_condition_description,
132: object_version_number = p_object_version_number,
133: last_update_date = hz_utility_v2pub.last_update_date,
134: last_updated_by = hz_utility_v2pub.last_updated_by,
135: last_update_login = hz_utility_v2pub.last_update_login,
136: source_lang = userenv('LANG')
137: where condition_id = x_condition_id

Line 134: last_updated_by = hz_utility_v2pub.last_updated_by,

130: condition_name = x_condition_name,
131: condition_description = x_condition_description,
132: object_version_number = p_object_version_number,
133: last_update_date = hz_utility_v2pub.last_update_date,
134: last_updated_by = hz_utility_v2pub.last_updated_by,
135: last_update_login = hz_utility_v2pub.last_update_login,
136: source_lang = userenv('LANG')
137: where condition_id = x_condition_id
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 135: last_update_login = hz_utility_v2pub.last_update_login,

131: condition_description = x_condition_description,
132: object_version_number = p_object_version_number,
133: last_update_date = hz_utility_v2pub.last_update_date,
134: last_updated_by = hz_utility_v2pub.last_updated_by,
135: last_update_login = hz_utility_v2pub.last_update_login,
136: source_lang = userenv('LANG')
137: where condition_id = x_condition_id
138: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
139: