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:
800: end if;
801: EXCEPTION
802:
803: WHEN OTHERS THEN
804: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
805: RAISE;
806:
807: END get_salary_percent_change;
808:
876: end if;
877: EXCEPTION
878:
879: WHEN OTHERS THEN
880: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
881: RAISE;
882:
883: END get_salary_amount_change;
884:
919: return lv_status;
920: EXCEPTION
921:
922: WHEN OTHERS THEN
923: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_step_id);
924: RAISE;
925: END is_new_change_pay;
926:
927: FUNCTION get_transaction_init_date
953: return lv_creation_date_string;
954: EXCEPTION
955:
956: WHEN OTHERS THEN
957: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
958: RAISE;
959:
960: END get_transaction_init_date;
961:
1000:
1001: EXCEPTION
1002:
1003: WHEN OTHERS THEN
1004: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1005: RAISE;
1006:
1007: END get_transaction_effective_date;
1008:
1054:
1055: EXCEPTION
1056:
1057: WHEN OTHERS THEN
1058: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1059: RAISE;
1060:
1061: END get_sel_person_prop_sup_id;
1062:
1098: return fnd_number.number_to_canonical(lv_selected_person_id);
1099: EXCEPTION
1100:
1101: WHEN OTHERS THEN
1102: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1103: RAISE;
1104:
1105: END get_selected_person_id;
1106:
1147: return lv_job_id;
1148: EXCEPTION
1149:
1150: WHEN OTHERS THEN
1151: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1152: RAISE;
1153:
1154: END get_proposed_job_id;
1155:
1196: return lv_position_id;
1197: EXCEPTION
1198:
1199: WHEN OTHERS THEN
1200: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1201: RAISE;
1202:
1203: END get_proposed_position_id;
1204:
1250: return lv_grade_id;
1251: EXCEPTION
1252:
1253: WHEN OTHERS THEN
1254: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1255: RAISE;
1256:
1257: END get_proposed_grade_id;
1258:
1297: return lv_location_id;
1298: EXCEPTION
1299:
1300: WHEN OTHERS THEN
1301: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1302: RAISE;
1303:
1304: END get_proposed_location_id;
1305:
1348: return lv_system_type;
1349: EXCEPTION
1350:
1351: WHEN OTHERS THEN
1352: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1353: RAISE;
1354:
1355: END get_appraisal_type;
1356:
1408: return fnd_number.number_to_canonical(ln_overall_rating);
1409: EXCEPTION
1410:
1411: WHEN OTHERS THEN
1412: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1413: RAISE;
1414:
1415: END get_overall_appraisal_rating;
1416:
1442: return lv_absence_type_id;
1443: EXCEPTION
1444:
1445: WHEN OTHERS THEN
1446: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1447: RAISE;
1448:
1449: END get_absence_type_id;
1450:
1491: return lv_payroll_id;
1492: EXCEPTION
1493:
1494: WHEN OTHERS THEN
1495: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1496: RAISE;
1497:
1498: END get_proposed_payroll_id;
1499:
1577: return lv_salary_basis;
1578: EXCEPTION
1579:
1580: WHEN OTHERS THEN
1581: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1582: RAISE;
1583:
1584: END get_proposed_salary_basis;
1585:
1630: return lv_asg_change_reason;
1631: EXCEPTION
1632:
1633: WHEN OTHERS THEN
1634: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1635: RAISE;
1636:
1637: END get_asg_change_reason;
1638:
1666: return lv_leaving_reason;
1667: EXCEPTION
1668:
1669: WHEN OTHERS THEN
1670: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1671: RAISE;
1672:
1673: END get_leaving_reason;
1674:
1694: return lv_person_type_id;
1695: EXCEPTION
1696:
1697: WHEN OTHERS THEN
1698: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1699: RAISE;
1700:
1701: END get_person_type_id;
1702:
1755: return fnd_number.number_to_canonical(ln_length_of_service);
1756: EXCEPTION
1757:
1758: WHEN OTHERS THEN
1759: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1760: RAISE;
1761:
1762: END get_length_of_service;
1763:
1807: return lv_assignment_category;
1808: EXCEPTION
1809:
1810: WHEN OTHERS THEN
1811: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1812: RAISE;
1813:
1814: END get_assignment_category;
1815:
1848:
1849: EXCEPTION
1850:
1851: WHEN OTHERS THEN
1852: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1853: RAISE;
1854:
1855: END get_payroll_con_user_name;
1856:
1886: return fnd_number.number_to_canonical(ln_step_id);
1887: EXCEPTION
1888:
1889: WHEN OTHERS THEN
1890: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1891: RAISE;
1892:
1893: END get_basic_details_step_id;
1894:
1922: return lv_status;
1923: EXCEPTION
1924:
1925: WHEN OTHERS THEN
1926: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1927: RAISE;
1928:
1929: END isPersonDetailsChange;
1930:
1962: return fnd_number.number_to_canonical(ln_step_id);
1963: EXCEPTION
1964:
1965: WHEN OTHERS THEN
1966: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
1967: RAISE;
1968:
1969: END get_person_address_step_id;
1970:
1998: return lv_status;
1999: EXCEPTION
2000:
2001: WHEN OTHERS THEN
2002: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2003: RAISE;
2004:
2005: END isPersonAddressChange;
2006:
2039: return fnd_number.number_to_canonical(ln_step_id);
2040: EXCEPTION
2041:
2042: WHEN OTHERS THEN
2043: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2044: RAISE;
2045:
2046: END get_person_contact_step_id;
2047:
2075: return lv_status;
2076: EXCEPTION
2077:
2078: WHEN OTHERS THEN
2079: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2080: RAISE;
2081:
2082: END isPersonContactChange;
2083:
2114: return fnd_number.number_to_canonical(ln_step_id);
2115: EXCEPTION
2116:
2117: WHEN OTHERS THEN
2118: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2119: RAISE;
2120:
2121: END get_caed_step_id;
2122:
2150: return lv_status;
2151: EXCEPTION
2152:
2153: WHEN OTHERS THEN
2154: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2155: RAISE;
2156:
2157: END isReleaseInformation;
2158:
2190: return fnd_number.number_to_canonical(ln_pay_basis_id);
2191: EXCEPTION
2192:
2193: WHEN OTHERS THEN
2194: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2195: RAISE;
2196:
2197: END get_paybasis_id;
2198:
2309:
2310: EXCEPTION
2311:
2312: WHEN OTHERS THEN
2313: WF_CORE.CONTEXT(g_package,'.lv_procedure_name',p_transaction_id);
2314: RAISE;
2315:
2316: END isMidPayPayPeriodChange;
2317: