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 515: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);

511: out_rec.start_date :=per_rec.start_date;
512: out_rec.applicant_number :=per_rec.applicant_number;
513: out_rec.background_check_status :=per_rec.background_check_status;
514: out_rec.background_date_check :=per_rec.background_date_check;
515: out_rec.blood_type_meaning :=hr_reports.get_lookup_meaning('BLOOD_TYPE',per_rec.blood_type);
516: out_rec.blood_type :=per_rec.blood_type;
517: --
518: hr_utility.set_location(l_proc, 50);
519: --

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

546: out_rec.date_of_birth :=per_rec.date_of_birth;
547: out_rec.age:=floor(months_between(p_effective_date,per_rec.date_of_birth)/12);
548: out_rec.email_address :=per_rec.email_address;
549: out_rec.employee_number :=per_rec.employee_number;
550: out_rec.expnse_chk_send_addr_meaning :=hr_reports.get_lookup_meaning('HOME_OFFICE',per_rec.expense_check_send_to_address);
551: out_rec.expnse_check_send_to_address :=per_rec.expense_check_send_to_address;
552: out_rec.first_name :=per_rec.first_name;
553: out_rec.per_fte_capacity :=per_rec.fte_capacity;
554: --

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

561: out_rec.known_as :=per_rec.known_as;
562: out_rec.last_medical_test_by :=per_rec.last_medical_test_by;
563: out_rec.last_medical_test_date :=per_rec.last_medical_test_date;
564: out_rec.mailstop :=per_rec.mailstop;
565: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
566: out_rec.marital_status :=per_rec.marital_status;
567: out_rec.middle_names :=per_rec.middle_names;
568: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
569: out_rec.nationality :=per_rec.nationality;

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

564: out_rec.mailstop :=per_rec.mailstop;
565: out_rec.marital_status_meaning :=hr_reports.get_lookup_meaning('MAR_STATUS',per_rec.marital_status);
566: out_rec.marital_status :=per_rec.marital_status;
567: out_rec.middle_names :=per_rec.middle_names;
568: out_rec.nationality_meaning :=hr_reports.get_lookup_meaning('NATIONALITY',per_rec.nationality);
569: out_rec.nationality :=per_rec.nationality;
570: out_rec.national_identifier :=per_rec.national_identifier;
571: out_rec.office_number :=per_rec.office_number;
572: out_rec.on_military_service :=per_rec.on_military_service;

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

579: out_rec.rehire_reason :=per_rec.rehire_reason;
580: out_rec.resume_exists :=per_rec.resume_exists;
581: out_rec.resume_last_updated :=per_rec.resume_last_updated;
582: -- Bug 3037019
583: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
584: out_rec.registered_disabled :=per_rec.registered_disabled_flag;
585: out_rec.second_passport_exists :=per_rec.second_passport_exists;
586: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
587: out_rec.sex :=per_rec.sex;

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

582: -- Bug 3037019
583: out_rec.registered_disabled_flag :=hr_reports.get_lookup_meaning('REGISTERED_DISABLED',per_rec.registered_disabled_flag);
584: out_rec.registered_disabled :=per_rec.registered_disabled_flag;
585: out_rec.second_passport_exists :=per_rec.second_passport_exists;
586: out_rec.sex_meaning :=hr_reports.get_lookup_meaning('SEX',per_rec.sex);
587: out_rec.sex :=per_rec.sex;
588: --
589: hr_utility.set_location(l_proc, 90);
590: --

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

587: out_rec.sex :=per_rec.sex;
588: --
589: hr_utility.set_location(l_proc, 90);
590: --
591: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
592: out_rec.student_status :=per_rec.student_status;
593: out_rec.suffix :=per_rec.suffix;
594: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
595: out_rec.title :=per_rec.title;

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

590: --
591: out_rec.student_status_meaning :=hr_reports.get_lookup_meaning('STUDENT_STATUS',per_rec.student_status);
592: out_rec.student_status :=per_rec.student_status;
593: out_rec.suffix :=per_rec.suffix;
594: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
595: out_rec.title :=per_rec.title;
596: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
597: out_rec.work_schedule :=per_rec.work_schedule;
598: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;

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

592: out_rec.student_status :=per_rec.student_status;
593: out_rec.suffix :=per_rec.suffix;
594: out_rec.title_meaning :=hr_reports.get_lookup_meaning('TITLE',per_rec.title);
595: out_rec.title :=per_rec.title;
596: out_rec.work_schedule_meaning :=hr_reports.get_lookup_meaning('WORK_SCHEDULE',per_rec.work_schedule);
597: out_rec.work_schedule :=per_rec.work_schedule;
598: out_rec.coord_ben_med_pln_no :=per_rec.coord_ben_med_pln_no;
599: out_rec.coord_ben_no_cvg_flag :=per_rec.coord_ben_no_cvg_flag;
600: out_rec.dpdnt_adoption_date :=per_rec.dpdnt_adoption_date;

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

686: out_rec.town_of_birth_meaning:=per_rec.town_of_birth;
687: else
688: close leg_lookup;
689: out_rec.town_of_birth_meaning:=
690: hr_reports.get_lookup_meaning(l_rule_type,per_rec.town_of_birth);
691: end if;
692: --
693: out_rec.region_of_birth :=per_rec.region_of_birth;
694: open leg_lookup('REGION_OF_BIRTH');

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

698: out_rec.region_of_birth_meaning:=per_rec.region_of_birth;
699: else
700: close leg_lookup;
701: out_rec.region_of_birth_meaning:=
702: hr_reports.get_lookup_meaning(l_rule_type,per_rec.region_of_birth);
703: end if;
704: --
705: out_rec.country_of_birth :=per_rec.country_of_birth;
706: --

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

749: out_rec.appl_attribute20 :=app_rec.appl_attribute20;
750: out_rec.current_employer :=app_rec.current_employer;
751: out_rec.successful_flag :=app_rec.successful_flag;
752: out_rec.termination_reason :=app_rec.termination_reason;
753: out_rec.termination_reason_meaning :=hr_reports.get_lookup_meaning('TERM_APL_REASON',app_rec.termination_reason);
754: out_rec.app_date_received :=app_rec.date_received;
755: out_rec.app_date_end :=app_rec.date_end;
756: out_rec.app_object_version_number :=app_rec.object_version_number;
757: end if;

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

827: out_rec.style :=addr_rec.style;
828: out_rec.address_line1 :=addr_rec.address_line1;
829: out_rec.address_line2 :=addr_rec.address_line2;
830: out_rec.address_line3 :=addr_rec.address_line3;
831: out_rec.address_type_meaning :=hr_reports.get_lookup_meaning('ADDRESS_TYPE',addr_rec.address_type);
832: out_rec.address_type :=addr_rec.address_type;
833: out_rec.country :=addr_rec.country;
834: out_rec.adr_date_to :=addr_rec.date_to;
835: out_rec.postal_code :=addr_rec.postal_code;

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

1014: out_rec.country3 :=dpf_rec.country3;
1015: --
1016: hr_utility.set_location(l_proc, 410);
1017: --
1018: out_rec.dpf_work_duration_meaning :=hr_reports.get_lookup_meaning('PER_TIME_SCALES',dpf_rec.work_duration);
1019: out_rec.dpf_work_duration :=dpf_rec.work_duration;
1020: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1021: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1022: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);

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

1016: hr_utility.set_location(l_proc, 410);
1017: --
1018: out_rec.dpf_work_duration_meaning :=hr_reports.get_lookup_meaning('PER_TIME_SCALES',dpf_rec.work_duration);
1019: out_rec.dpf_work_duration :=dpf_rec.work_duration;
1020: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1021: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1022: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);
1023: out_rec.dpf_work_hours :=dpf_rec.work_hours;
1024: out_rec.dpf_fte_capacity_meaning :=hr_reports.get_lookup_meaning('PER_FTE_CAPACITY',dpf_rec.fte_capacity);

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

1018: out_rec.dpf_work_duration_meaning :=hr_reports.get_lookup_meaning('PER_TIME_SCALES',dpf_rec.work_duration);
1019: out_rec.dpf_work_duration :=dpf_rec.work_duration;
1020: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1021: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1022: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);
1023: out_rec.dpf_work_hours :=dpf_rec.work_hours;
1024: out_rec.dpf_fte_capacity_meaning :=hr_reports.get_lookup_meaning('PER_FTE_CAPACITY',dpf_rec.fte_capacity);
1025: out_rec.dpf_fte_capacity :=dpf_rec.fte_capacity;
1026: out_rec.visit_internationally :=dpf_rec.visit_internationally;

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

1020: out_rec.dpf_work_schedule_meaning :=hr_reports.get_lookup_meaning('PER_WORK_SCHEDULE',dpf_rec.work_schedule);
1021: out_rec.dpf_work_schedule :=dpf_rec.work_schedule;
1022: out_rec.dpf_work_hours_meaning :=hr_reports.get_lookup_meaning('PER_WORK_HOURS',dpf_rec.work_hours);
1023: out_rec.dpf_work_hours :=dpf_rec.work_hours;
1024: out_rec.dpf_fte_capacity_meaning :=hr_reports.get_lookup_meaning('PER_FTE_CAPACITY',dpf_rec.fte_capacity);
1025: out_rec.dpf_fte_capacity :=dpf_rec.fte_capacity;
1026: out_rec.visit_internationally :=dpf_rec.visit_internationally;
1027: out_rec.only_current_location :=dpf_rec.only_current_location;
1028: --

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

1062: hr_utility.set_location(l_proc, 460);
1063: --
1064: out_rec.earliest_available_date :=dpf_rec.earliest_available_date;
1065: out_rec.available_for_transfer :=dpf_rec.available_for_transfer;
1066: out_rec.relocation_pref_meaning :=hr_reports.get_lookup_meaning('PER_RELOCATION_PREFERENCES',dpf_rec.relocation_preference);
1067: out_rec.relocation_preference :=dpf_rec.relocation_preference;
1068: out_rec.dpf_object_version_number :=dpf_rec.object_version_number;
1069: out_rec.dpf_attribute_category :=dpf_rec.attribute_category;
1070: out_rec.dpf_attribute1 :=dpf_rec.attribute1;

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

1139: close csr_checklist;
1140: out_rec.chk1_checklist_item_id :=chk_rec.checklist_item_id;
1141: out_rec.chk1_date_due :=chk_rec.date_due;
1142: out_rec.chk1_date_done :=chk_rec.date_done;
1143: out_rec.chk1_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1144: out_rec.chk1_status :=chk_rec.status;
1145: out_rec.chk1_notes :=chk_rec.notes;
1146: out_rec.chk1_object_version_number :=chk_rec.object_version_number;
1147: --

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

1201: close csr_checklist;
1202: out_rec.chk2_checklist_item_id :=chk_rec.checklist_item_id;
1203: out_rec.chk2_date_due :=chk_rec.date_due;
1204: out_rec.chk2_date_done :=chk_rec.date_done;
1205: out_rec.chk2_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1206: out_rec.chk2_status :=chk_rec.status;
1207: out_rec.chk2_notes :=chk_rec.notes;
1208: out_rec.chk2_object_version_number :=chk_rec.object_version_number;
1209: --

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

1264: close csr_checklist;
1265: out_rec.chk3_checklist_item_id :=chk_rec.checklist_item_id;
1266: out_rec.chk3_date_due :=chk_rec.date_due;
1267: out_rec.chk3_date_done :=chk_rec.date_done;
1268: out_rec.chk3_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1269: out_rec.chk3_status :=chk_rec.status;
1270: out_rec.chk3_notes :=chk_rec.notes;
1271: out_rec.chk3_object_version_number :=chk_rec.object_version_number;
1272: --

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

1327: close csr_checklist;
1328: out_rec.chk4_checklist_item_id :=chk_rec.checklist_item_id;
1329: out_rec.chk4_date_due :=chk_rec.date_due;
1330: out_rec.chk4_date_done :=chk_rec.date_done;
1331: out_rec.chk4_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1332: out_rec.chk4_status :=chk_rec.status;
1333: out_rec.chk4_notes :=chk_rec.notes;
1334: out_rec.chk4_object_version_number :=chk_rec.object_version_number;
1335: --

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

1390: close csr_checklist;
1391: out_rec.chk5_checklist_item_id :=chk_rec.checklist_item_id;
1392: out_rec.chk5_date_due :=chk_rec.date_due;
1393: out_rec.chk5_date_done :=chk_rec.date_done;
1394: out_rec.chk5_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1395: out_rec.chk5_status :=chk_rec.status;
1396: out_rec.chk5_notes :=chk_rec.notes;
1397: out_rec.chk5_object_version_number :=chk_rec.object_version_number;
1398: --

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

1453: close csr_checklist;
1454: out_rec.chk6_checklist_item_id :=chk_rec.checklist_item_id;
1455: out_rec.chk6_date_due :=chk_rec.date_due;
1456: out_rec.chk6_date_done :=chk_rec.date_done;
1457: out_rec.chk6_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1458: out_rec.chk6_status :=chk_rec.status;
1459: out_rec.chk6_notes :=chk_rec.notes;
1460: out_rec.chk6_object_version_number :=chk_rec.object_version_number;
1461: --

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

1516: close csr_checklist;
1517: out_rec.chk7_checklist_item_id :=chk_rec.checklist_item_id;
1518: out_rec.chk7_date_due :=chk_rec.date_due;
1519: out_rec.chk7_date_done :=chk_rec.date_done;
1520: out_rec.chk7_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1521: out_rec.chk7_status :=chk_rec.status;
1522: out_rec.chk7_notes :=chk_rec.notes;
1523: out_rec.chk7_object_version_number :=chk_rec.object_version_number;
1524: --

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

1579: close csr_checklist;
1580: out_rec.chk8_checklist_item_id :=chk_rec.checklist_item_id;
1581: out_rec.chk8_date_due :=chk_rec.date_due;
1582: out_rec.chk8_date_done :=chk_rec.date_done;
1583: out_rec.chk8_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1584: out_rec.chk8_status :=chk_rec.status;
1585: out_rec.chk8_notes :=chk_rec.notes;
1586: out_rec.chk8_object_version_number :=chk_rec.object_version_number;
1587: --

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

1642: close csr_checklist;
1643: out_rec.chk9_checklist_item_id :=chk_rec.checklist_item_id;
1644: out_rec.chk9_date_due :=chk_rec.date_due;
1645: out_rec.chk9_date_done :=chk_rec.date_done;
1646: out_rec.chk9_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1647: out_rec.chk9_status :=chk_rec.status;
1648: out_rec.chk9_notes :=chk_rec.notes;
1649: out_rec.chk9_object_version_number :=chk_rec.object_version_number;
1650: --

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

1705: close csr_checklist;
1706: out_rec.chk10_checklist_item_id :=chk_rec.checklist_item_id;
1707: out_rec.chk10_date_due :=chk_rec.date_due;
1708: out_rec.chk10_date_done :=chk_rec.date_done;
1709: out_rec.chk10_status_meaning :=hr_reports.get_lookup_meaning('CHECKLIST_STATUS',chk_rec.status);
1710: out_rec.chk10_status :=chk_rec.status;
1711: out_rec.chk10_notes :=chk_rec.notes;
1712: out_rec.chk10_object_version_number :=chk_rec.object_version_number;
1713: --

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

1977: per_pay_proposals_populate.get_number_format(out_rec.salary_format);
1978: end if;
1979: end if;
1980: out_rec.pay_basis_id :=asg_rec.pay_basis_id;
1981: out_rec.pay_basis_meaning :=hr_reports.get_lookup_meaning('PAY_BASIS',out_rec.pay_basis);
1982: --
1983: hr_utility.set_location(l_proc,900);
1984: --
1985: out_rec.assignment_sequence :=asg_rec.assignment_sequence;

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

1990: out_rec.default_code_comb_id :=asg_rec.default_code_comb_id;
1991: --
1992: if asg_rec.assignment_type = 'E' then
1993: out_rec.employment_category_meaning
1994: :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1995: elsif asg_rec.assignment_type = 'C' then
1996: out_rec.employment_category_meaning
1997: := hr_reports.get_lookup_meaning('CWK_ASG_CATEGORY',asg_rec.employment_category);
1998: end if;

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

1993: out_rec.employment_category_meaning
1994: :=hr_reports.get_lookup_meaning('EMP_CAT',asg_rec.employment_category);
1995: elsif asg_rec.assignment_type = 'C' then
1996: out_rec.employment_category_meaning
1997: := hr_reports.get_lookup_meaning('CWK_ASG_CATEGORY',asg_rec.employment_category);
1998: end if;
1999: --
2000: out_rec.employment_category :=asg_rec.employment_category;
2001: out_rec.employee_category_meaning :=hr_reports.get_lookup_meaning('EMPLOYEE_CATG',asg_rec.employee_category);

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

1997: := hr_reports.get_lookup_meaning('CWK_ASG_CATEGORY',asg_rec.employment_category);
1998: end if;
1999: --
2000: out_rec.employment_category :=asg_rec.employment_category;
2001: out_rec.employee_category_meaning :=hr_reports.get_lookup_meaning('EMPLOYEE_CATG',asg_rec.employee_category);
2002: out_rec.employee_category :=asg_rec.employee_category;
2003: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
2004: out_rec.frequency :=asg_rec.frequency;
2005: out_rec.normal_hours :=asg_rec.normal_hours;

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

1999: --
2000: out_rec.employment_category :=asg_rec.employment_category;
2001: out_rec.employee_category_meaning :=hr_reports.get_lookup_meaning('EMPLOYEE_CATG',asg_rec.employee_category);
2002: out_rec.employee_category :=asg_rec.employee_category;
2003: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
2004: out_rec.frequency :=asg_rec.frequency;
2005: out_rec.normal_hours :=asg_rec.normal_hours;
2006: out_rec.probation_period :=asg_rec.probation_period;
2007: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);

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

2003: out_rec.frequency_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.frequency);
2004: out_rec.frequency :=asg_rec.frequency;
2005: out_rec.normal_hours :=asg_rec.normal_hours;
2006: out_rec.probation_period :=asg_rec.probation_period;
2007: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
2008: out_rec.probation_unit :=asg_rec.probation_unit;
2009: out_rec.notice_period :=asg_rec.notice_period;
2010: out_rec.notice_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.notice_period_uom);
2011: out_rec.notice_unit :=asg_rec.notice_period_uom;

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

2006: out_rec.probation_period :=asg_rec.probation_period;
2007: out_rec.probation_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.probation_unit);
2008: out_rec.probation_unit :=asg_rec.probation_unit;
2009: out_rec.notice_period :=asg_rec.notice_period;
2010: out_rec.notice_unit_meaning :=hr_reports.get_lookup_meaning('QUALIFYING_UNITS',asg_rec.notice_period_uom);
2011: out_rec.notice_unit :=asg_rec.notice_period_uom;
2012: out_rec.set_of_books_id :=asg_rec.set_of_books_id;
2013: if asg_rec.set_of_books_id is not null then
2014: open csr_sob(asg_rec.set_of_books_id);

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

2155: out_rec.ass_attribute28 :=asg_rec.ass_attribute28;
2156: out_rec.ass_attribute29 :=asg_rec.ass_attribute29;
2157: out_rec.ass_attribute30 :=asg_rec.ass_attribute30;
2158: out_rec.asg_object_version_number :=asg_rec.object_version_number;
2159: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
2160: out_rec.bargaining_unit_code :=asg_rec.bargaining_unit_code;
2161: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
2162: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
2163: out_rec.hourly_salaried_code :=asg_rec.hourly_salaried_code;

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

2158: out_rec.asg_object_version_number :=asg_rec.object_version_number;
2159: out_rec.bargaining_unit_code_meaning :=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',asg_rec.bargaining_unit_code);
2160: out_rec.bargaining_unit_code :=asg_rec.bargaining_unit_code;
2161: out_rec.labour_union_member_flag :=asg_rec.labour_union_member_flag;
2162: out_rec.hourly_salaried_meaning :=hr_reports.get_lookup_meaning('HOURLY_SALARIED_CODE',asg_rec.hourly_salaried_code);
2163: out_rec.hourly_salaried_code :=asg_rec.hourly_salaried_code;
2164: --
2165: hr_utility.set_location(l_proc,920);
2166: --

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

2175: --
2176: -- Bug# 4153433 Start Here
2177: --
2178: if asg_rec.assignment_type = 'E' then
2179: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('EMP_ASSIGN_REASON',asg_rec.change_reason);
2180: elsif asg_rec.assignment_type = 'A' then
2181: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
2182: elsif asg_rec.assignment_type = 'C' then
2183: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('CWK_ASSIGN_REASON',asg_rec.change_reason);

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

2177: --
2178: if asg_rec.assignment_type = 'E' then
2179: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('EMP_ASSIGN_REASON',asg_rec.change_reason);
2180: elsif asg_rec.assignment_type = 'A' then
2181: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
2182: elsif asg_rec.assignment_type = 'C' then
2183: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('CWK_ASSIGN_REASON',asg_rec.change_reason);
2184: end if;
2185: --

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

2179: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('EMP_ASSIGN_REASON',asg_rec.change_reason);
2180: elsif asg_rec.assignment_type = 'A' then
2181: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('APL_ASSIGN_REASON',asg_rec.change_reason);
2182: elsif asg_rec.assignment_type = 'C' then
2183: out_rec.change_reason_meaning :=hr_reports.get_lookup_meaning('CWK_ASSIGN_REASON',asg_rec.change_reason);
2184: end if;
2185: --
2186: --Bug# 4153433 End here
2187: --

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

2188: out_rec.change_reason :=asg_rec.change_reason;
2189: out_rec.internal_address_line :=asg_rec.internal_address_line;
2190: out_rec.manager_flag :=asg_rec.manager_flag;
2191: out_rec.perf_review_period :=asg_rec.perf_review_period;
2192: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
2193: out_rec.perf_review_period_frequency :=asg_rec.perf_review_period_frequency;
2194: out_rec.sal_review_period :=asg_rec.sal_review_period;
2195: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
2196: out_rec.sal_review_period_frequency :=asg_rec.sal_review_period_frequency;

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

2191: out_rec.perf_review_period :=asg_rec.perf_review_period;
2192: out_rec.perf_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.perf_review_period_frequency);
2193: out_rec.perf_review_period_frequency :=asg_rec.perf_review_period_frequency;
2194: out_rec.sal_review_period :=asg_rec.sal_review_period;
2195: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
2196: out_rec.sal_review_period_frequency :=asg_rec.sal_review_period_frequency;
2197: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
2198: out_rec.source_type :=asg_rec.source_type;
2199: --

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

2193: out_rec.perf_review_period_frequency :=asg_rec.perf_review_period_frequency;
2194: out_rec.sal_review_period :=asg_rec.sal_review_period;
2195: out_rec.sal_rev_period_freq_meaning :=hr_reports.get_lookup_meaning('FREQUENCY',asg_rec.sal_review_period_frequency);
2196: out_rec.sal_review_period_frequency :=asg_rec.sal_review_period_frequency;
2197: out_rec.source_type_meaning :=hr_reports.get_lookup_meaning('REC_TYPE',asg_rec.source_type);
2198: out_rec.source_type :=asg_rec.source_type;
2199: --
2200: hr_utility.set_location(l_proc,940);
2201: --

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

2253: out_rec.change_date :=pyp_rec.change_date;
2254: out_rec.proposed_salary_n :=pyp_rec.proposed_salary_n;
2255: out_rec.proposal_reason :=pyp_rec.proposal_reason;
2256: out_rec.proposal_reason_meaning :=
2257: hr_reports.get_lookup_meaning('PROPOSAL_REASON',pyp_rec.proposal_reason);
2258: out_rec.pyp_attribute_category :=pyp_rec.attribute_category;
2259: out_rec.pyp_attribute1 :=pyp_rec.attribute1;
2260: out_rec.pyp_attribute2 :=pyp_rec.attribute2;
2261: out_rec.pyp_attribute3 :=pyp_rec.attribute3;