APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_USER_COLUMNS

Line 3825: -- INSTALLATION PROCEDURE FOR : PAY_USER_COLUMNS

3821:
3822: END install_utables;
3823:
3824: --****************************************************************************
3825: -- INSTALLATION PROCEDURE FOR : PAY_USER_COLUMNS
3826: --****************************************************************************
3827:
3828: PROCEDURE install_ucolumns (p_phase IN number)
3829: ----------------------------------------------

Line 3896: from pay_user_columns a

3892:
3893:
3894: select distinct null
3895: into l_null_return
3896: from pay_user_columns a
3897: where exists
3898: (select null
3899: from hr_s_user_columns b
3900: where a.user_column_id = b.user_column_id

Line 3928: select pay_user_columns_s.nextval

3924: into v_min_delivered
3925: , v_max_delivered
3926: from hr_s_user_columns;
3927:
3928: select pay_user_columns_s.nextval
3929: into v_sequence_number
3930: from dual;
3931:
3932: IF v_sequence_number

Line 3936: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',

3932: IF v_sequence_number
3933: BETWEEN v_min_delivered AND v_max_delivered
3934: THEN
3935:
3936: hr_legislation.munge_sequence('PAY_USER_COLUMNS_S',
3937: v_sequence_number,
3938: v_max_delivered);
3939:
3940: END IF;

Line 3949: -- PAY_USER_COLUMNS

3945: PROCEDURE crt_exc (exception_type IN varchar2)
3946: ----------------------------------------------
3947: IS
3948: -- Reports any exceptions during the delivery of startup data to
3949: -- PAY_USER_COLUMNS
3950:
3951: BEGIN
3952: -- When the installation procedures encounter an error that cannot
3953: -- be handled, an exception is raised and all work is rolled back

Line 3961: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'

3957:
3958:
3959: rollback to new_user_column_name;
3960:
3961: hr_legislation.insert_hr_stu_exceptions('pay_user_columns'
3962: , stu_rec.c_surrogate_key
3963: , exception_type
3964: , stu_rec.c_true_key);
3965:

Line 3985: from pay_user_columns

3981: -- Add the user table id to the select criteria.
3982: --
3983: select distinct user_column_id
3984: into l_new_surrogate_key
3985: from pay_user_columns
3986: where user_column_name = stu_rec.c_true_key
3987: and user_table_id = stu_rec.user_table_id
3988: and business_group_id is null
3989: and ( (legislation_code is null

Line 3996: select pay_user_columns_s.nextval

3992:
3993: EXCEPTION WHEN NO_DATA_FOUND THEN
3994:
3995:
3996: select pay_user_columns_s.nextval
3997: into l_new_surrogate_key
3998: from dual;
3999:
4000: WHEN TOO_MANY_ROWS THEN

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

3998: from dual;
3999:
4000: WHEN TOO_MANY_ROWS THEN
4001: hr_legislation.hrrunprc_trace_on;
4002: hr_utility.trace('sel pay_user_columns TMR');
4003: hr_utility.trace('user_column_name ' ||
4004: stu_rec.c_true_key);
4005: hr_utility.trace('user_table_id ' ||
4006: to_char(stu_rec.user_table_id));

Line 4278: from pay_user_columns a

4274: -- Add the user table id to the select criteria.
4275: --
4276: select distinct null
4277: into l_null_return
4278: from pay_user_columns a
4279: where a.user_table_id = stu_rec.user_table_id
4280: and a.user_column_name = stu_rec.c_true_key
4281: and a.business_group_id is not null
4282: and exists (select null from per_business_groups b

Line 4316: from pay_user_columns

4312: --
4313: BEGIN
4314: select distinct null
4315: into l_null_return
4316: from pay_user_columns
4317: where user_column_name = stu_rec.c_true_key
4318: and user_table_id = stu_rec.user_table_id
4319: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
4320: and (legislation_code is null or stu_rec.c_leg_code is null )

Line 4369: update pay_user_columns

4365: return;
4366: END IF;
4367:
4368:
4369: update pay_user_columns
4370: set formula_id = stu_rec.formula_id
4371: , last_update_date = stu_rec.last_update_date
4372: , last_updated_by = stu_rec.last_updated_by
4373: , last_update_login = stu_rec.last_update_login

Line 4381: insert into pay_user_columns

4377:
4378: IF NOT SQL%FOUND THEN
4379:
4380: BEGIN
4381: insert into pay_user_columns
4382: (user_column_id
4383: ,business_group_id
4384: ,legislation_code
4385: ,user_table_id

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

4407: ,stu_rec.creation_date
4408: );
4409: EXCEPTION WHEN OTHERS THEN
4410: hr_legislation.hrrunprc_trace_on;
4411: hr_utility.trace('ins pay_user_columns');
4412: hr_utility.trace('user_column_id ' ||
4413: to_char(stu_rec.c_surrogate_key));
4414: hr_utility.trace('user_column_name ' ||
4415: stu_rec.c_true_key);