eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 605: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_STATUS_TYPES

601: END create_zz_leg_rule;
602:
603:
604: --****************************************************************************
605: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_STATUS_TYPES
606: --****************************************************************************
607:
608: PROCEDURE install_past (p_phase IN number)
609: ------------------------------------------

Line 638: -- PER_ASSIGNMENT_STATUS_TYPES

634: PROCEDURE crt_exc (exception_type IN varchar2)
635: ----------------------------------------------
636: IS
637: -- Reports any exceptions during the delivery of startup data to
638: -- PER_ASSIGNMENT_STATUS_TYPES
639:
640: BEGIN
641: -- When the installation procedures encounter an error that cannot
642: -- be handled, an exception is raised and all work is rolled back

Line 648: insert_hr_stu_exceptions('per_assignment_status_types'

644: -- with the next primary key to install. The same exception will
645: -- not be raised more than once.
646:
647: rollback to new_primary_key;
648: insert_hr_stu_exceptions('per_assignment_status_types'
649: , stu_rec.c_surrogate_key
650: , exception_type
651: , 'User: ' || stu_rec.user_status ||
652: ' PER: ' || stu_rec.per_system_status ||

Line 698: from per_assignment_status_types a

694: If cnt=0 then return; end if;
695:
696: select distinct null
697: into l_null_return
698: from per_assignment_status_types a
699: where exists
700: (select null
701: from hr_s_assignment_status_types b
702: where a.assignment_status_type_id=b.assignment_status_type_id

Line 730: from per_assignment_status_types;

726: from hr_s_assignment_status_types;
727:
728: select max(assignment_status_type_id)
729: into v_max_live
730: from per_assignment_status_types;
731:
732: select per_assignment_status_types_s.nextval
733: into v_sequence_number
734: from dual;

Line 732: select per_assignment_status_types_s.nextval

728: select max(assignment_status_type_id)
729: into v_max_live
730: from per_assignment_status_types;
731:
732: select per_assignment_status_types_s.nextval
733: into v_sequence_number
734: from dual;
735:
736: -- bug 603778

Line 738: -- per_assignment_status_types. We are delivering one

734: from dual;
735:
736: -- bug 603778
737: -- There is a problem with delivery mechanism for
738: -- per_assignment_status_types. We are delivering one
739: -- legislative row for R11 with an assignment_status_type_id of
740: -- 50002. Existing code appears to assume that a row will be delivered
741: -- with an id of 1. This workaround will bump up the sequence
742: -- past 50002 so that the p.a.s.t. constraint will not be

Line 754: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

750: OR (v_sequence_number < v_max_live) THEN
751:
752: IF v_max_live > v_max_delivered THEN
753:
754: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
755: v_sequence_number,
756: v_max_live);
757: ELSE
758:

Line 759: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

755: v_sequence_number,
756: v_max_live);
757: ELSE
758:
759: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
760: v_sequence_number,
761: v_max_delivered);
762: END IF;
763: END IF;

Line 777: from per_assignment_status_types

773:
774: BEGIN
775: select distinct assignment_status_type_id
776: into l_new_surrogate_key
777: from per_assignment_status_types
778: where user_status = stu_rec.user_status
779: and per_system_status = stu_rec.per_system_status
780: and business_group_id is null
781: and ( (pay_system_status is null and stu_rec.pay_system_status is null)

Line 788: select per_assignment_status_types_s.nextval

784: or (legislation_code = stu_rec.c_leg_code) );
785:
786: EXCEPTION WHEN NO_DATA_FOUND THEN
787:
788: select per_assignment_status_types_s.nextval
789: into l_new_surrogate_key
790: from dual;
791: WHEN TOO_MANY_ROWS THEN
792: hrrunprc_trace_on;

Line 793: hr_utility.trace('sel per_assignment_status_types TMR');

789: into l_new_surrogate_key
790: from dual;
791: WHEN TOO_MANY_ROWS THEN
792: hrrunprc_trace_on;
793: hr_utility.trace('sel per_assignment_status_types TMR');
794:
795: hr_utility.trace('user_status ' ||
796: stu_rec.user_status);
797: hr_utility.trace('per_system_status ' ||

Line 835: delete from per_assignment_status_types

831: delete from hr_s_assignment_status_types
832: where rowid = stu_rec.rowid;
833: ELSE
834: IF p_phase = 1 THEN return; END IF;
835: delete from per_assignment_status_types
836: where rowid = l_inst_rowid;
837: END IF;
838:
839: END remove;

Line 925: from per_assignment_status_types

921:
922:
923: select distinct 1
924: into l_inst_row
925: from per_assignment_status_types
926: where user_status = stu_rec.user_status
927: and per_system_status = stu_Rec.per_system_status
928: and business_group_id is null
929: and ( (pay_system_status is null and stu_rec.pay_system_status is null)

Line 951: from per_assignment_status_types a

947: from dual
948: where exists (
949:
950: select null
951: from per_assignment_status_types a
952: , per_business_groups b
953: where a.default_flag = 'Y'
954: and a.per_system_status = stu_rec.per_system_status
955: and ( (a.business_group_id is not null

Line 1001: insert into per_assignment_status_types

997: -- transfered row from the delivery tables.
998:
999: IF l_inst_row is null THEN
1000:
1001: insert into per_assignment_status_types
1002: (ASSIGNMENT_STATUS_TYPE_ID
1003: ,BUSINESS_GROUP_ID
1004: ,LEGISLATION_CODE
1005: ,ACTIVE_FLAG

Line 1740: -- PER_ASSIGNMENT_STATUS_TYPES. See crt_exc in procedure install_past

1736: PROCEDURE crt_exc (exception_type IN varchar2)
1737: ----------------------------------------------
1738: IS
1739: -- Reports any exceptions during the delivery of startup data to
1740: -- PER_ASSIGNMENT_STATUS_TYPES. See crt_exc in procedure install_past
1741: -- for further, generic operational details.
1742:
1743: BEGIN
1744:

Line 5829: -- PER_ASSIGNMENT_STATUS_TYPES. See crt_exc in procedure install_past

5825: PROCEDURE crt_exc (exception_type IN varchar2)
5826: ----------------------------------------------
5827: IS
5828: -- Reports any exceptions during the delivery of startup data to
5829: -- PER_ASSIGNMENT_STATUS_TYPES. See crt_exc in procedure install_past
5830: -- for further, generic operational details.
5831:
5832: BEGIN
5833:

Line 6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL

6620: -- PAY_ELEMENT_CLASSIFICATIONS_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:

Line 7270: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.

7266:
7267: PROCEDURE install_pastt
7268: ----------------------
7269: IS
7270: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.
7271:
7272: CURSOR c_input_values IS
7273: select
7274: M.ASSIGNMENT_STATUS_TYPE_ID,

Line 7283: from PER_ASSIGNMENT_STATUS_TYPES M,

7279: M.LAST_UPDATED_BY,
7280: M.LAST_UPDATE_LOGIN,
7281: M.CREATED_BY,
7282: M.CREATION_DATE
7283: from PER_ASSIGNMENT_STATUS_TYPES M,
7284: FND_LANGUAGES L,
7285: FND_LANGUAGES B
7286: where L.INSTALLED_FLAG in ('I', 'B')
7287: and B.INSTALLED_FLAG = 'B'

Line 7291: from per_assignment_status_types_tl past

7287: and B.INSTALLED_FLAG = 'B'
7288: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7289: and not exists (
7290: select '1'
7291: from per_assignment_status_types_tl past
7292: where past.assignment_status_type_id =
7293: m.assignment_status_type_id
7294: and past.language = l.language_code);
7295:

Line 7305: insert into PER_ASSIGNMENT_STATUS_TYPES_TL

7301: FOR l_rec IN c_input_values LOOP
7302:
7303: -- Insert all selected rows into the TL table.
7304: -- If the row exist in the TL table then it will be ignored.
7305: insert into PER_ASSIGNMENT_STATUS_TYPES_TL
7306: (
7307: ASSIGNMENT_STATUS_TYPE_ID,
7308: LANGUAGE,
7309: SOURCE_LANG,

Line 7330: from per_assignment_status_types_tl past

7326: l_rec.CREATION_DATE
7327: from dual
7328: where not exists (
7329: select '1'
7330: from per_assignment_status_types_tl past
7331: where past.assignment_status_type_id =
7332: l_rec.assignment_status_type_id
7333: and past.language = l_rec.trans_lang);
7334: