APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_USER_COLUMNS

Line 3793: -- INSTALLATION PROCEDURE FOR : PAY_USER_COLUMNS

3789:
3790: END install_utables;
3791:
3792: --****************************************************************************
3793: -- INSTALLATION PROCEDURE FOR : PAY_USER_COLUMNS
3794: --****************************************************************************
3795:
3796: PROCEDURE install_ucolumns (p_phase IN number)
3797: ----------------------------------------------

Line 3864: from pay_user_columns a

3860:
3861:
3862: select distinct null
3863: into l_null_return
3864: from pay_user_columns a
3865: where exists
3866: (select null
3867: from hr_s_user_columns b
3868: where a.user_column_id = b.user_column_id

Line 3896: select pay_user_columns_s.nextval

3892: into v_min_delivered
3893: , v_max_delivered
3894: from hr_s_user_columns;
3895:
3896: select pay_user_columns_s.nextval
3897: into v_sequence_number
3898: from dual;
3899:
3900: IF v_sequence_number

Line 3904: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',

3900: IF v_sequence_number
3901: BETWEEN v_min_delivered AND v_max_delivered
3902: THEN
3903:
3904: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',
3905: v_sequence_number,
3906: v_max_delivered);
3907:
3908: END IF;

Line 3917: -- PAY_USER_COLUMNS

3913: PROCEDURE crt_exc (exception_type IN varchar2)
3914: ----------------------------------------------
3915: IS
3916: -- Reports any exceptions during the delivery of startup data to
3917: -- PAY_USER_COLUMNS
3918:
3919: BEGIN
3920: -- When the installation procedures encounter an error that cannot
3921: -- be handled, an exception is raised and all work is rolled back

Line 3929: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'

3925:
3926:
3927: rollback to new_user_column_name;
3928:
3929: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'
3930: , stu_rec.c_surrogate_key
3931: , exception_type
3932: , stu_rec.c_true_key);
3933:

Line 3953: from pay_user_columns

3949: -- Add the user table id to the select criteria.
3950: --
3951: select distinct user_column_id
3952: into l_new_surrogate_key
3953: from pay_user_columns
3954: where user_column_name = stu_rec.c_true_key
3955: and user_table_id = stu_rec.user_table_id
3956: and business_group_id is null
3957: and ( (legislation_code is null

Line 3964: select pay_user_columns_s.nextval

3960:
3961: EXCEPTION WHEN NO_DATA_FOUND THEN
3962:
3963:
3964: select pay_user_columns_s.nextval
3965: into l_new_surrogate_key
3966: from dual;
3967:
3968: WHEN TOO_MANY_ROWS THEN

Line 3970: hr_utility.trace('sel pay_user_columns TMR');

3966: from dual;
3967:
3968: WHEN TOO_MANY_ROWS THEN
3969: hr_legislation.hrrunprc_trace_on;
3970: hr_utility.trace('sel pay_user_columns TMR');
3971: hr_utility.trace('user_column_name ' ||
3972: stu_rec.c_true_key);
3973: hr_utility.trace('user_table_id ' ||
3974: to_char(stu_rec.user_table_id));

Line 4246: from pay_user_columns a

4242: -- Add the user table id to the select criteria.
4243: --
4244: select distinct null
4245: into l_null_return
4246: from pay_user_columns a
4247: where a.user_table_id = stu_rec.user_table_id
4248: and a.user_column_name = stu_rec.c_true_key
4249: and a.business_group_id is not null
4250: and exists (select null from per_business_groups b

Line 4284: from pay_user_columns

4280: --
4281: BEGIN
4282: select distinct null
4283: into l_null_return
4284: from pay_user_columns
4285: where user_column_name = stu_rec.c_true_key
4286: and user_table_id = stu_rec.user_table_id
4287: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
4288: and (legislation_code is null or stu_rec.c_leg_code is null )

Line 4337: update pay_user_columns

4333: return;
4334: END IF;
4335:
4336:
4337: update pay_user_columns
4338: set formula_id = stu_rec.formula_id
4339: , last_update_date = stu_rec.last_update_date
4340: , last_updated_by = stu_rec.last_updated_by
4341: , last_update_login = stu_rec.last_update_login

Line 4349: insert into pay_user_columns

4345:
4346: IF NOT SQL%FOUND THEN
4347:
4348: BEGIN
4349: insert into pay_user_columns
4350: (user_column_id
4351: ,business_group_id
4352: ,legislation_code
4353: ,user_table_id

Line 4379: hr_utility.trace('ins pay_user_columns');

4375: ,stu_rec.creation_date
4376: );
4377: EXCEPTION WHEN OTHERS THEN
4378: hr_legislation.hrrunprc_trace_on;
4379: hr_utility.trace('ins pay_user_columns');
4380: hr_utility.trace('user_column_id ' ||
4381: to_char(stu_rec.c_surrogate_key));
4382: hr_utility.trace('user_column_name ' ||
4383: stu_rec.c_true_key);