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

Line 27: from pay_element_classifications

23: v_match_found boolean;
24: --
25: cursor csr_matching_name is
26: select 1
27: from pay_element_classifications
28: where upper(classification_name) = upper(p_classification_name)
29: and nvl(legislation_code,nvl(p_legislation_code, ' '))
30: = nvl(p_legislation_code, ' ')
31: and (p_rowid is null

Line 37: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',1);

33: and business_group_id = p_business_group_id;
34: --
35: begin
36: --
37: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',1);
38: --
39: open csr_matching_name;
40: fetch csr_matching_name into g_dummy;
41: v_match_found := csr_matching_name%found;

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 87: pay_element_classifications ecl

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
91: AND (ecl.classification_id <> p_class_id OR p_class_id IS NULL)

Line 142: from pay_element_classifications

138: cursor csr_class_type is
139: select decode (parent_classification_id,
140: null,'PRIMARY',
141: 'SECONDARY')
142: from pay_element_classifications
143: where classification_id = p_classification_id;
144: --
145: function CHILD_CLASSIFICATIONS return boolean is
146: -- Check for child secondary classifications

Line 149: from pay_element_classifications

145: function CHILD_CLASSIFICATIONS return boolean is
146: -- Check for child secondary classifications
147: cursor csr_2ndary_classifications is
148: select 1
149: from pay_element_classifications
150: where parent_classification_id = p_classification_id;
151: --
152: begin
153: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',3);

Line 153: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',3);

149: from pay_element_classifications
150: where parent_classification_id = p_classification_id;
151: --
152: begin
153: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',3);
154: open csr_2ndary_classifications;
155: fetch csr_2ndary_classifications into g_dummy;
156: children_found := csr_2ndary_classifications%found;
157: close csr_2ndary_classifications;

Line 172: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',4);

168: from pay_element_types_f
169: where classification_id = p_classification_id;
170: --
171: begin
172: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',4);
173: open csr_element_types;
174: fetch csr_element_types into g_dummy;
175: children_found := csr_element_types%found;
176: close csr_element_types;

Line 191: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',5);

187: from pay_ele_classification_rules
188: where classification_id = p_classification_id;
189: --
190: begin
191: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',5);
192: open csr_class_rules;
193: fetch csr_class_rules into g_dummy;
194: children_found := csr_class_rules%found;
195: close csr_class_rules;

Line 210: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',6);

206: from pay_balance_classifications
207: where classification_id = p_classification_id;
208: --
209: begin
210: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',6);
211: open csr_balance_classes;
212: fetch csr_balance_classes into g_dummy;
213: children_found := csr_balance_classes%found;
214: close csr_balance_classes;

Line 229: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',7);

225: from pay_sub_classification_rules_f
226: where classification_id = p_classification_id;
227: --
228: begin
229: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',7);
230: open csr_sub_class_rules;
231: fetch csr_sub_class_rules into g_dummy;
232: children_found := csr_sub_class_rules%found;
233: close csr_sub_class_rules;

Line 242: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',1);

238: end child_sub_class_rules;
239: --
240: begin
241: --
242: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',1);
243: --
244: -- Find out whether this is a primary or secondary classification
245: --
246: open csr_class_type;

Line 252: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',2);

248: primary_classification := (classification_type = 'PRIMARY');
249: secondary_classification := (classification_type = 'SECONDARY');
250: close csr_class_type;
251: --
252: hr_utility.set_location ('PAY_ELEMENT_CLASSIFICATIONS_PKG',2);
253: --
254: -- Checks for deletion permission
255: --
256: if child_balance_classes

Line 292: from pay_element_classifications

288: and status = 'I';
289: --
290: cursor csr_seeded_data is
291: select 1
292: from pay_element_classifications
293: where legislation_code = p_legislation_code
294: and business_group_id is null;
295: --
296: cursor csr_localised is

Line 363: cursor C is select ROWID from PAY_ELEMENT_CLASSIFICATIONS

359: X_LAST_UPDATED_BY in NUMBER,
360: X_LAST_UPDATE_LOGIN in NUMBER,
361: X_FREQ_RULE_ENABLED in VARCHAR2 default null
362: ) is
363: cursor C is select ROWID from PAY_ELEMENT_CLASSIFICATIONS
364: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
365: ;
366: begin
367: insert into PAY_ELEMENT_CLASSIFICATIONS (

Line 367: insert into PAY_ELEMENT_CLASSIFICATIONS (

363: cursor C is select ROWID from PAY_ELEMENT_CLASSIFICATIONS
364: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
365: ;
366: begin
367: insert into PAY_ELEMENT_CLASSIFICATIONS (
368: CLASSIFICATION_ID,
369: CLASSIFICATION_NAME,
370: BUSINESS_GROUP_ID,
371: LEGISLATION_CODE,

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 491: from PAY_ELEMENT_CLASSIFICATIONS

487: CREATE_BY_DEFAULT_FLAG,
488: BALANCE_INITIALIZATION_FLAG,
489: OBJECT_VERSION_NUMBER,
490: FREQ_RULE_ENABLED
491: from PAY_ELEMENT_CLASSIFICATIONS
492: where CLASSIFICATION_ID = X_CLASSIFICATION_ID
493: for update of CLASSIFICATION_ID nowait;
494: recinfo c%rowtype;
495:

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 611: update PAY_ELEMENT_CLASSIFICATIONS set

607: else
608: X_MESG_FLG :=true;
609: end if;
610:
611: update PAY_ELEMENT_CLASSIFICATIONS set
612: CLASSIFICATION_NAME= decode(P_SOURCE_LANG,userenv('LANG'),X_CLASSIFICATION_NAME,CLASSIFICATION_NAME),
613: BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID,
614: LEGISLATION_CODE = X_LEGISLATION_CODE,
615: LEGISLATION_SUBGROUP = X_LEGISLATION_SUBGROUP,

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 663: delete from PAY_ELEMENT_CLASSIFICATIONS

659: if (sql%notfound) then
660: raise no_data_found;
661: end if;
662:
663: delete from PAY_ELEMENT_CLASSIFICATIONS
664: where CLASSIFICATION_ID = X_CLASSIFICATION_ID;
665:
666: if (sql%notfound) then
667: 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 677: from PAY_ELEMENT_CLASSIFICATIONS B

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
679: );
680:
681: update PAY_ELEMENT_CLASSIFICATIONS_TL T set (

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 742: FROM PAY_ELEMENT_CLASSIFICATIONS

738: is
739: result varchar2(255);
740: Begin
741: SELECT count(*) INTO result
742: FROM PAY_ELEMENT_CLASSIFICATIONS
743: WHERE nvl(CLASSIFICATION_NAME,'~null~') = nvl(E_CLASSIFICATION_NAME,'~null~')
744: and nvl(LEGISLATION_CODE,'~null~') = nvl(E_LEGISLATION_CODE,'~null~')
745: and BUSINESS_GROUP_ID is NULL;
746: --

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),

Line 780: from pay_element_classifications

776: source_lang = userenv('LANG')
777: WHERE userenv('LANG') IN (language,source_lang)
778: AND CLASSIFICATION_ID in
779: (select CLASSIFICATION_ID
780: from pay_element_classifications
781: where nvl(CLASSIFICATION_NAME,'~null~')=nvl(X_E_CLASSIFICATION_NAME,'~null~')
782: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_E_LEGISLATION_CODE,'~null~')
783: and BUSINESS_GROUP_ID is NULL);
784: --