[Home] [Help]
97: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
98: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
99: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
100:
101: INSERT INTO pv_ge_qsnr_elements_tl(
102: qsnr_element_id ,
103: --object_version_number,
104: language ,
105: last_update_date ,
122: USERENV('LANG'),
123: DECODE( p_elmt_content, FND_API.G_MISS_CHAR, NULL, p_elmt_content)
124: FROM fnd_languages l
125: WHERE l.installed_flag IN ('I','B')
126: AND NOT EXISTS(SELECT NULL FROM pv_ge_qsnr_elements_tl t
127: WHERE t.qsnr_element_id = DECODE( px_qsnr_element_id, FND_API.G_MISS_NUM, NULL, px_qsnr_element_id)
128: AND t.language = l.language_code);
129: END Insert_Row;
130:
178: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
179: WHERE qsnr_element_id = p_qsnr_element_id
180: AND object_version_number = px_object_version_number;
181:
182: UPDATE pv_ge_qsnr_elements_tl
183: set elmt_content = DECODE( p_elmt_content, null, elmt_content, FND_API.g_miss_char, null, p_elmt_content),
184: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
185: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
186: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
283: IS
284: BEGIN
285: -- changing by pukken as per performance team guidelines to fix performance issue
286: -- as described in bug 3723612 (*** RTIKKU 03/24/05 12:46pm ***)
287: INSERT /*+ append parallel(tt) */ INTO pv_ge_qsnr_elements_tl tt
288: (
289: qsnr_element_id,
290: creation_date,
291: created_by,
308: b.last_update_login,
309: b.elmt_content,
310: l.language_code,
311: b.source_lang
312: FROM pv_ge_qsnr_elements_tl B , FND_LANGUAGES L
313: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
314: ) v
315: , pv_ge_qsnr_elements_tl t
316: WHERE t.qsnr_element_id(+) = v.qsnr_element_id
311: b.source_lang
312: FROM pv_ge_qsnr_elements_tl B , FND_LANGUAGES L
313: WHERE L.INSTALLED_FLAG IN ( 'I','B' ) AND B.LANGUAGE = USERENV ( 'LANG' )
314: ) v
315: , pv_ge_qsnr_elements_tl t
316: WHERE t.qsnr_element_id(+) = v.qsnr_element_id
317: AND t.language(+) = v.language_code
318: AND t.qsnr_element_id IS NULL ;
319:
385: X_LAST_UPDATED_BY,
386: X_LAST_UPDATE_LOGIN
387: );
388:
389: insert into PV_GE_QSNR_ELEMENTS_TL (
390: QSNR_ELEMENT_ID,
391: ELMT_CONTENT,
392: CREATED_BY,
393: CREATION_DATE,
409: from FND_LANGUAGES L
410: where L.INSTALLED_FLAG in ('I', 'B')
411: and not exists
412: (select NULL
413: from PV_GE_QSNR_ELEMENTS_TL T
414: where T.QSNR_ELEMENT_ID = X_QSNR_ELEMENT_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416:
417: open c;
452:
453: cursor c1 is select
454: ELMT_CONTENT,
455: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
456: from PV_GE_QSNR_ELEMENTS_TL
457: where QSNR_ELEMENT_ID = X_QSNR_ELEMENT_ID
458: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
459: for update of QSNR_ELEMENT_ID nowait;
460: begin
530: if (sql%notfound) then
531: raise no_data_found;
532: end if;
533:
534: update PV_GE_QSNR_ELEMENTS_TL set
535: ELMT_CONTENT = X_ELMT_CONTENT,
536: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
537: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
538: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
548: procedure DELETE_ROW (
549: X_QSNR_ELEMENT_ID in NUMBER
550: ) is
551: begin
552: delete from PV_GE_QSNR_ELEMENTS_TL
553: where QSNR_ELEMENT_ID = X_QSNR_ELEMENT_ID;
554:
555: if (sql%notfound) then
556: raise no_data_found;