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 655: per_assignment_status_types ast

651: Select 'Y' into v_exists from dual where exists(
652: select null
653: from PAY_STATUS_PROCESSING_RULES_F spr,
654: pay_element_types_f et,
655: per_assignment_status_types ast
656: where spr.business_group_id is null
657: and spr.element_type_id = et.element_type_id
658: and ast.ASSIGNMENT_STATUS_TYPE_ID = spr.ASSIGNMENT_STATUS_TYPE_ID
659: and spr.legislation_code = p_legislation_code

Line 810: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_STATUS_TYPES

806: END create_zz_leg_rule;
807:
808:
809: --****************************************************************************
810: -- INSTALLATION PROCEDURE FOR : PER_ASSIGNMENT_STATUS_TYPES
811: --****************************************************************************
812:
813: PROCEDURE install_past (p_phase IN number)
814: ------------------------------------------

Line 843: -- PER_ASSIGNMENT_STATUS_TYPES

839: PROCEDURE crt_exc (exception_type IN varchar2)
840: ----------------------------------------------
841: IS
842: -- Reports any exceptions during the delivery of startup data to
843: -- PER_ASSIGNMENT_STATUS_TYPES
844:
845: BEGIN
846: -- When the installation procedures encounter an error that cannot
847: -- be handled, an exception is raised and all work is rolled back

Line 853: insert_hr_stu_exceptions('per_assignment_status_types'

849: -- with the next primary key to install. The same exception will
850: -- not be raised more than once.
851:
852: rollback to new_primary_key;
853: insert_hr_stu_exceptions('per_assignment_status_types'
854: , stu_rec.c_surrogate_key
855: , exception_type
856: , 'User: ' || stu_rec.user_status ||
857: ' PER: ' || stu_rec.per_system_status ||

Line 903: from per_assignment_status_types a

899: If cnt=0 then return; end if;
900:
901: select distinct null
902: into l_null_return
903: from per_assignment_status_types a
904: where exists
905: (select null
906: from hr_s_assignment_status_types b
907: where a.assignment_status_type_id=b.assignment_status_type_id

Line 935: from per_assignment_status_types;

931: from hr_s_assignment_status_types;
932:
933: select max(assignment_status_type_id)
934: into v_max_live
935: from per_assignment_status_types;
936:
937: select per_assignment_status_types_s.nextval
938: into v_sequence_number
939: from dual;

Line 937: select per_assignment_status_types_s.nextval

933: select max(assignment_status_type_id)
934: into v_max_live
935: from per_assignment_status_types;
936:
937: select per_assignment_status_types_s.nextval
938: into v_sequence_number
939: from dual;
940:
941: -- bug 603778

Line 943: -- per_assignment_status_types. We are delivering one

939: from dual;
940:
941: -- bug 603778
942: -- There is a problem with delivery mechanism for
943: -- per_assignment_status_types. We are delivering one
944: -- legislative row for R11 with an assignment_status_type_id of
945: -- 50002. Existing code appears to assume that a row will be delivered
946: -- with an id of 1. This workaround will bump up the sequence
947: -- past 50002 so that the p.a.s.t. constraint will not be

Line 959: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

955: OR (v_sequence_number < v_max_live) THEN
956:
957: IF v_max_live > v_max_delivered THEN
958:
959: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
960: v_sequence_number,
961: v_max_live);
962: ELSE
963:

Line 964: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',

960: v_sequence_number,
961: v_max_live);
962: ELSE
963:
964: hr_legislation.munge_sequence('PER_ASSIGNMENT_STATUS_TYPES_S',
965: v_sequence_number,
966: v_max_delivered);
967: END IF;
968: END IF;

Line 982: from per_assignment_status_types

978:
979: BEGIN
980: select distinct assignment_status_type_id
981: into l_new_surrogate_key
982: from per_assignment_status_types
983: where user_status = stu_rec.user_status
984: and per_system_status = stu_rec.per_system_status
985: and business_group_id is null
986: and ( (pay_system_status is null and stu_rec.pay_system_status is null)

Line 993: select per_assignment_status_types_s.nextval

989: or (legislation_code = stu_rec.c_leg_code) );
990:
991: EXCEPTION WHEN NO_DATA_FOUND THEN
992:
993: select per_assignment_status_types_s.nextval
994: into l_new_surrogate_key
995: from dual;
996: WHEN TOO_MANY_ROWS THEN
997: hrrunprc_trace_on;

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

994: into l_new_surrogate_key
995: from dual;
996: WHEN TOO_MANY_ROWS THEN
997: hrrunprc_trace_on;
998: hr_utility.trace('sel per_assignment_status_types TMR');
999:
1000: hr_utility.trace('user_status ' ||
1001: stu_rec.user_status);
1002: hr_utility.trace('per_system_status ' ||

Line 1040: delete from per_assignment_status_types

1036: delete from hr_s_assignment_status_types
1037: where rowid = stu_rec.rowid;
1038: ELSE
1039: IF p_phase = 1 THEN return; END IF;
1040: delete from per_assignment_status_types
1041: where rowid = l_inst_rowid;
1042: END IF;
1043:
1044: END remove;

Line 1130: from per_assignment_status_types

1126:
1127:
1128: select distinct 1
1129: into l_inst_row
1130: from per_assignment_status_types
1131: where user_status = stu_rec.user_status
1132: and per_system_status = stu_Rec.per_system_status
1133: and business_group_id is null
1134: and ( (pay_system_status is null and stu_rec.pay_system_status is null)

Line 1156: from per_assignment_status_types a

1152: from dual
1153: where exists (
1154:
1155: select null
1156: from per_assignment_status_types a
1157: , per_business_groups b
1158: where a.default_flag = 'Y'
1159: and a.per_system_status = stu_rec.per_system_status
1160: and ( (a.business_group_id is not null

Line 1206: insert into per_assignment_status_types

1202: -- transfered row from the delivery tables.
1203:
1204: IF l_inst_row is null THEN
1205:
1206: insert into per_assignment_status_types
1207: (ASSIGNMENT_STATUS_TYPE_ID
1208: ,BUSINESS_GROUP_ID
1209: ,LEGISLATION_CODE
1210: ,ACTIVE_FLAG

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

1941: PROCEDURE crt_exc (exception_type IN varchar2)
1942: ----------------------------------------------
1943: IS
1944: -- Reports any exceptions during the delivery of startup data to
1945: -- PER_ASSIGNMENT_STATUS_TYPES. See crt_exc in procedure install_past
1946: -- for further, generic operational details.
1947:
1948: BEGIN
1949:

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

6075: PROCEDURE crt_exc (exception_type IN varchar2)
6076: ----------------------------------------------
6077: IS
6078: -- Reports any exceptions during the delivery of startup data to
6079: -- PER_ASSIGNMENT_STATUS_TYPES. See crt_exc in procedure install_past
6080: -- for further, generic operational details.
6081:
6082: BEGIN
6083:

Line 6874: -- PER_ASSIGNMENT_STATUS_TYPES_TL

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

Line 7520: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.

7516:
7517: PROCEDURE install_pastt
7518: ----------------------
7519: IS
7520: -- Seeds the PER_ASSIGNMENT_STATUS_TYPES_TL table.
7521:
7522: CURSOR c_input_values IS
7523: select
7524: M.ASSIGNMENT_STATUS_TYPE_ID,

Line 7533: from PER_ASSIGNMENT_STATUS_TYPES M,

7529: M.LAST_UPDATED_BY,
7530: M.LAST_UPDATE_LOGIN,
7531: M.CREATED_BY,
7532: M.CREATION_DATE
7533: from PER_ASSIGNMENT_STATUS_TYPES M,
7534: FND_LANGUAGES L,
7535: FND_LANGUAGES B
7536: where L.INSTALLED_FLAG in ('I', 'B')
7537: and B.INSTALLED_FLAG = 'B'

Line 7541: from per_assignment_status_types_tl past

7537: and B.INSTALLED_FLAG = 'B'
7538: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7539: and not exists (
7540: select '1'
7541: from per_assignment_status_types_tl past
7542: where past.assignment_status_type_id =
7543: m.assignment_status_type_id
7544: and past.language = l.language_code);
7545:

Line 7555: insert into PER_ASSIGNMENT_STATUS_TYPES_TL

7551: FOR l_rec IN c_input_values LOOP
7552:
7553: -- Insert all selected rows into the TL table.
7554: -- If the row exist in the TL table then it will be ignored.
7555: insert into PER_ASSIGNMENT_STATUS_TYPES_TL
7556: (
7557: ASSIGNMENT_STATUS_TYPE_ID,
7558: LANGUAGE,
7559: SOURCE_LANG,

Line 7580: from per_assignment_status_types_tl past

7576: l_rec.CREATION_DATE
7577: from dual
7578: where not exists (
7579: select '1'
7580: from per_assignment_status_types_tl past
7581: where past.assignment_status_type_id =
7582: l_rec.assignment_status_type_id
7583: and past.language = l_rec.trans_lang);
7584: