APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_ELEMENT_SETS

Line 2702: -- INSTALLATION PROCEDURE FOR : PAY_ELEMENT_SETS

2698:
2699: END install_elements;
2700:
2701: --****************************************************************************
2702: -- INSTALLATION PROCEDURE FOR : PAY_ELEMENT_SETS
2703: --****************************************************************************
2704:
2705: PROCEDURE install_ele_sets(p_phase IN number)
2706: ---------------------------------------------

Line 2779: from pay_element_sets a

2775:
2776:
2777: select distinct null
2778: into l_null_return
2779: from pay_element_sets a
2780: where exists
2781: (select null
2782: from hr_s_element_sets b
2783: where a.element_set_id = b.element_set_id

Line 2814: select pay_element_sets_s.nextval

2810: into v_min_delivered
2811: , v_max_delivered
2812: from hr_s_element_sets;
2813:
2814: select pay_element_sets_s.nextval
2815: into v_sequence_number
2816: from dual;
2817:
2818: IF v_sequence_number

Line 2822: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',

2818: IF v_sequence_number
2819: BETWEEN v_min_delivered AND v_max_delivered
2820: THEN
2821:
2822: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',
2823: v_sequence_number,
2824: v_max_delivered);
2825:
2826: END IF;

Line 2835: -- PAY_ELEMENT_SETS

2831: PROCEDURE crt_exc (exception_type IN varchar2)
2832: ----------------------------------------------
2833: IS
2834: -- Reports any exceptions during the delivery of startup data to
2835: -- PAY_ELEMENT_SETS
2836:
2837: BEGIN
2838: -- When the installation procedures encounter an error that cannot
2839: -- be handled, an exception is raised and all work is rolled back

Line 2847: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'

2843:
2844:
2845: rollback to new_element_set_name;
2846:
2847: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'
2848: , stu_rec.c_surrogate_key
2849: , exception_type
2850: , stu_rec.c_true_key);
2851:

Line 2866: from pay_element_sets

2862: BEGIN
2863:
2864: select distinct element_set_id
2865: into l_new_surrogate_key
2866: from pay_element_sets
2867: where element_set_name = stu_rec.c_true_key
2868: and business_group_id is null
2869: and ( (legislation_code is null
2870: and stu_rec.c_leg_code is null)

Line 2876: select pay_element_sets_s.nextval

2872:
2873: EXCEPTION WHEN NO_DATA_FOUND THEN
2874:
2875:
2876: select pay_element_sets_s.nextval
2877: into l_new_surrogate_key
2878: from dual;
2879:
2880: WHEN TOO_MANY_ROWS THEN

Line 2883: hr_utility.trace('sel pay_element_sets TMR');

2879:
2880: WHEN TOO_MANY_ROWS THEN
2881:
2882: hr_legislation.hrrunprc_trace_on;
2883: hr_utility.trace('sel pay_element_sets TMR');
2884: hr_utility.trace('element_set_name ' ||
2885: stu_rec.c_true_key);
2886: hr_utility.trace(':lc: ' || ':' ||
2887: stu_rec.c_leg_code || ':');

Line 3018: from pay_element_sets a

3014: -- already been created by a user.
3015:
3016: select distinct null
3017: into l_null_return
3018: from pay_element_sets a
3019: where a.element_set_name = stu_rec.c_true_key
3020: and a.business_group_id is not null
3021: and exists (select null from per_business_groups b
3022: where b.business_group_id = a.business_group_id

Line 3051: from pay_element_sets

3047:
3048: BEGIN
3049: select distinct null
3050: into l_null_return
3051: from pay_element_sets
3052: where element_set_name = stu_rec.c_true_key
3053: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
3054: and (legislation_code is null
3055: or stu_rec.c_leg_code is null )

Line 3105: update pay_element_sets

3101:
3102: delete from pay_ele_classification_rules
3103: where element_set_id = l_new_surrogate_key;
3104:
3105: update pay_element_sets
3106: set element_set_type = stu_rec.element_set_type
3107: , last_update_date = stu_rec.last_update_date
3108: , last_updated_by = stu_rec.last_updated_by
3109: , last_update_login = stu_rec.last_update_login

Line 3118: insert into pay_element_sets

3114: IF NOT SQL%FOUND THEN
3115:
3116:
3117: BEGIN
3118: insert into pay_element_sets
3119: (element_set_name
3120: ,element_set_id
3121: ,legislation_code
3122: ,element_set_type

Line 3142: hr_utility.trace('ins pay_element_sets');

3138: ,stu_rec.creation_date
3139: );
3140: EXCEPTION WHEN OTHERS THEN
3141: hr_legislation.hrrunprc_trace_on;
3142: hr_utility.trace('ins pay_element_sets');
3143: hr_utility.trace('element_set_name ' ||
3144: stu_rec.c_true_key);
3145: hr_utility.trace('element_set_id ' ||
3146: to_char(stu_rec.c_surrogate_key));