[Home] [Help]
458: l_legislation_code varchar2(150);
459: l_proc varchar2(72) := g_package||'onerow';
460: --
461: begin
462: hr_utility.set_location('Entering:'|| l_proc, 10);
463: --
464: l_end_of_time:=hr_api.g_eot;
465: --
466: -- get the person record
475: out_rec.tax_update_allowed:='FALSE';
476: else
477: close csr_person_details;
478: --
479: hr_utility.set_location(l_proc, 20);
480: --
481: -- set the output fields
482: --
483: out_rec.person_id :=per_rec.person_id;
497: close csr_get_leg;
498: --
499: out_rec.legislation :=l_legislation_code;
500: --
501: hr_utility.set_location(l_proc, 30);
502: --
503: open csr_person_type(per_rec.person_type_id);
504: fetch csr_person_type into out_rec.person_type,out_rec.system_person_type;
505: close csr_person_type;
503: open csr_person_type(per_rec.person_type_id);
504: fetch csr_person_type into out_rec.person_type,out_rec.system_person_type;
505: close csr_person_type;
506: --
507: hr_utility.set_location(l_proc, 40);
508: --
509: out_rec.person_type_id :=per_rec.person_type_id;
510: out_rec.last_name :=per_rec.last_name;
511: out_rec.start_date :=per_rec.start_date;
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: --
520: if per_rec.person_id is not null then
521: open csr_bg_name(per_rec.person_id,p_effective_date);
522: fetch csr_bg_name into out_rec.business_group_name;
532: fetch csr_lang into out_rec.corr_lang_meaning;
533: close csr_lang;
534: end if;
535: --
536: hr_utility.set_location(l_proc, 60);
537: --
538: out_rec.correspondence_language :=per_rec.correspondence_language;
539: out_rec.current_applicant_flag :=per_rec.current_applicant_flag;
540: out_rec.current_emp_or_apl_flag :=per_rec.current_emp_or_apl_flag;
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: --
555: hr_utility.set_location(l_proc, 70);
556: --
557: out_rec.full_name :=per_rec.full_name;
558: out_rec.hold_applicant_date_until :=per_rec.hold_applicant_date_until;
559: out_rec.honors :=per_rec.honors;
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;
573: --
574: hr_utility.set_location(l_proc, 80);
575: --
576: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;
577: out_rec.previous_last_name :=per_rec.previous_last_name;
578: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
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: --
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;
601: out_rec.dpdnt_vlntry_svce_flag :=per_rec.dpdnt_vlntry_svce_flag;
602: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
603: out_rec.uses_tobacco_flag :=per_rec.uses_tobacco_flag;
604: --
605: hr_utility.set_location(l_proc, 100);
606: --
607: if per_rec.benefit_group_id is not null then
608: open csr_benfts_grp(per_rec.benefit_group_id);
609: fetch csr_benfts_grp into out_rec.benefit_group;
609: fetch csr_benfts_grp into out_rec.benefit_group;
610: close csr_benfts_grp;
611: end if;
612: --
613: hr_utility.set_location(l_proc, 110);
614: --
615: out_rec.benefit_group_id :=per_rec.benefit_group_id;
616: out_rec.attribute_category :=per_rec.attribute_category;
617: out_rec.attribute1 :=per_rec.attribute1;
711: end if;
712: --
713: out_rec.per_object_version_number :=per_rec.object_version_number;
714: --
715: hr_utility.set_location(l_proc, 120);
716: --
717: if per_rec.current_applicant_flag='Y' then
718: --
719: hr_utility.set_location(l_proc, 130);
715: hr_utility.set_location(l_proc, 120);
716: --
717: if per_rec.current_applicant_flag='Y' then
718: --
719: hr_utility.set_location(l_proc, 130);
720: --
721: open csr_application(p_person_id,p_effective_date);
722: fetch csr_application into app_rec;
723: close csr_application;
721: open csr_application(p_person_id,p_effective_date);
722: fetch csr_application into app_rec;
723: close csr_application;
724: --
725: hr_utility.set_location(l_proc, 140);
726: --
727: out_rec.application_id :=app_rec.application_id;
728: out_rec.projected_hire_date :=app_rec.projected_hire_date;
729: out_rec.appl_attribute_category :=app_rec.appl_attribute_category;
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;
758: --
759: hr_utility.set_location(l_proc, 150);
760: --
761: -- Bug 3540524 Starts Here
762: -- Description : Bring the data back to form even if the person is not an employee.
763: -- Here this restriction is blocking the Adjusted service date to propagate
765: -- in the form to prevent an update of the Adjusted Service date, if the person
766: -- is not an employee.
767: -- if per_rec.current_employee_flag='Y' then
768: --
769: hr_utility.set_location(l_proc, 160);
770: --
771: open csr_period_of_svc(p_person_id,p_effective_date);
772: fetch csr_period_of_svc into pds_rec;
773: close csr_period_of_svc;
790: --New check to verify the system_person_type is required as part of 5507008
791:
792: if out_rec.SYSTEM_PERSON_TYPE in ('OTHER','APL') then
793: --
794: hr_utility.set_location(l_proc, 165);
795: --
796: open csr_period_of_placement(p_person_id,p_effective_date);
797: fetch csr_period_of_placement into pdp_rec;
798: close csr_period_of_placement;
802: out_rec.employment_end_date:=pdp_rec.final_process_date;
803:
804: end if;
805: -- end of fix 5507008
806: hr_utility.set_location(l_proc, 170);
807: --
808: hr_utility.set_location(l_proc, 180);
809: --
810: open csr_addresses(p_person_id,p_effective_date);
804: end if;
805: -- end of fix 5507008
806: hr_utility.set_location(l_proc, 170);
807: --
808: hr_utility.set_location(l_proc, 180);
809: --
810: open csr_addresses(p_person_id,p_effective_date);
811: fetch csr_addresses into addr_rec;
812: if csr_addresses%found then
810: open csr_addresses(p_person_id,p_effective_date);
811: fetch csr_addresses into addr_rec;
812: if csr_addresses%found then
813: --
814: hr_utility.set_location(l_proc, 190);
815: --
816: close csr_addresses;
817: out_rec.address_id :=addr_rec.address_id;
818: out_rec.adr_date_from :=addr_rec.date_from;
821: open csr_address_style(addr_rec.style);
822: fetch csr_address_style into out_rec.style_meaning;
823: close csr_address_style;
824: --
825: hr_utility.set_location(l_proc, 200);
826: --
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;
870: out_rec.addr_attribute19 :=addr_rec.addr_attribute19;
871: out_rec.addr_attribute20 :=addr_rec.addr_attribute20;
872: out_rec.addr_object_version_number :=addr_rec.object_version_number;
873: --
874: hr_utility.set_location(l_proc, 240);
875: else
876: close csr_addresses;
877: end if;
878: --
875: else
876: close csr_addresses;
877: end if;
878: --
879: hr_utility.set_location(l_proc, 250);
880: --
881: open csr_phone(p_person_id,'H1',p_effective_date);
882: fetch csr_phone into phn_rec;
883: if csr_phone%found then
881: open csr_phone(p_person_id,'H1',p_effective_date);
882: fetch csr_phone into phn_rec;
883: if csr_phone%found then
884: --
885: hr_utility.set_location(l_proc, 260);
886: --
887: close csr_phone;
888: out_rec.phn_h_phone_id :=phn_rec.phone_id;
889: out_rec.phn_h_date_from :=phn_rec.date_from;
893: else
894: close csr_phone;
895: end if;
896: --
897: hr_utility.set_location(l_proc, 270);
898: --
899: open csr_phone(p_person_id,'W1',p_effective_date);
900: fetch csr_phone into phn_rec;
901: if csr_phone%found then
899: open csr_phone(p_person_id,'W1',p_effective_date);
900: fetch csr_phone into phn_rec;
901: if csr_phone%found then
902: --
903: hr_utility.set_location(l_proc, 280);
904: --
905: close csr_phone;
906: out_rec.phn_w_phone_id :=phn_rec.phone_id;
907: out_rec.phn_w_date_from :=phn_rec.date_from;
911: else
912: close csr_phone;
913: end if;
914: --
915: hr_utility.set_location(l_proc, 290);
916: --
917: open csr_phone(p_person_id,'M',p_effective_date);
918: fetch csr_phone into phn_rec;
919: if csr_phone%found then
917: open csr_phone(p_person_id,'M',p_effective_date);
918: fetch csr_phone into phn_rec;
919: if csr_phone%found then
920: --
921: hr_utility.set_location(l_proc, 300);
922: --
923: close csr_phone;
924: out_rec.phn_m_phone_id :=phn_rec.phone_id;
925: out_rec.phn_m_date_from :=phn_rec.date_from;
929: else
930: close csr_phone;
931: end if;
932: --
933: hr_utility.set_location(l_proc, 310);
934: --
935: open csr_phone(p_person_id,'HF',p_effective_date);
936: fetch csr_phone into phn_rec;
937: if csr_phone%found then
935: open csr_phone(p_person_id,'HF',p_effective_date);
936: fetch csr_phone into phn_rec;
937: if csr_phone%found then
938: --
939: hr_utility.set_location(l_proc, 320);
940: --
941: close csr_phone;
942: out_rec.phn_hf_phone_id :=phn_rec.phone_id;
943: out_rec.phn_hf_date_from :=phn_rec.date_from;
947: else
948: close csr_phone;
949: end if;
950: --
951: hr_utility.set_location(l_proc, 330);
952: --
953: open csr_phone(p_person_id,'WF',p_effective_date);
954: fetch csr_phone into phn_rec;
955: if csr_phone%found then
953: open csr_phone(p_person_id,'WF',p_effective_date);
954: fetch csr_phone into phn_rec;
955: if csr_phone%found then
956: --
957: hr_utility.set_location(l_proc, 340);
958: --
959: close csr_phone;
960: out_rec.phn_wf_phone_id :=phn_rec.phone_id;
961: out_rec.phn_wf_date_from :=phn_rec.date_from;
965: else
966: close csr_phone;
967: end if;
968: --
969: hr_utility.set_location(l_proc, 350);
970: --
971: open csr_deployment(p_person_id);
972: fetch csr_deployment into dpf_rec;
973: if csr_deployment%found then
971: open csr_deployment(p_person_id);
972: fetch csr_deployment into dpf_rec;
973: if csr_deployment%found then
974: --
975: hr_utility.set_location(l_proc, 360);
976: --
977: out_rec.deployment_factor_id :=dpf_rec.deployment_factor_id;
978: out_rec.work_any_country :=dpf_rec.work_any_country;
979: out_rec.work_any_location :=dpf_rec.work_any_location;
980: out_rec.relocate_domestically :=dpf_rec.relocate_domestically;
981: out_rec.relocate_internationally :=dpf_rec.relocate_internationally;
982: out_rec.travel_required :=dpf_rec.travel_required;
983: --
984: hr_utility.set_location(l_proc, 370);
985: --
986: if dpf_rec.country1 is not null then
987: --
988: hr_utility.set_location(l_proc, 380);
984: hr_utility.set_location(l_proc, 370);
985: --
986: if dpf_rec.country1 is not null then
987: --
988: hr_utility.set_location(l_proc, 380);
989: --
990: open csr_country(dpf_rec.country1);
991: fetch csr_country into out_rec.country1_meaning;
992: close csr_country;
994: out_rec.country1 :=dpf_rec.country1;
995: --
996: if dpf_rec.country2 is not null then
997: --
998: hr_utility.set_location(l_proc, 390);
999: --
1000: open csr_country(dpf_rec.country2);
1001: fetch csr_country into out_rec.country2_meaning;
1002: close csr_country;
1004: out_rec.country2 :=dpf_rec.country2;
1005: --
1006: if dpf_rec.country3 is not null then
1007: --
1008: hr_utility.set_location(l_proc, 400);
1009: --
1010: open csr_country(dpf_rec.country3);
1011: fetch csr_country into out_rec.country3_meaning;
1012: close csr_country;
1012: close csr_country;
1013: end if;
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);
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: --
1029: hr_utility.set_location(l_proc, 420);
1030: --
1031: if dpf_rec.no_country1 is not null then
1032: --
1033: hr_utility.set_location(l_proc, 430);
1029: hr_utility.set_location(l_proc, 420);
1030: --
1031: if dpf_rec.no_country1 is not null then
1032: --
1033: hr_utility.set_location(l_proc, 430);
1034: --
1035: open csr_country(dpf_rec.no_country1);
1036: fetch csr_country into out_rec.no_country1_meaning;
1037: close csr_country;
1039: out_rec.no_country1 :=dpf_rec.no_country1;
1040: --
1041: if dpf_rec.no_country2 is not null then
1042: --
1043: hr_utility.set_location(l_proc, 440);
1044: --
1045: open csr_country(dpf_rec.no_country2);
1046: fetch csr_country into out_rec.no_country2_meaning;
1047: close csr_country;
1049: out_rec.no_country2 :=dpf_rec.no_country2;
1050: --
1051: if dpf_rec.no_country3 is not null then
1052: --
1053: hr_utility.set_location(l_proc, 450);
1054: --
1055: open csr_country(dpf_rec.no_country3);
1056: fetch csr_country into out_rec.no_country3_meaning;
1057: close csr_country;
1058: end if;
1059: out_rec.no_country3 :=dpf_rec.no_country3;
1060: --
1061: --
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);
1087: out_rec.dpf_attribute18 :=dpf_rec.attribute18;
1088: out_rec.dpf_attribute19 :=dpf_rec.attribute19;
1089: out_rec.dpf_attribute20 :=dpf_rec.attribute20;
1090: --
1091: hr_utility.set_location(l_proc, 470);
1092: --
1093: else
1094: close csr_deployment;
1095: end if;
1097: open csr_template(per_per_bus.return_legislation_code(p_person_id));
1098: fetch csr_template into l_form_template_id;
1099: close csr_template;
1100: --
1101: hr_utility.set_location(l_proc, 475);
1102: --
1103: open csr_template_items
1104: (p_form_template_id => l_form_template_id
1105: ,p_full_item_name => p_block_name||'.CHK1_ITEM_CODE_MEANING'
1106: );
1107: fetch csr_template_items into l_template_item;
1108: --
1109: IF (csr_template_items%found) THEN
1110: hr_utility.set_location(l_proc, 480);
1111: close csr_template_items;
1112: open csr_template_item_contexts
1113: (p_template_item_id => l_template_item.template_item_id
1114: ,p_emp_apl_flag => out_rec.person_type
1124: --
1125: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1126: fetch reverse_lookup into chk_rec.item_code;
1127: if reverse_lookup%found then
1128: hr_utility.set_location(l_proc, 485);
1129: close reverse_lookup;
1130: out_rec.chk1_item_code_meaning:=l_default_value;
1131: out_rec.chk1_item_code :=chk_rec.item_code;
1132: --
1133: open csr_checklist(p_person_id, chk_rec.item_code);
1134: fetch csr_checklist into chk_rec;
1135: if csr_checklist%found then
1136: --
1137: hr_utility.set_location(l_proc, 490);
1138: --
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;
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: --
1148: hr_utility.set_location(l_proc,495);
1149: --
1150: else
1151: close csr_checklist;
1152: end if;
1150: else
1151: close csr_checklist;
1152: end if;
1153: else
1154: hr_utility.set_location(l_proc,500);
1155: close reverse_lookup;
1156: out_rec.chk1_item_code_meaning:=null;
1157: out_rec.chk1_item_code :=null;
1158: end if;
1160: else
1161: close csr_template_items;
1162: END IF;
1163: --
1164: hr_utility.set_location(l_proc, 505);
1165: open csr_template_items
1166: (p_form_template_id => l_form_template_id
1167: ,p_full_item_name => p_block_name||'.CHK2_ITEM_CODE_MEANING'
1168: );
1168: );
1169: fetch csr_template_items into l_template_item;
1170: --
1171: IF (csr_template_items%found) THEN
1172: hr_utility.set_location(l_proc, 510);
1173: close csr_template_items;
1174: open csr_template_item_contexts
1175: (p_template_item_id => l_template_item.template_item_id
1176: ,p_emp_apl_flag => out_rec.person_type
1186: --
1187: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1188: fetch reverse_lookup into chk_rec.item_code;
1189: if reverse_lookup%found then
1190: hr_utility.set_location(l_proc, 515);
1191: close reverse_lookup;
1192: out_rec.chk2_item_code_meaning:=l_default_value;
1193: out_rec.chk2_item_code :=chk_rec.item_code;
1194: --
1195: open csr_checklist(p_person_id, chk_rec.item_code);
1196: fetch csr_checklist into chk_rec;
1197: if csr_checklist%found then
1198: --
1199: hr_utility.set_location(l_proc, 520);
1200: --
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;
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: --
1210: hr_utility.set_location(l_proc,525);
1211: --
1212: else
1213: close csr_checklist;
1214: end if;
1212: else
1213: close csr_checklist;
1214: end if;
1215: else
1216: hr_utility.set_location(l_proc,530);
1217: close reverse_lookup;
1218: out_rec.chk2_item_code_meaning:=null;
1219: out_rec.chk2_item_code :=null;
1220: end if;
1222: else
1223: close csr_template_items;
1224: END IF;
1225: --
1226: hr_utility.set_location(l_proc,535);
1227: --
1228: open csr_template_items
1229: (p_form_template_id => l_form_template_id
1230: ,p_full_item_name => p_block_name||'.CHK3_ITEM_CODE_MEANING'
1231: );
1232: fetch csr_template_items into l_template_item;
1233: --
1234: IF (csr_template_items%found) THEN
1235: hr_utility.set_location(l_proc, 540);
1236: close csr_template_items;
1237: open csr_template_item_contexts
1238: (p_template_item_id => l_template_item.template_item_id
1239: ,p_emp_apl_flag => out_rec.person_type
1249: --
1250: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1251: fetch reverse_lookup into chk_rec.item_code;
1252: if reverse_lookup%found then
1253: hr_utility.set_location(l_proc, 545);
1254: close reverse_lookup;
1255: out_rec.chk3_item_code_meaning:=l_default_value;
1256: out_rec.chk3_item_code :=chk_rec.item_code;
1257: --
1258: open csr_checklist(p_person_id, chk_rec.item_code);
1259: fetch csr_checklist into chk_rec;
1260: if csr_checklist%found then
1261: --
1262: hr_utility.set_location(l_proc, 550);
1263: --
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;
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: --
1273: hr_utility.set_location(l_proc,555);
1274: --
1275: else
1276: close csr_checklist;
1277: end if;
1275: else
1276: close csr_checklist;
1277: end if;
1278: else
1279: hr_utility.set_location(l_proc,560);
1280: close reverse_lookup;
1281: out_rec.chk3_item_code_meaning:=null;
1282: out_rec.chk3_item_code :=null;
1283: end if;
1285: else
1286: close csr_template_items;
1287: END IF;
1288: --
1289: hr_utility.set_location(l_proc,565);
1290: --
1291: open csr_template_items
1292: (p_form_template_id => l_form_template_id
1293: ,p_full_item_name => p_block_name||'.CHK4_ITEM_CODE_MEANING'
1294: );
1295: fetch csr_template_items into l_template_item;
1296: --
1297: IF (csr_template_items%found) THEN
1298: hr_utility.set_location(l_proc, 570);
1299: close csr_template_items;
1300: open csr_template_item_contexts
1301: (p_template_item_id => l_template_item.template_item_id
1302: ,p_emp_apl_flag => out_rec.person_type
1312: --
1313: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1314: fetch reverse_lookup into chk_rec.item_code;
1315: if reverse_lookup%found then
1316: hr_utility.set_location(l_proc, 575);
1317: close reverse_lookup;
1318: out_rec.chk4_item_code_meaning:=l_default_value;
1319: out_rec.chk4_item_code :=chk_rec.item_code;
1320: --
1321: open csr_checklist(p_person_id, chk_rec.item_code);
1322: fetch csr_checklist into chk_rec;
1323: if csr_checklist%found then
1324: --
1325: hr_utility.set_location(l_proc, 580);
1326: --
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;
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: --
1336: hr_utility.set_location(l_proc,585);
1337: --
1338: else
1339: close csr_checklist;
1340: end if;
1338: else
1339: close csr_checklist;
1340: end if;
1341: else
1342: hr_utility.set_location(l_proc,590);
1343: close reverse_lookup;
1344: out_rec.chk4_item_code_meaning:=null;
1345: out_rec.chk4_item_code :=null;
1346: end if;
1348: else
1349: close csr_template_items;
1350: END IF;
1351: --
1352: hr_utility.set_location(l_proc,595);
1353: --
1354: open csr_template_items
1355: (p_form_template_id => l_form_template_id
1356: ,p_full_item_name => p_block_name||'.CHK5_ITEM_CODE_MEANING'
1357: );
1358: fetch csr_template_items into l_template_item;
1359: --
1360: IF (csr_template_items%found) THEN
1361: hr_utility.set_location(l_proc, 600);
1362: close csr_template_items;
1363: open csr_template_item_contexts
1364: (p_template_item_id => l_template_item.template_item_id
1365: ,p_emp_apl_flag => out_rec.person_type
1375: --
1376: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1377: fetch reverse_lookup into chk_rec.item_code;
1378: if reverse_lookup%found then
1379: hr_utility.set_location(l_proc, 605);
1380: close reverse_lookup;
1381: out_rec.chk5_item_code_meaning:=l_default_value;
1382: out_rec.chk5_item_code :=chk_rec.item_code;
1383: --
1384: open csr_checklist(p_person_id, chk_rec.item_code);
1385: fetch csr_checklist into chk_rec;
1386: if csr_checklist%found then
1387: --
1388: hr_utility.set_location(l_proc, 610);
1389: --
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;
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: --
1399: hr_utility.set_location(l_proc,615);
1400: --
1401: else
1402: close csr_checklist;
1403: end if;
1401: else
1402: close csr_checklist;
1403: end if;
1404: else
1405: hr_utility.set_location(l_proc,620);
1406: close reverse_lookup;
1407: out_rec.chk5_item_code_meaning:=null;
1408: out_rec.chk5_item_code :=null;
1409: end if;
1411: else
1412: close csr_template_items;
1413: END IF;
1414: --
1415: hr_utility.set_location(l_proc,625);
1416: --
1417: open csr_template_items
1418: (p_form_template_id => l_form_template_id
1419: ,p_full_item_name => p_block_name||'.CHK6_ITEM_CODE_MEANING'
1420: );
1421: fetch csr_template_items into l_template_item;
1422: --
1423: IF (csr_template_items%found) THEN
1424: hr_utility.set_location(l_proc, 630);
1425: close csr_template_items;
1426: open csr_template_item_contexts
1427: (p_template_item_id => l_template_item.template_item_id
1428: ,p_emp_apl_flag => out_rec.person_type
1438: --
1439: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1440: fetch reverse_lookup into chk_rec.item_code;
1441: if reverse_lookup%found then
1442: hr_utility.set_location(l_proc, 635);
1443: close reverse_lookup;
1444: out_rec.chk6_item_code_meaning:=l_default_value;
1445: out_rec.chk6_item_code :=chk_rec.item_code;
1446: --
1447: open csr_checklist(p_person_id, chk_rec.item_code);
1448: fetch csr_checklist into chk_rec;
1449: if csr_checklist%found then
1450: --
1451: hr_utility.set_location(l_proc, 640);
1452: --
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;
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: --
1462: hr_utility.set_location(l_proc,645);
1463: --
1464: else
1465: close csr_checklist;
1466: end if;
1464: else
1465: close csr_checklist;
1466: end if;
1467: else
1468: hr_utility.set_location(l_proc,650);
1469: close reverse_lookup;
1470: out_rec.chk6_item_code_meaning:=null;
1471: out_rec.chk6_item_code :=null;
1472: end if;
1474: else
1475: close csr_template_items;
1476: END IF;
1477: --
1478: hr_utility.set_location(l_proc,655);
1479: --
1480: open csr_template_items
1481: (p_form_template_id => l_form_template_id
1482: ,p_full_item_name => p_block_name||'.CHK7_ITEM_CODE_MEANING'
1483: );
1484: fetch csr_template_items into l_template_item;
1485: --
1486: IF (csr_template_items%found) THEN
1487: hr_utility.set_location(l_proc, 660);
1488: close csr_template_items;
1489: open csr_template_item_contexts
1490: (p_template_item_id => l_template_item.template_item_id
1491: ,p_emp_apl_flag => out_rec.person_type
1501: --
1502: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1503: fetch reverse_lookup into chk_rec.item_code;
1504: if reverse_lookup%found then
1505: hr_utility.set_location(l_proc, 665);
1506: close reverse_lookup;
1507: out_rec.chk7_item_code_meaning:=l_default_value;
1508: out_rec.chk7_item_code :=chk_rec.item_code;
1509: --
1510: open csr_checklist(p_person_id, chk_rec.item_code);
1511: fetch csr_checklist into chk_rec;
1512: if csr_checklist%found then
1513: --
1514: hr_utility.set_location(l_proc, 670);
1515: --
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;
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: --
1525: hr_utility.set_location(l_proc,675);
1526: --
1527: else
1528: close csr_checklist;
1529: end if;
1527: else
1528: close csr_checklist;
1529: end if;
1530: else
1531: hr_utility.set_location(l_proc,680);
1532: close reverse_lookup;
1533: out_rec.chk7_item_code_meaning:=null;
1534: out_rec.chk7_item_code :=null;
1535: end if;
1537: else
1538: close csr_template_items;
1539: END IF;
1540: --
1541: hr_utility.set_location(l_proc,685);
1542: --
1543: open csr_template_items
1544: (p_form_template_id => l_form_template_id
1545: ,p_full_item_name => p_block_name||'.CHK8_ITEM_CODE_MEANING'
1546: );
1547: fetch csr_template_items into l_template_item;
1548: --
1549: IF (csr_template_items%found) THEN
1550: hr_utility.set_location(l_proc, 690);
1551: close csr_template_items;
1552: open csr_template_item_contexts
1553: (p_template_item_id => l_template_item.template_item_id
1554: ,p_emp_apl_flag => out_rec.person_type
1564: --
1565: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1566: fetch reverse_lookup into chk_rec.item_code;
1567: if reverse_lookup%found then
1568: hr_utility.set_location(l_proc, 695);
1569: close reverse_lookup;
1570: out_rec.chk8_item_code_meaning:=l_default_value;
1571: out_rec.chk8_item_code :=chk_rec.item_code;
1572: --
1573: open csr_checklist(p_person_id, chk_rec.item_code);
1574: fetch csr_checklist into chk_rec;
1575: if csr_checklist%found then
1576: --
1577: hr_utility.set_location(l_proc, 700);
1578: --
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;
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: --
1588: hr_utility.set_location(l_proc,705);
1589: --
1590: else
1591: close csr_checklist;
1592: end if;
1590: else
1591: close csr_checklist;
1592: end if;
1593: else
1594: hr_utility.set_location(l_proc,710);
1595: close reverse_lookup;
1596: out_rec.chk8_item_code_meaning:=null;
1597: out_rec.chk8_item_code :=null;
1598: end if;
1600: else
1601: close csr_template_items;
1602: END IF;
1603: --
1604: hr_utility.set_location(l_proc,715);
1605: --
1606: open csr_template_items
1607: (p_form_template_id => l_form_template_id
1608: ,p_full_item_name => p_block_name||'.CHK9_ITEM_CODE_MEANING'
1609: );
1610: fetch csr_template_items into l_template_item;
1611: --
1612: IF (csr_template_items%found) THEN
1613: hr_utility.set_location(l_proc, 720);
1614: close csr_template_items;
1615: open csr_template_item_contexts
1616: (p_template_item_id => l_template_item.template_item_id
1617: ,p_emp_apl_flag => out_rec.person_type
1627: --
1628: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1629: fetch reverse_lookup into chk_rec.item_code;
1630: if reverse_lookup%found then
1631: hr_utility.set_location(l_proc, 725);
1632: close reverse_lookup;
1633: out_rec.chk9_item_code_meaning:=l_default_value;
1634: out_rec.chk9_item_code :=chk_rec.item_code;
1635: --
1636: open csr_checklist(p_person_id, chk_rec.item_code);
1637: fetch csr_checklist into chk_rec;
1638: if csr_checklist%found then
1639: --
1640: hr_utility.set_location(l_proc, 730);
1641: --
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;
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: --
1651: hr_utility.set_location(l_proc,735);
1652: --
1653: else
1654: close csr_checklist;
1655: end if;
1653: else
1654: close csr_checklist;
1655: end if;
1656: else
1657: hr_utility.set_location(l_proc,740);
1658: close reverse_lookup;
1659: out_rec.chk9_item_code_meaning:=null;
1660: out_rec.chk9_item_code :=null;
1661: end if;
1663: else
1664: close csr_template_items;
1665: END IF;
1666: --
1667: hr_utility.set_location(l_proc,745);
1668: --
1669: open csr_template_items
1670: (p_form_template_id => l_form_template_id
1671: ,p_full_item_name => p_block_name||'.CHK10_ITEM_CODE_MEANING'
1672: );
1673: fetch csr_template_items into l_template_item;
1674: --
1675: IF (csr_template_items%found) THEN
1676: hr_utility.set_location(l_proc, 750);
1677: close csr_template_items;
1678: open csr_template_item_contexts
1679: (p_template_item_id => l_template_item.template_item_id
1680: ,p_emp_apl_flag => out_rec.person_type
1690: --
1691: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1692: fetch reverse_lookup into chk_rec.item_code;
1693: if reverse_lookup%found then
1694: hr_utility.set_location(l_proc, 755);
1695: close reverse_lookup;
1696: out_rec.chk10_item_code_meaning:=l_default_value;
1697: out_rec.chk10_item_code :=chk_rec.item_code;
1698: --
1699: open csr_checklist(p_person_id, chk_rec.item_code);
1700: fetch csr_checklist into chk_rec;
1701: if csr_checklist%found then
1702: --
1703: hr_utility.set_location(l_proc, 760);
1704: --
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;
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: --
1714: hr_utility.set_location(l_proc,765);
1715: --
1716: else
1717: close csr_checklist;
1718: end if;
1716: else
1717: close csr_checklist;
1718: end if;
1719: else
1720: hr_utility.set_location(l_proc,770);
1721: close reverse_lookup;
1722: out_rec.chk10_item_code_meaning:=null;
1723: out_rec.chk10_item_code :=null;
1724: end if;
1726: else
1727: close csr_template_items;
1728: END IF;
1729: --
1730: hr_utility.set_location(l_proc,771);
1731: hr_utility.trace('p_assignment_id : ' || p_assignment_id);
1732: hr_utility.trace('p_effective_date : ' || p_effective_date);
1733: --
1734: if p_assignment_id is not null then
1727: close csr_template_items;
1728: END IF;
1729: --
1730: hr_utility.set_location(l_proc,771);
1731: hr_utility.trace('p_assignment_id : ' || p_assignment_id);
1732: hr_utility.trace('p_effective_date : ' || p_effective_date);
1733: --
1734: if p_assignment_id is not null then
1735: --
1728: END IF;
1729: --
1730: hr_utility.set_location(l_proc,771);
1731: hr_utility.trace('p_assignment_id : ' || p_assignment_id);
1732: hr_utility.trace('p_effective_date : ' || p_effective_date);
1733: --
1734: if p_assignment_id is not null then
1735: --
1736: hr_utility.set_location(l_proc,772);
1732: hr_utility.trace('p_effective_date : ' || p_effective_date);
1733: --
1734: if p_assignment_id is not null then
1735: --
1736: hr_utility.set_location(l_proc,772);
1737: --
1738: open csr_assignment_details(p_assignment_id,p_effective_date);
1739: fetch csr_assignment_details into asg_rec;
1740: if csr_assignment_details%notfound then
1742: out_rec.assignment_id:=-1;
1743: --no assignment found mean person is OTHER or EX-something
1744: --flag up that the fields should be disabled, fixes bug 3929761
1745: out_rec.asg_update_allowed:='FALSE';
1746: hr_utility.set_location(l_proc,773);
1747: else
1748: --
1749: hr_utility.set_location(l_proc,774);
1750: --
1745: out_rec.asg_update_allowed:='FALSE';
1746: hr_utility.set_location(l_proc,773);
1747: else
1748: --
1749: hr_utility.set_location(l_proc,774);
1750: --
1751: out_rec.assignment_id :=asg_rec.assignment_id;
1752: out_rec.asg_effective_start_date :=asg_rec.effective_start_date;
1753: out_rec.asg_effective_end_date :=asg_rec.effective_end_date;
1757: else
1758: out_rec.asg_update_allowed:='FALSE';
1759: end if;
1760: --
1761: hr_utility.set_location(l_proc,775);
1762: --
1763: if asg_rec.recruiter_id is not null then
1764: out_rec.recruiter
1765: :=per_qh_populate.get_full_name(asg_rec.recruiter_id,p_effective_date);
1765: :=per_qh_populate.get_full_name(asg_rec.recruiter_id,p_effective_date);
1766: end if;
1767: out_rec.recruiter_id :=asg_rec.recruiter_id;
1768: --
1769: hr_utility.set_location(l_proc,776);
1770: --
1771: if asg_rec.grade_id is not null then
1772: out_rec.grade:=per_qh_populate.get_grade(asg_rec.grade_id);
1773: end if;
1772: out_rec.grade:=per_qh_populate.get_grade(asg_rec.grade_id);
1773: end if;
1774: out_rec.grade_id :=asg_rec.grade_id;
1775: --
1776: hr_utility.set_location(l_proc,777);
1777: --
1778: if asg_rec.grade_ladder_pgm_id is not null then
1779: out_rec.grade_ladder
1780: := per_qh_populate.get_grade_ladder(asg_rec.grade_ladder_pgm_id
1781: ,p_effective_date);
1782: end if;
1783: out_rec.grade_ladder_pgm_id := asg_rec.grade_ladder_pgm_id;
1784: --
1785: hr_utility.set_location(l_proc,778);
1786: --
1787: if asg_rec.position_id is not null then
1788: out_rec.position
1789: :=per_qh_populate.get_position(asg_rec.position_id,p_effective_date);
1789: :=per_qh_populate.get_position(asg_rec.position_id,p_effective_date);
1790: end if;
1791: out_rec.position_id :=asg_rec.position_id;
1792: --
1793: hr_utility.set_location(l_proc,779);
1794: --
1795: if asg_rec.job_id is not null then
1796: out_rec.job:=per_qh_populate.get_job(asg_rec.job_id);
1797: end if;
1796: out_rec.job:=per_qh_populate.get_job(asg_rec.job_id);
1797: end if;
1798: out_rec.job_id :=asg_rec.job_id;
1799: --
1800: hr_utility.set_location(l_proc,780);
1801: --
1802: open csr_asg_status(asg_rec.assignment_status_type_id,asg_rec.business_group_id);
1803: fetch csr_asg_status into out_rec.assignment_status_type,out_rec.system_status;
1804: close csr_asg_status;
1803: fetch csr_asg_status into out_rec.assignment_status_type,out_rec.system_status;
1804: close csr_asg_status;
1805: out_rec.assignment_status_type_id :=asg_rec.assignment_status_type_id;
1806: --
1807: hr_utility.set_location(l_proc,782);
1808: --
1809: if asg_rec.payroll_id is not null then
1810: out_rec.payroll:=
1811: per_qh_populate.get_payroll(asg_rec.payroll_id,p_effective_date);
1811: per_qh_populate.get_payroll(asg_rec.payroll_id,p_effective_date);
1812: end if;
1813: out_rec.payroll_id :=asg_rec.payroll_id;
1814: --
1815: hr_utility.set_location(l_proc,785);
1816: --
1817: if asg_rec.location_id is not null then
1818: out_rec.location:=per_qh_populate.get_location(asg_rec.location_id);
1819: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1819: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1820: end if;
1821: out_rec.location_id :=asg_rec.location_id;
1822: --
1823: hr_utility.set_location(l_proc,790);
1824: --
1825: if asg_rec.person_referred_by_id is not null then
1826: out_rec.person_referred_by:=
1827: per_qh_populate.get_full_name(asg_rec.person_referred_by_id,p_effective_date);
1827: per_qh_populate.get_full_name(asg_rec.person_referred_by_id,p_effective_date);
1828: end if;
1829: out_rec.person_referred_by_id :=asg_rec.person_referred_by_id;
1830: --
1831: hr_utility.set_location(l_proc,800);
1832: --
1833: if asg_rec.supervisor_id is not null then
1834: out_rec.supervisor:=
1835: per_qh_populate.get_full_name(asg_rec.supervisor_id,p_effective_date);
1835: per_qh_populate.get_full_name(asg_rec.supervisor_id,p_effective_date);
1836: end if;
1837: out_rec.supervisor_id :=asg_rec.supervisor_id;
1838: --
1839: hr_utility.set_location(l_proc,805);
1840: --
1841: if asg_rec.supervisor_assignment_id is not null then
1842: out_rec.supervisor_assignment_number :=
1843: per_qh_populate.get_supervisor_assgn_number(
1844: asg_rec.supervisor_assignment_id,asg_rec.business_group_id);
1845: end if;
1846: out_rec.supervisor_assignment_id := asg_rec.supervisor_assignment_id;
1847: --
1848: hr_utility.set_location(l_proc,810);
1849: --
1850: if asg_rec.recruitment_activity_id is not null then
1851: open csr_rec_activity(asg_rec.recruitment_activity_id);
1852: fetch csr_rec_activity into out_rec.recruitment_activity;
1853: close csr_rec_activity;
1854: end if;
1855: out_rec.recruitment_activity_id :=asg_rec.recruitment_activity_id;
1856: --
1857: hr_utility.set_location(l_proc,820);
1858: --
1859: if asg_rec.source_organization_id is not null then
1860: out_rec.source_organization
1861: :=per_qh_populate.get_organization(asg_rec.source_organization_id);
1861: :=per_qh_populate.get_organization(asg_rec.source_organization_id);
1862: end if;
1863: out_rec.source_organization_id :=asg_rec.source_organization_id;
1864: --
1865: hr_utility.set_location(l_proc,830);
1866: --
1867: out_rec.organization
1868: :=per_qh_populate.get_organization(asg_rec.organization_id);
1869: out_rec.organization_id :=asg_rec.organization_id;
1867: out_rec.organization
1868: :=per_qh_populate.get_organization(asg_rec.organization_id);
1869: out_rec.organization_id :=asg_rec.organization_id;
1870: --
1871: hr_utility.set_location(l_proc,840);
1872: --
1873: if asg_rec.people_group_id is not null then
1874: open csr_pgp_rec(asg_rec.people_group_id);
1875: fetch csr_pgp_rec into pgp_rec;
1874: open csr_pgp_rec(asg_rec.people_group_id);
1875: fetch csr_pgp_rec into pgp_rec;
1876: close csr_pgp_rec;
1877: --
1878: hr_utility.set_location(l_proc,850);
1879: --
1880: out_rec.pgp_segment1 :=pgp_rec.segment1;
1881: out_rec.pgp_segment2 :=pgp_rec.segment2;
1882: out_rec.pgp_segment3 :=pgp_rec.segment3;
1909: out_rec.pgp_segment30 :=pgp_rec.segment30;
1910: end if;
1911: out_rec.people_group_id :=asg_rec.people_group_id;
1912: --
1913: hr_utility.set_location(l_proc,860);
1914: --
1915: if asg_rec.soft_coding_keyflex_id is not null then
1916: open csr_scl_rec(asg_rec.soft_coding_keyflex_id);
1917: fetch csr_scl_rec into scl_rec;
1916: open csr_scl_rec(asg_rec.soft_coding_keyflex_id);
1917: fetch csr_scl_rec into scl_rec;
1918: close csr_scl_rec;
1919: --
1920: hr_utility.set_location(l_proc,870);
1921: --
1922: out_rec.scl_segment1 :=scl_rec.segment1;
1923: out_rec.scl_segment2 :=scl_rec.segment2;
1924: out_rec.scl_segment3 :=scl_rec.segment3;
1951: out_rec.scl_segment30 :=scl_rec.segment30;
1952: end if;
1953: out_rec.soft_coding_keyflex_id :=asg_rec.soft_coding_keyflex_id;
1954: --
1955: hr_utility.set_location(l_proc,880);
1956: --
1957: if asg_rec.vacancy_id is not null then
1958: open csr_vacancy(asg_rec.vacancy_id);
1959: fetch csr_vacancy into out_rec.vacancy,out_rec.requisition;
1960: close csr_vacancy;
1961: end if;
1962: out_rec.vacancy_id :=asg_rec.vacancy_id;
1963: --
1964: hr_utility.set_location(l_proc,890);
1965: --
1966: if asg_rec.pay_basis_id is not null then
1967: open salary_basis(p_effective_date,asg_rec.pay_basis_id);
1968: fetch salary_basis into
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;
1986: out_rec.assignment_type :=asg_rec.assignment_type;
1987: out_rec.asg_primary_flag :=asg_rec.primary_flag;
2018: out_rec.billing_title :=asg_rec.title;
2019: out_rec.time_normal_finish :=asg_rec.time_normal_finish;
2020: out_rec.time_normal_start :=asg_rec.time_normal_start;
2021: --
2022: hr_utility.set_location(l_proc,910);
2023: --
2024: --CWK asg fields
2025: out_rec.projected_assignment_end :=asg_rec.projected_assignment_end;
2026: out_rec.vendor_employee_number :=asg_rec.vendor_employee_number;
2053: close csr_po_line;
2054: end if;
2055: out_rec.po_line_id :=asg_rec.po_line_id;
2056: --
2057: hr_utility.set_location(l_proc,915);
2058: --CWK asg rates
2059: if nvl(fnd_profile.value('PO_SERVICES_ENABLED'),'N') = 'Y' then
2060: fnd_message.set_name('PER','HR_PO_RATE_MESG');
2061: out_rec.grade_rule_id := l_rate_rec.grade_rule_id;
2072: else --try to find the HR assignment rates
2073: open csr_asg_rates(p_assignment_id, p_effective_date);
2074: fetch csr_asg_rates into l_rate_rec;
2075: if csr_asg_rates%notfound then
2076: hr_utility.set_location(l_proc,916);
2077: out_rec.grade_rule_id := null;
2078: out_rec.rate_id := null;
2079: out_rec.rate_name := null;
2080: out_rec.rate_basis := null;
2085: out_rec.rate_effective_start_date := null;
2086: out_rec.rate_effective_end_date := null;
2087: out_rec.rate_object_version_number := null;
2088: elsif csr_asg_rates%found then
2089: hr_utility.set_location(l_proc,917);
2090: out_rec.grade_rule_id := l_rate_rec.grade_rule_id;
2091: out_rec.rate_id := l_rate_rec.rate_id;
2092: out_rec.rate_name := l_rate_rec.rate_name;
2093: out_rec.rate_basis := l_rate_rec.rate_basis;
2103: null;
2104: elsif csr_asg_rates%found then
2105: --this means multiple rates exits. Further update processing will rely on setting
2106: --grade_rule_id but nothing else
2107: hr_utility.set_location(l_proc,918);
2108: fnd_message.set_name('PER','HR_MULTI_RATE_MESG');
2109: out_rec.grade_rule_id := l_rate_rec.grade_rule_id;
2110: out_rec.rate_id := null;
2111: out_rec.rate_name := null;
2121: end if;
2122: close csr_asg_rates;
2123: end if; --end check for PO_SERVICES_ENABLED
2124: --
2125: hr_utility.set_location(l_proc,919);
2126: --
2127: out_rec.ass_attribute_category :=asg_rec.ass_attribute_category;
2128: out_rec.ass_attribute1 :=asg_rec.ass_attribute1;
2129: out_rec.ass_attribute2 :=asg_rec.ass_attribute2;
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: --
2167: if asg_rec.special_ceiling_step_id is not null then
2168: open csr_ceiling_step(asg_rec.special_ceiling_step_id,p_effective_date);
2169: fetch csr_ceiling_step into out_rec.special_ceiling_point, out_rec.special_ceiling_step;
2170: close csr_ceiling_step;
2171: end if;
2172: out_rec.special_ceiling_step_id :=asg_rec.special_ceiling_step_id;
2173: --
2174: hr_utility.set_location(l_proc,930);
2175: --
2176: -- Bug# 4153433 Start Here
2177: --
2178: if asg_rec.assignment_type = 'E' then
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: --
2202: if asg_rec.contract_id is not null then
2203: open csr_reference(asg_rec.contract_id,p_effective_date);
2204: fetch csr_reference into out_rec.contract;
2205: close csr_reference;
2206: end if;
2207: out_rec.contract_id :=asg_rec.contract_id;
2208: --
2209: hr_utility.set_location(l_proc,950);
2210: --
2211: if asg_rec.collective_agreement_id is not null then
2212: open csr_collective_agr(asg_rec.collective_agreement_id);
2213: fetch csr_collective_agr into out_rec.collective_agreement;
2214: close csr_collective_agr;
2215: end if;
2216: out_rec.collective_agreement_id :=asg_rec.collective_agreement_id;
2217: --
2218: hr_utility.set_location(l_proc,960);
2219: --
2220: if asg_rec.cagr_id_flex_num is not null then
2221: open csr_cagr_flex_num(asg_rec.cagr_id_flex_num);
2222: fetch csr_cagr_flex_num into out_rec.cagr_id_flex_name;
2225: out_rec.cagr_id_flex_num :=asg_rec.cagr_id_flex_num;
2226: --
2227: out_rec.cagr_grade_def_id :=asg_rec.cagr_grade_def_id;
2228: --
2229: hr_utility.set_location(l_proc,970);
2230: --
2231: if asg_rec.establishment_id is not null then
2232: out_rec.establishment
2233: :=per_qh_populate.get_organization(asg_rec.establishment_id);
2233: :=per_qh_populate.get_organization(asg_rec.establishment_id);
2234: end if;
2235: out_rec.establishment_id :=asg_rec.establishment_id;
2236: --
2237: hr_utility.set_location(l_proc,980);
2238: --
2239: --Bug 3063591 Start Here
2240: out_rec.work_at_home :=asg_rec.work_at_home;
2241: --Bug 3063591 End Here
2239: --Bug 3063591 Start Here
2240: out_rec.work_at_home :=asg_rec.work_at_home;
2241: --Bug 3063591 End Here
2242: --
2243: hr_utility.set_location(l_proc,985);
2244: --
2245: open csr_pay_proposal(p_assignment_id,p_effective_date);
2246: fetch csr_pay_proposal into pyp_rec;
2247: if csr_pay_proposal%found then
2245: open csr_pay_proposal(p_assignment_id,p_effective_date);
2246: fetch csr_pay_proposal into pyp_rec;
2247: if csr_pay_proposal%found then
2248: --
2249: hr_utility.set_location(l_proc,990);
2250: --
2251: close csr_pay_proposal;
2252: out_rec.pay_proposal_id :=pyp_rec.pay_proposal_id;
2253: out_rec.change_date :=pyp_rec.change_date;
2450: ,p_effective_date => p_effective_date
2451: );
2452: --
2453: end if;
2454: hr_utility.set_location('Leaving: '||l_proc,1000);
2455: --
2456:
2457: end onerow;
2458: --