[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:
2531: where pov.vendor_name = p_vendor_name;
2532: return(l_vendor_id);
2533: exception
2534: when others then
2535: hr_data_pump.fail('get_vendor_id', sqlerrm, p_vendor_name);
2536: raise;
2537: end get_vendor_id;
2538:
2539: /* returns an assignment_status_type_id */
2586: );
2587: return(l_assignment_status_type_id);
2588: exception
2589: when others then
2590: hr_data_pump.fail('get_assignment_status_type_id', sqlerrm, p_user_status,
2591: p_business_group_id, p_language_code);
2592: raise;
2593: end get_assignment_status_type_id;
2594:
2612: and org.business_group_id + 0 = p_business_group_id;
2613: return(l_organization_id);
2614: exception
2615: when others then
2616: hr_data_pump.fail('get_organization_id', sqlerrm, p_organization_name,
2617: p_business_group_id, p_effective_date, p_language_code);
2618: raise;
2619: end get_organization_id;
2620:
2633: p_effective_date, p_language_code );
2634: return(l_establishment_org_id);
2635: exception
2636: when others then
2637: hr_data_pump.fail('get_establishment_org_id', sqlerrm,
2638: p_establishment_org_name, p_business_group_id,
2639: p_effective_date, p_language_code);
2640: raise;
2641: end get_establishment_org_id;
2655: p_effective_date, p_language_code );
2656: return(l_source_organization_id);
2657: exception
2658: when others then
2659: hr_data_pump.fail('get_source_organization_id', sqlerrm,
2660: p_source_organization_name, p_business_group_id,
2661: p_effective_date, p_language_code);
2662: raise;
2663: end get_source_organization_id;
2682: and gra.business_group_id + 0 = p_business_group_id;
2683: return(l_grade_id);
2684: exception
2685: when others then
2686: hr_data_pump.fail('get_grade_id', sqlerrm, p_grade_name, p_business_group_id, p_effective_date);
2687: raise;
2688: end get_grade_id;
2689:
2690: /* returns a grade_id */
2735: end if;
2736: return v_shared_type_id;
2737: exception
2738: when others then
2739: hr_data_pump.fail('get_availability_status_id', sqlerrm,
2740: p_shared_type_name, p_system_type_cd,
2741: p_business_group_id, p_language_code);
2742: raise;
2743: end get_availability_status_id;
2760: pos.effective_start_date and pos.effective_end_date;
2761: return(l_position_id);
2762: exception
2763: when others then
2764: hr_data_pump.fail('get_position_id', sqlerrm, p_position_name,
2765: p_business_group_id, p_effective_date);
2766: raise;
2767: end get_position_id;
2768:
2781: p_effective_date);
2782: return(l_pos_id);
2783: exception
2784: when others then
2785: hr_data_pump.fail('get_successor_position_id', sqlerrm,
2786: p_successor_position_name, p_business_group_id,
2787: p_effective_date);
2788: raise;
2789: end get_successor_position_id;
2803: p_effective_date);
2804: return(l_pos_id);
2805: exception
2806: when others then
2807: hr_data_pump.fail('get_relief_position_id', sqlerrm,
2808: p_relief_position_name, p_business_group_id,
2809: p_effective_date);
2810: raise;
2811: end get_relief_position_id;
2825: p_effective_date);
2826: return(l_pos_id);
2827: exception
2828: when others then
2829: hr_data_pump.fail('get_prior_position_id', sqlerrm,
2830: p_prior_position_name, p_business_group_id,
2831: p_effective_date);
2832: raise;
2833: end get_prior_position_id;
2847: p_effective_date);
2848: return(l_pos_id);
2849: exception
2850: when others then
2851: hr_data_pump.fail('get_supervisor_position_id', sqlerrm,
2852: p_supervisor_position_name, p_business_group_id,
2853: p_effective_date);
2854: raise;
2855: end get_supervisor_position_id;
2870: and job.business_group_id + 0 = p_business_group_id;
2871: return(l_job_id);
2872: exception
2873: when others then
2874: hr_data_pump.fail('get_job_id', sqlerrm,
2875: p_job_name, p_effective_date, p_business_group_id);
2876: raise;
2877: end get_job_id;
2878:
2894: pay.effective_start_date and pay.effective_end_date;
2895: return(l_payroll_id);
2896: exception
2897: when others then
2898: hr_data_pump.fail('get_payroll_id', sqlerrm, p_payroll_name,
2899: p_business_group_id, p_effective_date);
2900: raise;
2901: end get_payroll_id;
2902:
2933: p_language_code);
2934: return(l_location_id);
2935: exception
2936: when others then
2937: hr_data_pump.fail('get_location_id_update', sqlerrm,
2938: p_existing_location_code,
2939: p_business_group_id, p_language_code);
2940: raise;
2941: end get_location_id_update;
2960: loc.business_group_id + 0 = p_business_group_id);
2961: return(l_location_id);
2962: exception
2963: when others then
2964: hr_data_pump.fail('get_location_id', sqlerrm, p_location_code,
2965: p_business_group_id, p_language_code);
2966: raise;
2967: end get_location_id;
2968:
2984: and full_name = p_designated_receiver_name;
2985: return l_designated_receiver_id;
2986: Exception
2987: When Others Then
2988: hr_data_pump.fail('get_designated_receiver_id',sqlerrm,p_designated_receiver_name,
2989: p_business_group_id);
2990: raise;
2991: end get_designated_receiver_id;
2992:
3009: loc.business_group_id + 0 = p_business_group_id);
3010: return(l_location_id);
3011: exception
3012: when others then
3013: hr_data_pump.fail('get_ship_to_location_id', sqlerrm, p_ship_to_location_code,
3014: p_business_group_id, p_language_code);
3015: raise;
3016: end get_ship_to_location_id;
3017:
3030: and ppb.business_group_id + 0 = p_business_group_id;
3031: return(l_pay_basis_id);
3032: exception
3033: when others then
3034: hr_data_pump.fail('get_pay_basis_id', sqlerrm, p_pay_basis_name,
3035: p_business_group_id);
3036: raise;
3037: end get_pay_basis_id;
3038:
3054: pra.date_start and nvl(pra.date_end, END_OF_TIME);
3055: return(l_raid);
3056: exception
3057: when others then
3058: hr_data_pump.fail('get_recruitment_activity_id', sqlerrm,
3059: p_recruitment_activity_name, p_business_group_id,
3060: p_effective_date);
3061: raise;
3062: end get_recruitment_activity_id;
3071: l_vacancy_id := user_key_to_id( p_vacancy_user_key );
3072: return(l_vacancy_id);
3073: exception
3074: when others then
3075: hr_data_pump.fail('get_vacancy_id', sqlerrm, p_vacancy_user_key );
3076: raise;
3077: end get_vacancy_id;
3078:
3079: /* returns an org_payment_method_id */
3086: l_opmid := user_key_to_id( p_org_payment_method_user_key );
3087: return(l_opmid);
3088: exception
3089: when others then
3090: hr_data_pump.fail('get_org_payment_method_id', sqlerrm,
3091: p_org_payment_method_user_key );
3092: raise;
3093: end get_org_payment_method_id;
3094:
3107: p_effective_date, p_language_code );
3108: return(l_organization_id);
3109: exception
3110: when others then
3111: hr_data_pump.fail('get_payee_org_id', sqlerrm, p_payee_organization_name,
3112: p_business_group_id, p_effective_date, p_language_code);
3113: raise;
3114: end get_payee_org_id;
3115:
3123: l_person_id := get_person_id( p_payee_person_user_key );
3124: return(l_person_id);
3125: exception
3126: when others then
3127: hr_data_pump.fail('get_payee_person_id', sqlerrm, p_payee_person_user_key);
3128: raise;
3129: end get_payee_person_id;
3130:
3131: /* return payee_id for an organization or person payee. */
3176: raise value_error;
3177: end if;
3178: exception
3179: when others then
3180: hr_data_pump.fail('get_payee_id', sqlerrm, p_payee_type, p_payee_org,
3181: p_payee_person_user_key, p_effective_date, p_language_code);
3182: raise;
3183: end get_payee_id;
3184:
3192: l_ppmid := user_key_to_id( p_personal_pay_method_user_key );
3193: return(l_ppmid);
3194: exception
3195: when others then
3196: hr_data_pump.fail('get_personal_payment_method_id', sqlerrm,
3197: p_personal_pay_method_user_key);
3198: raise;
3199: end get_personal_payment_method_id;
3200:
3211: where sob.name = p_set_of_books_name;
3212: return(l_id);
3213: exception
3214: when others then
3215: hr_data_pump.fail('get_set_of_books_id', sqlerrm, p_set_of_books_name);
3216: raise;
3217: end get_set_of_books_id;
3218:
3219: /* returns a tax_unit_id */
3230: where tax.name = p_tax_unit_name;
3231: return(l_tax_unit_id);
3232: exception
3233: when others then
3234: hr_data_pump.fail('get_tax_unit_id', sqlerrm, p_tax_unit_name,
3235: p_effective_date);
3236: raise;
3237: end get_tax_unit_id;
3238:
3264: hoi.org_information1 is null);
3265: return(l_id);
3266: exception
3267: when others then
3268: hr_data_pump.fail('get_work_schedule', sqlerrm, p_work_schedule,
3269: p_organization_name, p_business_group_id,
3270: p_effective_date, p_language_code);
3271: raise;
3272: end get_work_schedule;
3287: and est.business_group_id + 0 = p_business_group_id;
3288: return(l_id);
3289: exception
3290: when others then
3291: hr_data_pump.fail('get_eeo_1_establishment_id', sqlerrm,
3292: p_eeo_1_establishment, p_business_group_id,
3293: p_effective_date);
3294: raise;
3295: end get_eeo_1_establishment_id;
3326: l_id_flex_num := user_key_to_id( p_id_flex_num_user_key );
3327: return(l_id_flex_num);
3328: exception
3329: when others then
3330: hr_data_pump.fail('get_id_flex_num', sqlerrm, p_id_flex_num_user_key);
3331: raise;
3332: end get_id_flex_num;
3333:
3334: /* get_gr_grade_rule_id */
3359: pgr.effective_end_date;
3360: return(l_grade_rule_id);
3361: exception
3362: when others then
3363: hr_data_pump.fail('get_gr_grade_rule_id', sqlerrm, p_grade_name,
3364: p_rate_name, p_business_group_id, p_effective_date);
3365: raise;
3366: end get_gr_grade_rule_id;
3367:
3398: pgr.effective_end_date;
3399: return( l_grade_rule_id );
3400: exception
3401: when others then
3402: hr_data_pump.fail('get_pp_grade_rule_id', sqlerrm, p_progression_point,
3403: p_pay_scale, p_rate_name, p_business_group_id,
3404: p_effective_date);
3405: raise;
3406: end get_pp_grade_rule_id;
3428: pgr.effective_end_date;
3429: return(l_grade_rule_id);
3430: exception
3431: when others then
3432: hr_data_pump.fail('get_ar_grade_rule_id', sqlerrm,
3433: p_rate_name, p_business_group_id, p_effective_date);
3434: raise;
3435: end get_ar_grade_rule_id;
3436:
3449: and pos.business_group_id + 0 = p_business_group_id;
3450: return (l_organization_structure_id);
3451: exception
3452: when others then
3453: hr_data_pump.fail('get_organization_structure_id', sqlerrm, p_name, p_business_group_id);
3454: raise;
3455: end get_organization_structure_id;
3456:
3457: function get_org_str_ver_id
3473: and osv.business_group_id + 0 = p_business_group_id;
3474: return (l_org_str_ver_id);
3475: exception
3476: when others then
3477: hr_data_pump.fail('get_org_str_ver_id', sqlerrm, p_business_group_id, p_organization_structure_id, p_date_from, p_version_number);
3478: raise;
3479: end get_org_str_ver_id;
3480:
3481: /* get_spinal_point_id */
3500: and psp.parent_spine_id = pps.parent_spine_id;
3501: return( l_spinal_point_id );
3502: exception
3503: when others then
3504: hr_data_pump.fail('get_spinal_point_id', sqlerrm, p_progression_point,
3505: p_pay_scale, p_business_group_id, p_effective_date);
3506: raise;
3507: end get_spinal_point_id;
3508:
3525: and pps.actual_termination_date is null;
3526: return(l_period_of_service_id);
3527: exception
3528: when others then
3529: hr_data_pump.fail('get_at_period_of_service_id', sqlerrm,
3530: p_person_user_key, p_business_group_id);
3531: raise;
3532: end get_at_period_of_service_id;
3533:
3551: and pps.final_process_date is null;
3552: return(l_period_of_service_id);
3553: exception
3554: when others then
3555: hr_data_pump.fail('get_fp_period_of_service_id', sqlerrm, p_person_user_key,
3556: p_business_group_id);
3557: raise;
3558: end get_fp_period_of_service_id;
3559:
3580: and p_effective_date between pps.date_start and NVL(pps.actual_termination_date,l_eot);
3581: return(l_period_of_service_id);
3582: exception
3583: when others then
3584: hr_data_pump.fail('get_ut_period_of_service_id', sqlerrm, p_person_user_key,
3585: p_effective_date,p_business_group_id);
3586: raise;
3587: end get_ut_period_of_service_id;
3588:
3598: user_key_to_id( p_special_ceilin_step_user_key );
3599: return(l_special_ceiling_step_id);
3600: exception
3601: when others then
3602: hr_data_pump.fail('get_special_ceiling_step_id', sqlerrm,
3603: p_special_ceilin_step_user_key );
3604: raise;
3605: end get_special_ceiling_step_id;
3606:
3615: l_default_code_comb_id := user_key_to_id( p_default_code_comb_user_key );
3616: return(l_default_code_comb_id);
3617: exception
3618: when others then
3619: hr_data_pump.fail('get_default_code_comb_id', sqlerrm,
3620: p_default_code_comb_user_key );
3621: raise;
3622: end get_default_code_comb_id;
3623:
3632: l_phone_id := user_key_to_id( p_phone_user_key );
3633: return(l_phone_id);
3634: exception
3635: when others then
3636: hr_data_pump.fail('get_phone_id', sqlerrm, p_phone_user_key);
3637: raise;
3638: end get_phone_id;
3639:
3640: /*-------------------------- get_grade_ladder_pgm_id -----------------------*/
3655: between pgm.effective_start_date and pgm.effective_end_date;
3656: return(l_grade_ladder_pgm_id);
3657: exception
3658: when others then
3659: hr_data_pump.fail('get_grade_ladder_pgm_id', sqlerrm,
3660: p_grade_ladder_name);
3661: raise;
3662: end get_grade_ladder_pgm_id;
3663: /*---------------------- get_supervisor_assignment_id -----------------------*/
3671: l_supervisor_assignment_id := get_assignment_id(p_svr_assignment_user_key );
3672: return(l_supervisor_assignment_id);
3673: exception
3674: when others then
3675: hr_data_pump.fail('get_supervisor_assignment_id', sqlerrm,
3676: p_svr_assignment_user_key);
3677: raise;
3678: end get_supervisor_assignment_id;
3679:
3693: and business_group_id = p_business_group_id;
3694: return(l_parent_spine_id);
3695: exception
3696: when others then
3697: hr_data_pump.fail('get_parent_spine_id', sqlerrm, p_parent_spine,
3698: p_business_group_id);
3699: raise;
3700: end get_parent_spine_id;
3701: /*--------------------- get_ceiling_step_id ----------------------------------*/
3719: sps.effective_start_date and sps.effective_end_date;
3720: return(l_ceiling_step_id);
3721: exception
3722: when others then
3723: hr_data_pump.fail('get_ceiling_step_id', sqlerrm, p_ceiling_point,
3724: p_business_group_id, p_effective_date);
3725: raise;
3726: end get_ceiling_step_id;
3727:
3746: nvl(start_date,START_OF_TIME) and nvl(end_date,END_OF_TIME);
3747: return l_object_version_number;
3748: exception
3749: when others then
3750: hr_data_pump.fail('get_collective_agreement_ovn', sqlerrm,
3751: p_business_group_id, p_cagr_name, p_effective_date);
3752: raise;
3753: end get_collective_agreement_ovn;
3754:
3769: pc.effective_start_date and pc.effective_end_date;
3770: return(l_object_version_number);
3771: exception
3772: when others then
3773: hr_data_pump.fail('get_contract_ovn', sqlerrm, p_contract_user_key);
3774: raise;
3775: end get_contract_ovn;
3776:
3777: /*--------------------------- get_establishment_ovn ---------------------------*/
3788: and pe.name = p_establishment_name;
3789: return l_object_version_number;
3790: exception
3791: when others then
3792: hr_data_pump.fail('get_establishment_ovn', sqlerrm,
3793: p_establishment_name, p_location);
3794: raise;
3795: end get_establishment_ovn;
3796:
3812: rules.effective_start_date and rules.effective_end_date;
3813: return(l_ovn);
3814: exception
3815: when others then
3816: hr_data_pump.fail('get_us_emp_fed_tax_rule_ovn', sqlerrm,
3817: p_emp_fed_tax_rule_user_key, p_effective_date);
3818: raise;
3819: end get_us_emp_fed_tax_rule_ovn;
3820:
3836: rules.effective_start_date and rules.effective_end_date;
3837: return(l_ovn);
3838: exception
3839: when others then
3840: hr_data_pump.fail('get_us_emp_state_tax_rule_ovn', sqlerrm,
3841: p_emp_state_tax_rule_user_key, p_effective_date);
3842: raise;
3843: end get_us_emp_state_tax_rule_ovn;
3844:
3860: rules.effective_start_date and rules.effective_end_date;
3861: return(l_ovn);
3862: exception
3863: when others then
3864: hr_data_pump.fail('get_us_emp_county_tax_rule_ovn', sqlerrm,
3865: p_emp_county_tax_rule_user_key, p_effective_date);
3866: raise;
3867: end get_us_emp_county_tax_rule_ovn;
3868:
3884: rules.effective_start_date and rules.effective_end_date;
3885: return(l_ovn);
3886: exception
3887: when others then
3888: hr_data_pump.fail('get_us_emp_city_tax_rule_ovn', sqlerrm,
3889: p_emp_city_tax_rule_user_key, p_effective_date);
3890: raise;
3891: end get_us_emp_city_tax_rule_ovn;
3892:
3908: per.effective_start_date and per.effective_end_date;
3909: return(l_ovn);
3910: exception
3911: when others then
3912: hr_data_pump.fail('get_per_ovn', sqlerrm, p_person_user_key,
3913: p_effective_date);
3914: raise;
3915: end get_per_ovn;
3916:
3932: asg.effective_start_date and asg.effective_end_date;
3933: return(l_ovn);
3934: exception
3935: when others then
3936: hr_data_pump.fail('get_asg_ovn', sqlerrm, p_assignment_user_key,
3937: p_effective_date);
3938: raise;
3939: end get_asg_ovn;
3940:
3954: and adr.address_id = key.unique_key_id;
3955: return(l_ovn);
3956: exception
3957: when others then
3958: hr_data_pump.fail('get_adr_ovn', sqlerrm, p_address_user_key,
3959: p_effective_date);
3960: raise;
3961: end get_adr_ovn;
3962:
3976: where loc.location_code = p_location_code;
3977: return(l_ovn);
3978: exception
3979: when others then
3980: hr_data_pump.fail('get_loc_ovn', sqlerrm, p_location_code);
3981: raise;
3982: end get_loc_ovn;
3983:
3984: /* returns a job object version number */
3996: and ors.business_group_id + 0 = p_business_group_id;
3997: return(l_ovn);
3998: exception
3999: when others then
4000: hr_data_pump.fail('get_org_str_ovn', sqlerrm, p_name, p_business_group_id);
4001: raise;
4002: end get_org_str_ovn;
4003:
4004: /* returns a organization structure version object version number */
4020: and osv.business_group_id + 0 = p_business_group_id;
4021: return(l_ovn);
4022: exception
4023: when others then
4024: hr_data_pump.fail('get_org_str_ver_ovn', sqlerrm, p_business_group_id, p_organization_structure_id, p_date_from, p_version_number);
4025: raise;
4026: end get_org_str_ver_ovn;
4027:
4028: /* returns an organization object version number */
4044: and org.business_group_id + 0 = p_business_group_id;
4045: return(l_ovn);
4046: exception
4047: when others then
4048: hr_data_pump.fail('get_org_ovn', sqlerrm, p_business_group_id, p_organization_name, p_language_code);
4049: raise;
4050: end get_org_ovn;
4051:
4052: /* returns a job object version number */
4065: and job.business_group_id + 0 = p_business_group_id;
4066: return(l_ovn);
4067: exception
4068: when others then
4069: hr_data_pump.fail('get_job_ovn', sqlerrm, p_job_name, p_effective_date,
4070: p_business_group_id);
4071: raise;
4072: end get_job_ovn;
4073:
4089: pos.effective_start_date and pos.effective_end_date;
4090: return(l_ovn);
4091: exception
4092: when others then
4093: hr_data_pump.fail('get_pos_ovn', sqlerrm, p_position_name,
4094: p_business_group_id, p_effective_date);
4095: raise;
4096: end get_pos_ovn;
4097:
4113: ppm.effective_start_date and ppm.effective_end_date;
4114: return(l_ovn);
4115: exception
4116: when others then
4117: hr_data_pump.fail('get_ppm_ovn', sqlerrm,
4118: p_personal_pay_method_user_key, p_effective_date);
4119: raise;
4120: end get_ppm_ovn;
4121:
4137: pee.effective_start_date and pee.effective_end_date;
4138: return(l_element_entry_ovn);
4139: exception
4140: when others then
4141: hr_data_pump.fail('get_element_entry_ovn', sqlerrm, p_element_entry_user_key, p_effective_date);
4142: raise;
4143: end get_element_entry_ovn;
4144:
4145: /* get_gr_grade_rule_ovn */
4170: pgr.effective_end_date;
4171: return(l_object_version_number);
4172: exception
4173: when others then
4174: hr_data_pump.fail('get_gr_grade_rule_ovn', sqlerrm, p_grade_name,
4175: p_rate_name, p_business_group_id, p_effective_date);
4176: raise;
4177: end get_gr_grade_rule_ovn;
4178:
4209: pgr.effective_end_date;
4210: return(l_object_version_number);
4211: exception
4212: when others then
4213: hr_data_pump.fail('get_pp_grade_rule_id', sqlerrm, p_progression_point,
4214: p_pay_scale, p_rate_name, p_business_group_id,
4215: p_effective_date);
4216: raise;
4217: end get_pp_grade_rule_ovn;
4235: and pps.actual_termination_date is null;
4236: return(l_object_version_number);
4237: exception
4238: when others then
4239: hr_data_pump.fail('get_at_period_of_service_ovn', sqlerrm, p_person_user_key,
4240: p_business_group_id);
4241: raise;
4242: end get_at_period_of_service_ovn;
4243:
4261: and pps.final_process_date is null;
4262: return(l_object_version_number);
4263: exception
4264: when others then
4265: hr_data_pump.fail('get_fp_period_of_service_ovn', sqlerrm, p_person_user_key,
4266: p_business_group_id);
4267: raise;
4268: end get_fp_period_of_service_ovn;
4269:
4290: and p_effective_date between pps.date_start and NVL(pps.actual_termination_date,l_eot);
4291: return(l_object_version_number);
4292: exception
4293: when others then
4294: hr_data_pump.fail('get_ut_period_of_service_id', sqlerrm, p_person_user_key,
4295: p_effective_date,p_business_group_id);
4296: raise;
4297: end get_ut_period_of_service_ovn;
4298:
4306: l_entry_step_id := user_key_to_id( p_entry_step_user_key );
4307: return(l_entry_step_id);
4308: exception
4309: when others then
4310: hr_data_pump.fail('get_entry_step_id', sqlerrm, p_entry_step_user_key);
4311: raise;
4312: end get_entry_step_id;
4313:
4314: /* get entry_grade_rule_id - requires user key */
4321: l_entry_grade_rule_id := user_key_to_id( p_entry_grade_rule_user_key );
4322: return(l_entry_grade_rule_id);
4323: exception
4324: when others then
4325: hr_data_pump.fail('get_entry_grade_rule_id', sqlerrm, p_entry_grade_rule_user_key);
4326: raise;
4327: end get_entry_grade_rule_id;
4328:
4329: /* Added for 11i - Rvydyana - 06-DEC-1999 */
4342: and phn.phone_id = key.unique_key_id;
4343: return(l_ovn);
4344: exception
4345: when others then
4346: hr_data_pump.fail('get_phn_ovn', sqlerrm, p_phone_user_key);
4347: raise;
4348: end get_phn_ovn;
4349: --
4350: /* --------------------------------------------------- */
4364: and jgr.job_group_id = key.unique_key_id;
4365: return(l_ovn);
4366: exception
4367: when others then
4368: hr_data_pump.fail('get_jgr_ovn', sqlerrm, p_job_group_user_key);
4369: raise;
4370: end get_jgr_ovn;
4371:
4372: /* --------------------------------------------------- */
4386: and rol.role_id = key.unique_key_id;
4387: return(l_ovn);
4388: exception
4389: when others then
4390: hr_data_pump.fail('get_rol_ovn', sqlerrm, p_role_user_key);
4391: raise;
4392: end get_rol_ovn;
4393: /*-------------- returns a pay scale object version number --------------------*/
4394: function get_pay_scale_ovn
4405: and business_group_id + 0 = p_business_group_id;
4406: return(l_ovn);
4407: exception
4408: when others then
4409: hr_data_pump.fail('get_pay_scale_ovn', sqlerrm, p_pay_scale,
4410: p_business_group_id);
4411: raise;
4412: end get_pay_scale_ovn;
4413: /*-------------- returns a preogresion point object version number ------------*/
4425: and business_group_id + 0 = p_business_group_id;
4426: return(l_ovn);
4427: exception
4428: when others then
4429: hr_data_pump.fail('get_progression_point_ovn', sqlerrm, p_point,
4430: p_business_group_id);
4431: raise;
4432: end get_progression_point_ovn;
4433: /*-------------- returns a grade scale object version number ------------*/
4454: pgs.effective_start_date and pgs.effective_end_date;
4455: return(l_ovn);
4456: exception
4457: when others then
4458: hr_data_pump.fail('get_grade_scale_ovn', sqlerrm, p_grade,
4459: p_pay_scale, p_effective_date ,p_business_group_id);
4460: raise;
4461: end get_grade_scale_ovn;
4462: /*-------------- returns a grade step object version number ------------*/
4484: sps.effective_start_date and sps.effective_end_date;
4485: return(l_ovn);
4486: exception
4487: when others then
4488: hr_data_pump.fail('get_grade_step_ovn', sqlerrm, p_point,
4489: p_sequence,p_effective_date, p_business_group_id);
4490: raise;
4491: end get_grade_step_ovn;
4492: /*---------------------------------------------------------------------------*/
4510: -- entering the code directly.
4511: when no_data_found then
4512: return(p_correspondence_language);
4513: when others then
4514: hr_data_pump.fail('get_correspondence_language', sqlerrm,
4515: p_correspondence_language);
4516: raise;
4517: end get_correspondence_language;
4518:
4530: -- entering the code directly.
4531: when no_data_found then
4532: return(p_country);
4533: when others then
4534: hr_data_pump.fail('get_country', sqlerrm, p_country );
4535: raise;
4536: end get_country;
4537:
4538: /* get change reason lookup code, dependent on assignment */
4573: -- Assume that the user entered the code directly when no data found.
4574: when no_data_found then
4575: return(p_change_reason);
4576: when others then
4577: hr_data_pump.fail('get_change_reason', sqlerrm, p_change_reason,
4578: p_assignment_user_key, p_effective_date);
4579: raise;
4580: end get_change_reason;
4581:
4589: l_job_group_id := user_key_to_id( p_job_group_user_key );
4590: return(l_job_group_id);
4591: exception
4592: when others then
4593: hr_data_pump.fail('get_job_group_id', sqlerrm, p_job_group_user_key);
4594: raise;
4595: end get_job_group_id;
4596:
4597: /* get_benchmark_job_id - requires user key */
4604: l_benchmark_job_id := user_key_to_id( p_benchmark_job_user_key );
4605: return(l_benchmark_job_id);
4606: exception
4607: when others then
4608: hr_data_pump.fail('get_benchmark_job_id', sqlerrm, p_benchmark_job_user_key);
4609: raise;
4610: end get_benchmark_job_id;
4611:
4612: /* get_role_id - requires user key */
4619: l_role_id := user_key_to_id( p_role_user_key );
4620: return(l_role_id);
4621: exception
4622: when others then
4623: hr_data_pump.fail('get_role_id', sqlerrm, p_role_user_key);
4624: raise;
4625: end get_role_id;
4626:
4627: /* get_loc_id - requires user key */
4634: l_location_id := user_key_to_id( p_location_user_key );
4635: return(l_location_id);
4636: exception
4637: when others then
4638: hr_data_pump.fail('get_loc_id', sqlerrm, p_location_user_key);
4639: raise;
4640: end get_loc_id;
4641:
4642: /* get_org_structure_id - requires user key */
4649: l_organization_structure_id := user_key_to_id( p_org_structure_user_key );
4650: return(l_organization_structure_id);
4651: exception
4652: when others then
4653: hr_data_pump.fail('get_org_structure_id', sqlerrm, p_org_structure_user_key);
4654: raise;
4655: end get_org_structure_id;
4656:
4657: /* get_org_str_version_id - requires user key */
4664: l_org_structure_version_id := user_key_to_id( p_org_str_version_user_key );
4665: return(l_org_structure_version_id);
4666: exception
4667: when others then
4668: hr_data_pump.fail('get_org_str_version_id', sqlerrm, p_org_str_version_user_key);
4669: raise;
4670: end get_org_str_version_id;
4671:
4672: /* get_org_id - requires user key */
4679: l_org_id := user_key_to_id( p_org_user_key );
4680: return(l_org_id);
4681: exception
4682: when others then
4683: hr_data_pump.fail('get_org_id', sqlerrm, p_org_user_key);
4684: raise;
4685: end get_org_id;
4686:
4687: /* get_grade_rule_id - requires user key */
4694: l_grade_rule_id := user_key_to_id( p_grade_rule_user_key );
4695: return(l_grade_rule_id);
4696: exception
4697: when others then
4698: hr_data_pump.fail('get_grade_rule_id', sqlerrm, p_grade_rule_user_key);
4699: raise;
4700: end get_grade_rule_id;
4701:
4702: /* returns lookup_code */
4713: begin
4714: --
4715: -- Is lookup checking disabled ?
4716: --
4717: if hr_data_pump.g_disable_lookup_checks then
4718: return p_meaning_or_code;
4719: end if;
4720: --
4721: -- Set language code (handling possible defaults).
4775: -- should be able to pick up bad code values.
4776: --
4777: return(p_meaning_or_code);
4778: when others then
4779: hr_data_pump.fail
4780: ('get_lookup_code', sqlerrm, p_meaning_or_code,
4781: p_lookup_type, p_effective_date, p_language_code);
4782: raise;
4783: end gl;
4812: --
4813: return(l_people_group_id);
4814: exception
4815: when others then
4816: hr_data_pump.fail('get_people_group_id', sqlerrm,
4817: p_people_group_user_name,
4818: p_effective_date);
4819: raise;
4820: end get_people_group_id;
4840: --
4841: return(l_absence_attendance_type_id);
4842: exception
4843: when others then
4844: hr_data_pump.fail('get_absence_attendance_type_id', sqlerrm,
4845: p_aat_user_name,
4846: p_business_group_id,
4847: p_effective_date);
4848: raise;
4866: --
4867: return(l_soft_coding_keyflex_id);
4868: exception
4869: when others then
4870: hr_data_pump.fail('get_soft_coding_keyflex_id', sqlerrm,
4871: p_con_seg_user_name,
4872: p_effective_date);
4873: raise;
4874: end get_soft_coding_keyflex_id;
4885: --
4886: return(l_pk_id);
4887: exception
4888: when others then
4889: hr_data_pump.fail('get_pk_id', sqlerrm,
4890: p_pk_name
4891: );
4892: raise;
4893: end get_pk_id;
4911:
4912: return l_ovn;
4913: exception
4914: when others then
4915: hr_data_pump.fail('get_fed_tax_rule_ovn', sqlerrm,
4916: p_emp_fed_tax_rule_user_key,
4917: p_effective_date);
4918: raise;
4919: end get_fed_tax_rule_ovn;
4940:
4941: return l_ovn;
4942: exception
4943: when others then
4944: hr_data_pump.fail('get_state_tax_rule_ovn', sqlerrm,
4945: p_emp_state_tax_rule_user_key,
4946: p_effective_date);
4947: raise;
4948: end get_state_tax_rule_ovn;
4966:
4967: return l_ovn;
4968: exception
4969: when others then
4970: hr_data_pump.fail('get_county_tax_rule_ovn', sqlerrm,
4971: p_emp_county_tax_rule_user_key,
4972: p_effective_date);
4973: raise;
4974: end get_county_tax_rule_ovn;
4993:
4994: return l_ovn;
4995: exception
4996: when others then
4997: hr_data_pump.fail('get_city_tax_rule_ovn', sqlerrm,
4998: p_emp_city_tax_rule_user_key,
4999: p_effective_date);
5000: raise;
5001: end get_city_tax_rule_ovn;
5016: BEGIN
5017: return (null);
5018: EXCEPTION
5019: WHEN OTHERS THEN
5020: hr_data_pump.fail('get_parent_comp_element_id'
5021: , sqlerrm
5022: );
5023: RAISE;
5024: END get_parent_comp_element_id;
5066:
5067: RETURN(l_competence_id);
5068: EXCEPTION
5069: WHEN OTHERS THEN
5070: hr_data_pump.fail('get_competence_id'
5071: , sqlerrm
5072: , p_competence_name
5073: , p_business_group_id);
5074: RAISE;
5120:
5121: RETURN(l_cpn_ovn);
5122: EXCEPTION
5123: WHEN OTHERS THEN
5124: hr_data_pump.fail('get_cpn_ovn'
5125: , sqlerrm
5126: , p_competence_name
5127: , p_business_group_id);
5128: RAISE;
5158:
5159: RETURN(l_qualification_type_id);
5160: EXCEPTION
5161: WHEN OTHERS THEN
5162: hr_data_pump.fail('get_qualification_type_id'
5163: , sqlerrm
5164: , p_qualification_type_name);
5165: RAISE;
5166: END get_qualification_type_id;
5196:
5197: RETURN(l_outcome_id);
5198: EXCEPTION
5199: WHEN OTHERS THEN
5200: hr_data_pump.fail('get_outcome_id'
5201: , sqlerrm
5202: , p_outcome_name
5203: );
5204: RAISE;
5237:
5238: RETURN(l_cpo_ovn);
5239: EXCEPTION
5240: WHEN OTHERS THEN
5241: hr_data_pump.fail('get_cpo_ovn'
5242: , sqlerrm
5243: , p_outcome_name
5244: );
5245: RAISE;
5278:
5279: RETURN(l_eqt_ovn);
5280: EXCEPTION
5281: WHEN OTHERS THEN
5282: hr_data_pump.fail('get_eqt_ovn'
5283: , sqlerrm
5284: , p_qualification_type_name
5285: );
5286: RAISE;
5319:
5320: RETURN(l_ceo_ovn);
5321: EXCEPTION
5322: WHEN OTHERS THEN
5323: hr_data_pump.fail('get_ceo_ovn'
5324: , sqlerrm
5325: , p_element_outcome_name
5326: );
5327: RAISE;
5359:
5360: RETURN(l_competence_element_id);
5361: EXCEPTION
5362: WHEN OTHERS THEN
5363: hr_data_pump.fail('get_competence_element_id'
5364: , sqlerrm
5365: , p_competence_name
5366: , p_person_user_key
5367: , p_business_group_id
5396:
5397: RETURN(l_cost_code);
5398: EXCEPTION
5399: WHEN OTHERS THEN
5400: hr_data_pump.fail('get_cost_flex_stru_num'
5401: , sqlerrm
5402: , p_cost_flex_stru_code
5403: );
5404: RAISE;
5430:
5431: RETURN(l_grade_code);
5432: EXCEPTION
5433: WHEN OTHERS THEN
5434: hr_data_pump.fail('get_grade_flex_stru_num'
5435: , sqlerrm
5436: , p_grade_flex_stru_code
5437: );
5438: RAISE;
5464:
5465: RETURN(l_job_code);
5466: EXCEPTION
5467: WHEN OTHERS THEN
5468: hr_data_pump.fail('get_job_flex_stru_num'
5469: , sqlerrm
5470: , p_job_flex_stru_code
5471: );
5472: RAISE;
5498:
5499: RETURN(l_position_code);
5500: EXCEPTION
5501: WHEN OTHERS THEN
5502: hr_data_pump.fail('get_position_flex_stru_num'
5503: , sqlerrm
5504: , p_position_flex_stru_code
5505: );
5506: RAISE;
5532:
5533: RETURN(l_group_code);
5534: EXCEPTION
5535: WHEN OTHERS THEN
5536: hr_data_pump.fail('get_group_flex_stru_num'
5537: , sqlerrm
5538: , p_group_flex_stru_code
5539: );
5540: RAISE;
5566:
5567: RETURN(l_competence_code);
5568: EXCEPTION
5569: WHEN OTHERS THEN
5570: hr_data_pump.fail('get_competence_flex_stru_num'
5571: , sqlerrm
5572: , p_competence_flex_stru_code
5573: );
5574: RAISE;
5602:
5603: RETURN(l_get_sec_group_id);
5604: EXCEPTION
5605: WHEN OTHERS THEN
5606: hr_data_pump.fail('get_sec_group_id'
5607: , sqlerrm
5608: , p_security_group_name
5609: );
5610: RAISE;
5638:
5639: RETURN(l_sec_profile_id);
5640: EXCEPTION
5641: WHEN OTHERS THEN
5642: hr_data_pump.fail('get_security_profile_id'
5643: , sqlerrm
5644: , p_security_profile_name
5645: , p_business_group_id
5646: );
5678: END IF;
5679: return(l_organization_id);
5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: hr_data_pump.fail('get_parent_organization_id', sqlerrm, p_parent_organization_name,
5683: p_business_group_id, p_effective_date, p_language_code);
5684: raise;
5685: end get_parent_organization_id;
5686: --
5715: --
5716: return(l_organization_id);
5717: EXCEPTION
5718: WHEN OTHERS THEN
5719: hr_data_pump.fail('get_child_organization_id', sqlerrm, p_child_organization_name,
5720: p_business_group_id, p_effective_date, p_language_code);
5721: raise;
5722: end get_child_organization_id;
5723: --
5731: l_person_extra_info_id := user_key_to_id( p_person_extra_info_user_key );
5732: return(l_person_extra_info_id);
5733: exception
5734: when others then
5735: hr_data_pump.fail('get_person_extra_info_id', sqlerrm, p_person_extra_info_user_key);
5736: raise;
5737: end get_person_extra_info_id;
5738: --
5739: --
5750: and pei.person_extra_info_id = key.unique_key_id;
5751: return(l_ovn);
5752: exception
5753: when others then
5754: hr_data_pump.fail('get_person_extra_info_ovn', sqlerrm, p_person_extra_info_user_key);
5755: raise;
5756: end get_person_extra_info_ovn;
5757:
5758: --
5767: l_emp_fed_tax_inf_id := user_key_to_id( P_EMP_FED_TAX_INF_USER_KEY );
5768: return(l_emp_fed_tax_inf_id);
5769: exception
5770: when others then
5771: hr_data_pump.fail('GET_EMP_FED_TAX_INF_ID', sqlerrm, P_EMP_FED_TAX_INF_USER_KEY);
5772: raise;
5773: end GET_EMP_FED_TAX_INF_ID;
5774:
5775:
5792: rules.effective_start_date and rules.effective_end_date;
5793: return(l_ovn);
5794: exception
5795: when others then
5796: hr_data_pump.fail('GET_CA_EMP_FEDTAX_INF_OVN', sqlerrm,
5797: P_EMP_FED_TAX_INF_USER_KEY, p_effective_date);
5798: raise;
5799: end GET_CA_EMP_FEDTAX_INF_OVN;
5800:
5810: l_emp_prov_tax_inf_id := user_key_to_id( P_EMP_PROV_TAX_INF_USER_KEY );
5811: return(l_emp_prov_tax_inf_id);
5812: exception
5813: when others then
5814: hr_data_pump.fail('GET_EMP_PROVINCE_TAX_INF_ID', sqlerrm, P_EMP_PROV_TAX_INF_USER_KEY);
5815: raise;
5816: end GET_EMP_PROVINCE_TAX_INF_ID;
5817:
5818:
5835: rules.effective_start_date and rules.effective_end_date;
5836: return(l_ovn);
5837: exception
5838: when others then
5839: hr_data_pump.fail('GET_CA_EMP_PRVTAX_INF_OVN', sqlerrm,
5840: P_EMP_PROV_TAX_INF_USER_KEY, p_effective_date);
5841: raise;
5842: end GET_CA_EMP_PRVTAX_INF_OVN;
5843: