APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_INFO_TYPES

Line 3880: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_INFO_TYPES

3876:
3877: END install_org_info;
3878:
3879: --****************************************************************************
3880: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_INFO_TYPES
3881: --****************************************************************************
3882:
3883: PROCEDURE install_ass_info (p_phase IN number)
3884: ----------------------------------------------

Line 3916: -- PER_ASSIGNMENT_INFO_TYPES.

3912: PROCEDURE crt_exc (exception_type IN varchar2)
3913: ----------------------------------------------
3914: IS
3915: -- Reports any exceptions during the delivery of startup data to
3916: -- PER_ASSIGNMENT_INFO_TYPES.
3917:
3918: BEGIN
3919:
3920: -- When the installation procedures encounter an error that cannot

Line 3928: insert_hr_stu_exceptions('per_assignment_info_types'

3924: -- not be raised more than once.
3925:
3926: rollback to new_information_type;
3927:
3928: insert_hr_stu_exceptions('per_assignment_info_types'
3929: , 0
3930: , exception_type
3931: , stu_rec.c_true_key);
3932:

Line 3965: from per_assignment_info_types

3961:
3962: BEGIN
3963: select distinct null
3964: into l_null_return
3965: from per_assignment_info_types
3966: where information_type = stu_rec.c_true_key
3967: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
3968: and (legislation_code is null or stu_rec.c_leg_code is null);
3969:

Line 3986: from per_assignment_info_types

3982:
3983: BEGIN
3984: select distinct null
3985: into l_null_return
3986: from per_assignment_info_types
3987: where legislation_code = stu_rec.c_leg_code
3988: and information_type = stu_rec.c_true_key;
3989:
3990: remove; -- The row exists

Line 4001: insert into per_assignment_info_types

3997:
3998:
3999: --+++ Has occurences below meant to have 2 rs ?
4000: BEGIN
4001: insert into per_assignment_info_types
4002: (information_type
4003: ,active_inactive_flag
4004: ,description
4005: ,legislation_code

Line 6875: -- PER_ASSIGNMENT_INFO_TYPES_TL

6871: -- PAY_ELEMENT_TYPES_F_TL
6872: -- PAY_INPUT_VALUES_F_TL
6873: -- PAY_PAYMENT_TYPES_TL
6874: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6875: -- PER_ASSIGNMENT_INFO_TYPES_TL
6876: -- PAY_MONETARY_UNITS_TL
6877: -- PAY_BALANCE_CATEGORIES_F_TL
6878:
6879:

Line 7431: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.

7427:
7428: PROCEDURE install_paitt
7429: ----------------------
7430: IS
7431: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.
7432:
7433: CURSOR c_input_values IS
7434: select
7435: M.INFORMATION_TYPE,

Line 7444: from PER_ASSIGNMENT_INFO_TYPES M,

7440: M.LAST_UPDATED_BY,
7441: M.LAST_UPDATE_LOGIN,
7442: M.CREATED_BY,
7443: M.CREATION_DATE
7444: from PER_ASSIGNMENT_INFO_TYPES M,
7445: FND_LANGUAGES L,
7446: FND_LANGUAGES B
7447: where L.INSTALLED_FLAG in ('I', 'B')
7448: and B.INSTALLED_FLAG = 'B'

Line 7450: from per_assignment_info_types_tl pait

7446: FND_LANGUAGES B
7447: where L.INSTALLED_FLAG in ('I', 'B')
7448: and B.INSTALLED_FLAG = 'B'
7449: and not exists ( select '1'
7450: from per_assignment_info_types_tl pait
7451: where pait.information_type = m.information_type
7452: and pait.language = l.language_code);
7453:
7454: l_counter NUMBER(3) := 0;

Line 7463: insert into PER_ASSIGNMENT_INFO_TYPES_TL

7459: FOR l_rec IN c_input_values LOOP
7460:
7461: -- Insert all selected rows into the TL table.
7462: -- If the row exist in the TL table then it will be ignored.
7463: insert into PER_ASSIGNMENT_INFO_TYPES_TL
7464: (
7465: INFORMATION_TYPE,
7466: LANGUAGE,
7467: SOURCE_LANG,

Line 7487: from per_assignment_info_types_tl pait

7483: l_rec.CREATED_BY,
7484: l_rec.CREATION_DATE
7485: from dual
7486: where not exists ( select '1'
7487: from per_assignment_info_types_tl pait
7488: where pait.information_type =
7489: l_rec.information_type
7490: and pait.language = l_rec.trans_lang);
7491: