APPS.OE_PC_RSETS_PKG dependencies on OE_PC_RSETS_TL

Line 113: INSERT INTO oe_pc_rsets_tl (

109: ,x_attribute15
110: );
111:
112:
113: INSERT INTO oe_pc_rsets_tl (
114: record_set_id
115: ,language
116: ,source_lang
117: ,created_by

Line 140: FROM oe_pc_rsets_tl t

136: FROM fnd_languages l
137: WHERE l.installed_flag in ('I', 'B')
138: AND not exists (
139: SELECT null
140: FROM oe_pc_rsets_tl t
141: WHERE t.record_set_id = x_record_set_id
142: AND t.language = l.language_code);
143:
144: Open CROWID;

Line 196: FROM oe_pc_rsets_tl t

192: Recinfo C%ROWTYPE;
193:
194: CURSOR C1 IS
195: SELECT *
196: FROM oe_pc_rsets_tl t
197: WHERE record_set_id = x_record_set_id
198: AND language = userenv('LANG')
199: FOR UPDATE OF record_set_id NOWAIT;
200:

Line 329: UPDATE oe_pc_rsets_tl

325: RAISE NO_DATA_FOUND;
326: end if;
327:
328:
329: UPDATE oe_pc_rsets_tl
330: SET
331: source_lang = USERENV('LANG')
332: ,last_updated_by = x_last_updated_by
333: ,last_update_date = x_last_update_date

Line 362: DELETE FROM OE_PC_RSETS_TL

358: DELETE FROM OE_PC_VALIDATION_PKGS
359: WHERE record_set_id = x_record_set_id;
360:
361: -- delete the tl table
362: DELETE FROM OE_PC_RSETS_TL
363: WHERE record_set_id = x_record_set_id;
364:
365: DELETE FROM OE_PC_RSETS
366: WHERE record_set_id = x_record_set_id;

Line 377: DELETE FROM oe_pc_rsets_tl t

373: -------------------------------------------------------------------
374: PROCEDURE Add_Language
375: IS
376: Begin
377: DELETE FROM oe_pc_rsets_tl t
378: WHERE NOT EXISTS
379: (SELECT null
380: FROM oe_pc_rsets b
381: where record_set_id = t.record_set_id);

Line 383: UPDATE oe_pc_rsets_tl t

379: (SELECT null
380: FROM oe_pc_rsets b
381: where record_set_id = t.record_set_id);
382:
383: UPDATE oe_pc_rsets_tl t
384: SET
385: (
386: display_name,
387: description

Line 392: FROM oe_pc_rsets_tl b

388: ) = (
389: SELECT
390: b.display_name,
391: b.description
392: FROM oe_pc_rsets_tl b
393: WHERE b.record_set_id = t.record_set_id
394: AND b.language = t.source_lang
395: )
396: where

Line 404: FROM oe_pc_rsets_tl subb, oe_pc_rsets_tl subt

400: ) IN (
401: SELECT
402: subt.record_set_id,
403: subt.language
404: FROM oe_pc_rsets_tl subb, oe_pc_rsets_tl subt
405: WHERE subb.record_set_id = subt.record_set_id
406: AND subb.language = subt.source_lang
407: AND(subb.display_name <> subt.display_name
408: OR subb.DESCRIPTION <> subt.description

Line 414: INSERT INTO oe_pc_rsets_tl

410: OR (subb.description IS NOT null AND subt.description IS null)
411: )
412: );
413:
414: INSERT INTO oe_pc_rsets_tl
415: (
416: record_set_id
417: ,language
418: ,source_lang

Line 438: FROM oe_pc_rsets_tl b, fnd_languages l

434: ,b.last_update_date
435: ,b.display_name
436: ,b.description
437: ,b.last_update_login
438: FROM oe_pc_rsets_tl b, fnd_languages l
439: WHERE l.installed_flag IN ('I', 'B')
440: AND b.language = USERENV('LANG')
441: AND NOT EXISTS
442: ( SELECT null

Line 443: FROM oe_pc_rsets_tl t

439: WHERE l.installed_flag IN ('I', 'B')
440: AND b.language = USERENV('LANG')
441: AND NOT EXISTS
442: ( SELECT null
443: FROM oe_pc_rsets_tl t
444: WHERE t.record_set_id = b.record_set_id
445: AND t.language = l.language_code);
446: End Add_Language;
447: -------------------------------------------------------------------

Line 552: UPDATE oe_pc_rsets_tl

548: IS
549: l_user_id number :=0;
550: BEGIN
551: l_user_id := fnd_load_util.owner_id(x_owner); --Seed data changes
552: UPDATE oe_pc_rsets_tl
553: SET
554: source_lang = USERENV('LANG')
555: --,last_updated_by = decode(x_OWNER, 'SEED', 1, 0)
556: ,last_updated_by = l_user_id