[Home] [Help]
61: begin
62: return(l_position_definition_id);
63: exception
64: when others then
65: hr_data_pump.fail('get_position_definition_id', sqlerrm, p_position_name,
66: p_business_group_id, p_effective_date);
67: raise;
68: end get_position_definition_id;
69: /*--------------------- get_collective_agreement_id ------------------------*/
83: nvl(start_date,START_OF_TIME) and nvl(end_date,END_OF_TIME);
84: return l_collective_agreement_id;
85: exception
86: when others then
87: hr_data_pump.fail('get_collective_agreement_id', sqlerrm,
88: p_business_group_id, p_cagr_name, p_effective_date);
89: raise;
90: end get_collective_agreement_id;
91:
98: l_contract_id := user_key_to_id( p_contract_user_key );
99: return(l_contract_id);
100: exception
101: when others then
102: hr_data_pump.fail('get_contract_id', sqlerrm, p_contract_user_key);
103: raise;
104: end get_contract_id;
105:
106: /*---------------------------- get_establishment_id ---------------------------*/
117: and pe.name = p_establishment_name;
118: return l_establishment_id;
119: exception
120: when others then
121: hr_data_pump.fail('get_establishment_id', sqlerrm,
122: p_establishment_name, p_location);
123: raise;
124: end get_establishment_id;
125:
132: l_cagr_id_flex_num := user_key_to_id( p_cagr_id_flex_num_user_key );
133: return(l_cagr_id_flex_num);
134: exception
135: when others then
136: hr_data_pump.fail('get_cagr_id_flex_num', sqlerrm, p_cagr_id_flex_num_user_key);
137: raise;
138: end get_cagr_id_flex_num;
139:
140: /* get element_entry_id - requires user key */
147: l_element_entry_id := user_key_to_id( p_element_entry_user_key );
148: return(l_element_entry_id);
149: exception
150: when others then
151: hr_data_pump.fail('get_element_entry_id', sqlerrm, p_element_entry_user_key);
152: raise;
153: end get_element_entry_id;
154:
155: /* get original element_entry_id - requires user key */
162: l_original_entry_id := get_element_entry_id( p_original_entry_user_key );
163: return(l_original_entry_id);
164: exception
165: when others then
166: hr_data_pump.fail('get_original_entry_id', sqlerrm,
167: p_original_entry_user_key);
168: raise;
169: end get_original_entry_id;
170:
178: l_target_entry_id := get_element_entry_id( p_target_entry_user_key );
179: return(l_target_entry_id);
180: exception
181: when others then
182: hr_data_pump.fail('get_target_entry_id', sqlerrm, p_target_entry_user_key);
183: raise;
184: end get_target_entry_id;
185:
186: /* get_element_link_id - requires user key */
193: l_element_link_id := user_key_to_id( p_element_link_user_key );
194: return(l_element_link_id);
195: exception
196: when others then
197: hr_data_pump.fail('get_element_link_id', sqlerrm, p_element_link_user_key);
198: raise;
199: end get_element_link_id;
200:
201: /* get_cost_allocation_key_flex_id - requires user key */
209: user_key_to_id( p_cost_alloc_keyflex_user_key );
210: return(l_cost_allocation_keyflex_id);
211: exception
212: when others then
213: hr_data_pump.fail('get_cost_allocation_keyflex_id', sqlerrm,
214: p_cost_alloc_keyflex_user_key);
215: raise;
216: end get_cost_allocation_keyflex_id;
217:
223: l_comment_id := user_key_to_id( p_comment_user_key );
224: return(l_comment_id);
225: exception
226: when others then
227: hr_data_pump.fail('get_comment_id', sqlerrm, p_comment_user_key);
228: raise;
229: end get_comment_id;
230:
231: /* get_assignment_action_id - requires user key */
236: l_assignment_action_id := user_key_to_id( p_assignment_action_user_key );
237: return(l_assignment_action_id);
238: exception
239: when others then
240: hr_data_pump.fail('get_assignment_action_id', sqlerrm,
241: p_assignment_action_user_key);
242: raise;
243: end get_assignment_action_id;
244:
251: get_assignment_action_id( p_updating_action_user_key );
252: return(l_updating_action_id);
253: exception
254: when others then
255: hr_data_pump.fail('get_updating_action_id', sqlerrm,
256: p_updating_action_user_key);
257: raise;
258: end get_updating_action_id;
259:
297: and pivtl.LANGUAGE = p_language_code;
298: return(l_input_value_id);
299: exception
300: when others then
301: hr_data_pump.fail('get_input_value_id', sqlerrm, p_input_value_name,
302: p_element_name, p_business_group_id, p_effective_date,
303: p_language_code);
304: raise;
305: end get_input_value_id;
321: p_language_code );
322: return(l_input_value_id1);
323: exception
324: when others then
325: hr_data_pump.fail('get_input_value_id1', sqlerrm, p_input_value_name1,
326: p_element_name, p_business_group_id, p_effective_date,
327: p_language_code);
328: raise;
329: end get_input_value_id1;
345: p_language_code );
346: return(l_input_value_id2);
347: exception
348: when others then
349: hr_data_pump.fail('get_input_value_id2', sqlerrm, p_input_value_name2,
350: p_element_name, p_business_group_id, p_effective_date,
351: p_language_code);
352: raise;
353: end get_input_value_id2;
369: p_language_code );
370: return(l_input_value_id3);
371: exception
372: when others then
373: hr_data_pump.fail('get_input_value_id3', sqlerrm, p_input_value_name3,
374: p_element_name, p_business_group_id, p_effective_date,
375: p_language_code);
376: raise;
377: end get_input_value_id3;
393: p_language_code );
394: return(l_input_value_id4);
395: exception
396: when others then
397: hr_data_pump.fail('get_input_value_id4', sqlerrm, p_input_value_name4,
398: p_element_name, p_business_group_id, p_effective_date,
399: p_language_code);
400: raise;
401: end get_input_value_id4;
417: p_language_code );
418: return(l_input_value_id5);
419: exception
420: when others then
421: hr_data_pump.fail('get_input_value_id5', sqlerrm, p_input_value_name5,
422: p_element_name, p_business_group_id, p_effective_date,
423: p_language_code);
424: raise;
425: end get_input_value_id5;
441: p_language_code );
442: return(l_input_value_id6);
443: exception
444: when others then
445: hr_data_pump.fail('get_input_value_id6', sqlerrm, p_input_value_name6,
446: p_element_name, p_business_group_id, p_effective_date,
447: p_language_code);
448: raise;
449: end get_input_value_id6;
465: p_language_code );
466: return(l_input_value_id7);
467: exception
468: when others then
469: hr_data_pump.fail('get_input_value_id7', sqlerrm, p_input_value_name7,
470: p_element_name, p_business_group_id, p_effective_date,
471: p_language_code);
472: raise;
473: end get_input_value_id7;
489: p_language_code );
490: return(l_input_value_id8);
491: exception
492: when others then
493: hr_data_pump.fail('get_input_value_id8', sqlerrm, p_input_value_name8,
494: p_element_name, p_business_group_id, p_effective_date,
495: p_language_code);
496: raise;
497: end get_input_value_id8;
513: p_language_code );
514: return(l_input_value_id9);
515: exception
516: when others then
517: hr_data_pump.fail('get_input_value_id9', sqlerrm, p_input_value_name9,
518: p_element_name, p_business_group_id, p_effective_date,
519: p_language_code);
520: raise;
521: end get_input_value_id9;
537: p_language_code );
538: return(l_input_value_id10);
539: exception
540: when others then
541: hr_data_pump.fail('get_input_value_id10', sqlerrm, p_input_value_name10,
542: p_element_name, p_business_group_id, p_effective_date,
543: p_language_code);
544: raise;
545: end get_input_value_id10;
561: p_language_code );
562: return(l_input_value_id11);
563: exception
564: when others then
565: hr_data_pump.fail('get_input_value_id11', sqlerrm, p_input_value_name11,
566: p_element_name, p_business_group_id, p_effective_date,
567: p_language_code);
568: raise;
569: end get_input_value_id11;
585: p_language_code );
586: return(l_input_value_id12);
587: exception
588: when others then
589: hr_data_pump.fail('get_input_value_id12', sqlerrm, p_input_value_name12,
590: p_element_name, p_business_group_id, p_effective_date,
591: p_language_code);
592: raise;
593: end get_input_value_id12;
609: p_language_code );
610: return(l_input_value_id13);
611: exception
612: when others then
613: hr_data_pump.fail('get_input_value_id13', sqlerrm, p_input_value_name13,
614: p_element_name, p_business_group_id, p_effective_date,
615: p_language_code);
616: raise;
617: end get_input_value_id13;
633: p_language_code );
634: return(l_input_value_id14);
635: exception
636: when others then
637: hr_data_pump.fail('get_input_value_id14', sqlerrm, p_input_value_name14,
638: p_element_name, p_business_group_id, p_effective_date,
639: p_language_code);
640: raise;
641: end get_input_value_id14;
657: p_language_code );
658: return(l_input_value_id15);
659: exception
660: when others then
661: hr_data_pump.fail('get_input_value_id15', sqlerrm, p_input_value_name15,
662: p_element_name, p_business_group_id, p_effective_date,
663: p_language_code);
664: raise;
665: end get_input_value_id15;
678: and business_group_id + 0 = p_business_group_id;
679: return(l_rate_id);
680: exception
681: when others then
682: hr_data_pump.fail('get_rate_id', sqlerrm, p_rate_name, p_business_group_id);
683: raise;
684: end get_rate_id;
685:
686: /* get_emp_fed_tax_rule_id - requires user key */
693: l_emp_fed_tax_rule_id := user_key_to_id( p_emp_fed_tax_rule_user_key );
694: return(l_emp_fed_tax_rule_id);
695: exception
696: when others then
697: hr_data_pump.fail('get_emp_fed_tax_rule_id', sqlerrm, p_emp_fed_tax_rule_user_key);
698: raise;
699: end get_emp_fed_tax_rule_id;
700:
701: /* get_emp_state_tax_rule_id - requires user key */
708: l_emp_state_tax_rule_id := user_key_to_id( p_emp_state_tax_rule_user_key );
709: return(l_emp_state_tax_rule_id);
710: exception
711: when others then
712: hr_data_pump.fail('get_emp_state_tax_rule_id', sqlerrm, p_emp_state_tax_rule_user_key);
713: raise;
714: end get_emp_state_tax_rule_id;
715:
716: /* get_emp_county_tax_rule_id - requires user key */
723: l_emp_county_tax_rule_id := user_key_to_id( p_emp_county_tax_rule_user_key );
724: return(l_emp_county_tax_rule_id);
725: exception
726: when others then
727: hr_data_pump.fail('get_emp_county_tax_rule_id', sqlerrm, p_emp_county_tax_rule_user_key);
728: raise;
729: end get_emp_county_tax_rule_id;
730:
731: /* get_emp_city_tax_rule_id - requires user key */
738: l_emp_city_tax_rule_id := user_key_to_id( p_emp_city_tax_rule_user_key );
739: return(l_emp_city_tax_rule_id);
740: exception
741: when others then
742: hr_data_pump.fail('get_emp_city_tax_rule_id', sqlerrm, p_emp_city_tax_rule_user_key);
743: raise;
744: end get_emp_city_tax_rule_id;
745:
746: /* get_ler_internal */
756: get_ler_id(p_business_group_id, p_ler_name, p_effective_date);
757: return(l_ler_id);
758: exception
759: when others then
760: hr_data_pump.fail(p_caller, sqlerrm, p_business_group_id,
761: p_effective_date, p_ler_name);
762: raise;
763: end get_ler_internal;
764:
806: and bbg.business_group_id + 0 = p_business_group_id;
807: return(l_benefit_group_id);
808: exception
809: when others then
810: hr_data_pump.fail('get_benefit_group_id', sqlerrm, p_business_group_id,
811: p_benefit_group);
812: raise;
813: end get_benefit_group_id;
814:
828: l_ptnl_ler_for_per_id := user_key_to_id( p_ptnl_ler_for_per_user_key );
829: return(l_ptnl_ler_for_per_id);
830: exception
831: when others then
832: hr_data_pump.fail('get_ptnl_ler_for_per_id', sqlerrm, p_ptnl_ler_for_per_user_key);
833: raise;
834: end get_ptnl_ler_for_per_id;
835: -------------
836: function get_ws_mgr_id
844: l_ws_mgr_id := user_key_to_id( p_ws_mgr_user_key );
845: return(l_ws_mgr_id);
846: exception
847: when others then
848: hr_data_pump.fail('GET_WS_MGR_ID', sqlerrm, p_ws_mgr_user_key);
849: raise;
850: end get_ws_mgr_id;
851: --
852: function get_group_pl_id
860: l_group_pl_id := user_key_to_id( p_group_pl_user_key );
861: return(l_group_pl_id);
862: exception
863: when others then
864: hr_data_pump.fail('get_group_pl_id', sqlerrm, p_group_pl_user_key);
865: raise;
866: end get_group_pl_id;
867: --
868: function get_mgr_ovrid_person_id
876: l_mgr_ovrid_person_id := user_key_to_id( p_mgr_ovrid_person_user_key );
877: return(l_mgr_ovrid_person_id);
878: exception
879: when others then
880: hr_data_pump.fail('get_mgr_ovrid_person_id', sqlerrm, p_mgr_ovrid_person_user_key);
881: raise;
882: end get_mgr_ovrid_person_id;
883: ------------
884:
894: l_csd_by_ptnl_ler_for_per_id := user_key_to_id( p_csd_by_ppl_user_key );
895: return(l_csd_by_ptnl_ler_for_per_id);
896: exception
897: when others then
898: hr_data_pump.fail('get_csd_by_ptnl_ler_for_per_id', sqlerrm, p_csd_by_ppl_user_key);
899: raise;
900: end get_csd_by_ptnl_ler_for_per_id;
901:
902: /* returns a ptnl_ler_for_per object_version_number */
913: and ppl.ptnl_ler_for_per_id = key.unique_key_id;
914: return(l_ovn);
915: exception
916: when others then
917: hr_data_pump.fail('get_ptnl_ler_for_per_ovn', sqlerrm, p_ptnl_ler_for_per_user_key);
918: raise;
919: end get_ptnl_ler_for_per_ovn;
920:
921: /* returns a per_in_ler_id from supplied user_key */
930: l_per_in_ler_id := user_key_to_id( p_per_in_ler_user_key );
931: return(l_per_in_ler_id);
932: exception
933: when others then
934: hr_data_pump.fail('get_per_in_ler_id', sqlerrm, p_per_in_ler_user_key);
935: raise;
936: end get_per_in_ler_id;
937:
938: /* returns a per_in_ler_id from supplied user_key */
949: -- return a null value for now
950: return null;
951: exception
952: when others then
953: hr_data_pump.fail('get_trgr_table_pk_id', sqlerrm, p_trgr_table_pk_user_key);
954: raise;
955: end get_trgr_table_pk_id;
956:
957: /* returns a bckt_per_in_ler_id from supplied user_key */
966: l_bckt_per_in_ler_id := user_key_to_id( p_bckt_per_in_ler_user_key );
967: return(l_bckt_per_in_ler_id);
968: exception
969: when others then
970: hr_data_pump.fail('get_bckt_per_in_ler_id', sqlerrm, p_bckt_per_in_ler_user_key);
971: raise;
972: end get_bckt_per_in_ler_id;
973:
974: /* returns a ended_per_in_ler_id from supplied user_key */
983: l_ended_per_in_ler_id := user_key_to_id( p_ended_per_in_ler_user_key );
984: return(l_ended_per_in_ler_id);
985: exception
986: when others then
987: hr_data_pump.fail('get_ended_per_in_ler_id', sqlerrm, p_ended_per_in_ler_user_key);
988: raise;
989: end get_ended_per_in_ler_id;
990:
991: /* returns a per_in_ler object_version_number */
1002: and pil.per_in_ler_id = key.unique_key_id;
1003: return(l_ovn);
1004: exception
1005: when others then
1006: hr_data_pump.fail('get_per_in_ler_ovn', sqlerrm, p_per_in_ler_user_key);
1007: raise;
1008: end get_per_in_ler_ovn;
1009:
1010: /* returns a prtt_enrt_rslt_id from supplied user_key */
1019: l_prtt_enrt_rslt_id := user_key_to_id( p_prtt_enrt_rslt_user_key );
1020: return(l_prtt_enrt_rslt_id);
1021: exception
1022: when others then
1023: hr_data_pump.fail('get_prtt_enrt_rslt_id', sqlerrm, p_prtt_enrt_rslt_user_key);
1024: raise;
1025: end get_prtt_enrt_rslt_id;
1026:
1027: /* returns a rplcs_sspndd_rslt_id from supplied user_key */
1036: l_rplcs_sspndd_rslt_id := user_key_to_id( p_rplcs_sspndd_rslt_user_key );
1037: return(l_rplcs_sspndd_rslt_id);
1038: exception
1039: when others then
1040: hr_data_pump.fail('get_rplcs_sspndd_rslt_id', sqlerrm, p_rplcs_sspndd_rslt_user_key);
1041: raise;
1042: end get_rplcs_sspndd_rslt_id;
1043:
1044: /* returns a prtt_enrt_rslt object_version_number */
1058: pen.effective_start_date and pen.effective_end_date;
1059: return(l_ovn);
1060: exception
1061: when others then
1062: hr_data_pump.fail('get_prtt_enrt_rslt_ovn', sqlerrm, p_prtt_enrt_rslt_user_key);
1063: raise;
1064: end get_prtt_enrt_rslt_ovn;
1065:
1066: /* returns a prtt_rt_val_id from supplied user_key */
1075: l_prtt_rt_val_id := user_key_to_id( p_prtt_rt_val_user_key );
1076: return(l_prtt_rt_val_id);
1077: exception
1078: when others then
1079: hr_data_pump.fail('get_prtt_rt_val_id', sqlerrm, p_prtt_rt_val_user_key);
1080: raise;
1081: end get_prtt_rt_val_id;
1082:
1083: /* returns a prtt_rt_val object_version_number */
1094: and prv.prtt_rt_val_id = key.unique_key_id;
1095: return(l_ovn);
1096: exception
1097: when others then
1098: hr_data_pump.fail('get_prtt_rt_val_ovn', sqlerrm, p_prtt_rt_val_user_key);
1099: raise;
1100: end get_prtt_rt_val_ovn;
1101:
1102: /* returns a cbr_quald_bnf_id from supplied user_key */
1111: l_cbr_quald_bnf_id := user_key_to_id( p_cbr_quald_bnf_user_key );
1112: return(l_cbr_quald_bnf_id);
1113: exception
1114: when others then
1115: hr_data_pump.fail('get_cbr_quald_bnf_id', sqlerrm, p_cbr_quald_bnf_user_key);
1116: raise;
1117: end get_cbr_quald_bnf_id;
1118:
1119: /* returns a cbr_quald_bnf object_version_number */
1130: and cqb.cbr_quald_bnf_id = key.unique_key_id;
1131: return(l_ovn);
1132: exception
1133: when others then
1134: hr_data_pump.fail('get_cbr_quald_bnf_ovn', sqlerrm, p_cbr_quald_bnf_user_key);
1135: raise;
1136: end get_cbr_quald_bnf_ovn;
1137:
1138: /* returns a cbr_per_in_ler_id from supplied user_key */
1147: l_cbr_per_in_ler_id := user_key_to_id( p_cbr_per_in_ler_user_key );
1148: return(l_cbr_per_in_ler_id);
1149: exception
1150: when others then
1151: hr_data_pump.fail('get_cbr_per_in_ler_id', sqlerrm, p_cbr_per_in_ler_user_key);
1152: raise;
1153: end get_cbr_per_in_ler_id;
1154:
1155: /* returns a cbr_per_in_ler object_version_number */
1166: and crp.cbr_per_in_ler_id = key.unique_key_id;
1167: return(l_ovn);
1168: exception
1169: when others then
1170: hr_data_pump.fail('get_cbr_per_in_ler_ovn', sqlerrm, p_cbr_per_in_ler_user_key);
1171: raise;
1172: end get_cbr_per_in_ler_ovn;
1173:
1174: /* returns a elig_cvrd_dpnt_id from supplied user_key */
1183: l_elig_cvrd_dpnt_id := user_key_to_id( p_elig_cvrd_dpnt_user_key );
1184: return(l_elig_cvrd_dpnt_id);
1185: exception
1186: when others then
1187: hr_data_pump.fail('get_elig_cvrd_dpnt_id', sqlerrm, p_elig_cvrd_dpnt_user_key);
1188: raise;
1189: end get_elig_cvrd_dpnt_id;
1190:
1191: /* returns a elig_cvrd_dpnt object_version_number */
1205: pdp.effective_start_date and pdp.effective_end_date;
1206: return(l_ovn);
1207: exception
1208: when others then
1209: hr_data_pump.fail('get_elig_cvrd_dpnt_ovn', sqlerrm, p_effective_date, p_elig_cvrd_dpnt_user_key);
1210: raise;
1211: end get_elig_cvrd_dpnt_ovn;
1212:
1213: /* returns a prtt_prem_id from supplied user_key */
1222: l_prtt_prem_id := user_key_to_id( p_prtt_prem_user_key );
1223: return(l_prtt_prem_id);
1224: exception
1225: when others then
1226: hr_data_pump.fail('get_prtt_prem_id', sqlerrm, p_prtt_prem_user_key);
1227: raise;
1228: end get_prtt_prem_id;
1229:
1230: /* returns a prtt_prem object_version_number */
1244: ppe.effective_start_date and ppe.effective_end_date;
1245: return(l_ovn);
1246: exception
1247: when others then
1248: hr_data_pump.fail('get_prtt_prem_ovn', sqlerrm, p_effective_date, p_prtt_prem_user_key);
1249: raise;
1250: end get_prtt_prem_ovn;
1251:
1252: /* returns a elig_dpnt_id from supplied user_key */
1261: l_elig_dpnt_id := user_key_to_id( p_elig_dpnt_user_key );
1262: return(l_elig_dpnt_id);
1263: exception
1264: when others then
1265: hr_data_pump.fail('get_elig_dpnt_id', sqlerrm, p_elig_dpnt_user_key);
1266: raise;
1267: end get_elig_dpnt_id;
1268:
1269: /* returns a elig_dpnt object_version_number */
1280: and egd.elig_dpnt_id = key.unique_key_id;
1281: return(l_ovn);
1282: exception
1283: when others then
1284: hr_data_pump.fail('get_elig_dpnt_ovn', sqlerrm, p_elig_dpnt_user_key);
1285: raise;
1286: end get_elig_dpnt_ovn;
1287:
1288: /* returns a elig_per_id from supplied user_key */
1297: l_elig_per_id := user_key_to_id( p_elig_per_user_key );
1298: return(l_elig_per_id);
1299: exception
1300: when others then
1301: hr_data_pump.fail('get_elig_per_id', sqlerrm, p_elig_per_user_key);
1302: raise;
1303: end get_elig_per_id;
1304:
1305: /* returns a elig_per object_version_number */
1319: pep.effective_start_date and pep.effective_end_date;
1320: return(l_ovn);
1321: exception
1322: when others then
1323: hr_data_pump.fail('get_elig_per_ovn', sqlerrm, p_effective_date, p_elig_per_user_key);
1324: raise;
1325: end get_elig_per_ovn;
1326:
1327: /* returns a elig_per_opt_id from supplied user_key */
1336: l_elig_per_opt_id := user_key_to_id( p_elig_per_opt_user_key );
1337: return(l_elig_per_opt_id);
1338: exception
1339: when others then
1340: hr_data_pump.fail('get_elig_per_opt_id', sqlerrm, p_elig_per_opt_user_key);
1341: raise;
1342: end get_elig_per_opt_id;
1343:
1344: /* returns a elig_per_opt object_version_number */
1358: epo.effective_start_date and epo.effective_end_date;
1359: return(l_ovn);
1360: exception
1361: when others then
1362: hr_data_pump.fail('get_elig_per_opt_ovn', sqlerrm, p_effective_date, p_elig_per_opt_user_key);
1363: raise;
1364: end get_elig_per_opt_ovn;
1365:
1366: /* returns a pl_bnf_id from supplied user_key */
1375: l_pl_bnf_id := user_key_to_id( p_pl_bnf_user_key );
1376: return(l_pl_bnf_id);
1377: exception
1378: when others then
1379: hr_data_pump.fail('get_pl_bnf_id', sqlerrm, p_pl_bnf_user_key);
1380: raise;
1381: end get_pl_bnf_id;
1382:
1383: /* returns a pl_bnf object_version_number */
1397: pbn.effective_start_date and pbn.effective_end_date;
1398: return(l_ovn);
1399: exception
1400: when others then
1401: hr_data_pump.fail('get_pl_bnf_ovn', sqlerrm, p_effective_date, p_pl_bnf_user_key);
1402: raise;
1403: end get_pl_bnf_ovn;
1404:
1405: /* returns a oipl_id from supplied user_key */
1414: l_oipl_id := user_key_to_id( p_oipl_user_key );
1415: return(l_oipl_id);
1416: exception
1417: when others then
1418: hr_data_pump.fail('get_oipl_id', sqlerrm, p_oipl_user_key);
1419: raise;
1420: end get_oipl_id;
1421:
1422: /* returns a oipl object_version_number */
1436: cop.effective_start_date and cop.effective_end_date;
1437: return(l_ovn);
1438: exception
1439: when others then
1440: hr_data_pump.fail('get_oipl_ovn', sqlerrm, p_effective_date, p_oipl_user_key);
1441: raise;
1442: end get_oipl_ovn;
1443:
1444: /* returns a plip_id from supplied user_key */
1453: l_plip_id := user_key_to_id( p_plip_user_key );
1454: return(l_plip_id);
1455: exception
1456: when others then
1457: hr_data_pump.fail('get_plip_id', sqlerrm, p_plip_user_key);
1458: raise;
1459: end get_plip_id;
1460:
1461: /* returns a plip object_version_number */
1475: cpp.effective_start_date and cpp.effective_end_date;
1476: return(l_ovn);
1477: exception
1478: when others then
1479: hr_data_pump.fail('get_plip_ovn', sqlerrm, p_effective_date, p_plip_user_key);
1480: raise;
1481: end get_plip_ovn;
1482:
1483: /* returns a ptip_id from supplied user_key */
1492: l_ptip_id := user_key_to_id( p_ptip_user_key );
1493: return(l_ptip_id);
1494: exception
1495: when others then
1496: hr_data_pump.fail('get_ptip_id', sqlerrm, p_ptip_user_key);
1497: raise;
1498: end get_ptip_id;
1499:
1500: /* returns a ptip object_version_number */
1514: ctp.effective_start_date and ctp.effective_end_date;
1515: return(l_ovn);
1516: exception
1517: when others then
1518: hr_data_pump.fail('get_ptip_ovn', sqlerrm, p_effective_date, p_ptip_user_key);
1519: raise;
1520: end get_ptip_ovn;
1521:
1522: /* returns a enrt_rt_id from supplied user_key */
1531: l_enrt_rt_id := user_key_to_id( p_enrt_rt_user_key );
1532: return(l_enrt_rt_id);
1533: exception
1534: when others then
1535: hr_data_pump.fail('get_enrt_rt_id', sqlerrm, p_enrt_rt_user_key);
1536: raise;
1537: end get_enrt_rt_id;
1538:
1539: /* returns a enrt_rt object_version_number */
1550: and ecr.enrt_rt_id = key.unique_key_id;
1551: return(l_ovn);
1552: exception
1553: when others then
1554: hr_data_pump.fail('get_enrt_rt_ovn', sqlerrm, p_enrt_rt_user_key);
1555: raise;
1556: end get_enrt_rt_ovn;
1557:
1558: /* returns a enrt_perd_id from supplied user_key */
1567: l_enrt_perd_id := user_key_to_id( p_enrt_perd_user_key );
1568: return(l_enrt_perd_id);
1569: exception
1570: when others then
1571: hr_data_pump.fail('get_enrt_perd_id', sqlerrm, p_enrt_perd_user_key);
1572: raise;
1573: end get_enrt_perd_id;
1574:
1575: /* returns a enrt_perd object_version_number */
1586: and enp.enrt_perd_id = key.unique_key_id;
1587: return(l_ovn);
1588: exception
1589: when others then
1590: hr_data_pump.fail('get_enrt_perd_ovn', sqlerrm, p_enrt_perd_user_key);
1591: raise;
1592: end get_enrt_perd_ovn;
1593:
1594: /* returns a prtt_reimbmt_rqst_id from supplied user_key */
1603: l_prtt_reimbmt_rqst_id := user_key_to_id( p_prtt_reimbmt_rqst_user_key );
1604: return(l_prtt_reimbmt_rqst_id);
1605: exception
1606: when others then
1607: hr_data_pump.fail('get_prtt_reimbmt_rqst_id', sqlerrm, p_prtt_reimbmt_rqst_user_key);
1608: raise;
1609: end get_prtt_reimbmt_rqst_id;
1610:
1611: /* returns a prtt_reimbmt_rqst object_version_number */
1625: prc.effective_start_date and prc.effective_end_date;
1626: return(l_ovn);
1627: exception
1628: when others then
1629: hr_data_pump.fail('get_prtt_reimbmt_rqst_ovn', sqlerrm, p_prtt_reimbmt_rqst_user_key);
1630: raise;
1631: end get_prtt_reimbmt_rqst_ovn;
1632:
1633: /* returns a elig_per_elctbl_chc_id from supplied user_key */
1642: l_elig_per_elctbl_chc_id := user_key_to_id( p_elig_per_elctbl_chc_user_key );
1643: return(l_elig_per_elctbl_chc_id);
1644: exception
1645: when others then
1646: hr_data_pump.fail('get_elig_per_elctbl_chc_id', sqlerrm, p_elig_per_elctbl_chc_user_key);
1647: raise;
1648: end get_elig_per_elctbl_chc_id;
1649:
1650: /* returns a elig_per_elctbl_chc object_version_number */
1661: and epe.elig_per_elctbl_chc_id = key.unique_key_id;
1662: return(l_ovn);
1663: exception
1664: when others then
1665: hr_data_pump.fail('get_elig_per_elctbl_chc_ovn', sqlerrm, p_elig_per_elctbl_chc_user_key);
1666: raise;
1667: end get_elig_per_elctbl_chc_ovn;
1668:
1669: /** end of USER_KEY additions */
1684: and bng.business_group_id + 0 = p_business_group_id;
1685: return(l_benefit_group_id);
1686: exception
1687: when others then
1688: hr_data_pump.fail('get_benfts_grp_id', sqlerrm, p_business_group_id, p_benefits_group);
1689: raise;
1690: end get_benfts_grp_id;
1691:
1692: /* returns a benefits group object version number */
1703: and bng.business_group_id + 0 = p_business_group_id;
1704: return(l_ovn);
1705: exception
1706: when others then
1707: hr_data_pump.fail('get_benfts_grp_ovn', sqlerrm, p_business_group_id, p_benefits_group);
1708: raise;
1709: end get_benfts_grp_ovn;
1710:
1711: /* returns a pl_typ_id */
1725: ptp.effective_start_date and ptp.effective_end_date;
1726: return(l_plan_type_id);
1727: exception
1728: when others then
1729: hr_data_pump.fail('get_pl_typ_id', sqlerrm, p_business_group_id, p_plan_type, p_effective_date);
1730: raise;
1731: end get_pl_typ_id;
1732:
1733: /* returns a plan type object version number */
1747: ptp.effective_start_date and ptp.effective_end_date;
1748: return(l_ovn);
1749: exception
1750: when others then
1751: hr_data_pump.fail('get_pl_typ_ovn', sqlerrm, p_business_group_id, p_plan_type, p_effective_date);
1752: raise;
1753: end get_pl_typ_ovn;
1754:
1755: -- Note: an overloaded routine predates this. Left it for upward compat.
1770: ler.effective_start_date and ler.effective_end_date;
1771: return(l_ler_id);
1772: exception
1773: when others then
1774: hr_data_pump.fail('get_ler_id', sqlerrm, p_business_group_id, p_life_event_reason, p_effective_date);
1775: raise;
1776: end get_ler_id;
1777:
1778: /* returns a life event reason object version number */
1792: ler.effective_start_date and ler.effective_end_date;
1793: return(l_ovn);
1794: exception
1795: when others then
1796: hr_data_pump.fail('get_ler_ovn', sqlerrm, p_business_group_id, p_life_event_reason, p_effective_date);
1797: raise;
1798: end get_ler_ovn;
1799:
1800: /* returns an acty_base_rt_id */
1814: abr.effective_start_date and abr.effective_end_date;
1815: return(l_acty_base_rt_id);
1816: exception
1817: when others then
1818: hr_data_pump.fail('get_acty_base_rt_id', sqlerrm, p_business_group_id, p_acty_base_rate, p_effective_date);
1819: raise;
1820: end get_acty_base_rt_id;
1821:
1822: /* returns an acty base rate object version number */
1836: abr.effective_start_date and abr.effective_end_date;
1837: return(l_ovn);
1838: exception
1839: when others then
1840: hr_data_pump.fail('get_acty_base_rt_ovn', sqlerrm, p_business_group_id, p_acty_base_rate, p_effective_date);
1841: raise;
1842: end get_acty_base_rt_ovn;
1843:
1844: /* returns an actl_prem_id */
1858: apr.effective_start_date and apr.effective_end_date;
1859: return(l_actl_prem_id);
1860: exception
1861: when others then
1862: hr_data_pump.fail('get_actl_prem_id', sqlerrm, p_business_group_id, p_actual_premium, p_effective_date);
1863: raise;
1864: end get_actl_prem_id;
1865:
1866: /* returns an actual premium object version number */
1880: apr.effective_start_date and apr.effective_end_date;
1881: return(l_ovn);
1882: exception
1883: when others then
1884: hr_data_pump.fail('get_actl_prem_ovn', sqlerrm, p_business_group_id, p_actual_premium, p_effective_date);
1885: raise;
1886: end get_actl_prem_ovn;
1887:
1888: /* returns a comp_lvl_fctr_id */
1899: and clf.business_group_id + 0 = p_business_group_id;
1900: return(l_comp_lvl_fctr_id);
1901: exception
1902: when others then
1903: hr_data_pump.fail('get_comp_lvl_fctr_id', sqlerrm, p_business_group_id, p_comp_level_factor);
1904: raise;
1905: end get_comp_lvl_fctr_id;
1906:
1907: /* returns a comp level factor object version number */
1918: and clf.business_group_id + 0 = p_business_group_id;
1919: return(l_ovn);
1920: exception
1921: when others then
1922: hr_data_pump.fail('get_comp_lvl_fctr_ovn', sqlerrm, p_business_group_id, p_comp_level_factor);
1923: raise;
1924: end get_comp_lvl_fctr_ovn;
1925:
1926: /* returns a cvg_amt_calc_mthd_id */
1940: ccm.effective_start_date and ccm.effective_end_date;
1941: return(l_cvg_amt_calc_mthd_id);
1942: exception
1943: when others then
1944: hr_data_pump.fail('get_cvg_amt_calc_mthd_id', sqlerrm, p_business_group_id, p_cvg_amt_calc, p_effective_date);
1945: raise;
1946: end get_cvg_amt_calc_mthd_id;
1947:
1948: /* returns a cvg amt calc object version number */
1962: ccm.effective_start_date and ccm.effective_end_date;
1963: return(l_ovn);
1964: exception
1965: when others then
1966: hr_data_pump.fail('get_cvg_amt_calc_mthd_ovn', sqlerrm, p_business_group_id, p_cvg_amt_calc, p_effective_date);
1967: raise;
1968: end get_cvg_amt_calc_mthd_ovn;
1969:
1970: /* returns an opt_id */
1984: opt.effective_start_date and opt.effective_end_date;
1985: return(l_opt_id);
1986: exception
1987: when others then
1988: hr_data_pump.fail('get_opt_id', sqlerrm, p_business_group_id, p_option_definition, p_effective_date);
1989: raise;
1990: end get_opt_id;
1991:
1992: /* returns an option definition object version number */
2006: opt.effective_start_date and opt.effective_end_date;
2007: return(l_ovn);
2008: exception
2009: when others then
2010: hr_data_pump.fail('get_opt_ovn', sqlerrm, p_business_group_id, p_option_definition, p_effective_date);
2011: raise;
2012: end get_opt_ovn;
2013:
2014: /* returns a pl_id */
2028: pln.effective_start_date and pln.effective_end_date;
2029: return(l_pl_id);
2030: exception
2031: when others then
2032: hr_data_pump.fail('get_pl_id', sqlerrm, p_business_group_id, p_plan, p_effective_date);
2033: raise;
2034: end get_pl_id;
2035:
2036: /* returns a plan object version number */
2050: pln.effective_start_date and pln.effective_end_date;
2051: return(l_ovn);
2052: exception
2053: when others then
2054: hr_data_pump.fail('get_pl_ovn', sqlerrm, p_business_group_id, p_plan, p_effective_date);
2055: raise;
2056: end get_pl_ovn;
2057:
2058: /* returns a pgm_id */
2072: pgm.effective_start_date and pgm.effective_end_date;
2073: return(l_pgm_id);
2074: exception
2075: when others then
2076: hr_data_pump.fail('get_pgm_id', sqlerrm, p_business_group_id, p_program, p_effective_date);
2077: raise;
2078: end get_pgm_id;
2079:
2080: /* returns a program object version number */
2094: pgm.effective_start_date and pgm.effective_end_date;
2095: return(l_ovn);
2096: exception
2097: when others then
2098: hr_data_pump.fail('get_pgm_ovn', sqlerrm, p_business_group_id, p_program, p_effective_date);
2099: raise;
2100: end get_pgm_ovn;
2101:
2102: /** start of NAME lookups for PER/PAY/HR tables **/
2119: pet.effective_start_date and pet.effective_end_date;
2120: return(l_element_type_id);
2121: exception
2122: when others then
2123: hr_data_pump.fail('get_element_type_id', sqlerrm, p_business_group_id, p_element_name);
2124: raise;
2125: end get_element_type_id;
2126:
2127: /** end of NAME additions **/
2132: p_effective_date in date
2133: ) return varchar2 is
2134: l_code fnd_currencies_vl.currency_code%type;
2135: begin
2136: --hr_data_pump.message('**bp** in hr_pump_get.get_cur_code: '|| p_name_or_code);
2137: --
2138: begin
2139: if p_name_or_code is null or p_name_or_code = hr_api.g_varchar2
2140: then
2154: and p_effective_date between
2155: nvl(start_date_active, START_OF_TIME) and nvl(end_date_active, END_OF_TIME);
2156: end if;
2157: --
2158: --hr_data_pump.message('**bp** out hr_pump_get.get_cur_code: '||l_code);
2159: return(l_code);
2160: exception
2161: when no_data_found then
2162: --
2169: and enabled_flag = 'Y'
2170: and p_effective_date between
2171: nvl(start_date_active, START_OF_TIME) and nvl(end_date_active, END_OF_TIME);
2172: --
2173: --hr_data_pump.message('**bp** out hr_pump_get.get_cur_code: '||l_code);
2174: return(l_code);
2175: when others then
2176: raise;
2177: end;
2178: --
2179: exception
2180: --
2181: when no_data_found then
2182: hr_data_pump.fail('get_currency_code', sqlerrm, p_name_or_code);
2183: raise value_error;
2184: when others then
2185: hr_data_pump.fail('get_currency_code', sqlerrm, p_name_or_code);
2186: raise;
2181: when no_data_found then
2182: hr_data_pump.fail('get_currency_code', sqlerrm, p_name_or_code);
2183: raise value_error;
2184: when others then
2185: hr_data_pump.fail('get_currency_code', sqlerrm, p_name_or_code);
2186: raise;
2187: end get_currency_code;
2188:
2189: /* start HR/PER additional get_xyz routines for BEN */
2196: begin
2197: return(get_currency_code( p_uom, p_effective_date ));
2198: exception
2199: when others then
2200: hr_data_pump.fail('get_uom_code', sqlerrm, p_uom);
2201: raise;
2202: end get_uom_code;
2203:
2204: /* returns a std_prem_uom code */
2209: begin
2210: return(get_currency_code( p_std_prem_uom, p_effective_date ));
2211: exception
2212: when others then
2213: hr_data_pump.fail('get_std_prem_uom_code', sqlerrm, p_std_prem_uom);
2214: raise;
2215: end get_std_prem_uom_code;
2216:
2217: /* returns a comp_ref_uom code */
2222: begin
2223: return(get_currency_code( p_comp_ref_uom, p_effective_date ));
2224: exception
2225: when others then
2226: hr_data_pump.fail('get_comp_ref_uom_code', sqlerrm, p_comp_ref_uom);
2227: raise;
2228: end get_comp_ref_uom_code;
2229:
2230: /* returns a rt_comp_ref_uom code */
2235: begin
2236: return(get_currency_code( p_rt_comp_ref_uom, p_effective_date ));
2237: exception
2238: when others then
2239: hr_data_pump.fail('get_rt_comp_ref_uom_code', sqlerrm, p_rt_comp_ref_uom);
2240: raise;
2241: end get_rt_comp_ref_uom_code;
2242:
2243: /* returns a amt_dsgd_uom code */
2248: begin
2249: return(get_currency_code( p_amt_dsgd_uom, p_effective_date ));
2250: exception
2251: when others then
2252: hr_data_pump.fail('get_amt_dsgd_uom_code', sqlerrm, p_amt_dsgd_uom);
2253: raise;
2254: end get_amt_dsgd_uom_code;
2255:
2256: /* get_quald_bnf_person_id - requires user key */
2266: l_person_id := user_key_to_id( p_quald_bnf_person_user_key );
2267: return(l_person_id);
2268: exception
2269: when others then
2270: hr_data_pump.fail('get_quald_bnf_person_id', sqlerrm, p_quald_bnf_person_user_key);
2271: raise;
2272: end get_quald_bnf_person_id;
2273:
2274: /* get_cvrd_emp_person_id - requires user key */
2284: l_person_id := user_key_to_id( p_cvrd_emp_person_user_key );
2285: return(l_person_id);
2286: exception
2287: when others then
2288: hr_data_pump.fail('get_cvrd_emp_person_id', sqlerrm, p_cvrd_emp_person_user_key);
2289: raise;
2290: end get_cvrd_emp_person_id;
2291:
2292: /* get_dpnt_person_id - requires user key */
2302: l_person_id := user_key_to_id( p_dpnt_person_user_key );
2303: return(l_person_id);
2304: exception
2305: when others then
2306: hr_data_pump.fail('get_dpnt_person_id', sqlerrm, p_dpnt_person_user_key);
2307: raise;
2308: end get_dpnt_person_id;
2309:
2310: /* get_bnf_person_id - requires user key */
2320: l_person_id := user_key_to_id( p_bnf_person_user_key );
2321: return(l_person_id);
2322: exception
2323: when others then
2324: hr_data_pump.fail('get_bnf_person_id', sqlerrm, p_bnf_person_user_key);
2325: raise;
2326: end get_bnf_person_id;
2327:
2328: /* get_ttee_person_id - requires user key */
2338: l_person_id := user_key_to_id( p_ttee_person_user_key );
2339: return(l_person_id);
2340: exception
2341: when others then
2342: hr_data_pump.fail('get_ttee_person_id', sqlerrm, p_ttee_person_user_key);
2343: raise;
2344: end get_ttee_person_id;
2345:
2346: /****** end OAB additions ******/
2355: l_person_id := user_key_to_id( p_person_user_key );
2356: return(l_person_id);
2357: exception
2358: when others then
2359: hr_data_pump.fail('get_person_id', sqlerrm, p_person_user_key);
2360: raise;
2361: end get_person_id;
2362:
2363: /* return person_id for contact person. */
2370: l_contact_person_id := get_person_id(p_contact_person_user_key);
2371: return(l_contact_person_id);
2372: exception
2373: when others then
2374: hr_data_pump.fail('get_contact_person_id', sqlerrm,
2375: p_contact_person_user_key);
2376: raise;
2377: end get_contact_person_id;
2378:
2386: l_assignment_id := user_key_to_id( p_assignment_user_key );
2387: return(l_assignment_id);
2388: exception
2389: when others then
2390: hr_data_pump.fail('get_assignment_id', sqlerrm, p_assignment_user_key);
2391: raise;
2392: end get_assignment_id;
2393:
2394: /* return address_id - requires user key */
2401: l_address_id := user_key_to_id( p_address_user_key );
2402: return(l_address_id);
2403: exception
2404: when others then
2405: hr_data_pump.fail('get_address_id', sqlerrm, p_address_user_key);
2406: raise;
2407: end get_address_id;
2408:
2409: /* return supervisor person_id - requires user key */
2416: l_supervisor_id := get_person_id( p_supervisor_user_key );
2417: return(l_supervisor_id);
2418: exception
2419: when others then
2420: hr_data_pump.fail('get_supervisor_id', sqlerrm, p_supervisor_user_key);
2421: raise;
2422: end get_supervisor_id;
2423:
2424: /* return recruiter person_id - requires user key */
2431: l_recruiter_id := get_person_id( p_recruiter_user_key );
2432: return(l_recruiter_id);
2433: exception
2434: when others then
2435: hr_data_pump.fail('get_recruiter_id', sqlerrm, p_recruiter_user_key);
2436: raise;
2437: end get_recruiter_id;
2438:
2439: /* return person_referred_by_id - requires user key */
2446: l_person_referred_by_id := get_person_id( p_person_referred_by_user_key );
2447: return(l_person_referred_by_id);
2448: exception
2449: when others then
2450: hr_data_pump.fail('get_person_referred_by_id', sqlerrm,
2451: p_person_referred_by_user_key);
2452: raise;
2453: end get_person_referred_by_id;
2454:
2462: l_timecard_approver_id := get_person_id(p_timecard_approver_user_key);
2463: return(l_timecard_approver_id);
2464: exception
2465: when others then
2466: hr_data_pump.fail('get_timecard_approver_id', sqlerrm,
2467: p_timecard_approver_user_key);
2468: raise;
2469: end get_timecard_approver_id;
2470:
2487: and pcr.person_id = contactee_key.unique_key_id;
2488: return(l_contact_relationship_id);
2489: exception
2490: when others then
2491: hr_data_pump.fail('get_contact_relationship_id', sqlerrm,
2492: p_contact_user_key, p_contactee_user_key );
2493: raise;
2494: end get_contact_relationship_id;
2495:
2512: and typtl.LANGUAGE = p_language_code;
2513: return(l_person_type_id);
2514: exception
2515: when others then
2516: hr_data_pump.fail('get_person_type_id', sqlerrm, p_user_person_type,
2517: p_business_group_id, p_language_code);
2518: raise;
2519: end get_person_type_id;
2520:
2539: and typtl.LANGUAGE = p_language_code;
2540: return(l_person_type_id);
2541: exception
2542: when others then
2543: hr_data_pump.fail('get_original_person_type_id', sqlerrm, p_user_person_type,
2544: p_business_group_id, p_language_code);
2545: raise;
2546: end get_original_person_type_id;
2547:
2558: where pov.vendor_name = p_vendor_name;
2559: return(l_vendor_id);
2560: exception
2561: when others then
2562: hr_data_pump.fail('get_vendor_id', sqlerrm, p_vendor_name);
2563: raise;
2564: end get_vendor_id;
2565:
2566: /* returns an assignment_status_type_id */
2613: );
2614: return(l_assignment_status_type_id);
2615: exception
2616: when others then
2617: hr_data_pump.fail('get_assignment_status_type_id', sqlerrm, p_user_status,
2618: p_business_group_id, p_language_code);
2619: raise;
2620: end get_assignment_status_type_id;
2621:
2639: and org.business_group_id + 0 = p_business_group_id;
2640: return(l_organization_id);
2641: exception
2642: when others then
2643: hr_data_pump.fail('get_organization_id', sqlerrm, p_organization_name,
2644: p_business_group_id, p_effective_date, p_language_code);
2645: raise;
2646: end get_organization_id;
2647:
2660: p_effective_date, p_language_code );
2661: return(l_establishment_org_id);
2662: exception
2663: when others then
2664: hr_data_pump.fail('get_establishment_org_id', sqlerrm,
2665: p_establishment_org_name, p_business_group_id,
2666: p_effective_date, p_language_code);
2667: raise;
2668: end get_establishment_org_id;
2682: p_effective_date, p_language_code );
2683: return(l_source_organization_id);
2684: exception
2685: when others then
2686: hr_data_pump.fail('get_source_organization_id', sqlerrm,
2687: p_source_organization_name, p_business_group_id,
2688: p_effective_date, p_language_code);
2689: raise;
2690: end get_source_organization_id;
2709: and gra.business_group_id + 0 = p_business_group_id;
2710: return(l_grade_id);
2711: exception
2712: when others then
2713: hr_data_pump.fail('get_grade_id', sqlerrm, p_grade_name, p_business_group_id, p_effective_date);
2714: raise;
2715: end get_grade_id;
2716:
2717: /* returns a grade_id */
2762: end if;
2763: return v_shared_type_id;
2764: exception
2765: when others then
2766: hr_data_pump.fail('get_availability_status_id', sqlerrm,
2767: p_shared_type_name, p_system_type_cd,
2768: p_business_group_id, p_language_code);
2769: raise;
2770: end get_availability_status_id;
2787: pos.effective_start_date and pos.effective_end_date;
2788: return(l_position_id);
2789: exception
2790: when others then
2791: hr_data_pump.fail('get_position_id', sqlerrm, p_position_name,
2792: p_business_group_id, p_effective_date);
2793: raise;
2794: end get_position_id;
2795:
2808: p_effective_date);
2809: return(l_pos_id);
2810: exception
2811: when others then
2812: hr_data_pump.fail('get_successor_position_id', sqlerrm,
2813: p_successor_position_name, p_business_group_id,
2814: p_effective_date);
2815: raise;
2816: end get_successor_position_id;
2830: p_effective_date);
2831: return(l_pos_id);
2832: exception
2833: when others then
2834: hr_data_pump.fail('get_relief_position_id', sqlerrm,
2835: p_relief_position_name, p_business_group_id,
2836: p_effective_date);
2837: raise;
2838: end get_relief_position_id;
2852: p_effective_date);
2853: return(l_pos_id);
2854: exception
2855: when others then
2856: hr_data_pump.fail('get_prior_position_id', sqlerrm,
2857: p_prior_position_name, p_business_group_id,
2858: p_effective_date);
2859: raise;
2860: end get_prior_position_id;
2874: p_effective_date);
2875: return(l_pos_id);
2876: exception
2877: when others then
2878: hr_data_pump.fail('get_supervisor_position_id', sqlerrm,
2879: p_supervisor_position_name, p_business_group_id,
2880: p_effective_date);
2881: raise;
2882: end get_supervisor_position_id;
2897: and job.business_group_id + 0 = p_business_group_id;
2898: return(l_job_id);
2899: exception
2900: when others then
2901: hr_data_pump.fail('get_job_id', sqlerrm,
2902: p_job_name, p_effective_date, p_business_group_id);
2903: raise;
2904: end get_job_id;
2905:
2921: pay.effective_start_date and pay.effective_end_date;
2922: return(l_payroll_id);
2923: exception
2924: when others then
2925: hr_data_pump.fail('get_payroll_id', sqlerrm, p_payroll_name,
2926: p_business_group_id, p_effective_date);
2927: raise;
2928: end get_payroll_id;
2929:
2960: p_language_code);
2961: return(l_location_id);
2962: exception
2963: when others then
2964: hr_data_pump.fail('get_location_id_update', sqlerrm,
2965: p_existing_location_code,
2966: p_business_group_id, p_language_code);
2967: raise;
2968: end get_location_id_update;
2987: loc.business_group_id + 0 = p_business_group_id);
2988: return(l_location_id);
2989: exception
2990: when others then
2991: hr_data_pump.fail('get_location_id', sqlerrm, p_location_code,
2992: p_business_group_id, p_language_code);
2993: raise;
2994: end get_location_id;
2995:
3011: and full_name = p_designated_receiver_name;
3012: return l_designated_receiver_id;
3013: Exception
3014: When Others Then
3015: hr_data_pump.fail('get_designated_receiver_id',sqlerrm,p_designated_receiver_name,
3016: p_business_group_id);
3017: raise;
3018: end get_designated_receiver_id;
3019:
3036: loc.business_group_id + 0 = p_business_group_id);
3037: return(l_location_id);
3038: exception
3039: when others then
3040: hr_data_pump.fail('get_ship_to_location_id', sqlerrm, p_ship_to_location_code,
3041: p_business_group_id, p_language_code);
3042: raise;
3043: end get_ship_to_location_id;
3044:
3057: and ppb.business_group_id + 0 = p_business_group_id;
3058: return(l_pay_basis_id);
3059: exception
3060: when others then
3061: hr_data_pump.fail('get_pay_basis_id', sqlerrm, p_pay_basis_name,
3062: p_business_group_id);
3063: raise;
3064: end get_pay_basis_id;
3065:
3081: pra.date_start and nvl(pra.date_end, END_OF_TIME);
3082: return(l_raid);
3083: exception
3084: when others then
3085: hr_data_pump.fail('get_recruitment_activity_id', sqlerrm,
3086: p_recruitment_activity_name, p_business_group_id,
3087: p_effective_date);
3088: raise;
3089: end get_recruitment_activity_id;
3098: l_vacancy_id := user_key_to_id( p_vacancy_user_key );
3099: return(l_vacancy_id);
3100: exception
3101: when others then
3102: hr_data_pump.fail('get_vacancy_id', sqlerrm, p_vacancy_user_key );
3103: raise;
3104: end get_vacancy_id;
3105:
3106: /* returns an org_payment_method_id */
3113: l_opmid := user_key_to_id( p_org_payment_method_user_key );
3114: return(l_opmid);
3115: exception
3116: when others then
3117: hr_data_pump.fail('get_org_payment_method_id', sqlerrm,
3118: p_org_payment_method_user_key );
3119: raise;
3120: end get_org_payment_method_id;
3121:
3134: p_effective_date, p_language_code );
3135: return(l_organization_id);
3136: exception
3137: when others then
3138: hr_data_pump.fail('get_payee_org_id', sqlerrm, p_payee_organization_name,
3139: p_business_group_id, p_effective_date, p_language_code);
3140: raise;
3141: end get_payee_org_id;
3142:
3150: l_person_id := get_person_id( p_payee_person_user_key );
3151: return(l_person_id);
3152: exception
3153: when others then
3154: hr_data_pump.fail('get_payee_person_id', sqlerrm, p_payee_person_user_key);
3155: raise;
3156: end get_payee_person_id;
3157:
3158: /* return payee_id for an organization or person payee. */
3203: raise value_error;
3204: end if;
3205: exception
3206: when others then
3207: hr_data_pump.fail('get_payee_id', sqlerrm, p_payee_type, p_payee_org,
3208: p_payee_person_user_key, p_effective_date, p_language_code);
3209: raise;
3210: end get_payee_id;
3211:
3219: l_ppmid := user_key_to_id( p_personal_pay_method_user_key );
3220: return(l_ppmid);
3221: exception
3222: when others then
3223: hr_data_pump.fail('get_personal_payment_method_id', sqlerrm,
3224: p_personal_pay_method_user_key);
3225: raise;
3226: end get_personal_payment_method_id;
3227:
3238: where sob.name = p_set_of_books_name;
3239: return(l_id);
3240: exception
3241: when others then
3242: hr_data_pump.fail('get_set_of_books_id', sqlerrm, p_set_of_books_name);
3243: raise;
3244: end get_set_of_books_id;
3245:
3246: /* returns a tax_unit_id */
3257: where tax.name = p_tax_unit_name;
3258: return(l_tax_unit_id);
3259: exception
3260: when others then
3261: hr_data_pump.fail('get_tax_unit_id', sqlerrm, p_tax_unit_name,
3262: p_effective_date);
3263: raise;
3264: end get_tax_unit_id;
3265:
3291: hoi.org_information1 is null);
3292: return(l_id);
3293: exception
3294: when others then
3295: hr_data_pump.fail('get_work_schedule', sqlerrm, p_work_schedule,
3296: p_organization_name, p_business_group_id,
3297: p_effective_date, p_language_code);
3298: raise;
3299: end get_work_schedule;
3314: and est.business_group_id + 0 = p_business_group_id;
3315: return(l_id);
3316: exception
3317: when others then
3318: hr_data_pump.fail('get_eeo_1_establishment_id', sqlerrm,
3319: p_eeo_1_establishment, p_business_group_id,
3320: p_effective_date);
3321: raise;
3322: end get_eeo_1_establishment_id;
3353: l_id_flex_num := user_key_to_id( p_id_flex_num_user_key );
3354: return(l_id_flex_num);
3355: exception
3356: when others then
3357: hr_data_pump.fail('get_id_flex_num', sqlerrm, p_id_flex_num_user_key);
3358: raise;
3359: end get_id_flex_num;
3360:
3361: /* get_gr_grade_rule_id */
3386: pgr.effective_end_date;
3387: return(l_grade_rule_id);
3388: exception
3389: when others then
3390: hr_data_pump.fail('get_gr_grade_rule_id', sqlerrm, p_grade_name,
3391: p_rate_name, p_business_group_id, p_effective_date);
3392: raise;
3393: end get_gr_grade_rule_id;
3394:
3425: pgr.effective_end_date;
3426: return( l_grade_rule_id );
3427: exception
3428: when others then
3429: hr_data_pump.fail('get_pp_grade_rule_id', sqlerrm, p_progression_point,
3430: p_pay_scale, p_rate_name, p_business_group_id,
3431: p_effective_date);
3432: raise;
3433: end get_pp_grade_rule_id;
3455: pgr.effective_end_date;
3456: return(l_grade_rule_id);
3457: exception
3458: when others then
3459: hr_data_pump.fail('get_ar_grade_rule_id', sqlerrm,
3460: p_rate_name, p_business_group_id, p_effective_date);
3461: raise;
3462: end get_ar_grade_rule_id;
3463:
3476: and pos.business_group_id + 0 = p_business_group_id;
3477: return (l_organization_structure_id);
3478: exception
3479: when others then
3480: hr_data_pump.fail('get_organization_structure_id', sqlerrm, p_name, p_business_group_id);
3481: raise;
3482: end get_organization_structure_id;
3483:
3484: function get_org_str_ver_id
3500: and osv.business_group_id + 0 = p_business_group_id;
3501: return (l_org_str_ver_id);
3502: exception
3503: when others then
3504: hr_data_pump.fail('get_org_str_ver_id', sqlerrm, p_business_group_id, p_organization_structure_id, p_date_from, p_version_number);
3505: raise;
3506: end get_org_str_ver_id;
3507:
3508: /* get_spinal_point_id */
3527: and psp.parent_spine_id = pps.parent_spine_id;
3528: return( l_spinal_point_id );
3529: exception
3530: when others then
3531: hr_data_pump.fail('get_spinal_point_id', sqlerrm, p_progression_point,
3532: p_pay_scale, p_business_group_id, p_effective_date);
3533: raise;
3534: end get_spinal_point_id;
3535:
3552: and pps.actual_termination_date is null;
3553: return(l_period_of_service_id);
3554: exception
3555: when others then
3556: hr_data_pump.fail('get_at_period_of_service_id', sqlerrm,
3557: p_person_user_key, p_business_group_id);
3558: raise;
3559: end get_at_period_of_service_id;
3560:
3578: and pps.final_process_date is null;
3579: return(l_period_of_service_id);
3580: exception
3581: when others then
3582: hr_data_pump.fail('get_fp_period_of_service_id', sqlerrm, p_person_user_key,
3583: p_business_group_id);
3584: raise;
3585: end get_fp_period_of_service_id;
3586:
3607: and p_effective_date between pps.date_start and NVL(pps.actual_termination_date,l_eot);
3608: return(l_period_of_service_id);
3609: exception
3610: when others then
3611: hr_data_pump.fail('get_ut_period_of_service_id', sqlerrm, p_person_user_key,
3612: p_effective_date,p_business_group_id);
3613: raise;
3614: end get_ut_period_of_service_id;
3615:
3625: user_key_to_id( p_special_ceilin_step_user_key );
3626: return(l_special_ceiling_step_id);
3627: exception
3628: when others then
3629: hr_data_pump.fail('get_special_ceiling_step_id', sqlerrm,
3630: p_special_ceilin_step_user_key );
3631: raise;
3632: end get_special_ceiling_step_id;
3633:
3642: l_default_code_comb_id := user_key_to_id( p_default_code_comb_user_key );
3643: return(l_default_code_comb_id);
3644: exception
3645: when others then
3646: hr_data_pump.fail('get_default_code_comb_id', sqlerrm,
3647: p_default_code_comb_user_key );
3648: raise;
3649: end get_default_code_comb_id;
3650:
3659: l_phone_id := user_key_to_id( p_phone_user_key );
3660: return(l_phone_id);
3661: exception
3662: when others then
3663: hr_data_pump.fail('get_phone_id', sqlerrm, p_phone_user_key);
3664: raise;
3665: end get_phone_id;
3666:
3667: /*-------------------------- get_grade_ladder_pgm_id -----------------------*/
3682: between pgm.effective_start_date and pgm.effective_end_date;
3683: return(l_grade_ladder_pgm_id);
3684: exception
3685: when others then
3686: hr_data_pump.fail('get_grade_ladder_pgm_id', sqlerrm,
3687: p_grade_ladder_name);
3688: raise;
3689: end get_grade_ladder_pgm_id;
3690: /*---------------------- get_supervisor_assignment_id -----------------------*/
3698: l_supervisor_assignment_id := get_assignment_id(p_svr_assignment_user_key );
3699: return(l_supervisor_assignment_id);
3700: exception
3701: when others then
3702: hr_data_pump.fail('get_supervisor_assignment_id', sqlerrm,
3703: p_svr_assignment_user_key);
3704: raise;
3705: end get_supervisor_assignment_id;
3706:
3720: and business_group_id = p_business_group_id;
3721: return(l_parent_spine_id);
3722: exception
3723: when others then
3724: hr_data_pump.fail('get_parent_spine_id', sqlerrm, p_parent_spine,
3725: p_business_group_id);
3726: raise;
3727: end get_parent_spine_id;
3728: /*--------------------- get_ceiling_step_id ----------------------------------*/
3746: sps.effective_start_date and sps.effective_end_date;
3747: return(l_ceiling_step_id);
3748: exception
3749: when others then
3750: hr_data_pump.fail('get_ceiling_step_id', sqlerrm, p_ceiling_point,
3751: p_business_group_id, p_effective_date);
3752: raise;
3753: end get_ceiling_step_id;
3754:
3773: nvl(start_date,START_OF_TIME) and nvl(end_date,END_OF_TIME);
3774: return l_object_version_number;
3775: exception
3776: when others then
3777: hr_data_pump.fail('get_collective_agreement_ovn', sqlerrm,
3778: p_business_group_id, p_cagr_name, p_effective_date);
3779: raise;
3780: end get_collective_agreement_ovn;
3781:
3796: pc.effective_start_date and pc.effective_end_date;
3797: return(l_object_version_number);
3798: exception
3799: when others then
3800: hr_data_pump.fail('get_contract_ovn', sqlerrm, p_contract_user_key);
3801: raise;
3802: end get_contract_ovn;
3803:
3804: /*--------------------------- get_establishment_ovn ---------------------------*/
3815: and pe.name = p_establishment_name;
3816: return l_object_version_number;
3817: exception
3818: when others then
3819: hr_data_pump.fail('get_establishment_ovn', sqlerrm,
3820: p_establishment_name, p_location);
3821: raise;
3822: end get_establishment_ovn;
3823:
3839: rules.effective_start_date and rules.effective_end_date;
3840: return(l_ovn);
3841: exception
3842: when others then
3843: hr_data_pump.fail('get_us_emp_fed_tax_rule_ovn', sqlerrm,
3844: p_emp_fed_tax_rule_user_key, p_effective_date);
3845: raise;
3846: end get_us_emp_fed_tax_rule_ovn;
3847:
3863: rules.effective_start_date and rules.effective_end_date;
3864: return(l_ovn);
3865: exception
3866: when others then
3867: hr_data_pump.fail('get_us_emp_state_tax_rule_ovn', sqlerrm,
3868: p_emp_state_tax_rule_user_key, p_effective_date);
3869: raise;
3870: end get_us_emp_state_tax_rule_ovn;
3871:
3887: rules.effective_start_date and rules.effective_end_date;
3888: return(l_ovn);
3889: exception
3890: when others then
3891: hr_data_pump.fail('get_us_emp_county_tax_rule_ovn', sqlerrm,
3892: p_emp_county_tax_rule_user_key, p_effective_date);
3893: raise;
3894: end get_us_emp_county_tax_rule_ovn;
3895:
3911: rules.effective_start_date and rules.effective_end_date;
3912: return(l_ovn);
3913: exception
3914: when others then
3915: hr_data_pump.fail('get_us_emp_city_tax_rule_ovn', sqlerrm,
3916: p_emp_city_tax_rule_user_key, p_effective_date);
3917: raise;
3918: end get_us_emp_city_tax_rule_ovn;
3919:
3935: per.effective_start_date and per.effective_end_date;
3936: return(l_ovn);
3937: exception
3938: when others then
3939: hr_data_pump.fail('get_per_ovn', sqlerrm, p_person_user_key,
3940: p_effective_date);
3941: raise;
3942: end get_per_ovn;
3943:
3959: asg.effective_start_date and asg.effective_end_date;
3960: return(l_ovn);
3961: exception
3962: when others then
3963: hr_data_pump.fail('get_asg_ovn', sqlerrm, p_assignment_user_key,
3964: p_effective_date);
3965: raise;
3966: end get_asg_ovn;
3967:
3981: and adr.address_id = key.unique_key_id;
3982: return(l_ovn);
3983: exception
3984: when others then
3985: hr_data_pump.fail('get_adr_ovn', sqlerrm, p_address_user_key,
3986: p_effective_date);
3987: raise;
3988: end get_adr_ovn;
3989:
4003: where loc.location_code = p_location_code;
4004: return(l_ovn);
4005: exception
4006: when others then
4007: hr_data_pump.fail('get_loc_ovn', sqlerrm, p_location_code);
4008: raise;
4009: end get_loc_ovn;
4010:
4011: /* returns a job object version number */
4023: and ors.business_group_id + 0 = p_business_group_id;
4024: return(l_ovn);
4025: exception
4026: when others then
4027: hr_data_pump.fail('get_org_str_ovn', sqlerrm, p_name, p_business_group_id);
4028: raise;
4029: end get_org_str_ovn;
4030:
4031: /* returns a organization structure version object version number */
4047: and osv.business_group_id + 0 = p_business_group_id;
4048: return(l_ovn);
4049: exception
4050: when others then
4051: hr_data_pump.fail('get_org_str_ver_ovn', sqlerrm, p_business_group_id, p_organization_structure_id, p_date_from, p_version_number);
4052: raise;
4053: end get_org_str_ver_ovn;
4054:
4055: /* returns an organization object version number */
4071: and org.business_group_id + 0 = p_business_group_id;
4072: return(l_ovn);
4073: exception
4074: when others then
4075: hr_data_pump.fail('get_org_ovn', sqlerrm, p_business_group_id, p_organization_name, p_language_code);
4076: raise;
4077: end get_org_ovn;
4078:
4079: /* returns a job object version number */
4092: and job.business_group_id + 0 = p_business_group_id;
4093: return(l_ovn);
4094: exception
4095: when others then
4096: hr_data_pump.fail('get_job_ovn', sqlerrm, p_job_name, p_effective_date,
4097: p_business_group_id);
4098: raise;
4099: end get_job_ovn;
4100:
4116: pos.effective_start_date and pos.effective_end_date;
4117: return(l_ovn);
4118: exception
4119: when others then
4120: hr_data_pump.fail('get_pos_ovn', sqlerrm, p_position_name,
4121: p_business_group_id, p_effective_date);
4122: raise;
4123: end get_pos_ovn;
4124:
4140: ppm.effective_start_date and ppm.effective_end_date;
4141: return(l_ovn);
4142: exception
4143: when others then
4144: hr_data_pump.fail('get_ppm_ovn', sqlerrm,
4145: p_personal_pay_method_user_key, p_effective_date);
4146: raise;
4147: end get_ppm_ovn;
4148:
4164: pee.effective_start_date and pee.effective_end_date;
4165: return(l_element_entry_ovn);
4166: exception
4167: when others then
4168: hr_data_pump.fail('get_element_entry_ovn', sqlerrm, p_element_entry_user_key, p_effective_date);
4169: raise;
4170: end get_element_entry_ovn;
4171:
4172: /* get_gr_grade_rule_ovn */
4197: pgr.effective_end_date;
4198: return(l_object_version_number);
4199: exception
4200: when others then
4201: hr_data_pump.fail('get_gr_grade_rule_ovn', sqlerrm, p_grade_name,
4202: p_rate_name, p_business_group_id, p_effective_date);
4203: raise;
4204: end get_gr_grade_rule_ovn;
4205:
4236: pgr.effective_end_date;
4237: return(l_object_version_number);
4238: exception
4239: when others then
4240: hr_data_pump.fail('get_pp_grade_rule_id', sqlerrm, p_progression_point,
4241: p_pay_scale, p_rate_name, p_business_group_id,
4242: p_effective_date);
4243: raise;
4244: end get_pp_grade_rule_ovn;
4262: and pps.actual_termination_date is null;
4263: return(l_object_version_number);
4264: exception
4265: when others then
4266: hr_data_pump.fail('get_at_period_of_service_ovn', sqlerrm, p_person_user_key,
4267: p_business_group_id);
4268: raise;
4269: end get_at_period_of_service_ovn;
4270:
4288: and pps.final_process_date is null;
4289: return(l_object_version_number);
4290: exception
4291: when others then
4292: hr_data_pump.fail('get_fp_period_of_service_ovn', sqlerrm, p_person_user_key,
4293: p_business_group_id);
4294: raise;
4295: end get_fp_period_of_service_ovn;
4296:
4317: and p_effective_date between pps.date_start and NVL(pps.actual_termination_date,l_eot);
4318: return(l_object_version_number);
4319: exception
4320: when others then
4321: hr_data_pump.fail('get_ut_period_of_service_id', sqlerrm, p_person_user_key,
4322: p_effective_date,p_business_group_id);
4323: raise;
4324: end get_ut_period_of_service_ovn;
4325:
4333: l_entry_step_id := user_key_to_id( p_entry_step_user_key );
4334: return(l_entry_step_id);
4335: exception
4336: when others then
4337: hr_data_pump.fail('get_entry_step_id', sqlerrm, p_entry_step_user_key);
4338: raise;
4339: end get_entry_step_id;
4340:
4341: /* get entry_grade_rule_id - requires user key */
4348: l_entry_grade_rule_id := user_key_to_id( p_entry_grade_rule_user_key );
4349: return(l_entry_grade_rule_id);
4350: exception
4351: when others then
4352: hr_data_pump.fail('get_entry_grade_rule_id', sqlerrm, p_entry_grade_rule_user_key);
4353: raise;
4354: end get_entry_grade_rule_id;
4355:
4356: /* Added for 11i - Rvydyana - 06-DEC-1999 */
4369: and phn.phone_id = key.unique_key_id;
4370: return(l_ovn);
4371: exception
4372: when others then
4373: hr_data_pump.fail('get_phn_ovn', sqlerrm, p_phone_user_key);
4374: raise;
4375: end get_phn_ovn;
4376: --
4377: /* --------------------------------------------------- */
4391: and jgr.job_group_id = key.unique_key_id;
4392: return(l_ovn);
4393: exception
4394: when others then
4395: hr_data_pump.fail('get_jgr_ovn', sqlerrm, p_job_group_user_key);
4396: raise;
4397: end get_jgr_ovn;
4398:
4399: /* --------------------------------------------------- */
4413: and rol.role_id = key.unique_key_id;
4414: return(l_ovn);
4415: exception
4416: when others then
4417: hr_data_pump.fail('get_rol_ovn', sqlerrm, p_role_user_key);
4418: raise;
4419: end get_rol_ovn;
4420: /*-------------- returns a pay scale object version number --------------------*/
4421: function get_pay_scale_ovn
4432: and business_group_id + 0 = p_business_group_id;
4433: return(l_ovn);
4434: exception
4435: when others then
4436: hr_data_pump.fail('get_pay_scale_ovn', sqlerrm, p_pay_scale,
4437: p_business_group_id);
4438: raise;
4439: end get_pay_scale_ovn;
4440: /*-------------- returns a preogresion point object version number ------------*/
4452: and business_group_id + 0 = p_business_group_id;
4453: return(l_ovn);
4454: exception
4455: when others then
4456: hr_data_pump.fail('get_progression_point_ovn', sqlerrm, p_point,
4457: p_business_group_id);
4458: raise;
4459: end get_progression_point_ovn;
4460: /*-------------- returns a grade scale object version number ------------*/
4481: pgs.effective_start_date and pgs.effective_end_date;
4482: return(l_ovn);
4483: exception
4484: when others then
4485: hr_data_pump.fail('get_grade_scale_ovn', sqlerrm, p_grade,
4486: p_pay_scale, p_effective_date ,p_business_group_id);
4487: raise;
4488: end get_grade_scale_ovn;
4489: /*-------------- returns a grade step object version number ------------*/
4511: sps.effective_start_date and sps.effective_end_date;
4512: return(l_ovn);
4513: exception
4514: when others then
4515: hr_data_pump.fail('get_grade_step_ovn', sqlerrm, p_point,
4516: p_sequence,p_effective_date, p_business_group_id);
4517: raise;
4518: end get_grade_step_ovn;
4519: /*---------------------------------------------------------------------------*/
4537: -- entering the code directly.
4538: when no_data_found then
4539: return(p_correspondence_language);
4540: when others then
4541: hr_data_pump.fail('get_correspondence_language', sqlerrm,
4542: p_correspondence_language);
4543: raise;
4544: end get_correspondence_language;
4545:
4557: -- entering the code directly.
4558: when no_data_found then
4559: return(p_country);
4560: when others then
4561: hr_data_pump.fail('get_country', sqlerrm, p_country );
4562: raise;
4563: end get_country;
4564:
4565: /* get change reason lookup code, dependent on assignment */
4600: -- Assume that the user entered the code directly when no data found.
4601: when no_data_found then
4602: return(p_change_reason);
4603: when others then
4604: hr_data_pump.fail('get_change_reason', sqlerrm, p_change_reason,
4605: p_assignment_user_key, p_effective_date);
4606: raise;
4607: end get_change_reason;
4608:
4616: l_job_group_id := user_key_to_id( p_job_group_user_key );
4617: return(l_job_group_id);
4618: exception
4619: when others then
4620: hr_data_pump.fail('get_job_group_id', sqlerrm, p_job_group_user_key);
4621: raise;
4622: end get_job_group_id;
4623:
4624: /* get_benchmark_job_id - requires user key */
4631: l_benchmark_job_id := user_key_to_id( p_benchmark_job_user_key );
4632: return(l_benchmark_job_id);
4633: exception
4634: when others then
4635: hr_data_pump.fail('get_benchmark_job_id', sqlerrm, p_benchmark_job_user_key);
4636: raise;
4637: end get_benchmark_job_id;
4638:
4639: /* get_role_id - requires user key */
4646: l_role_id := user_key_to_id( p_role_user_key );
4647: return(l_role_id);
4648: exception
4649: when others then
4650: hr_data_pump.fail('get_role_id', sqlerrm, p_role_user_key);
4651: raise;
4652: end get_role_id;
4653:
4654: /* get_loc_id - requires user key */
4661: l_location_id := user_key_to_id( p_location_user_key );
4662: return(l_location_id);
4663: exception
4664: when others then
4665: hr_data_pump.fail('get_loc_id', sqlerrm, p_location_user_key);
4666: raise;
4667: end get_loc_id;
4668:
4669: /* get_org_structure_id - requires user key */
4676: l_organization_structure_id := user_key_to_id( p_org_structure_user_key );
4677: return(l_organization_structure_id);
4678: exception
4679: when others then
4680: hr_data_pump.fail('get_org_structure_id', sqlerrm, p_org_structure_user_key);
4681: raise;
4682: end get_org_structure_id;
4683:
4684: /* get_org_str_version_id - requires user key */
4691: l_org_structure_version_id := user_key_to_id( p_org_str_version_user_key );
4692: return(l_org_structure_version_id);
4693: exception
4694: when others then
4695: hr_data_pump.fail('get_org_str_version_id', sqlerrm, p_org_str_version_user_key);
4696: raise;
4697: end get_org_str_version_id;
4698:
4699: /* get_org_id - requires user key */
4706: l_org_id := user_key_to_id( p_org_user_key );
4707: return(l_org_id);
4708: exception
4709: when others then
4710: hr_data_pump.fail('get_org_id', sqlerrm, p_org_user_key);
4711: raise;
4712: end get_org_id;
4713:
4714: /* get_grade_rule_id - requires user key */
4721: l_grade_rule_id := user_key_to_id( p_grade_rule_user_key );
4722: return(l_grade_rule_id);
4723: exception
4724: when others then
4725: hr_data_pump.fail('get_grade_rule_id', sqlerrm, p_grade_rule_user_key);
4726: raise;
4727: end get_grade_rule_id;
4728:
4729: /* returns lookup_code */
4740: begin
4741: --
4742: -- Is lookup checking disabled ?
4743: --
4744: if hr_data_pump.g_disable_lookup_checks then
4745: return p_meaning_or_code;
4746: end if;
4747: --
4748: -- Set language code (handling possible defaults).
4802: -- should be able to pick up bad code values.
4803: --
4804: return(p_meaning_or_code);
4805: when others then
4806: hr_data_pump.fail
4807: ('get_lookup_code', sqlerrm, p_meaning_or_code,
4808: p_lookup_type, p_effective_date, p_language_code);
4809: raise;
4810: end gl;
4839: --
4840: return(l_people_group_id);
4841: exception
4842: when others then
4843: hr_data_pump.fail('get_people_group_id', sqlerrm,
4844: p_people_group_user_name,
4845: p_effective_date);
4846: raise;
4847: end get_people_group_id;
4867: --
4868: return(l_absence_attendance_type_id);
4869: exception
4870: when others then
4871: hr_data_pump.fail('get_absence_attendance_type_id', sqlerrm,
4872: p_aat_user_name,
4873: p_business_group_id,
4874: p_effective_date);
4875: raise;
4893: --
4894: return(l_soft_coding_keyflex_id);
4895: exception
4896: when others then
4897: hr_data_pump.fail('get_soft_coding_keyflex_id', sqlerrm,
4898: p_con_seg_user_name,
4899: p_effective_date);
4900: raise;
4901: end get_soft_coding_keyflex_id;
4912: --
4913: return(l_pk_id);
4914: exception
4915: when others then
4916: hr_data_pump.fail('get_pk_id', sqlerrm,
4917: p_pk_name
4918: );
4919: raise;
4920: end get_pk_id;
4938:
4939: return l_ovn;
4940: exception
4941: when others then
4942: hr_data_pump.fail('get_fed_tax_rule_ovn', sqlerrm,
4943: p_emp_fed_tax_rule_user_key,
4944: p_effective_date);
4945: raise;
4946: end get_fed_tax_rule_ovn;
4967:
4968: return l_ovn;
4969: exception
4970: when others then
4971: hr_data_pump.fail('get_state_tax_rule_ovn', sqlerrm,
4972: p_emp_state_tax_rule_user_key,
4973: p_effective_date);
4974: raise;
4975: end get_state_tax_rule_ovn;
4993:
4994: return l_ovn;
4995: exception
4996: when others then
4997: hr_data_pump.fail('get_county_tax_rule_ovn', sqlerrm,
4998: p_emp_county_tax_rule_user_key,
4999: p_effective_date);
5000: raise;
5001: end get_county_tax_rule_ovn;
5020:
5021: return l_ovn;
5022: exception
5023: when others then
5024: hr_data_pump.fail('get_city_tax_rule_ovn', sqlerrm,
5025: p_emp_city_tax_rule_user_key,
5026: p_effective_date);
5027: raise;
5028: end get_city_tax_rule_ovn;
5043: BEGIN
5044: return (null);
5045: EXCEPTION
5046: WHEN OTHERS THEN
5047: hr_data_pump.fail('get_parent_comp_element_id'
5048: , sqlerrm
5049: );
5050: RAISE;
5051: END get_parent_comp_element_id;
5093:
5094: RETURN(l_competence_id);
5095: EXCEPTION
5096: WHEN OTHERS THEN
5097: hr_data_pump.fail('get_competence_id'
5098: , sqlerrm
5099: , p_competence_name
5100: , p_business_group_id);
5101: RAISE;
5147:
5148: RETURN(l_cpn_ovn);
5149: EXCEPTION
5150: WHEN OTHERS THEN
5151: hr_data_pump.fail('get_cpn_ovn'
5152: , sqlerrm
5153: , p_competence_name
5154: , p_business_group_id);
5155: RAISE;
5185:
5186: RETURN(l_qualification_type_id);
5187: EXCEPTION
5188: WHEN OTHERS THEN
5189: hr_data_pump.fail('get_qualification_type_id'
5190: , sqlerrm
5191: , p_qualification_type_name);
5192: RAISE;
5193: END get_qualification_type_id;
5223:
5224: RETURN(l_outcome_id);
5225: EXCEPTION
5226: WHEN OTHERS THEN
5227: hr_data_pump.fail('get_outcome_id'
5228: , sqlerrm
5229: , p_outcome_name
5230: );
5231: RAISE;
5264:
5265: RETURN(l_cpo_ovn);
5266: EXCEPTION
5267: WHEN OTHERS THEN
5268: hr_data_pump.fail('get_cpo_ovn'
5269: , sqlerrm
5270: , p_outcome_name
5271: );
5272: RAISE;
5305:
5306: RETURN(l_eqt_ovn);
5307: EXCEPTION
5308: WHEN OTHERS THEN
5309: hr_data_pump.fail('get_eqt_ovn'
5310: , sqlerrm
5311: , p_qualification_type_name
5312: );
5313: RAISE;
5346:
5347: RETURN(l_ceo_ovn);
5348: EXCEPTION
5349: WHEN OTHERS THEN
5350: hr_data_pump.fail('get_ceo_ovn'
5351: , sqlerrm
5352: , p_element_outcome_name
5353: );
5354: RAISE;
5386:
5387: RETURN(l_competence_element_id);
5388: EXCEPTION
5389: WHEN OTHERS THEN
5390: hr_data_pump.fail('get_competence_element_id'
5391: , sqlerrm
5392: , p_competence_name
5393: , p_person_user_key
5394: , p_business_group_id
5423:
5424: RETURN(l_cost_code);
5425: EXCEPTION
5426: WHEN OTHERS THEN
5427: hr_data_pump.fail('get_cost_flex_stru_num'
5428: , sqlerrm
5429: , p_cost_flex_stru_code
5430: );
5431: RAISE;
5457:
5458: RETURN(l_grade_code);
5459: EXCEPTION
5460: WHEN OTHERS THEN
5461: hr_data_pump.fail('get_grade_flex_stru_num'
5462: , sqlerrm
5463: , p_grade_flex_stru_code
5464: );
5465: RAISE;
5491:
5492: RETURN(l_job_code);
5493: EXCEPTION
5494: WHEN OTHERS THEN
5495: hr_data_pump.fail('get_job_flex_stru_num'
5496: , sqlerrm
5497: , p_job_flex_stru_code
5498: );
5499: RAISE;
5525:
5526: RETURN(l_position_code);
5527: EXCEPTION
5528: WHEN OTHERS THEN
5529: hr_data_pump.fail('get_position_flex_stru_num'
5530: , sqlerrm
5531: , p_position_flex_stru_code
5532: );
5533: RAISE;
5559:
5560: RETURN(l_group_code);
5561: EXCEPTION
5562: WHEN OTHERS THEN
5563: hr_data_pump.fail('get_group_flex_stru_num'
5564: , sqlerrm
5565: , p_group_flex_stru_code
5566: );
5567: RAISE;
5593:
5594: RETURN(l_competence_code);
5595: EXCEPTION
5596: WHEN OTHERS THEN
5597: hr_data_pump.fail('get_competence_flex_stru_num'
5598: , sqlerrm
5599: , p_competence_flex_stru_code
5600: );
5601: RAISE;
5629:
5630: RETURN(l_get_sec_group_id);
5631: EXCEPTION
5632: WHEN OTHERS THEN
5633: hr_data_pump.fail('get_sec_group_id'
5634: , sqlerrm
5635: , p_security_group_name
5636: );
5637: RAISE;
5665:
5666: RETURN(l_sec_profile_id);
5667: EXCEPTION
5668: WHEN OTHERS THEN
5669: hr_data_pump.fail('get_security_profile_id'
5670: , sqlerrm
5671: , p_security_profile_name
5672: , p_business_group_id
5673: );
5705: END IF;
5706: return(l_organization_id);
5707: EXCEPTION
5708: WHEN OTHERS THEN
5709: hr_data_pump.fail('get_parent_organization_id', sqlerrm, p_parent_organization_name,
5710: p_business_group_id, p_effective_date, p_language_code);
5711: raise;
5712: end get_parent_organization_id;
5713: --
5742: --
5743: return(l_organization_id);
5744: EXCEPTION
5745: WHEN OTHERS THEN
5746: hr_data_pump.fail('get_child_organization_id', sqlerrm, p_child_organization_name,
5747: p_business_group_id, p_effective_date, p_language_code);
5748: raise;
5749: end get_child_organization_id;
5750: --
5758: l_person_extra_info_id := user_key_to_id( p_person_extra_info_user_key );
5759: return(l_person_extra_info_id);
5760: exception
5761: when others then
5762: hr_data_pump.fail('get_person_extra_info_id', sqlerrm, p_person_extra_info_user_key);
5763: raise;
5764: end get_person_extra_info_id;
5765: --
5766: --
5777: and pei.person_extra_info_id = key.unique_key_id;
5778: return(l_ovn);
5779: exception
5780: when others then
5781: hr_data_pump.fail('get_person_extra_info_ovn', sqlerrm, p_person_extra_info_user_key);
5782: raise;
5783: end get_person_extra_info_ovn;
5784:
5785: --
5794: l_emp_fed_tax_inf_id := user_key_to_id( P_EMP_FED_TAX_INF_USER_KEY );
5795: return(l_emp_fed_tax_inf_id);
5796: exception
5797: when others then
5798: hr_data_pump.fail('GET_EMP_FED_TAX_INF_ID', sqlerrm, P_EMP_FED_TAX_INF_USER_KEY);
5799: raise;
5800: end GET_EMP_FED_TAX_INF_ID;
5801:
5802:
5819: rules.effective_start_date and rules.effective_end_date;
5820: return(l_ovn);
5821: exception
5822: when others then
5823: hr_data_pump.fail('GET_CA_EMP_FEDTAX_INF_OVN', sqlerrm,
5824: P_EMP_FED_TAX_INF_USER_KEY, p_effective_date);
5825: raise;
5826: end GET_CA_EMP_FEDTAX_INF_OVN;
5827:
5837: l_emp_prov_tax_inf_id := user_key_to_id( P_EMP_PROV_TAX_INF_USER_KEY );
5838: return(l_emp_prov_tax_inf_id);
5839: exception
5840: when others then
5841: hr_data_pump.fail('GET_EMP_PROVINCE_TAX_INF_ID', sqlerrm, P_EMP_PROV_TAX_INF_USER_KEY);
5842: raise;
5843: end GET_EMP_PROVINCE_TAX_INF_ID;
5844:
5845:
5862: rules.effective_start_date and rules.effective_end_date;
5863: return(l_ovn);
5864: exception
5865: when others then
5866: hr_data_pump.fail('GET_CA_EMP_PRVTAX_INF_OVN', sqlerrm,
5867: P_EMP_PROV_TAX_INF_USER_KEY, p_effective_date);
5868: raise;
5869: end GET_CA_EMP_PRVTAX_INF_OVN;
5870: