APPS.PV_GE_HIST_LOG_PKG dependencies on PV_GE_HISTORY_LOG_TL

Line 97: INSERT INTO pv_ge_history_log_tl(

93: DECODE( p_partner_id, FND_API.G_MISS_NUM, NULL, p_partner_id),
94: DECODE( p_access_level_flag, FND_API.g_miss_char, NULL, p_access_level_flag),
95: DECODE( p_interaction_level, FND_API.G_MISS_NUM, NULL, p_interaction_level));
96:
97: INSERT INTO pv_ge_history_log_tl(
98: entity_history_log_id ,
99: language ,
100: last_update_date ,
101: last_updated_by ,

Line 120: AND NOT EXISTS(SELECT NULL FROM pv_ge_history_log_tl t

116: USERENV('LANG'),
117: DECODE( p_COMMENTS , FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
118: FROM fnd_languages l
119: WHERE l.installed_flag IN ('I','B')
120: AND NOT EXISTS(SELECT NULL FROM pv_ge_history_log_tl t
121: WHERE t.entity_history_log_id = DECODE( px_entity_history_log_id, FND_API.G_MISS_NUM, NULL, px_entity_history_log_id)
122: AND t.language = l.language_code);
123: END Insert_Row;
124:

Line 175: UPDATE pv_ge_history_log_tl

171: interaction_level = DECODE( p_interaction_level, null, interaction_level, FND_API.G_MISS_NUM, null, p_interaction_level)
172: WHERE entity_history_log_id = p_entity_history_log_id
173: AND object_version_number = p_object_version_number;
174:
175: UPDATE pv_ge_history_log_tl
176: set COMMENTS = DECODE( p_COMMENTS, null, COMMENTS, FND_API.g_miss_char, null, p_COMMENTS),
177: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
178: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
179: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 279: INSERT /*+ append parallel(tt) */ INTO pv_ge_history_log_tl tt

275: BEGIN
276:
277: -- changing by pukken as per performance team guidelines to fix performance issue
278: -- as described in bug 3723612 (*** RTIKKU 03/24/05 12:46pm ***)
279: INSERT /*+ append parallel(tt) */ INTO pv_ge_history_log_tl tt
280: (
281: entity_history_log_id,
282: creation_date,
283: created_by,

Line 304: FROM pv_ge_history_log_tl B , FND_LANGUAGES L

300: b.last_update_login,
301: b.comments,
302: l.language_code,
303: b.source_lang
304: FROM pv_ge_history_log_tl B , FND_LANGUAGES L
305: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
306: ) v
307: , pv_ge_history_log_tl t
308: WHERE t.entity_history_log_id(+) = v.entity_history_log_id

Line 307: , pv_ge_history_log_tl t

303: b.source_lang
304: FROM pv_ge_history_log_tl B , FND_LANGUAGES L
305: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
306: ) v
307: , pv_ge_history_log_tl t
308: WHERE t.entity_history_log_id(+) = v.entity_history_log_id
309: AND t.language(+) = v.language_code
310: AND t.entity_history_log_id IS NULL ;
311: