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.PAY_ELEMENT_CLASS_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS_TL

Line 86: FROM pay_element_classifications_tl ect,

82: p_class_id IN NUMBER,
83: p_bus_grp_id IN NUMBER,
84: p_leg_code IN varchar2) IS
85: SELECT 1
86: FROM pay_element_classifications_tl ect,
87: pay_element_classifications ecl
88: WHERE upper(ect.classification_name)=upper(p_class_name)
89: AND ect.classification_id = ecl.classification_id
90: AND ect.language = p_language

Line 415: insert into PAY_ELEMENT_CLASSIFICATIONS_TL (

411: X_LAST_UPDATE_LOGIN,
412: X_FREQ_RULE_ENABLED
413: );
414:
415: insert into PAY_ELEMENT_CLASSIFICATIONS_TL (
416: CLASSIFICATION_ID,
417: CLASSIFICATION_NAME,
418: DESCRIPTION,
419: LAST_UPDATE_DATE,

Line 441: from PAY_ELEMENT_CLASSIFICATIONS_TL T

437: from FND_LANGUAGES L
438: where L.INSTALLED_FLAG in ('I', 'B')
439: and not exists
440: (select NULL
441: from PAY_ELEMENT_CLASSIFICATIONS_TL T
442: where T.CLASSIFICATION_ID = X_CLASSIFICATION_ID
443: and T.LANGUAGE = L.LANGUAGE_CODE);
444:
445: open c;

Line 500: from PAY_ELEMENT_CLASSIFICATIONS_TL

496: cursor c1 is select
497: CLASSIFICATION_NAME,
498: DESCRIPTION,
499: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
500: from PAY_ELEMENT_CLASSIFICATIONS_TL
501: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
502: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
503: for update of CLASSIFICATION_ID nowait;
504: begin

Line 591: P_SOURCE_LANG PAY_ELEMENT_CLASSIFICATIONS_TL.SOURCE_LANG%type;

587: X_MESG_FLG out nocopy Boolean,
588: X_FREQ_RULE_ENABLED in VARCHAR2 default null
589: ) is
590:
591: P_SOURCE_LANG PAY_ELEMENT_CLASSIFICATIONS_TL.SOURCE_LANG%type;
592: begin
593: begin
594: select source_lang
595: into P_SOURCE_LANG

Line 596: from PAY_ELEMENT_CLASSIFICATIONS_TL

592: begin
593: begin
594: select source_lang
595: into P_SOURCE_LANG
596: from PAY_ELEMENT_CLASSIFICATIONS_TL
597: where
598: CLASSIFICATION_ID = X_CLASSIFICATION_ID
599: and userenv('LANG') = LANGUAGE;
600: Exception

Line 637: update PAY_ELEMENT_CLASSIFICATIONS_TL set

633: if (sql%notfound) then
634: raise no_data_found;
635: end if;
636:
637: update PAY_ELEMENT_CLASSIFICATIONS_TL set
638: CLASSIFICATION_NAME = X_CLASSIFICATION_NAME,
639: DESCRIPTION = X_DESCRIPTION,
640: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
641: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 656: delete from PAY_ELEMENT_CLASSIFICATIONS_TL

652: procedure DELETE_ROW (
653: X_CLASSIFICATION_ID in NUMBER
654: ) is
655: begin
656: delete from PAY_ELEMENT_CLASSIFICATIONS_TL
657: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
658:
659: if (sql%notfound) then
660: raise no_data_found;

Line 674: delete from PAY_ELEMENT_CLASSIFICATIONS_TL T

670: --------------------------------------------------------------------------------
671: procedure ADD_LANGUAGE
672: is
673: begin
674: delete from PAY_ELEMENT_CLASSIFICATIONS_TL T
675: where not exists
676: (select NULL
677: from PAY_ELEMENT_CLASSIFICATIONS B
678: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID

Line 681: update PAY_ELEMENT_CLASSIFICATIONS_TL T set (

677: from PAY_ELEMENT_CLASSIFICATIONS B
678: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
679: );
680:
681: update PAY_ELEMENT_CLASSIFICATIONS_TL T set (
682: CLASSIFICATION_NAME,
683: DESCRIPTION
684: ) = (select
685: B.CLASSIFICATION_NAME,

Line 687: from PAY_ELEMENT_CLASSIFICATIONS_TL B

683: DESCRIPTION
684: ) = (select
685: B.CLASSIFICATION_NAME,
686: B.DESCRIPTION
687: from PAY_ELEMENT_CLASSIFICATIONS_TL B
688: where B.CLASSIFICATION_ID = T.CLASSIFICATION_ID
689: and B.LANGUAGE = T.SOURCE_LANG)
690: where (
691: T.CLASSIFICATION_ID,

Line 696: from PAY_ELEMENT_CLASSIFICATIONS_TL SUBB, PAY_ELEMENT_CLASSIFICATIONS_TL SUBT

692: T.LANGUAGE
693: ) in (select
694: SUBT.CLASSIFICATION_ID,
695: SUBT.LANGUAGE
696: from PAY_ELEMENT_CLASSIFICATIONS_TL SUBB, PAY_ELEMENT_CLASSIFICATIONS_TL SUBT
697: where SUBB.CLASSIFICATION_ID = SUBT.CLASSIFICATION_ID
698: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
699: and (SUBB.CLASSIFICATION_NAME <> SUBT.CLASSIFICATION_NAME
700: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 705: insert into PAY_ELEMENT_CLASSIFICATIONS_TL (

701: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
702: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
703: ));
704:
705: insert into PAY_ELEMENT_CLASSIFICATIONS_TL (
706: CLASSIFICATION_ID,
707: CLASSIFICATION_NAME,
708: DESCRIPTION,
709: LAST_UPDATE_DATE,

Line 727: from PAY_ELEMENT_CLASSIFICATIONS_TL B, FND_LANGUAGES L

723: B.CREATED_BY,
724: B.CREATION_DATE,
725: L.LANGUAGE_CODE,
726: B.SOURCE_LANG
727: from PAY_ELEMENT_CLASSIFICATIONS_TL B, FND_LANGUAGES L
728: where L.INSTALLED_FLAG in ('I', 'B')
729: and B.LANGUAGE = userenv('LANG')
730: and not exists
731: (select NULL

Line 732: from PAY_ELEMENT_CLASSIFICATIONS_TL T

728: where L.INSTALLED_FLAG in ('I', 'B')
729: and B.LANGUAGE = userenv('LANG')
730: and not exists
731: (select NULL
732: from PAY_ELEMENT_CLASSIFICATIONS_TL T
733: where T.CLASSIFICATION_ID = B.CLASSIFICATION_ID
734: and T.LANGUAGE = L.LANGUAGE_CODE);
735: end ADD_LANGUAGE;
736: --------------------------------------------------------------------------------

Line 770: UPDATE pay_element_classifications_tl

766: X_OWNER in VARCHAR2) is
767: begin
768: -- unique_chk(X_E_CLASSIFICATION_NAME,X_E_LEGISLATION_CODE);
769: --
770: UPDATE pay_element_classifications_tl
771: SET CLASSIFICATION_NAME = nvl(X_CLASSIFICATION_NAME,CLASSIFICATION_NAME),
772: description = nvl(x_description,description),
773: last_update_date = SYSDATE,
774: last_updated_by = decode(x_owner,'SEED',1,0),