APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_USER_TABLES

Line 3282: -- INSTALLATION PROCEDURE FOR : PAY_USER_TABLES

3278:
3279: END install_ele_sets;
3280:
3281: --****************************************************************************
3282: -- INSTALLATION PROCEDURE FOR : PAY_USER_TABLES
3283: --****************************************************************************
3284:
3285: PROCEDURE install_utables(p_phase IN number)
3286: --------------------------------------------

Line 3348: from pay_user_tables a

3344:
3345:
3346: select distinct null
3347: into l_null_return
3348: from pay_user_tables a
3349: where exists
3350: (select null
3351: from hr_s_user_tables b
3352: where a.user_table_id = b.user_table_id

Line 3383: select pay_user_tables_s.nextval

3379: into v_min_delivered
3380: , v_max_delivered
3381: from hr_s_user_tables;
3382:
3383: select pay_user_tables_s.nextval
3384: into v_sequence_number
3385: from dual;
3386:
3387: IF v_sequence_number

Line 3391: hr_legislation.munge_sequence('PAY_USER_TABLES_S',

3387: IF v_sequence_number
3388: BETWEEN v_min_delivered AND v_max_delivered
3389: THEN
3390:
3391: hr_legislation.munge_sequence('PAY_USER_TABLES_S',
3392: v_sequence_number,
3393: v_max_delivered);
3394:
3395: END IF;

Line 3404: -- PAY_USER_TABLES

3400: PROCEDURE crt_exc (exception_type IN varchar2)
3401: ----------------------------------------------
3402: IS
3403: -- Reports any exceptions during the delivery of startup data to
3404: -- PAY_USER_TABLES
3405:
3406: BEGIN
3407: -- When the installation procedures encounter an error that cannot
3408: -- be handled, an exception is raised and all work is rolled back

Line 3416: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'

3412:
3413:
3414: rollback to new_user_table_name;
3415:
3416: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'
3417: , stu_rec.c_surrogate_key
3418: , exception_type
3419: , stu_rec.c_true_key);
3420:

Line 3436: from pay_user_tables

3432: BEGIN
3433:
3434: select distinct user_table_id
3435: into l_new_surrogate_key
3436: from pay_user_tables
3437: where user_table_name = stu_rec.c_true_key
3438: and business_group_id is null
3439: and ( (legislation_code is null
3440: and stu_rec.c_leg_code is null)

Line 3446: select pay_user_tables_s.nextval

3442:
3443: EXCEPTION WHEN NO_DATA_FOUND THEN
3444:
3445:
3446: select pay_user_tables_s.nextval
3447: into l_new_surrogate_key
3448: from dual;
3449:
3450: WHEN TOO_MANY_ROWS THEN

Line 3452: hr_utility.trace('sel pay_user_tables TMR');

3448: from dual;
3449:
3450: WHEN TOO_MANY_ROWS THEN
3451: hr_legislation.hrrunprc_trace_on;
3452: hr_utility.trace('sel pay_user_tables TMR');
3453: hr_utility.trace('user_table_name ' ||
3454: stu_rec.c_true_key);
3455: hr_utility.trace(':lc: ' || ':' ||
3456: stu_rec.c_leg_code || ':');

Line 3604: from pay_user_tables a

3600: -- already been created by a user.
3601:
3602: select distinct null
3603: into l_null_return
3604: from pay_user_tables a
3605: where a.user_table_name = stu_rec.c_true_key
3606: and a.business_group_id is not null
3607: and exists (select null from per_business_groups b
3608: where b.business_group_id = a.business_group_id

Line 3636: from pay_user_tables

3632: BEGIN
3633:
3634: select distinct null
3635: into l_null_return
3636: from pay_user_tables
3637: where user_table_name = stu_rec.c_true_key
3638: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
3639: and (legislation_code is null or stu_rec.c_leg_code is null )
3640: and business_group_id is null;

Line 3682: update pay_user_tables

3678: return;
3679: END IF;
3680:
3681:
3682: update pay_user_tables
3683: set range_or_match = stu_rec.range_or_match
3684: , user_key_units = stu_rec.user_key_units
3685: , last_update_date = stu_rec.last_update_date
3686: , last_updated_by = stu_rec.last_updated_by

Line 3696: insert into pay_user_tables

3692:
3693: IF NOT SQL%FOUND THEN
3694:
3695: BEGIN
3696: insert into pay_user_tables
3697: (user_table_id
3698: ,business_group_id
3699: ,legislation_code
3700: ,range_or_match

Line 3728: hr_utility.trace('ins pay_user_tables');

3724: ,stu_rec.user_row_title
3725: );
3726: EXCEPTION WHEN OTHERS THEN
3727: hr_legislation.hrrunprc_trace_on;
3728: hr_utility.trace('ins pay_user_tables');
3729: hr_utility.trace('user_table_id ' ||
3730: to_char(stu_rec.c_surrogate_key));
3731: hr_utility.trace('user_table_name ' ||
3732: stu_rec.c_true_key);

Line 4124: -- Start with checking the parent PAY_USER_TABLES

4120:
4121: -- The distinct is used in case the parent is date effective and many rows
4122: -- may be returned by the same parent id.
4123:
4124: -- Start with checking the parent PAY_USER_TABLES
4125:
4126:
4127: BEGIN
4128:

Line 4155: from pay_user_tables

4151: BEGIN
4152:
4153: select null
4154: into l_null_return
4155: from pay_user_tables
4156: where user_table_id = stu_rec.user_table_id;
4157:
4158: EXCEPTION WHEN NO_DATA_FOUND THEN
4159: