eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_GE_CHKLST_PKG dependencies on PV_GE_CHKLST_ITEMS_TL

Line 97: INSERT INTO pv_ge_chklst_items_tl(

93: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
94: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
95: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
96:
97: INSERT INTO pv_ge_chklst_items_tl(
98: checklist_item_id ,
99: language ,
100: last_update_date ,
101: last_updated_by ,

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

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

Line 171: UPDATE pv_ge_chklst_items_tl

167: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
168: WHERE checklist_item_id = p_checklist_item_id;
169: --AND object_version_number = p_object_version_number;
170:
171: UPDATE pv_ge_chklst_items_tl
172: set checklist_item_name = DECODE( p_checklist_item_name, null, checklist_item_name, FND_API.g_miss_char, null, p_checklist_item_name),
173: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
174: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
175: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),

Line 275: INSERT /+ append parallel(tt) / INTO pv_ge_chklst_items_tl tt (

271: IS
272: BEGIN
273: -- changing by ktsao as per performance team guidelines to fix performance issue
274: -- as described in bug 3723612 (*** RTIKKU 03/24/05 12:46pm ***)
275: INSERT /*+ append parallel(tt) */ INTO pv_ge_chklst_items_tl tt (
276: checklist_item_id,
277: creation_date,
278: created_by,
279: last_update_date,

Line 297: FROM pv_ge_chklst_items_tl B ,

293: b.last_update_login,
294: b.checklist_item_name,
295: l.language_code,
296: b.source_lang
297: FROM pv_ge_chklst_items_tl B ,
298: FND_LANGUAGES L
299: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
300: AND B.LANGUAGE = USERENV ( 'LANG' )
301: ) v, pv_ge_chklst_items_tl t

Line 301: ) v, pv_ge_chklst_items_tl t

297: FROM pv_ge_chklst_items_tl B ,
298: FND_LANGUAGES L
299: WHERE L.INSTALLED_FLAG IN ( 'I','B' )
300: AND B.LANGUAGE = USERENV ( 'LANG' )
301: ) v, pv_ge_chklst_items_tl t
302: WHERE t.checklist_item_id(+) = v.checklist_item_id
303: AND t.language(+) = v.language_code
304: AND t.checklist_item_id IS NULL;
305: