[Home] [Help]
488: l_legislation_code varchar2(150);
489: l_proc varchar2(72) := g_package||'onerow';
490: --
491: begin
492: hr_utility.set_location('Entering:'|| l_proc, 10);
493: --
494: l_end_of_time:=hr_api.g_eot;
495: --
496: -- get the person record
505: out_rec.tax_update_allowed:='FALSE';
506: else
507: close csr_person_details;
508: --
509: hr_utility.set_location(l_proc, 20);
510: --
511: -- set the output fields
512: --
513: out_rec.person_id :=per_rec.person_id;
527: close csr_get_leg;
528: --
529: out_rec.legislation :=l_legislation_code;
530: --
531: hr_utility.set_location(l_proc, 30);
532: --
533: open csr_person_type(per_rec.person_type_id);
534: fetch csr_person_type into out_rec.person_type,out_rec.system_person_type;
535: close csr_person_type;
537: OPEN csr_person_type_new_1(PER_REC.PERSON_ID,P_EFFECTIVE_DATE,out_rec.system_person_type);
538: FETCH csr_person_type_new_1 INTO PER_REC.PERSON_TYPE_ID;
539: CLOSE csr_person_type_new_1;
540: --
541: hr_utility.set_location(l_proc, 40);
542: --
543: out_rec.person_type_id :=per_rec.person_type_id;
544: out_rec.last_name :=per_rec.last_name;
545: out_rec.start_date :=per_rec.start_date;
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: --
554: if per_rec.person_id is not null then
555: open csr_bg_name(per_rec.person_id,p_effective_date);
556: fetch csr_bg_name into out_rec.business_group_name;
566: fetch csr_lang into out_rec.corr_lang_meaning;
567: close csr_lang;
568: end if;
569: --
570: hr_utility.set_location(l_proc, 60);
571: --
572: out_rec.correspondence_language :=per_rec.correspondence_language;
573: out_rec.current_applicant_flag :=per_rec.current_applicant_flag;
574: out_rec.current_emp_or_apl_flag :=per_rec.current_emp_or_apl_flag;
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: --
589: hr_utility.set_location(l_proc, 70);
590: --
591: out_rec.full_name :=per_rec.full_name;
592: out_rec.hold_applicant_date_until :=per_rec.hold_applicant_date_until;
593: out_rec.honors :=per_rec.honors;
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;
607: --
608: hr_utility.set_location(l_proc, 80);
609: --
610: out_rec.pre_name_adjunct :=per_rec.pre_name_adjunct;
611: out_rec.previous_last_name :=per_rec.previous_last_name;
612: out_rec.rehire_recommendation :=per_rec.rehire_recommendation;
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: --
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;
635: out_rec.dpdnt_vlntry_svce_flag :=per_rec.dpdnt_vlntry_svce_flag;
636: out_rec.receipt_of_death_cert_date :=per_rec.receipt_of_death_cert_date;
637: out_rec.uses_tobacco_flag :=per_rec.uses_tobacco_flag;
638: --
639: hr_utility.set_location(l_proc, 100);
640: --
641: if per_rec.benefit_group_id is not null then
642: open csr_benfts_grp(per_rec.benefit_group_id);
643: fetch csr_benfts_grp into out_rec.benefit_group;
643: fetch csr_benfts_grp into out_rec.benefit_group;
644: close csr_benfts_grp;
645: end if;
646: --
647: hr_utility.set_location(l_proc, 110);
648: --
649: out_rec.benefit_group_id :=per_rec.benefit_group_id;
650: out_rec.attribute_category :=per_rec.attribute_category;
651: out_rec.attribute1 :=per_rec.attribute1;
745: end if;
746: --
747: out_rec.per_object_version_number :=per_rec.object_version_number;
748: --
749: hr_utility.set_location(l_proc, 120);
750: --
751: if per_rec.current_applicant_flag='Y' then
752: --
753: hr_utility.set_location(l_proc, 130);
749: hr_utility.set_location(l_proc, 120);
750: --
751: if per_rec.current_applicant_flag='Y' then
752: --
753: hr_utility.set_location(l_proc, 130);
754: --
755: open csr_application(p_person_id,p_effective_date);
756: fetch csr_application into app_rec;
757: close csr_application;
755: open csr_application(p_person_id,p_effective_date);
756: fetch csr_application into app_rec;
757: close csr_application;
758: --
759: hr_utility.set_location(l_proc, 140);
760: --
761: out_rec.application_id :=app_rec.application_id;
762: out_rec.projected_hire_date :=app_rec.projected_hire_date;
763: out_rec.appl_attribute_category :=app_rec.appl_attribute_category;
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;
792: --
793: hr_utility.set_location(l_proc, 150);
794: --
795: -- Bug 3540524 Starts Here
796: -- Description : Bring the data back to form even if the person is not an employee.
797: -- Here this restriction is blocking the Adjusted service date to propagate
799: -- in the form to prevent an update of the Adjusted Service date, if the person
800: -- is not an employee.
801: -- if per_rec.current_employee_flag='Y' then
802: --
803: hr_utility.set_location(l_proc, 160);
804: --
805: open csr_period_of_svc(p_person_id,p_effective_date);
806: fetch csr_period_of_svc into pds_rec;
807: close csr_period_of_svc;
824: --New check to verify the system_person_type is required as part of 5507008
825: -- added CWK and EX_EMP for the bug#10223423
826: if out_rec.SYSTEM_PERSON_TYPE in ('OTHER','APL','CWK','EX_EMP') then
827: --
828: hr_utility.set_location(l_proc, 165);
829: --
830: open csr_period_of_placement(p_person_id,p_effective_date);
831: fetch csr_period_of_placement into pdp_rec;
832: close csr_period_of_placement;
836: out_rec.employment_end_date:=NVL(pdp_rec.final_process_date,pds_rec.final_process_date); --Modified for bu#12411175
837:
838: end if;
839: -- end of fix 5507008
840: hr_utility.set_location(l_proc, 170);
841: --
842: hr_utility.set_location(l_proc, 180);
843: --
844: open csr_addresses(p_person_id,p_effective_date);
838: end if;
839: -- end of fix 5507008
840: hr_utility.set_location(l_proc, 170);
841: --
842: hr_utility.set_location(l_proc, 180);
843: --
844: open csr_addresses(p_person_id,p_effective_date);
845: fetch csr_addresses into addr_rec;
846: if csr_addresses%found then
844: open csr_addresses(p_person_id,p_effective_date);
845: fetch csr_addresses into addr_rec;
846: if csr_addresses%found then
847: --
848: hr_utility.set_location(l_proc, 190);
849: --
850: close csr_addresses;
851: out_rec.address_id :=addr_rec.address_id;
852: out_rec.adr_date_from :=addr_rec.date_from;
855: open csr_address_style(addr_rec.style);
856: fetch csr_address_style into out_rec.style_meaning;
857: close csr_address_style;
858: --
859: hr_utility.set_location(l_proc, 200);
860: --
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;
904: out_rec.addr_attribute19 :=addr_rec.addr_attribute19;
905: out_rec.addr_attribute20 :=addr_rec.addr_attribute20;
906: out_rec.addr_object_version_number :=addr_rec.object_version_number;
907: --
908: hr_utility.set_location(l_proc, 240);
909: else
910: close csr_addresses;
911: end if;
912: --
909: else
910: close csr_addresses;
911: end if;
912: --
913: hr_utility.set_location(l_proc, 250);
914: --
915: open csr_phone(p_person_id,'H1',p_effective_date);
916: fetch csr_phone into phn_rec;
917: if csr_phone%found then
915: open csr_phone(p_person_id,'H1',p_effective_date);
916: fetch csr_phone into phn_rec;
917: if csr_phone%found then
918: --
919: hr_utility.set_location(l_proc, 260);
920: --
921: close csr_phone;
922: out_rec.phn_h_phone_id :=phn_rec.phone_id;
923: out_rec.phn_h_date_from :=phn_rec.date_from;
927: else
928: close csr_phone;
929: end if;
930: --
931: hr_utility.set_location(l_proc, 270);
932: --
933: open csr_phone(p_person_id,'W1',p_effective_date);
934: fetch csr_phone into phn_rec;
935: if csr_phone%found then
933: open csr_phone(p_person_id,'W1',p_effective_date);
934: fetch csr_phone into phn_rec;
935: if csr_phone%found then
936: --
937: hr_utility.set_location(l_proc, 280);
938: --
939: close csr_phone;
940: out_rec.phn_w_phone_id :=phn_rec.phone_id;
941: out_rec.phn_w_date_from :=phn_rec.date_from;
945: else
946: close csr_phone;
947: end if;
948: --
949: hr_utility.set_location(l_proc, 290);
950: --
951: open csr_phone(p_person_id,'M',p_effective_date);
952: fetch csr_phone into phn_rec;
953: if csr_phone%found then
951: open csr_phone(p_person_id,'M',p_effective_date);
952: fetch csr_phone into phn_rec;
953: if csr_phone%found then
954: --
955: hr_utility.set_location(l_proc, 300);
956: --
957: close csr_phone;
958: out_rec.phn_m_phone_id :=phn_rec.phone_id;
959: out_rec.phn_m_date_from :=phn_rec.date_from;
963: else
964: close csr_phone;
965: end if;
966: --
967: hr_utility.set_location(l_proc, 310);
968: --
969: open csr_phone(p_person_id,'HF',p_effective_date);
970: fetch csr_phone into phn_rec;
971: if csr_phone%found then
969: open csr_phone(p_person_id,'HF',p_effective_date);
970: fetch csr_phone into phn_rec;
971: if csr_phone%found then
972: --
973: hr_utility.set_location(l_proc, 320);
974: --
975: close csr_phone;
976: out_rec.phn_hf_phone_id :=phn_rec.phone_id;
977: out_rec.phn_hf_date_from :=phn_rec.date_from;
981: else
982: close csr_phone;
983: end if;
984: --
985: hr_utility.set_location(l_proc, 330);
986: --
987: open csr_phone(p_person_id,'WF',p_effective_date);
988: fetch csr_phone into phn_rec;
989: if csr_phone%found then
987: open csr_phone(p_person_id,'WF',p_effective_date);
988: fetch csr_phone into phn_rec;
989: if csr_phone%found then
990: --
991: hr_utility.set_location(l_proc, 340);
992: --
993: close csr_phone;
994: out_rec.phn_wf_phone_id :=phn_rec.phone_id;
995: out_rec.phn_wf_date_from :=phn_rec.date_from;
999: else
1000: close csr_phone;
1001: end if;
1002: --
1003: hr_utility.set_location(l_proc, 350);
1004: --
1005: open csr_deployment(p_person_id);
1006: fetch csr_deployment into dpf_rec;
1007: if csr_deployment%found then
1005: open csr_deployment(p_person_id);
1006: fetch csr_deployment into dpf_rec;
1007: if csr_deployment%found then
1008: --
1009: hr_utility.set_location(l_proc, 360);
1010: --
1011: out_rec.deployment_factor_id :=dpf_rec.deployment_factor_id;
1012: out_rec.work_any_country :=dpf_rec.work_any_country;
1013: out_rec.work_any_location :=dpf_rec.work_any_location;
1014: out_rec.relocate_domestically :=dpf_rec.relocate_domestically;
1015: out_rec.relocate_internationally :=dpf_rec.relocate_internationally;
1016: out_rec.travel_required :=dpf_rec.travel_required;
1017: --
1018: hr_utility.set_location(l_proc, 370);
1019: --
1020: if dpf_rec.country1 is not null then
1021: --
1022: hr_utility.set_location(l_proc, 380);
1018: hr_utility.set_location(l_proc, 370);
1019: --
1020: if dpf_rec.country1 is not null then
1021: --
1022: hr_utility.set_location(l_proc, 380);
1023: --
1024: open csr_country(dpf_rec.country1);
1025: fetch csr_country into out_rec.country1_meaning;
1026: close csr_country;
1028: out_rec.country1 :=dpf_rec.country1;
1029: --
1030: if dpf_rec.country2 is not null then
1031: --
1032: hr_utility.set_location(l_proc, 390);
1033: --
1034: open csr_country(dpf_rec.country2);
1035: fetch csr_country into out_rec.country2_meaning;
1036: close csr_country;
1038: out_rec.country2 :=dpf_rec.country2;
1039: --
1040: if dpf_rec.country3 is not null then
1041: --
1042: hr_utility.set_location(l_proc, 400);
1043: --
1044: open csr_country(dpf_rec.country3);
1045: fetch csr_country into out_rec.country3_meaning;
1046: close csr_country;
1046: close csr_country;
1047: end if;
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);
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: --
1063: hr_utility.set_location(l_proc, 420);
1064: --
1065: if dpf_rec.no_country1 is not null then
1066: --
1067: hr_utility.set_location(l_proc, 430);
1063: hr_utility.set_location(l_proc, 420);
1064: --
1065: if dpf_rec.no_country1 is not null then
1066: --
1067: hr_utility.set_location(l_proc, 430);
1068: --
1069: open csr_country(dpf_rec.no_country1);
1070: fetch csr_country into out_rec.no_country1_meaning;
1071: close csr_country;
1073: out_rec.no_country1 :=dpf_rec.no_country1;
1074: --
1075: if dpf_rec.no_country2 is not null then
1076: --
1077: hr_utility.set_location(l_proc, 440);
1078: --
1079: open csr_country(dpf_rec.no_country2);
1080: fetch csr_country into out_rec.no_country2_meaning;
1081: close csr_country;
1083: out_rec.no_country2 :=dpf_rec.no_country2;
1084: --
1085: if dpf_rec.no_country3 is not null then
1086: --
1087: hr_utility.set_location(l_proc, 450);
1088: --
1089: open csr_country(dpf_rec.no_country3);
1090: fetch csr_country into out_rec.no_country3_meaning;
1091: close csr_country;
1092: end if;
1093: out_rec.no_country3 :=dpf_rec.no_country3;
1094: --
1095: --
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);
1121: out_rec.dpf_attribute18 :=dpf_rec.attribute18;
1122: out_rec.dpf_attribute19 :=dpf_rec.attribute19;
1123: out_rec.dpf_attribute20 :=dpf_rec.attribute20;
1124: --
1125: hr_utility.set_location(l_proc, 470);
1126: --
1127: else
1128: close csr_deployment;
1129: end if;
1131: open csr_template(per_per_bus.return_legislation_code(p_person_id));
1132: fetch csr_template into l_form_template_id;
1133: close csr_template;
1134: --
1135: hr_utility.set_location(l_proc, 475);
1136: --
1137: open csr_template_items
1138: (p_form_template_id => l_form_template_id
1139: ,p_full_item_name => p_block_name||'.CHK1_ITEM_CODE_MEANING'
1140: );
1141: fetch csr_template_items into l_template_item;
1142: --
1143: IF (csr_template_items%found) THEN
1144: hr_utility.set_location(l_proc, 480);
1145: close csr_template_items;
1146: open csr_template_item_contexts
1147: (p_template_item_id => l_template_item.template_item_id
1148: ,p_emp_apl_flag => out_rec.person_type
1158: --
1159: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1160: fetch reverse_lookup into chk_rec.item_code;
1161: if reverse_lookup%found then
1162: hr_utility.set_location(l_proc, 485);
1163: close reverse_lookup;
1164: out_rec.chk1_item_code_meaning:=l_default_value;
1165: out_rec.chk1_item_code :=chk_rec.item_code;
1166: --
1167: open csr_checklist(p_person_id, chk_rec.item_code);
1168: fetch csr_checklist into chk_rec;
1169: if csr_checklist%found then
1170: --
1171: hr_utility.set_location(l_proc, 490);
1172: --
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;
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: --
1182: hr_utility.set_location(l_proc,495);
1183: --
1184: else
1185: close csr_checklist;
1186: end if;
1184: else
1185: close csr_checklist;
1186: end if;
1187: else
1188: hr_utility.set_location(l_proc,500);
1189: close reverse_lookup;
1190: out_rec.chk1_item_code_meaning:=null;
1191: out_rec.chk1_item_code :=null;
1192: end if;
1194: else
1195: close csr_template_items;
1196: END IF;
1197: --
1198: hr_utility.set_location(l_proc, 505);
1199: open csr_template_items
1200: (p_form_template_id => l_form_template_id
1201: ,p_full_item_name => p_block_name||'.CHK2_ITEM_CODE_MEANING'
1202: );
1202: );
1203: fetch csr_template_items into l_template_item;
1204: --
1205: IF (csr_template_items%found) THEN
1206: hr_utility.set_location(l_proc, 510);
1207: close csr_template_items;
1208: open csr_template_item_contexts
1209: (p_template_item_id => l_template_item.template_item_id
1210: ,p_emp_apl_flag => out_rec.person_type
1220: --
1221: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1222: fetch reverse_lookup into chk_rec.item_code;
1223: if reverse_lookup%found then
1224: hr_utility.set_location(l_proc, 515);
1225: close reverse_lookup;
1226: out_rec.chk2_item_code_meaning:=l_default_value;
1227: out_rec.chk2_item_code :=chk_rec.item_code;
1228: --
1229: open csr_checklist(p_person_id, chk_rec.item_code);
1230: fetch csr_checklist into chk_rec;
1231: if csr_checklist%found then
1232: --
1233: hr_utility.set_location(l_proc, 520);
1234: --
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;
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: --
1244: hr_utility.set_location(l_proc,525);
1245: --
1246: else
1247: close csr_checklist;
1248: end if;
1246: else
1247: close csr_checklist;
1248: end if;
1249: else
1250: hr_utility.set_location(l_proc,530);
1251: close reverse_lookup;
1252: out_rec.chk2_item_code_meaning:=null;
1253: out_rec.chk2_item_code :=null;
1254: end if;
1256: else
1257: close csr_template_items;
1258: END IF;
1259: --
1260: hr_utility.set_location(l_proc,535);
1261: --
1262: open csr_template_items
1263: (p_form_template_id => l_form_template_id
1264: ,p_full_item_name => p_block_name||'.CHK3_ITEM_CODE_MEANING'
1265: );
1266: fetch csr_template_items into l_template_item;
1267: --
1268: IF (csr_template_items%found) THEN
1269: hr_utility.set_location(l_proc, 540);
1270: close csr_template_items;
1271: open csr_template_item_contexts
1272: (p_template_item_id => l_template_item.template_item_id
1273: ,p_emp_apl_flag => out_rec.person_type
1283: --
1284: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1285: fetch reverse_lookup into chk_rec.item_code;
1286: if reverse_lookup%found then
1287: hr_utility.set_location(l_proc, 545);
1288: close reverse_lookup;
1289: out_rec.chk3_item_code_meaning:=l_default_value;
1290: out_rec.chk3_item_code :=chk_rec.item_code;
1291: --
1292: open csr_checklist(p_person_id, chk_rec.item_code);
1293: fetch csr_checklist into chk_rec;
1294: if csr_checklist%found then
1295: --
1296: hr_utility.set_location(l_proc, 550);
1297: --
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;
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: --
1307: hr_utility.set_location(l_proc,555);
1308: --
1309: else
1310: close csr_checklist;
1311: end if;
1309: else
1310: close csr_checklist;
1311: end if;
1312: else
1313: hr_utility.set_location(l_proc,560);
1314: close reverse_lookup;
1315: out_rec.chk3_item_code_meaning:=null;
1316: out_rec.chk3_item_code :=null;
1317: end if;
1319: else
1320: close csr_template_items;
1321: END IF;
1322: --
1323: hr_utility.set_location(l_proc,565);
1324: --
1325: open csr_template_items
1326: (p_form_template_id => l_form_template_id
1327: ,p_full_item_name => p_block_name||'.CHK4_ITEM_CODE_MEANING'
1328: );
1329: fetch csr_template_items into l_template_item;
1330: --
1331: IF (csr_template_items%found) THEN
1332: hr_utility.set_location(l_proc, 570);
1333: close csr_template_items;
1334: open csr_template_item_contexts
1335: (p_template_item_id => l_template_item.template_item_id
1336: ,p_emp_apl_flag => out_rec.person_type
1346: --
1347: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1348: fetch reverse_lookup into chk_rec.item_code;
1349: if reverse_lookup%found then
1350: hr_utility.set_location(l_proc, 575);
1351: close reverse_lookup;
1352: out_rec.chk4_item_code_meaning:=l_default_value;
1353: out_rec.chk4_item_code :=chk_rec.item_code;
1354: --
1355: open csr_checklist(p_person_id, chk_rec.item_code);
1356: fetch csr_checklist into chk_rec;
1357: if csr_checklist%found then
1358: --
1359: hr_utility.set_location(l_proc, 580);
1360: --
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;
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: --
1370: hr_utility.set_location(l_proc,585);
1371: --
1372: else
1373: close csr_checklist;
1374: end if;
1372: else
1373: close csr_checklist;
1374: end if;
1375: else
1376: hr_utility.set_location(l_proc,590);
1377: close reverse_lookup;
1378: out_rec.chk4_item_code_meaning:=null;
1379: out_rec.chk4_item_code :=null;
1380: end if;
1382: else
1383: close csr_template_items;
1384: END IF;
1385: --
1386: hr_utility.set_location(l_proc,595);
1387: --
1388: open csr_template_items
1389: (p_form_template_id => l_form_template_id
1390: ,p_full_item_name => p_block_name||'.CHK5_ITEM_CODE_MEANING'
1391: );
1392: fetch csr_template_items into l_template_item;
1393: --
1394: IF (csr_template_items%found) THEN
1395: hr_utility.set_location(l_proc, 600);
1396: close csr_template_items;
1397: open csr_template_item_contexts
1398: (p_template_item_id => l_template_item.template_item_id
1399: ,p_emp_apl_flag => out_rec.person_type
1409: --
1410: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1411: fetch reverse_lookup into chk_rec.item_code;
1412: if reverse_lookup%found then
1413: hr_utility.set_location(l_proc, 605);
1414: close reverse_lookup;
1415: out_rec.chk5_item_code_meaning:=l_default_value;
1416: out_rec.chk5_item_code :=chk_rec.item_code;
1417: --
1418: open csr_checklist(p_person_id, chk_rec.item_code);
1419: fetch csr_checklist into chk_rec;
1420: if csr_checklist%found then
1421: --
1422: hr_utility.set_location(l_proc, 610);
1423: --
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;
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: --
1433: hr_utility.set_location(l_proc,615);
1434: --
1435: else
1436: close csr_checklist;
1437: end if;
1435: else
1436: close csr_checklist;
1437: end if;
1438: else
1439: hr_utility.set_location(l_proc,620);
1440: close reverse_lookup;
1441: out_rec.chk5_item_code_meaning:=null;
1442: out_rec.chk5_item_code :=null;
1443: end if;
1445: else
1446: close csr_template_items;
1447: END IF;
1448: --
1449: hr_utility.set_location(l_proc,625);
1450: --
1451: open csr_template_items
1452: (p_form_template_id => l_form_template_id
1453: ,p_full_item_name => p_block_name||'.CHK6_ITEM_CODE_MEANING'
1454: );
1455: fetch csr_template_items into l_template_item;
1456: --
1457: IF (csr_template_items%found) THEN
1458: hr_utility.set_location(l_proc, 630);
1459: close csr_template_items;
1460: open csr_template_item_contexts
1461: (p_template_item_id => l_template_item.template_item_id
1462: ,p_emp_apl_flag => out_rec.person_type
1472: --
1473: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1474: fetch reverse_lookup into chk_rec.item_code;
1475: if reverse_lookup%found then
1476: hr_utility.set_location(l_proc, 635);
1477: close reverse_lookup;
1478: out_rec.chk6_item_code_meaning:=l_default_value;
1479: out_rec.chk6_item_code :=chk_rec.item_code;
1480: --
1481: open csr_checklist(p_person_id, chk_rec.item_code);
1482: fetch csr_checklist into chk_rec;
1483: if csr_checklist%found then
1484: --
1485: hr_utility.set_location(l_proc, 640);
1486: --
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;
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: --
1496: hr_utility.set_location(l_proc,645);
1497: --
1498: else
1499: close csr_checklist;
1500: end if;
1498: else
1499: close csr_checklist;
1500: end if;
1501: else
1502: hr_utility.set_location(l_proc,650);
1503: close reverse_lookup;
1504: out_rec.chk6_item_code_meaning:=null;
1505: out_rec.chk6_item_code :=null;
1506: end if;
1508: else
1509: close csr_template_items;
1510: END IF;
1511: --
1512: hr_utility.set_location(l_proc,655);
1513: --
1514: open csr_template_items
1515: (p_form_template_id => l_form_template_id
1516: ,p_full_item_name => p_block_name||'.CHK7_ITEM_CODE_MEANING'
1517: );
1518: fetch csr_template_items into l_template_item;
1519: --
1520: IF (csr_template_items%found) THEN
1521: hr_utility.set_location(l_proc, 660);
1522: close csr_template_items;
1523: open csr_template_item_contexts
1524: (p_template_item_id => l_template_item.template_item_id
1525: ,p_emp_apl_flag => out_rec.person_type
1535: --
1536: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1537: fetch reverse_lookup into chk_rec.item_code;
1538: if reverse_lookup%found then
1539: hr_utility.set_location(l_proc, 665);
1540: close reverse_lookup;
1541: out_rec.chk7_item_code_meaning:=l_default_value;
1542: out_rec.chk7_item_code :=chk_rec.item_code;
1543: --
1544: open csr_checklist(p_person_id, chk_rec.item_code);
1545: fetch csr_checklist into chk_rec;
1546: if csr_checklist%found then
1547: --
1548: hr_utility.set_location(l_proc, 670);
1549: --
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;
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: --
1559: hr_utility.set_location(l_proc,675);
1560: --
1561: else
1562: close csr_checklist;
1563: end if;
1561: else
1562: close csr_checklist;
1563: end if;
1564: else
1565: hr_utility.set_location(l_proc,680);
1566: close reverse_lookup;
1567: out_rec.chk7_item_code_meaning:=null;
1568: out_rec.chk7_item_code :=null;
1569: end if;
1571: else
1572: close csr_template_items;
1573: END IF;
1574: --
1575: hr_utility.set_location(l_proc,685);
1576: --
1577: open csr_template_items
1578: (p_form_template_id => l_form_template_id
1579: ,p_full_item_name => p_block_name||'.CHK8_ITEM_CODE_MEANING'
1580: );
1581: fetch csr_template_items into l_template_item;
1582: --
1583: IF (csr_template_items%found) THEN
1584: hr_utility.set_location(l_proc, 690);
1585: close csr_template_items;
1586: open csr_template_item_contexts
1587: (p_template_item_id => l_template_item.template_item_id
1588: ,p_emp_apl_flag => out_rec.person_type
1598: --
1599: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1600: fetch reverse_lookup into chk_rec.item_code;
1601: if reverse_lookup%found then
1602: hr_utility.set_location(l_proc, 695);
1603: close reverse_lookup;
1604: out_rec.chk8_item_code_meaning:=l_default_value;
1605: out_rec.chk8_item_code :=chk_rec.item_code;
1606: --
1607: open csr_checklist(p_person_id, chk_rec.item_code);
1608: fetch csr_checklist into chk_rec;
1609: if csr_checklist%found then
1610: --
1611: hr_utility.set_location(l_proc, 700);
1612: --
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;
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: --
1622: hr_utility.set_location(l_proc,705);
1623: --
1624: else
1625: close csr_checklist;
1626: end if;
1624: else
1625: close csr_checklist;
1626: end if;
1627: else
1628: hr_utility.set_location(l_proc,710);
1629: close reverse_lookup;
1630: out_rec.chk8_item_code_meaning:=null;
1631: out_rec.chk8_item_code :=null;
1632: end if;
1634: else
1635: close csr_template_items;
1636: END IF;
1637: --
1638: hr_utility.set_location(l_proc,715);
1639: --
1640: open csr_template_items
1641: (p_form_template_id => l_form_template_id
1642: ,p_full_item_name => p_block_name||'.CHK9_ITEM_CODE_MEANING'
1643: );
1644: fetch csr_template_items into l_template_item;
1645: --
1646: IF (csr_template_items%found) THEN
1647: hr_utility.set_location(l_proc, 720);
1648: close csr_template_items;
1649: open csr_template_item_contexts
1650: (p_template_item_id => l_template_item.template_item_id
1651: ,p_emp_apl_flag => out_rec.person_type
1661: --
1662: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1663: fetch reverse_lookup into chk_rec.item_code;
1664: if reverse_lookup%found then
1665: hr_utility.set_location(l_proc, 725);
1666: close reverse_lookup;
1667: out_rec.chk9_item_code_meaning:=l_default_value;
1668: out_rec.chk9_item_code :=chk_rec.item_code;
1669: --
1670: open csr_checklist(p_person_id, chk_rec.item_code);
1671: fetch csr_checklist into chk_rec;
1672: if csr_checklist%found then
1673: --
1674: hr_utility.set_location(l_proc, 730);
1675: --
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;
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: --
1685: hr_utility.set_location(l_proc,735);
1686: --
1687: else
1688: close csr_checklist;
1689: end if;
1687: else
1688: close csr_checklist;
1689: end if;
1690: else
1691: hr_utility.set_location(l_proc,740);
1692: close reverse_lookup;
1693: out_rec.chk9_item_code_meaning:=null;
1694: out_rec.chk9_item_code :=null;
1695: end if;
1697: else
1698: close csr_template_items;
1699: END IF;
1700: --
1701: hr_utility.set_location(l_proc,745);
1702: --
1703: open csr_template_items
1704: (p_form_template_id => l_form_template_id
1705: ,p_full_item_name => p_block_name||'.CHK10_ITEM_CODE_MEANING'
1706: );
1707: fetch csr_template_items into l_template_item;
1708: --
1709: IF (csr_template_items%found) THEN
1710: hr_utility.set_location(l_proc, 750);
1711: close csr_template_items;
1712: open csr_template_item_contexts
1713: (p_template_item_id => l_template_item.template_item_id
1714: ,p_emp_apl_flag => out_rec.person_type
1724: --
1725: open reverse_lookup(l_default_value,'CHECKLIST_ITEM');
1726: fetch reverse_lookup into chk_rec.item_code;
1727: if reverse_lookup%found then
1728: hr_utility.set_location(l_proc, 755);
1729: close reverse_lookup;
1730: out_rec.chk10_item_code_meaning:=l_default_value;
1731: out_rec.chk10_item_code :=chk_rec.item_code;
1732: --
1733: open csr_checklist(p_person_id, chk_rec.item_code);
1734: fetch csr_checklist into chk_rec;
1735: if csr_checklist%found then
1736: --
1737: hr_utility.set_location(l_proc, 760);
1738: --
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;
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: --
1748: hr_utility.set_location(l_proc,765);
1749: --
1750: else
1751: close csr_checklist;
1752: end if;
1750: else
1751: close csr_checklist;
1752: end if;
1753: else
1754: hr_utility.set_location(l_proc,770);
1755: close reverse_lookup;
1756: out_rec.chk10_item_code_meaning:=null;
1757: out_rec.chk10_item_code :=null;
1758: end if;
1760: else
1761: close csr_template_items;
1762: END IF;
1763: --
1764: hr_utility.set_location(l_proc,771);
1765: hr_utility.trace('p_assignment_id : ' || p_assignment_id);
1766: hr_utility.trace('p_effective_date : ' || p_effective_date);
1767: --
1768: if p_assignment_id is not null then
1761: close csr_template_items;
1762: END IF;
1763: --
1764: hr_utility.set_location(l_proc,771);
1765: hr_utility.trace('p_assignment_id : ' || p_assignment_id);
1766: hr_utility.trace('p_effective_date : ' || p_effective_date);
1767: --
1768: if p_assignment_id is not null then
1769: --
1762: END IF;
1763: --
1764: hr_utility.set_location(l_proc,771);
1765: hr_utility.trace('p_assignment_id : ' || p_assignment_id);
1766: hr_utility.trace('p_effective_date : ' || p_effective_date);
1767: --
1768: if p_assignment_id is not null then
1769: --
1770: hr_utility.set_location(l_proc,772);
1766: hr_utility.trace('p_effective_date : ' || p_effective_date);
1767: --
1768: if p_assignment_id is not null then
1769: --
1770: hr_utility.set_location(l_proc,772);
1771: --
1772: open csr_assignment_details(p_assignment_id,p_effective_date);
1773: fetch csr_assignment_details into asg_rec;
1774: if csr_assignment_details%notfound then
1776: out_rec.assignment_id:=-1;
1777: --no assignment found mean person is OTHER or EX-something
1778: --flag up that the fields should be disabled, fixes bug 3929761
1779: out_rec.asg_update_allowed:='FALSE';
1780: hr_utility.set_location(l_proc,773);
1781: else
1782: --
1783: hr_utility.set_location(l_proc,774);
1784: --
1779: out_rec.asg_update_allowed:='FALSE';
1780: hr_utility.set_location(l_proc,773);
1781: else
1782: --
1783: hr_utility.set_location(l_proc,774);
1784: --
1785: out_rec.assignment_id :=asg_rec.assignment_id;
1786: out_rec.asg_effective_start_date :=asg_rec.effective_start_date;
1787: out_rec.asg_effective_end_date :=asg_rec.effective_end_date;
1791: else
1792: out_rec.asg_update_allowed:='FALSE';
1793: end if;
1794: --
1795: hr_utility.set_location(l_proc,775);
1796: --
1797: if asg_rec.recruiter_id is not null then
1798: out_rec.recruiter
1799: :=per_qh_populate.get_full_name(asg_rec.recruiter_id,p_effective_date);
1799: :=per_qh_populate.get_full_name(asg_rec.recruiter_id,p_effective_date);
1800: end if;
1801: out_rec.recruiter_id :=asg_rec.recruiter_id;
1802: --
1803: hr_utility.set_location(l_proc,776);
1804: --
1805: if asg_rec.grade_id is not null then
1806: out_rec.grade:=per_qh_populate.get_grade(asg_rec.grade_id);
1807: end if;
1806: out_rec.grade:=per_qh_populate.get_grade(asg_rec.grade_id);
1807: end if;
1808: out_rec.grade_id :=asg_rec.grade_id;
1809: --
1810: hr_utility.set_location(l_proc,777);
1811: --
1812: if asg_rec.grade_ladder_pgm_id is not null then
1813: out_rec.grade_ladder
1814: := per_qh_populate.get_grade_ladder(asg_rec.grade_ladder_pgm_id
1815: ,p_effective_date);
1816: end if;
1817: out_rec.grade_ladder_pgm_id := asg_rec.grade_ladder_pgm_id;
1818: --
1819: hr_utility.set_location(l_proc,778);
1820: --
1821: if asg_rec.position_id is not null then
1822: out_rec.position
1823: :=per_qh_populate.get_position(asg_rec.position_id,p_effective_date);
1823: :=per_qh_populate.get_position(asg_rec.position_id,p_effective_date);
1824: end if;
1825: out_rec.position_id :=asg_rec.position_id;
1826: --
1827: hr_utility.set_location(l_proc,779);
1828: --
1829: if asg_rec.job_id is not null then
1830: out_rec.job:=per_qh_populate.get_job(asg_rec.job_id);
1831: end if;
1830: out_rec.job:=per_qh_populate.get_job(asg_rec.job_id);
1831: end if;
1832: out_rec.job_id :=asg_rec.job_id;
1833: --
1834: hr_utility.set_location(l_proc,780);
1835: --
1836: open csr_asg_status(asg_rec.assignment_status_type_id,asg_rec.business_group_id);
1837: fetch csr_asg_status into out_rec.assignment_status_type,out_rec.system_status;
1838: close csr_asg_status;
1837: fetch csr_asg_status into out_rec.assignment_status_type,out_rec.system_status;
1838: close csr_asg_status;
1839: out_rec.assignment_status_type_id :=asg_rec.assignment_status_type_id;
1840: --
1841: hr_utility.set_location(l_proc,782);
1842: --
1843: if asg_rec.payroll_id is not null then
1844: out_rec.payroll:=
1845: per_qh_populate.get_payroll(asg_rec.payroll_id,p_effective_date);
1845: per_qh_populate.get_payroll(asg_rec.payroll_id,p_effective_date);
1846: end if;
1847: out_rec.payroll_id :=asg_rec.payroll_id;
1848: --
1849: hr_utility.set_location(l_proc,785);
1850: --
1851: if asg_rec.location_id is not null then
1852: out_rec.location:=per_qh_populate.get_location(asg_rec.location_id);
1853: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1853: out_rec.location_address:=hr_general.hr_lookup_locations(asg_rec.location_id);
1854: end if;
1855: out_rec.location_id :=asg_rec.location_id;
1856: --
1857: hr_utility.set_location(l_proc,790);
1858: --
1859: if asg_rec.person_referred_by_id is not null then
1860: out_rec.person_referred_by:=
1861: per_qh_populate.get_full_name(asg_rec.person_referred_by_id,p_effective_date);
1861: per_qh_populate.get_full_name(asg_rec.person_referred_by_id,p_effective_date);
1862: end if;
1863: out_rec.person_referred_by_id :=asg_rec.person_referred_by_id;
1864: --
1865: hr_utility.set_location(l_proc,800);
1866: --
1867: if asg_rec.supervisor_id is not null then
1868: out_rec.supervisor:=
1869: per_qh_populate.get_full_name(asg_rec.supervisor_id,p_effective_date);
1869: per_qh_populate.get_full_name(asg_rec.supervisor_id,p_effective_date);
1870: end if;
1871: out_rec.supervisor_id :=asg_rec.supervisor_id;
1872: --
1873: hr_utility.set_location(l_proc,805);
1874: --
1875: if asg_rec.supervisor_assignment_id is not null then
1876: out_rec.supervisor_assignment_number :=
1877: per_qh_populate.get_supervisor_assgn_number(
1878: asg_rec.supervisor_assignment_id,asg_rec.business_group_id);
1879: end if;
1880: out_rec.supervisor_assignment_id := asg_rec.supervisor_assignment_id;
1881: --
1882: hr_utility.set_location(l_proc,810);
1883: --
1884: if asg_rec.recruitment_activity_id is not null then
1885: open csr_rec_activity(asg_rec.recruitment_activity_id);
1886: fetch csr_rec_activity into out_rec.recruitment_activity;
1887: close csr_rec_activity;
1888: end if;
1889: out_rec.recruitment_activity_id :=asg_rec.recruitment_activity_id;
1890: --
1891: hr_utility.set_location(l_proc,820);
1892: --
1893: if asg_rec.source_organization_id is not null then
1894: out_rec.source_organization
1895: :=per_qh_populate.get_organization(asg_rec.source_organization_id);
1895: :=per_qh_populate.get_organization(asg_rec.source_organization_id);
1896: end if;
1897: out_rec.source_organization_id :=asg_rec.source_organization_id;
1898: --
1899: hr_utility.set_location(l_proc,830);
1900: --
1901: out_rec.organization
1902: :=per_qh_populate.get_organization(asg_rec.organization_id);
1903: out_rec.organization_id :=asg_rec.organization_id;
1901: out_rec.organization
1902: :=per_qh_populate.get_organization(asg_rec.organization_id);
1903: out_rec.organization_id :=asg_rec.organization_id;
1904: --
1905: hr_utility.set_location(l_proc,840);
1906: --
1907: if asg_rec.people_group_id is not null then
1908: open csr_pgp_rec(asg_rec.people_group_id);
1909: fetch csr_pgp_rec into pgp_rec;
1908: open csr_pgp_rec(asg_rec.people_group_id);
1909: fetch csr_pgp_rec into pgp_rec;
1910: close csr_pgp_rec;
1911: --
1912: hr_utility.set_location(l_proc,850);
1913: --
1914: out_rec.pgp_segment1 :=pgp_rec.segment1;
1915: out_rec.pgp_segment2 :=pgp_rec.segment2;
1916: out_rec.pgp_segment3 :=pgp_rec.segment3;
1943: out_rec.pgp_segment30 :=pgp_rec.segment30;
1944: end if;
1945: out_rec.people_group_id :=asg_rec.people_group_id;
1946: --
1947: hr_utility.set_location(l_proc,860);
1948: --
1949: if asg_rec.soft_coding_keyflex_id is not null then
1950: open csr_scl_rec(asg_rec.soft_coding_keyflex_id);
1951: fetch csr_scl_rec into scl_rec;
1950: open csr_scl_rec(asg_rec.soft_coding_keyflex_id);
1951: fetch csr_scl_rec into scl_rec;
1952: close csr_scl_rec;
1953: --
1954: hr_utility.set_location(l_proc,870);
1955: --
1956: out_rec.scl_segment1 :=scl_rec.segment1;
1957: out_rec.scl_segment2 :=scl_rec.segment2;
1958: out_rec.scl_segment3 :=scl_rec.segment3;
1985: out_rec.scl_segment30 :=scl_rec.segment30;
1986: end if;
1987: out_rec.soft_coding_keyflex_id :=asg_rec.soft_coding_keyflex_id;
1988: --
1989: hr_utility.set_location(l_proc,880);
1990: --
1991: if asg_rec.vacancy_id is not null then
1992: open csr_vacancy(asg_rec.vacancy_id);
1993: fetch csr_vacancy into out_rec.vacancy,out_rec.requisition;
1994: close csr_vacancy;
1995: end if;
1996: out_rec.vacancy_id :=asg_rec.vacancy_id;
1997: --
1998: hr_utility.set_location(l_proc,890);
1999: --
2000: if asg_rec.pay_basis_id is not null then
2001: open salary_basis(p_effective_date,asg_rec.pay_basis_id);
2002: fetch salary_basis into
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;
2020: out_rec.assignment_type :=asg_rec.assignment_type;
2021: out_rec.asg_primary_flag :=asg_rec.primary_flag;
2052: out_rec.billing_title :=asg_rec.title;
2053: out_rec.time_normal_finish :=asg_rec.time_normal_finish;
2054: out_rec.time_normal_start :=asg_rec.time_normal_start;
2055: --
2056: hr_utility.set_location(l_proc,910);
2057: --
2058: --CWK asg fields
2059: out_rec.projected_assignment_end :=asg_rec.projected_assignment_end;
2060: out_rec.vendor_employee_number :=asg_rec.vendor_employee_number;
2087: close csr_po_line;
2088: end if;
2089: out_rec.po_line_id :=asg_rec.po_line_id;
2090: --
2091: hr_utility.set_location(l_proc,915);
2092: --CWK asg rates
2093: if nvl(fnd_profile.value('PO_SERVICES_ENABLED'),'N') = 'Y' then
2094: fnd_message.set_name('PER','HR_PO_RATE_MESG');
2095: out_rec.grade_rule_id := l_rate_rec.grade_rule_id;
2106: else --try to find the HR assignment rates
2107: open csr_asg_rates(p_assignment_id, p_effective_date);
2108: fetch csr_asg_rates into l_rate_rec;
2109: if csr_asg_rates%notfound then
2110: hr_utility.set_location(l_proc,916);
2111: out_rec.grade_rule_id := null;
2112: out_rec.rate_id := null;
2113: out_rec.rate_name := null;
2114: out_rec.rate_basis := null;
2119: out_rec.rate_effective_start_date := null;
2120: out_rec.rate_effective_end_date := null;
2121: out_rec.rate_object_version_number := null;
2122: elsif csr_asg_rates%found then
2123: hr_utility.set_location(l_proc,917);
2124: out_rec.grade_rule_id := l_rate_rec.grade_rule_id;
2125: out_rec.rate_id := l_rate_rec.rate_id;
2126: out_rec.rate_name := l_rate_rec.rate_name;
2127: out_rec.rate_basis := l_rate_rec.rate_basis;
2137: null;
2138: elsif csr_asg_rates%found then
2139: --this means multiple rates exits. Further update processing will rely on setting
2140: --grade_rule_id but nothing else
2141: hr_utility.set_location(l_proc,918);
2142: fnd_message.set_name('PER','HR_MULTI_RATE_MESG');
2143: out_rec.grade_rule_id := l_rate_rec.grade_rule_id;
2144: out_rec.rate_id := null;
2145: out_rec.rate_name := null;
2155: end if;
2156: close csr_asg_rates;
2157: end if; --end check for PO_SERVICES_ENABLED
2158: --
2159: hr_utility.set_location(l_proc,919);
2160: --
2161: out_rec.ass_attribute_category :=asg_rec.ass_attribute_category;
2162: out_rec.ass_attribute1 :=asg_rec.ass_attribute1;
2163: out_rec.ass_attribute2 :=asg_rec.ass_attribute2;
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: --
2201: if asg_rec.special_ceiling_step_id is not null then
2202: open csr_ceiling_step(asg_rec.special_ceiling_step_id,p_effective_date);
2203: fetch csr_ceiling_step into out_rec.special_ceiling_point, out_rec.special_ceiling_step;
2204: close csr_ceiling_step;
2205: end if;
2206: out_rec.special_ceiling_step_id :=asg_rec.special_ceiling_step_id;
2207: --
2208: hr_utility.set_location(l_proc,930);
2209: --
2210: -- Bug# 4153433 Start Here
2211: --
2212: if asg_rec.assignment_type = 'E' then
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: --
2236: if asg_rec.contract_id is not null then
2237: open csr_reference(asg_rec.contract_id,p_effective_date);
2238: fetch csr_reference into out_rec.contract;
2239: close csr_reference;
2240: end if;
2241: out_rec.contract_id :=asg_rec.contract_id;
2242: --
2243: hr_utility.set_location(l_proc,950);
2244: --
2245: if asg_rec.collective_agreement_id is not null then
2246: open csr_collective_agr(asg_rec.collective_agreement_id);
2247: fetch csr_collective_agr into out_rec.collective_agreement;
2248: close csr_collective_agr;
2249: end if;
2250: out_rec.collective_agreement_id :=asg_rec.collective_agreement_id;
2251: --
2252: hr_utility.set_location(l_proc,960);
2253: --
2254: if asg_rec.cagr_id_flex_num is not null then
2255: open csr_cagr_flex_num(asg_rec.cagr_id_flex_num);
2256: fetch csr_cagr_flex_num into out_rec.cagr_id_flex_name;
2259: out_rec.cagr_id_flex_num :=asg_rec.cagr_id_flex_num;
2260: --
2261: out_rec.cagr_grade_def_id :=asg_rec.cagr_grade_def_id;
2262: --
2263: hr_utility.set_location(l_proc,970);
2264: --
2265: if asg_rec.establishment_id is not null then
2266: out_rec.establishment
2267: :=per_qh_populate.get_organization(asg_rec.establishment_id);
2267: :=per_qh_populate.get_organization(asg_rec.establishment_id);
2268: end if;
2269: out_rec.establishment_id :=asg_rec.establishment_id;
2270: --
2271: hr_utility.set_location(l_proc,980);
2272: --
2273: --Bug 3063591 Start Here
2274: out_rec.work_at_home :=asg_rec.work_at_home;
2275: --Bug 3063591 End Here
2273: --Bug 3063591 Start Here
2274: out_rec.work_at_home :=asg_rec.work_at_home;
2275: --Bug 3063591 End Here
2276: --
2277: hr_utility.set_location(l_proc,985);
2278: --
2279: open csr_pay_proposal(p_assignment_id,p_effective_date);
2280: fetch csr_pay_proposal into pyp_rec;
2281: if csr_pay_proposal%found then
2279: open csr_pay_proposal(p_assignment_id,p_effective_date);
2280: fetch csr_pay_proposal into pyp_rec;
2281: if csr_pay_proposal%found then
2282: --
2283: hr_utility.set_location(l_proc,990);
2284: --
2285: close csr_pay_proposal;
2286: out_rec.pay_proposal_id :=pyp_rec.pay_proposal_id;
2287: out_rec.change_date :=pyp_rec.change_date;
2484: ,p_effective_date => p_effective_date
2485: );
2486: --
2487: end if;
2488: hr_utility.set_location('Leaving: '||l_proc,1000);
2489: --
2490:
2491: end onerow;
2492: --