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.PER_QH_MAINTAIN_QUERY dependencies on HR_REPORTS

Line 549: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);

545: out_rec.start_date :=per_rec.start_date;
546: out_rec.applicant_number :=per_rec.applicant_number;
547: out_rec.background_check_status :=per_rec.background_check_status;
548: out_rec.background_date_check :=per_rec.background_date_check;
549: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);
550: out_rec.blood_type :=per_rec.blood_type;
551: --
552: hr_utility.set_location(l_proc, 50);
553: --

Line 584: out_rec.expnse_chk_send_addr_meaning :=hr_reports.get_lookup_meaning('HOME_OFFICE',per_rec.expense_check_send_to_address);

580: out_rec.date_of_birth :=per_rec.date_of_birth;
581: out_rec.age:=floor(months_between(p_effective_date,per_rec.date_of_birth)/12);
582: out_rec.email_address :=per_rec.email_address;
583: out_rec.employee_number :=per_rec.employee_number;
584: out_rec.expnse_chk_send_addr_meaning :=hr_reports.get_lookup_meaning('HOME_OFFICE',per_rec.expense_check_send_to_address);
585: out_rec.expnse_check_send_to_address :=per_rec.expense_check_send_to_address;
586: out_rec.first_name :=per_rec.first_name;
587: out_rec.per_fte_capacity :=per_rec.fte_capacity;
588: --

Line 599: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);

595: out_rec.known_as :=per_rec.known_as;
596: out_rec.last_medical_test_by :=per_rec.last_medical_test_by;
597: out_rec.last_medical_test_date :=per_rec.last_medical_test_date;
598: out_rec.mailstop :=per_rec.mailstop;
599: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
600: out_rec.marital_status :=per_rec.marital_status;
601: out_rec.middle_names :=per_rec.middle_names;
602: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
603: out_rec.nationality :=per_rec.nationality;

Line 602: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);

598: out_rec.mailstop :=per_rec.mailstop;
599: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
600: out_rec.marital_status :=per_rec.marital_status;
601: out_rec.middle_names :=per_rec.middle_names;
602: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
603: out_rec.nationality :=per_rec.nationality;
604: out_rec.national_identifier :=per_rec.national_identifier;
605: out_rec.office_number :=per_rec.office_number;
606: out_rec.on_military_service :=per_rec.on_military_service;

Line 617: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);

613: out_rec.rehire_reason :=per_rec.rehire_reason;
614: out_rec.resume_exists :=per_rec.resume_exists;
615: out_rec.resume_last_updated :=per_rec.resume_last_updated;
616: -- Bug 3037019
617: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
618: out_rec.registered_disabled :=per_rec.registered_disabled_flag;
619: out_rec.second_passport_exists :=per_rec.second_passport_exists;
620: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
621: out_rec.sex :=per_rec.sex;

Line 620: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);

616: -- Bug 3037019
617: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
618: out_rec.registered_disabled :=per_rec.registered_disabled_flag;
619: out_rec.second_passport_exists :=per_rec.second_passport_exists;
620: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
621: out_rec.sex :=per_rec.sex;
622: --
623: hr_utility.set_location(l_proc, 90);
624: --

Line 625: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);

621: out_rec.sex :=per_rec.sex;
622: --
623: hr_utility.set_location(l_proc, 90);
624: --
625: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
626: out_rec.student_status :=per_rec.student_status;
627: out_rec.suffix :=per_rec.suffix;
628: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
629: out_rec.title :=per_rec.title;

Line 628: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);

624: --
625: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
626: out_rec.student_status :=per_rec.student_status;
627: out_rec.suffix :=per_rec.suffix;
628: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
629: out_rec.title :=per_rec.title;
630: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
631: out_rec.work_schedule :=per_rec.work_schedule;
632: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;

Line 630: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);

626: out_rec.student_status :=per_rec.student_status;
627: out_rec.suffix :=per_rec.suffix;
628: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
629: out_rec.title :=per_rec.title;
630: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
631: out_rec.work_schedule :=per_rec.work_schedule;
632: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
633: out_rec.coord_ben_no_cvg_flag :=per_rec.coord_ben_no_cvg_flag;
634: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;

Line 724: hr_reports.get_lookup_meaning(l_rule_type,per_rec.town_of_birth);

720: out_rec.town_of_birth_meaning:=per_rec.town_of_birth;
721: else
722: close leg_lookup;
723: out_rec.town_of_birth_meaning:=
724: hr_reports.get_lookup_meaning(l_rule_type,per_rec.town_of_birth);
725: end if;
726: --
727: out_rec.region_of_birth :=per_rec.region_of_birth;
728: open leg_lookup('REGION_OF_BIRTH');

Line 736: hr_reports.get_lookup_meaning(l_rule_type,per_rec.region_of_birth);

732: out_rec.region_of_birth_meaning:=per_rec.region_of_birth;
733: else
734: close leg_lookup;
735: out_rec.region_of_birth_meaning:=
736: hr_reports.get_lookup_meaning(l_rule_type,per_rec.region_of_birth);
737: end if;
738: --
739: out_rec.country_of_birth :=per_rec.country_of_birth;
740: --

Line 787: out_rec.termination_reason_meaning :=hr_reports.get_lookup_meaning('TERM_APL_REASON',app_rec.termination_reason);

783: out_rec.appl_attribute20 :=app_rec.appl_attribute20;
784: out_rec.current_employer :=app_rec.current_employer;
785: out_rec.successful_flag :=app_rec.successful_flag;
786: out_rec.termination_reason :=app_rec.termination_reason;
787: out_rec.termination_reason_meaning :=hr_reports.get_lookup_meaning('TERM_APL_REASON',app_rec.termination_reason);
788: out_rec.app_date_received :=app_rec.date_received;
789: out_rec.app_date_end :=app_rec.date_end;
790: out_rec.app_object_version_number :=app_rec.object_version_number;
791: end if;

Line 865: out_rec.address_type_meaning :=hr_reports.get_lookup_meaning('ADDRESS_TYPE',addr_rec.address_type);

861: out_rec.style :=addr_rec.style;
862: out_rec.address_line1 :=addr_rec.address_line1;
863: out_rec.address_line2 :=addr_rec.address_line2;
864: out_rec.address_line3 :=addr_rec.address_line3;
865: out_rec.address_type_meaning :=hr_reports.get_lookup_meaning('ADDRESS_TYPE',addr_rec.address_type);
866: out_rec.address_type :=addr_rec.address_type;
867: out_rec.country :=addr_rec.country;
868: out_rec.adr_date_to :=addr_rec.date_to;
869: out_rec.postal_code :=addr_rec.postal_code;

Line 1052: out_rec.dpf_work_duration_meaning :=hr_reports.get_lookup_meaning('PER_TIME_SCALES',dpf_rec.work_duration);

1048: out_rec.country3 :=dpf_rec.country3;
1049: --
1050: hr_utility.set_location(l_proc, 410);
1051: --
1052: out_rec.dpf_work_duration_meaning :=hr_reports.get_lookup_meaning('PER_TIME_SCALES',dpf_rec.work_duration);
1053: out_rec.dpf_work_duration :=dpf_rec.work_duration;
1054: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1055: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1056: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);

Line 1054: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);

1050: hr_utility.set_location(l_proc, 410);
1051: --
1052: out_rec.dpf_work_duration_meaning :=hr_reports.get_lookup_meaning('PER_TIME_SCALES',dpf_rec.work_duration);
1053: out_rec.dpf_work_duration :=dpf_rec.work_duration;
1054: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1055: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1056: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);
1057: out_rec.dpf_work_hours :=dpf_rec.work_hours;
1058: out_rec.dpf_fte_capacity_meaning :=hr_reports.get_lookup_meaning('PER_FTE_CAPACITY',dpf_rec.fte_capacity);

Line 1056: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);

1052: out_rec.dpf_work_duration_meaning :=hr_reports.get_lookup_meaning('PER_TIME_SCALES',dpf_rec.work_duration);
1053: out_rec.dpf_work_duration :=dpf_rec.work_duration;
1054: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1055: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1056: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);
1057: out_rec.dpf_work_hours :=dpf_rec.work_hours;
1058: out_rec.dpf_fte_capacity_meaning :=hr_reports.get_lookup_meaning('PER_FTE_CAPACITY',dpf_rec.fte_capacity);
1059: out_rec.dpf_fte_capacity :=dpf_rec.fte_capacity;
1060: out_rec.visit_internationally :=dpf_rec.visit_internationally;

Line 1058: out_rec.dpf_fte_capacity_meaning :=hr_reports.get_lookup_meaning('PER_FTE_CAPACITY',dpf_rec.fte_capacity);

1054: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1055: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1056: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);
1057: out_rec.dpf_work_hours :=dpf_rec.work_hours;
1058: out_rec.dpf_fte_capacity_meaning :=hr_reports.get_lookup_meaning('PER_FTE_CAPACITY',dpf_rec.fte_capacity);
1059: out_rec.dpf_fte_capacity :=dpf_rec.fte_capacity;
1060: out_rec.visit_internationally :=dpf_rec.visit_internationally;
1061: out_rec.only_current_location :=dpf_rec.only_current_location;
1062: --

Line 1100: out_rec.relocation_pref_meaning :=hr_reports.get_lookup_meaning('PER_RELOCATION_PREFERENCES',dpf_rec.relocation_preference);

1096: hr_utility.set_location(l_proc, 460);
1097: --
1098: out_rec.earliest_available_date :=dpf_rec.earliest_available_date;
1099: out_rec.available_for_transfer :=dpf_rec.available_for_transfer;
1100: out_rec.relocation_pref_meaning :=hr_reports.get_lookup_meaning('PER_RELOCATION_PREFERENCES',dpf_rec.relocation_preference);
1101: out_rec.relocation_preference :=dpf_rec.relocation_preference;
1102: out_rec.dpf_object_version_number :=dpf_rec.object_version_number;
1103: out_rec.dpf_attribute_category :=dpf_rec.attribute_category;
1104: out_rec.dpf_attribute1 :=dpf_rec.attribute1;

Line 1177: out_rec.chk1_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1173: close csr_checklist;
1174: out_rec.chk1_checklist_item_id :=chk_rec.checklist_item_id;
1175: out_rec.chk1_date_due :=chk_rec.date_due;
1176: out_rec.chk1_date_done :=chk_rec.date_done;
1177: out_rec.chk1_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1178: out_rec.chk1_status :=chk_rec.status;
1179: out_rec.chk1_notes :=chk_rec.notes;
1180: out_rec.chk1_object_version_number :=chk_rec.object_version_number;
1181: --

Line 1239: out_rec.chk2_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1235: close csr_checklist;
1236: out_rec.chk2_checklist_item_id :=chk_rec.checklist_item_id;
1237: out_rec.chk2_date_due :=chk_rec.date_due;
1238: out_rec.chk2_date_done :=chk_rec.date_done;
1239: out_rec.chk2_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1240: out_rec.chk2_status :=chk_rec.status;
1241: out_rec.chk2_notes :=chk_rec.notes;
1242: out_rec.chk2_object_version_number :=chk_rec.object_version_number;
1243: --

Line 1302: out_rec.chk3_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1298: close csr_checklist;
1299: out_rec.chk3_checklist_item_id :=chk_rec.checklist_item_id;
1300: out_rec.chk3_date_due :=chk_rec.date_due;
1301: out_rec.chk3_date_done :=chk_rec.date_done;
1302: out_rec.chk3_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1303: out_rec.chk3_status :=chk_rec.status;
1304: out_rec.chk3_notes :=chk_rec.notes;
1305: out_rec.chk3_object_version_number :=chk_rec.object_version_number;
1306: --

Line 1365: out_rec.chk4_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1361: close csr_checklist;
1362: out_rec.chk4_checklist_item_id :=chk_rec.checklist_item_id;
1363: out_rec.chk4_date_due :=chk_rec.date_due;
1364: out_rec.chk4_date_done :=chk_rec.date_done;
1365: out_rec.chk4_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1366: out_rec.chk4_status :=chk_rec.status;
1367: out_rec.chk4_notes :=chk_rec.notes;
1368: out_rec.chk4_object_version_number :=chk_rec.object_version_number;
1369: --

Line 1428: out_rec.chk5_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1424: close csr_checklist;
1425: out_rec.chk5_checklist_item_id :=chk_rec.checklist_item_id;
1426: out_rec.chk5_date_due :=chk_rec.date_due;
1427: out_rec.chk5_date_done :=chk_rec.date_done;
1428: out_rec.chk5_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1429: out_rec.chk5_status :=chk_rec.status;
1430: out_rec.chk5_notes :=chk_rec.notes;
1431: out_rec.chk5_object_version_number :=chk_rec.object_version_number;
1432: --

Line 1491: out_rec.chk6_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1487: close csr_checklist;
1488: out_rec.chk6_checklist_item_id :=chk_rec.checklist_item_id;
1489: out_rec.chk6_date_due :=chk_rec.date_due;
1490: out_rec.chk6_date_done :=chk_rec.date_done;
1491: out_rec.chk6_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1492: out_rec.chk6_status :=chk_rec.status;
1493: out_rec.chk6_notes :=chk_rec.notes;
1494: out_rec.chk6_object_version_number :=chk_rec.object_version_number;
1495: --

Line 1554: out_rec.chk7_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1550: close csr_checklist;
1551: out_rec.chk7_checklist_item_id :=chk_rec.checklist_item_id;
1552: out_rec.chk7_date_due :=chk_rec.date_due;
1553: out_rec.chk7_date_done :=chk_rec.date_done;
1554: out_rec.chk7_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1555: out_rec.chk7_status :=chk_rec.status;
1556: out_rec.chk7_notes :=chk_rec.notes;
1557: out_rec.chk7_object_version_number :=chk_rec.object_version_number;
1558: --

Line 1617: out_rec.chk8_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1613: close csr_checklist;
1614: out_rec.chk8_checklist_item_id :=chk_rec.checklist_item_id;
1615: out_rec.chk8_date_due :=chk_rec.date_due;
1616: out_rec.chk8_date_done :=chk_rec.date_done;
1617: out_rec.chk8_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1618: out_rec.chk8_status :=chk_rec.status;
1619: out_rec.chk8_notes :=chk_rec.notes;
1620: out_rec.chk8_object_version_number :=chk_rec.object_version_number;
1621: --

Line 1680: out_rec.chk9_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1676: close csr_checklist;
1677: out_rec.chk9_checklist_item_id :=chk_rec.checklist_item_id;
1678: out_rec.chk9_date_due :=chk_rec.date_due;
1679: out_rec.chk9_date_done :=chk_rec.date_done;
1680: out_rec.chk9_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1681: out_rec.chk9_status :=chk_rec.status;
1682: out_rec.chk9_notes :=chk_rec.notes;
1683: out_rec.chk9_object_version_number :=chk_rec.object_version_number;
1684: --

Line 1743: out_rec.chk10_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);

1739: close csr_checklist;
1740: out_rec.chk10_checklist_item_id :=chk_rec.checklist_item_id;
1741: out_rec.chk10_date_due :=chk_rec.date_due;
1742: out_rec.chk10_date_done :=chk_rec.date_done;
1743: out_rec.chk10_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1744: out_rec.chk10_status :=chk_rec.status;
1745: out_rec.chk10_notes :=chk_rec.notes;
1746: out_rec.chk10_object_version_number :=chk_rec.object_version_number;
1747: --

Line 2015: out_rec.pay_basis_meaning :=hr_reports.get_lookup_meaning('PAY_BASIS',out_rec.pay_basis);

2011: per_pay_proposals_populate.get_number_format(out_rec.salary_format);
2012: end if;
2013: end if;
2014: out_rec.pay_basis_id :=asg_rec.pay_basis_id;
2015: out_rec.pay_basis_meaning :=hr_reports.get_lookup_meaning('PAY_BASIS',out_rec.pay_basis);
2016: --
2017: hr_utility.set_location(l_proc,900);
2018: --
2019: out_rec.assignment_sequence :=asg_rec.assignment_sequence;

Line 2028: :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);

2024: out_rec.default_code_comb_id :=asg_rec.default_code_comb_id;
2025: --
2026: if asg_rec.assignment_type in ('E','A') then -- fix for the bug 8727447
2027: out_rec.employment_category_meaning
2028: :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
2029: elsif asg_rec.assignment_type = 'C' then
2030: out_rec.employment_category_meaning
2031: := hr_reports.get_lookup_meaning('CWK_ASG_CATEGORY',asg_rec.employment_category);
2032: end if;

Line 2031: := hr_reports.get_lookup_meaning('CWK_ASG_CATEGORY',asg_rec.employment_category);

2027: out_rec.employment_category_meaning
2028: :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
2029: elsif asg_rec.assignment_type = 'C' then
2030: out_rec.employment_category_meaning
2031: := hr_reports.get_lookup_meaning('CWK_ASG_CATEGORY',asg_rec.employment_category);
2032: end if;
2033: --
2034: out_rec.employment_category :=asg_rec.employment_category;
2035: out_rec.employee_category_meaning :=hr_reports.get_lookup_meaning('EMPLOYEE_CATG',asg_rec.employee_category);

Line 2035: out_rec.employee_category_meaning :=hr_reports.get_lookup_meaning('EMPLOYEE_CATG',asg_rec.employee_category);

2031: := hr_reports.get_lookup_meaning('CWK_ASG_CATEGORY',asg_rec.employment_category);
2032: end if;
2033: --
2034: out_rec.employment_category :=asg_rec.employment_category;
2035: out_rec.employee_category_meaning :=hr_reports.get_lookup_meaning('EMPLOYEE_CATG',asg_rec.employee_category);
2036: out_rec.employee_category :=asg_rec.employee_category;
2037: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
2038: out_rec.frequency :=asg_rec.frequency;
2039: out_rec.normal_hours :=asg_rec.normal_hours;

Line 2037: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);

2033: --
2034: out_rec.employment_category :=asg_rec.employment_category;
2035: out_rec.employee_category_meaning :=hr_reports.get_lookup_meaning('EMPLOYEE_CATG',asg_rec.employee_category);
2036: out_rec.employee_category :=asg_rec.employee_category;
2037: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
2038: out_rec.frequency :=asg_rec.frequency;
2039: out_rec.normal_hours :=asg_rec.normal_hours;
2040: out_rec.probation_period :=asg_rec.probation_period;
2041: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);

Line 2041: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);

2037: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
2038: out_rec.frequency :=asg_rec.frequency;
2039: out_rec.normal_hours :=asg_rec.normal_hours;
2040: out_rec.probation_period :=asg_rec.probation_period;
2041: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
2042: out_rec.probation_unit :=asg_rec.probation_unit;
2043: out_rec.notice_period :=asg_rec.notice_period;
2044: out_rec.notice_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.notice_period_uom);
2045: out_rec.notice_unit :=asg_rec.notice_period_uom;

Line 2044: out_rec.notice_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.notice_period_uom);

2040: out_rec.probation_period :=asg_rec.probation_period;
2041: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
2042: out_rec.probation_unit :=asg_rec.probation_unit;
2043: out_rec.notice_period :=asg_rec.notice_period;
2044: out_rec.notice_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.notice_period_uom);
2045: out_rec.notice_unit :=asg_rec.notice_period_uom;
2046: out_rec.set_of_books_id :=asg_rec.set_of_books_id;
2047: if asg_rec.set_of_books_id is not null then
2048: open csr_sob(asg_rec.set_of_books_id);

Line 2193: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);

2189: out_rec.ass_attribute28 :=asg_rec.ass_attribute28;
2190: out_rec.ass_attribute29 :=asg_rec.ass_attribute29;
2191: out_rec.ass_attribute30 :=asg_rec.ass_attribute30;
2192: out_rec.asg_object_version_number :=asg_rec.object_version_number;
2193: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
2194: out_rec.bargaining_unit_code :=asg_rec.bargaining_unit_code;
2195: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
2196: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
2197: out_rec.hourly_salaried_code :=asg_rec.hourly_salaried_code;

Line 2196: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);

2192: out_rec.asg_object_version_number :=asg_rec.object_version_number;
2193: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
2194: out_rec.bargaining_unit_code :=asg_rec.bargaining_unit_code;
2195: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
2196: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
2197: out_rec.hourly_salaried_code :=asg_rec.hourly_salaried_code;
2198: --
2199: hr_utility.set_location(l_proc,920);
2200: --

Line 2213: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('EMP_ASSIGN_REASON',asg_rec.change_reason);

2209: --
2210: -- Bug# 4153433 Start Here
2211: --
2212: if asg_rec.assignment_type = 'E' then
2213: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('EMP_ASSIGN_REASON',asg_rec.change_reason);
2214: elsif asg_rec.assignment_type = 'A' then
2215: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
2216: elsif asg_rec.assignment_type = 'C' then
2217: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('CWK_ASSIGN_REASON',asg_rec.change_reason);

Line 2215: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);

2211: --
2212: if asg_rec.assignment_type = 'E' then
2213: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('EMP_ASSIGN_REASON',asg_rec.change_reason);
2214: elsif asg_rec.assignment_type = 'A' then
2215: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
2216: elsif asg_rec.assignment_type = 'C' then
2217: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('CWK_ASSIGN_REASON',asg_rec.change_reason);
2218: end if;
2219: --

Line 2217: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('CWK_ASSIGN_REASON',asg_rec.change_reason);

2213: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('EMP_ASSIGN_REASON',asg_rec.change_reason);
2214: elsif asg_rec.assignment_type = 'A' then
2215: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
2216: elsif asg_rec.assignment_type = 'C' then
2217: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('CWK_ASSIGN_REASON',asg_rec.change_reason);
2218: end if;
2219: --
2220: --Bug# 4153433 End here
2221: --

Line 2226: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);

2222: out_rec.change_reason :=asg_rec.change_reason;
2223: out_rec.internal_address_line :=asg_rec.internal_address_line;
2224: out_rec.manager_flag :=asg_rec.manager_flag;
2225: out_rec.perf_review_period :=asg_rec.perf_review_period;
2226: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
2227: out_rec.perf_review_period_frequency :=asg_rec.perf_review_period_frequency;
2228: out_rec.sal_review_period :=asg_rec.sal_review_period;
2229: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
2230: out_rec.sal_review_period_frequency :=asg_rec.sal_review_period_frequency;

Line 2229: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);

2225: out_rec.perf_review_period :=asg_rec.perf_review_period;
2226: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
2227: out_rec.perf_review_period_frequency :=asg_rec.perf_review_period_frequency;
2228: out_rec.sal_review_period :=asg_rec.sal_review_period;
2229: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
2230: out_rec.sal_review_period_frequency :=asg_rec.sal_review_period_frequency;
2231: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
2232: out_rec.source_type :=asg_rec.source_type;
2233: --

Line 2231: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);

2227: out_rec.perf_review_period_frequency :=asg_rec.perf_review_period_frequency;
2228: out_rec.sal_review_period :=asg_rec.sal_review_period;
2229: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
2230: out_rec.sal_review_period_frequency :=asg_rec.sal_review_period_frequency;
2231: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
2232: out_rec.source_type :=asg_rec.source_type;
2233: --
2234: hr_utility.set_location(l_proc,940);
2235: --

Line 2291: hr_reports.get_lookup_meaning('PROPOSAL_REASON',pyp_rec.proposal_reason);

2287: out_rec.change_date :=pyp_rec.change_date;
2288: out_rec.proposed_salary_n :=pyp_rec.proposed_salary_n;
2289: out_rec.proposal_reason :=pyp_rec.proposal_reason;
2290: out_rec.proposal_reason_meaning :=
2291: hr_reports.get_lookup_meaning('PROPOSAL_REASON',pyp_rec.proposal_reason);
2292: out_rec.pyp_attribute_category :=pyp_rec.attribute_category;
2293: out_rec.pyp_attribute1 :=pyp_rec.attribute1;
2294: out_rec.pyp_attribute2 :=pyp_rec.attribute2;
2295: out_rec.pyp_attribute3 :=pyp_rec.attribute3;