APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_USER_TABLES

Line 3314: -- INSTALLATION PROCEDURE FOR : PAY_USER_TABLES

3310:
3311: END install_ele_sets;
3312:
3313: --****************************************************************************
3314: -- INSTALLATION PROCEDURE FOR : PAY_USER_TABLES
3315: --****************************************************************************
3316:
3317: PROCEDURE install_utables(p_phase IN number)
3318: --------------------------------------------

Line 3380: from pay_user_tables a

3376:
3377:
3378: select distinct null
3379: into l_null_return
3380: from pay_user_tables a
3381: where exists
3382: (select null
3383: from hr_s_user_tables b
3384: where a.user_table_id = b.user_table_id

Line 3415: select pay_user_tables_s.nextval

3411: into v_min_delivered
3412: , v_max_delivered
3413: from hr_s_user_tables;
3414:
3415: select pay_user_tables_s.nextval
3416: into v_sequence_number
3417: from dual;
3418:
3419: IF v_sequence_number

Line 3423: hr_legislation.munge_sequence('PAY_USER_TABLES_S',

3419: IF v_sequence_number
3420: BETWEEN v_min_delivered AND v_max_delivered
3421: THEN
3422:
3423: hr_legislation.munge_sequence('PAY_USER_TABLES_S',
3424: v_sequence_number,
3425: v_max_delivered);
3426:
3427: END IF;

Line 3436: -- PAY_USER_TABLES

3432: PROCEDURE crt_exc (exception_type IN varchar2)
3433: ----------------------------------------------
3434: IS
3435: -- Reports any exceptions during the delivery of startup data to
3436: -- PAY_USER_TABLES
3437:
3438: BEGIN
3439: -- When the installation procedures encounter an error that cannot
3440: -- be handled, an exception is raised and all work is rolled back

Line 3448: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'

3444:
3445:
3446: rollback to new_user_table_name;
3447:
3448: hr_legislation.insert_hr_stu_exceptions('pay_user_tables'
3449: , stu_rec.c_surrogate_key
3450: , exception_type
3451: , stu_rec.c_true_key);
3452:

Line 3468: from pay_user_tables

3464: BEGIN
3465:
3466: select distinct user_table_id
3467: into l_new_surrogate_key
3468: from pay_user_tables
3469: where user_table_name = stu_rec.c_true_key
3470: and business_group_id is null
3471: and ( (legislation_code is null
3472: and stu_rec.c_leg_code is null)

Line 3478: select pay_user_tables_s.nextval

3474:
3475: EXCEPTION WHEN NO_DATA_FOUND THEN
3476:
3477:
3478: select pay_user_tables_s.nextval
3479: into l_new_surrogate_key
3480: from dual;
3481:
3482: WHEN TOO_MANY_ROWS THEN

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

3480: from dual;
3481:
3482: WHEN TOO_MANY_ROWS THEN
3483: hr_legislation.hrrunprc_trace_on;
3484: hr_utility.trace('sel pay_user_tables TMR');
3485: hr_utility.trace('user_table_name ' ||
3486: stu_rec.c_true_key);
3487: hr_utility.trace(':lc: ' || ':' ||
3488: stu_rec.c_leg_code || ':');

Line 3636: from pay_user_tables a

3632: -- already been created by a user.
3633:
3634: select distinct null
3635: into l_null_return
3636: from pay_user_tables a
3637: where a.user_table_name = stu_rec.c_true_key
3638: and a.business_group_id is not null
3639: and exists (select null from per_business_groups b
3640: where b.business_group_id = a.business_group_id

Line 3668: from pay_user_tables

3664: BEGIN
3665:
3666: select distinct null
3667: into l_null_return
3668: from pay_user_tables
3669: where user_table_name = stu_rec.c_true_key
3670: and nvl(legislation_code,'x') <> nvl(stu_rec.c_leg_code,'x')
3671: and (legislation_code is null or stu_rec.c_leg_code is null )
3672: and business_group_id is null;

Line 3714: update pay_user_tables

3710: return;
3711: END IF;
3712:
3713:
3714: update pay_user_tables
3715: set range_or_match = stu_rec.range_or_match
3716: , user_key_units = stu_rec.user_key_units
3717: , last_update_date = stu_rec.last_update_date
3718: , last_updated_by = stu_rec.last_updated_by

Line 3728: insert into pay_user_tables

3724:
3725: IF NOT SQL%FOUND THEN
3726:
3727: BEGIN
3728: insert into pay_user_tables
3729: (user_table_id
3730: ,business_group_id
3731: ,legislation_code
3732: ,range_or_match

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

3756: ,stu_rec.user_row_title
3757: );
3758: EXCEPTION WHEN OTHERS THEN
3759: hr_legislation.hrrunprc_trace_on;
3760: hr_utility.trace('ins pay_user_tables');
3761: hr_utility.trace('user_table_id ' ||
3762: to_char(stu_rec.c_surrogate_key));
3763: hr_utility.trace('user_table_name ' ||
3764: stu_rec.c_true_key);

Line 4156: -- Start with checking the parent PAY_USER_TABLES

4152:
4153: -- The distinct is used in case the parent is date effective and many rows
4154: -- may be returned by the same parent id.
4155:
4156: -- Start with checking the parent PAY_USER_TABLES
4157:
4158:
4159: BEGIN
4160:

Line 4187: from pay_user_tables

4183: BEGIN
4184:
4185: select null
4186: into l_null_return
4187: from pay_user_tables
4188: where user_table_id = stu_rec.user_table_id;
4189:
4190: EXCEPTION WHEN NO_DATA_FOUND THEN
4191: