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.OE_PC_VTMPLTS_PKG dependencies on OE_PC_VTMPLTS

Line 1: PACKAGE BODY OE_PC_VTMPLTS_PKG AS

1: PACKAGE BODY OE_PC_VTMPLTS_PKG AS
2: /* $Header: OEXPCVTB.pls 120.1 2005/07/15 03:05:54 ppnair noship $ */
3:
4: -------------------------------------------------
5: PROCEDURE Insert_Row(

Line 43: CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplts

39: ,x_attribute14 in varchar2
40: ,x_attribute15 in varchar2
41: )
42: Is
43: CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplts
44: WHERE validation_tmplt_id = x_validation_tmplt_id;
45:
46: CURSOR CID IS SELECT oe_pc_vtmplts_s.nextval
47: FROM sys.dual;

Line 46: CURSOR CID IS SELECT oe_pc_vtmplts_s.nextval

42: Is
43: CURSOR CROWID IS SELECT rowid FROM oe_pc_vtmplts
44: WHERE validation_tmplt_id = x_validation_tmplt_id;
45:
46: CURSOR CID IS SELECT oe_pc_vtmplts_s.nextval
47: FROM sys.dual;
48: Begin
49:
50: IF x_validation_tmplt_id IS NULL THEN

Line 60: INSERT INTO oe_pc_vtmplts (

56: end if;
57: Close CID;
58: END IF;
59:
60: INSERT INTO oe_pc_vtmplts (
61: validation_tmplt_id
62: ,entity_id
63: ,validation_tmplt_short_name
64: ,validation_type

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 213: FROM oe_pc_vtmplts

209: )
210: Is
211: CURSOR C IS
212: SELECT *
213: FROM oe_pc_vtmplts
214: WHERE rowid = x_rowid
215: FOR UPDATE OF validation_tmplt_id NOWAIT;
216:
217: Recinfo C%ROWTYPE;

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 344: UPDATE oe_pc_vtmplts

340: )
341: Is
342: Begin
343:
344: UPDATE oe_pc_vtmplts
345: SET
346: entity_id = x_entity_id
347: ,validation_tmplt_short_name = x_validation_tmplt_short_name
348: ,validation_type = x_validation_type

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 420: DELETE FROM OE_PC_VTMPLTS

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;
422:
423:
424:

Line 434: DELETE FROM oe_pc_vtmplts t

430: -------------------------------------------------------------------
431: PROCEDURE Add_Language
432: IS
433: Begin
434: DELETE FROM oe_pc_vtmplts t
435: WHERE NOT EXISTS
436: (SELECT null
437: FROM oe_pc_vtmplts b
438: where validation_tmplt_id = t.validation_tmplt_id);

Line 437: FROM oe_pc_vtmplts b

433: Begin
434: DELETE FROM oe_pc_vtmplts t
435: WHERE NOT EXISTS
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

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 549: FROM oe_pc_vtmplts_vl

545: if (chk_display_name = TRUE) then
546: -- record set short name should be unique within an entity
547: SELECT count(1)
548: INTO dummy
549: FROM oe_pc_vtmplts_vl
550: WHERE entity_id = x_entity_id
551: AND validation_tmplt_display_name = x_display_name
552: AND ((x_rowid IS null) OR (row_id <> x_rowid));
553:

Line 564: FROM oe_pc_vtmplts

560: if (chk_short_name = TRUE) then
561: -- record set short name should be unique within an entity
562: SELECT count(1)
563: INTO dummy
564: FROM oe_pc_vtmplts
565: WHERE entity_id = x_entity_id
566: AND validation_tmplt_short_name = x_validation_tmplt_short_name
567: AND ((x_rowid IS null) OR (rowid <> x_rowid));
568:

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

Line 652: from oe_pc_vtmplts

648: user_id :=fnd_load_util.owner_id(x_owner);
649: begin
650: select last_updated_by
651: into l_db_user_id
652: from oe_pc_vtmplts
653: where validation_tmplt_id = x_validation_tmplt_id;
654: exception
655: when no_data_found then
656: null;

Line 665: OE_PC_vtmplts_pkg.UPDATE_ROW(

661: l_valid_release :=true ;
662: end if;
663: if l_valid_release then
664: --Seed data versioning changes end
665: OE_PC_vtmplts_pkg.UPDATE_ROW(
666: x_rowid => row_id
667: ,x_validation_tmplt_id => x_validation_tmplt_id
668: ,x_display_name => x_display_name
669: ,x_description => x_description

Line 708: oe_pc_vtmplts_pkg.INSERT_ROW(

704: when NO_DATA_FOUND then
705:
706: l_validation_tmplt_id := x_validation_tmplt_id;
707:
708: oe_pc_vtmplts_pkg.INSERT_ROW(
709: x_rowid => row_id
710: ,x_validation_tmplt_id => l_validation_tmplt_id
711: ,x_display_name => x_display_name
712: ,x_description => x_description

Line 749: END OE_PC_VTMPLTS_PKG;

745: end;
746:
747: END LOAD_ROW;
748:
749: END OE_PC_VTMPLTS_PKG;