APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_INFO_TYPES

Line 3634: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_INFO_TYPES

3630:
3631: END install_org_info;
3632:
3633: --****************************************************************************
3634: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_INFO_TYPES
3635: --****************************************************************************
3636:
3637: PROCEDURE install_ass_info (p_phase IN number)
3638: ----------------------------------------------

Line 3670: -- PER_ASSIGNMENT_INFO_TYPES.

3666: PROCEDURE crt_exc (exception_type IN varchar2)
3667: ----------------------------------------------
3668: IS
3669: -- Reports any exceptions during the delivery of startup data to
3670: -- PER_ASSIGNMENT_INFO_TYPES.
3671:
3672: BEGIN
3673:
3674: -- When the installation procedures encounter an error that cannot

Line 3682: insert_hr_stu_exceptions('per_assignment_info_types'

3678: -- not be raised more than once.
3679:
3680: rollback to new_information_type;
3681:
3682: insert_hr_stu_exceptions('per_assignment_info_types'
3683: , 0
3684: , exception_type
3685: , stu_rec.c_true_key);
3686:

Line 3719: from per_assignment_info_types

3715:
3716: BEGIN
3717: select distinct null
3718: into l_null_return
3719: from per_assignment_info_types
3720: where information_type = stu_rec.c_true_key
3721: and nvl(legislation_code,'X') <> nvl(stu_rec.c_leg_code,'X')
3722: and (legislation_code is null or stu_rec.c_leg_code is null);
3723:

Line 3740: from per_assignment_info_types

3736:
3737: BEGIN
3738: select distinct null
3739: into l_null_return
3740: from per_assignment_info_types
3741: where legislation_code = stu_rec.c_leg_code
3742: and information_type = stu_rec.c_true_key;
3743:
3744: remove; -- The row exists

Line 3755: insert into per_assignment_info_types

3751:
3752:
3753: --+++ Has occurences below meant to have 2 rs ?
3754: BEGIN
3755: insert into per_assignment_info_types
3756: (information_type
3757: ,active_inactive_flag
3758: ,description
3759: ,legislation_code

Line 6625: -- PER_ASSIGNMENT_INFO_TYPES_TL

6621: -- PAY_ELEMENT_TYPES_F_TL
6622: -- PAY_INPUT_VALUES_F_TL
6623: -- PAY_PAYMENT_TYPES_TL
6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6625: -- PER_ASSIGNMENT_INFO_TYPES_TL
6626: -- PAY_MONETARY_UNITS_TL
6627: -- PAY_BALANCE_CATEGORIES_F_TL
6628:
6629:

Line 7181: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.

7177:
7178: PROCEDURE install_paitt
7179: ----------------------
7180: IS
7181: -- Seeds the PER_ASSIGNMENT_INFO_TYPES_TL table.
7182:
7183: CURSOR c_input_values IS
7184: select
7185: M.INFORMATION_TYPE,

Line 7194: from PER_ASSIGNMENT_INFO_TYPES M,

7190: M.LAST_UPDATED_BY,
7191: M.LAST_UPDATE_LOGIN,
7192: M.CREATED_BY,
7193: M.CREATION_DATE
7194: from PER_ASSIGNMENT_INFO_TYPES M,
7195: FND_LANGUAGES L,
7196: FND_LANGUAGES B
7197: where L.INSTALLED_FLAG in ('I', 'B')
7198: and B.INSTALLED_FLAG = 'B'

Line 7200: from per_assignment_info_types_tl pait

7196: FND_LANGUAGES B
7197: where L.INSTALLED_FLAG in ('I', 'B')
7198: and B.INSTALLED_FLAG = 'B'
7199: and not exists ( select '1'
7200: from per_assignment_info_types_tl pait
7201: where pait.information_type = m.information_type
7202: and pait.language = l.language_code);
7203:
7204: l_counter NUMBER(3) := 0;

Line 7213: insert into PER_ASSIGNMENT_INFO_TYPES_TL

7209: FOR l_rec IN c_input_values LOOP
7210:
7211: -- Insert all selected rows into the TL table.
7212: -- If the row exist in the TL table then it will be ignored.
7213: insert into PER_ASSIGNMENT_INFO_TYPES_TL
7214: (
7215: INFORMATION_TYPE,
7216: LANGUAGE,
7217: SOURCE_LANG,

Line 7237: from per_assignment_info_types_tl pait

7233: l_rec.CREATED_BY,
7234: l_rec.CREATION_DATE
7235: from dual
7236: where not exists ( select '1'
7237: from per_assignment_info_types_tl pait
7238: where pait.information_type =
7239: l_rec.information_type
7240: and pait.language = l_rec.trans_lang);
7241: