APPS.OE_PC_VTMPLTS_PKG dependencies on OE_PC_VTMPLTS_TL

Line 131: INSERT INTO oe_pc_vtmplts_tl (

127: ,x_attribute15
128: );
129:
130:
131: INSERT INTO oe_pc_vtmplts_tl (
132: validation_tmplt_id
133: ,language
134: ,source_lang
135: ,created_by

Line 158: FROM oe_pc_vtmplts_tl t

154: FROM fnd_languages l
155: WHERE l.installed_flag in ('I', 'B')
156: AND not exists (
157: SELECT null
158: FROM oe_pc_vtmplts_tl t
159: WHERE t.validation_tmplt_id = x_validation_tmplt_id
160: AND t.language = l.language_code);
161:
162:

Line 221: FROM oe_pc_vtmplts_tl t

217: Recinfo C%ROWTYPE;
218:
219: CURSOR C1 IS
220: SELECT *
221: FROM oe_pc_vtmplts_tl t
222: WHERE validation_tmplt_id = x_validation_tmplt_id
223: AND language = userenv('LANG')
224: FOR UPDATE OF validation_tmplt_id NOWAIT;
225:

Line 384: UPDATE oe_pc_vtmplts_tl

380: RAISE NO_DATA_FOUND;
381: end if;
382:
383:
384: UPDATE oe_pc_vtmplts_tl
385: SET
386: source_lang = USERENV('LANG')
387: ,last_updated_by = x_last_updated_by
388: ,last_update_date = x_last_update_date

Line 417: DELETE FROM OE_PC_VTMPLTS_TL

413: DELETE FROM OE_PC_VALIDATION_PKGS
414: WHERE validation_tmplt_id = x_validation_tmplt_id;
415:
416: -- delete the tl table
417: DELETE FROM OE_PC_VTMPLTS_TL
418: WHERE validation_tmplt_id = x_validation_tmplt_id;
419:
420: DELETE FROM OE_PC_VTMPLTS
421: WHERE validation_tmplt_id = x_validation_tmplt_id;

Line 440: UPDATE oe_pc_vtmplts_tl t

436: (SELECT null
437: FROM oe_pc_vtmplts b
438: where validation_tmplt_id = t.validation_tmplt_id);
439:
440: UPDATE oe_pc_vtmplts_tl t
441: SET
442: (
443: display_name,
444: description

Line 449: FROM oe_pc_vtmplts_tl b

445: ) = (
446: SELECT
447: b.display_name,
448: b.description
449: FROM oe_pc_vtmplts_tl b
450: WHERE b.validation_tmplt_id = t.validation_tmplt_id
451: AND b.language = t.source_lang
452: )
453: where

Line 461: FROM oe_pc_vtmplts_tl subb, oe_pc_vtmplts_tl subt

457: ) IN (
458: SELECT
459: subt.validation_tmplt_id,
460: subt.language
461: FROM oe_pc_vtmplts_tl subb, oe_pc_vtmplts_tl subt
462: WHERE subb.validation_tmplt_id = subt.validation_tmplt_id
463: AND subb.language = subt.source_lang
464: AND(subb.display_name <> subt.display_name
465: OR subb.DESCRIPTION <> subt.description

Line 471: INSERT INTO oe_pc_vtmplts_tl

467: OR (subb.description IS NOT null AND subt.description IS null)
468: )
469: );
470:
471: INSERT INTO oe_pc_vtmplts_tl
472: (
473: validation_tmplt_id
474: ,language
475: ,source_lang

Line 495: FROM oe_pc_vtmplts_tl b, fnd_languages l

491: ,b.last_update_date
492: ,b.display_name
493: ,b.description
494: ,b.last_update_login
495: FROM oe_pc_vtmplts_tl b, fnd_languages l
496: WHERE l.installed_flag IN ('I', 'B')
497: AND b.language = USERENV('LANG')
498: AND NOT EXISTS
499: ( SELECT null

Line 500: FROM oe_pc_vtmplts_tl t

496: WHERE l.installed_flag IN ('I', 'B')
497: AND b.language = USERENV('LANG')
498: AND NOT EXISTS
499: ( SELECT null
500: FROM oe_pc_vtmplts_tl t
501: WHERE t.validation_tmplt_id = b.validation_tmplt_id
502: AND t.language = l.language_code);
503: End Add_Language;
504: -------------------------------------------------------------------

Line 587: UPDATE oe_pc_vtmplts_tl

583: IS
584: l_user_id number :=0;
585: BEGIN
586: l_user_id :=fnd_load_util.owner_id(x_owner);
587: UPDATE oe_pc_vtmplts_tl
588: SET
589: source_lang = USERENV('LANG')
590: --,last_updated_by = decode(x_OWNER, 'SEED', 1, 0)
591: ,last_updated_by = l_user_id