APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_ELEMENT_SETS

Line 2670: -- INSTALLATION PROCEDURE FOR : PAY_ELEMENT_SETS

2666:
2667: END install_elements;
2668:
2669: --****************************************************************************
2670: -- INSTALLATION PROCEDURE FOR : PAY_ELEMENT_SETS
2671: --****************************************************************************
2672:
2673: PROCEDURE install_ele_sets(p_phase IN number)
2674: ---------------------------------------------

Line 2747: from pay_element_sets a

2743:
2744:
2745: select distinct null
2746: into l_null_return
2747: from pay_element_sets a
2748: where exists
2749: (select null
2750: from hr_s_element_sets b
2751: where a.element_set_id = b.element_set_id

Line 2782: select pay_element_sets_s.nextval

2778: into v_min_delivered
2779: , v_max_delivered
2780: from hr_s_element_sets;
2781:
2782: select pay_element_sets_s.nextval
2783: into v_sequence_number
2784: from dual;
2785:
2786: IF v_sequence_number

Line 2790: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',

2786: IF v_sequence_number
2787: BETWEEN v_min_delivered AND v_max_delivered
2788: THEN
2789:
2790: hr_legislation.munge_sequence('PAY_ELEMENT_SETS_S',
2791: v_sequence_number,
2792: v_max_delivered);
2793:
2794: END IF;

Line 2803: -- PAY_ELEMENT_SETS

2799: PROCEDURE crt_exc (exception_type IN varchar2)
2800: ----------------------------------------------
2801: IS
2802: -- Reports any exceptions during the delivery of startup data to
2803: -- PAY_ELEMENT_SETS
2804:
2805: BEGIN
2806: -- When the installation procedures encounter an error that cannot
2807: -- be handled, an exception is raised and all work is rolled back

Line 2815: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'

2811:
2812:
2813: rollback to new_element_set_name;
2814:
2815: hr_legislation.insert_hr_stu_exceptions('pay_element_sets'
2816: , stu_rec.c_surrogate_key
2817: , exception_type
2818: , stu_rec.c_true_key);
2819:

Line 2834: from pay_element_sets

2830: BEGIN
2831:
2832: select distinct element_set_id
2833: into l_new_surrogate_key
2834: from pay_element_sets
2835: where element_set_name = stu_rec.c_true_key
2836: and business_group_id is null
2837: and ( (legislation_code is null
2838: and stu_rec.c_leg_code is null)

Line 2844: select pay_element_sets_s.nextval

2840:
2841: EXCEPTION WHEN NO_DATA_FOUND THEN
2842:
2843:
2844: select pay_element_sets_s.nextval
2845: into l_new_surrogate_key
2846: from dual;
2847:
2848: WHEN TOO_MANY_ROWS THEN

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

2847:
2848: WHEN TOO_MANY_ROWS THEN
2849:
2850: hr_legislation.hrrunprc_trace_on;
2851: hr_utility.trace('sel pay_element_sets TMR');
2852: hr_utility.trace('element_set_name ' ||
2853: stu_rec.c_true_key);
2854: hr_utility.trace(':lc: ' || ':' ||
2855: stu_rec.c_leg_code || ':');

Line 2986: from pay_element_sets a

2982: -- already been created by a user.
2983:
2984: select distinct null
2985: into l_null_return
2986: from pay_element_sets a
2987: where a.element_set_name = stu_rec.c_true_key
2988: and a.business_group_id is not null
2989: and exists (select null from per_business_groups b
2990: where b.business_group_id = a.business_group_id

Line 3019: from pay_element_sets

3015:
3016: BEGIN
3017: select distinct null
3018: into l_null_return
3019: from pay_element_sets
3020: where element_set_name = stu_rec.c_true_key
3021: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
3022: and (legislation_code is null
3023: or stu_rec.c_leg_code is null )

Line 3073: update pay_element_sets

3069:
3070: delete from pay_ele_classification_rules
3071: where element_set_id = l_new_surrogate_key;
3072:
3073: update pay_element_sets
3074: set element_set_type = stu_rec.element_set_type
3075: , last_update_date = stu_rec.last_update_date
3076: , last_updated_by = stu_rec.last_updated_by
3077: , last_update_login = stu_rec.last_update_login

Line 3086: insert into pay_element_sets

3082: IF NOT SQL%FOUND THEN
3083:
3084:
3085: BEGIN
3086: insert into pay_element_sets
3087: (element_set_name
3088: ,element_set_id
3089: ,legislation_code
3090: ,element_set_type

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

3106: ,stu_rec.creation_date
3107: );
3108: EXCEPTION WHEN OTHERS THEN
3109: hr_legislation.hrrunprc_trace_on;
3110: hr_utility.trace('ins pay_element_sets');
3111: hr_utility.trace('element_set_name ' ||
3112: stu_rec.c_true_key);
3113: hr_utility.trace('element_set_id ' ||
3114: to_char(stu_rec.c_surrogate_key));