44:
45: return c_item_type;
46: EXCEPTION
47: WHEN OTHERS THEN
48: WF_CORE.CONTEXT(g_package,'.get_item_type',p_transaction_id);
49: RAISE;
50:
51: end get_item_type;
52:
87:
88: return get_item_key.c_item_key;
89: EXCEPTION
90: WHEN OTHERS THEN
91: WF_CORE.CONTEXT(g_package,'.get_item_key',p_transaction_id);
92: RAISE;
93:
94: end get_item_key;
95:
113:
114: return c_process_name;
115: EXCEPTION
116: WHEN OTHERS THEN
117: WF_CORE.CONTEXT(g_package,'.get_process_name',c_item_type,c_item_key);
118: RAISE;
119: end get_process_name ;
120:
121: ------------------------------------------------------------------
314: return fnd_number.number_to_canonical(ln_requestor_person_id);
315: EXCEPTION
316:
317: WHEN OTHERS THEN
318: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
319: RAISE;
320:
321: END get_requestor_person_id;
322:
345:
346: return fnd_number.number_to_canonical(c_assignment_id);
347: EXCEPTION
348: WHEN OTHERS THEN
349: WF_CORE.CONTEXT(g_package,'.get_sel_person_assignment_id',c_item_type,c_item_key);
350: RAISE;
351:
352:
353: end get_sel_person_assignment_id ;
385: return fnd_number.number_to_canonical(ln_step_id);
386: EXCEPTION
387:
388: WHEN OTHERS THEN
389: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
390: RAISE;
391:
392: END get_payrate_step_id;
393:
425: return fnd_number.number_to_canonical(ln_step_id);
426: EXCEPTION
427:
428: WHEN OTHERS THEN
429: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
430: RAISE;
431:
432: END get_assignment_step_id;
433:
463: return fnd_number.number_to_canonical(ln_step_id);
464: EXCEPTION
465:
466: WHEN OTHERS THEN
467: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
468: RAISE;
469:
470: END get_supeversior_Chg_step_id;
471:
501: return fnd_number.number_to_canonical(ln_step_id);
502: EXCEPTION
503:
504: WHEN OTHERS THEN
505: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
506: RAISE;
507:
508: END get_loa_step_id;
509:
539: return fnd_number.number_to_canonical(ln_step_id);
540: EXCEPTION
541:
542: WHEN OTHERS THEN
543: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
544: RAISE;
545:
546: END get_termination_step_id;
547:
574: return lv_status;
575: EXCEPTION
576:
577: WHEN OTHERS THEN
578: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
579: RAISE;
580:
581: END isChangePay;
582:
609: return lv_status;
610: EXCEPTION
611:
612: WHEN OTHERS THEN
613: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
614: RAISE;
615:
616: END isAssignmentChange;
617:
645: return lv_status;
646: EXCEPTION
647:
648: WHEN OTHERS THEN
649: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
650: RAISE;
651:
652: END isSupervisorChange;
653:
682: return lv_status;
683: EXCEPTION
684:
685: WHEN OTHERS THEN
686: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
687: RAISE;
688:
689: END isLOAChange;
690:
718: return lv_status;
719: EXCEPTION
720:
721: WHEN OTHERS THEN
722: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
723: RAISE;
724:
725: END isTermination;
726:
799: end if;
800: EXCEPTION
801:
802: WHEN OTHERS THEN
803: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
804: RAISE;
805:
806: END get_salary_percent_change;
807:
874: end if;
875: EXCEPTION
876:
877: WHEN OTHERS THEN
878: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
879: RAISE;
880:
881: END get_salary_amount_change;
882:
917: return lv_status;
918: EXCEPTION
919:
920: WHEN OTHERS THEN
921: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_step_id);
922: RAISE;
923: END is_new_change_pay;
924:
925: FUNCTION get_transaction_init_date
951: return lv_creation_date_string;
952: EXCEPTION
953:
954: WHEN OTHERS THEN
955: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
956: RAISE;
957:
958: END get_transaction_init_date;
959:
998:
999: EXCEPTION
1000:
1001: WHEN OTHERS THEN
1002: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1003: RAISE;
1004:
1005: END get_transaction_effective_date;
1006:
1052:
1053: EXCEPTION
1054:
1055: WHEN OTHERS THEN
1056: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1057: RAISE;
1058:
1059: END get_sel_person_prop_sup_id;
1060:
1096: return fnd_number.number_to_canonical(lv_selected_person_id);
1097: EXCEPTION
1098:
1099: WHEN OTHERS THEN
1100: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1101: RAISE;
1102:
1103: END get_selected_person_id;
1104:
1145: return lv_job_id;
1146: EXCEPTION
1147:
1148: WHEN OTHERS THEN
1149: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1150: RAISE;
1151:
1152: END get_proposed_job_id;
1153:
1194: return lv_position_id;
1195: EXCEPTION
1196:
1197: WHEN OTHERS THEN
1198: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1199: RAISE;
1200:
1201: END get_proposed_position_id;
1202:
1248: return lv_grade_id;
1249: EXCEPTION
1250:
1251: WHEN OTHERS THEN
1252: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1253: RAISE;
1254:
1255: END get_proposed_grade_id;
1256:
1295: return lv_location_id;
1296: EXCEPTION
1297:
1298: WHEN OTHERS THEN
1299: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1300: RAISE;
1301:
1302: END get_proposed_location_id;
1303:
1346: return lv_system_type;
1347: EXCEPTION
1348:
1349: WHEN OTHERS THEN
1350: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1351: RAISE;
1352:
1353: END get_appraisal_type;
1354:
1406: return fnd_number.number_to_canonical(ln_overall_rating);
1407: EXCEPTION
1408:
1409: WHEN OTHERS THEN
1410: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1411: RAISE;
1412:
1413: END get_overall_appraisal_rating;
1414:
1440: return lv_absence_type_id;
1441: EXCEPTION
1442:
1443: WHEN OTHERS THEN
1444: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1445: RAISE;
1446:
1447: END get_absence_type_id;
1448:
1489: return lv_payroll_id;
1490: EXCEPTION
1491:
1492: WHEN OTHERS THEN
1493: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1494: RAISE;
1495:
1496: END get_proposed_payroll_id;
1497:
1575: return lv_salary_basis;
1576: EXCEPTION
1577:
1578: WHEN OTHERS THEN
1579: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1580: RAISE;
1581:
1582: END get_proposed_salary_basis;
1583:
1628: return lv_asg_change_reason;
1629: EXCEPTION
1630:
1631: WHEN OTHERS THEN
1632: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1633: RAISE;
1634:
1635: END get_asg_change_reason;
1636:
1664: return lv_leaving_reason;
1665: EXCEPTION
1666:
1667: WHEN OTHERS THEN
1668: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1669: RAISE;
1670:
1671: END get_leaving_reason;
1672:
1692: return lv_person_type_id;
1693: EXCEPTION
1694:
1695: WHEN OTHERS THEN
1696: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1697: RAISE;
1698:
1699: END get_person_type_id;
1700:
1753: return fnd_number.number_to_canonical(ln_length_of_service);
1754: EXCEPTION
1755:
1756: WHEN OTHERS THEN
1757: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1758: RAISE;
1759:
1760: END get_length_of_service;
1761:
1805: return lv_assignment_category;
1806: EXCEPTION
1807:
1808: WHEN OTHERS THEN
1809: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1810: RAISE;
1811:
1812: END get_assignment_category;
1813:
1846:
1847: EXCEPTION
1848:
1849: WHEN OTHERS THEN
1850: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1851: RAISE;
1852:
1853: END get_payroll_con_user_name;
1854:
1884: return fnd_number.number_to_canonical(ln_step_id);
1885: EXCEPTION
1886:
1887: WHEN OTHERS THEN
1888: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1889: RAISE;
1890:
1891: END get_basic_details_step_id;
1892:
1920: return lv_status;
1921: EXCEPTION
1922:
1923: WHEN OTHERS THEN
1924: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1925: RAISE;
1926:
1927: END isPersonDetailsChange;
1928:
1960: return fnd_number.number_to_canonical(ln_step_id);
1961: EXCEPTION
1962:
1963: WHEN OTHERS THEN
1964: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1965: RAISE;
1966:
1967: END get_person_address_step_id;
1968:
1996: return lv_status;
1997: EXCEPTION
1998:
1999: WHEN OTHERS THEN
2000: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2001: RAISE;
2002:
2003: END isPersonAddressChange;
2004:
2037: return fnd_number.number_to_canonical(ln_step_id);
2038: EXCEPTION
2039:
2040: WHEN OTHERS THEN
2041: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2042: RAISE;
2043:
2044: END get_person_contact_step_id;
2045:
2073: return lv_status;
2074: EXCEPTION
2075:
2076: WHEN OTHERS THEN
2077: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2078: RAISE;
2079:
2080: END isPersonContactChange;
2081:
2112: return fnd_number.number_to_canonical(ln_step_id);
2113: EXCEPTION
2114:
2115: WHEN OTHERS THEN
2116: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2117: RAISE;
2118:
2119: END get_caed_step_id;
2120:
2148: return lv_status;
2149: EXCEPTION
2150:
2151: WHEN OTHERS THEN
2152: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2153: RAISE;
2154:
2155: END isReleaseInformation;
2156:
2188: return fnd_number.number_to_canonical(ln_pay_basis_id);
2189: EXCEPTION
2190:
2191: WHEN OTHERS THEN
2192: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2193: RAISE;
2194:
2195: END get_paybasis_id;
2196:
2307:
2308: EXCEPTION
2309:
2310: WHEN OTHERS THEN
2311: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2312: RAISE;
2313:
2314: END isMidPayPayPeriodChange;
2315: