eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_JP_ID_PKG dependencies on HR_API

Line 29: p_effective_date IN DATE DEFAULT hr_api.g_sys) RETURN RefCsr

25: FUNCTION CSR(
26: p_base_table IN VARCHAR2,
27: p_unique_column_tbl IN UniColTbl,
28: p_date_track_type IN VARCHAR2 DEFAULT 'NONE',--'DATETRACKED','DATED','NONE'
29: p_effective_date IN DATE DEFAULT hr_api.g_sys) RETURN RefCsr
30: --------------------------------------------------------------------------------
31: IS
32: l_csr RefCsr;
33: l_id NUMBER;

Line 209: p_effective_date IN DATE DEFAULT hr_api.g_sys) RETURN RefCsr

205: p_unique_column_value IN VARCHAR2,
206: p_business_group_id IN NUMBER DEFAULT NULL,
207: p_legislation_code IN VARCHAR2 DEFAULT NULL,
208: p_date_track_type IN VARCHAR2 DEFAULT 'NONE',
209: p_effective_date IN DATE DEFAULT hr_api.g_sys) RETURN RefCsr
210: --------------------------------------------------------------------------------
211: IS
212: l_unique_column_tbl UniColTbl;
213: BEGIN

Line 227: p_effective_date IN DATE DEFAULT hr_api.g_sys) RETURN RefCsr

223: p_unique_column_data_type IN VARCHAR2 DEFAULT 'T',
224: p_unique_column_value IN VARCHAR2,
225: p_business_group_id IN NUMBER,
226: p_date_track_type IN VARCHAR2 DEFAULT 'NONE',
227: p_effective_date IN DATE DEFAULT hr_api.g_sys) RETURN RefCsr
228: --------------------------------------------------------------------------------
229: IS
230: l_unique_column_tbl UniColTbl;
231: BEGIN

Line 489: p_effective_date IN DATE DEFAULT hr_api.g_sys,

485: FUNCTION element_type_rec(
486: p_element_name IN VARCHAR2,
487: p_business_group_id IN NUMBER DEFAULT NULL,
488: p_legislation_code IN VARCHAR2 DEFAULT NULL,
489: p_effective_date IN DATE DEFAULT hr_api.g_sys,
490: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_TYPES_F%ROWTYPE
491: --------------------------------------------------------------------------------
492: IS
493: l_csr RefCsr;

Line 697: p_effective_date IN DATE DEFAULT hr_api.g_sys,

693: --------------------------------------------------------------------------------
694: FUNCTION org_payment_method_rec(
695: p_org_payment_method_name IN VARCHAR2,
696: p_business_group_id IN NUMBER,
697: p_effective_date IN DATE DEFAULT hr_api.g_sys,
698: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAYMENT_METHODS_F%ROWTYPE
699: --------------------------------------------------------------------------------
700: IS
701: l_csr RefCsr;

Line 726: p_effective_date IN DATE DEFAULT hr_api.g_sys,

722: --------------------------------------------------------------------------------
723: FUNCTION payroll_rec(
724: p_payroll_name IN VARCHAR2,
725: p_business_group_id IN NUMBER,
726: p_effective_date IN DATE DEFAULT hr_api.g_sys,
727: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ALL_PAYROLLS_F%ROWTYPE
728: --------------------------------------------------------------------------------
729: IS
730: l_csr RefCsr;

Line 867: p_effective_date IN DATE DEFAULT hr_api.g_sys,

863: --------------------------------------------------------------------------------
864: FUNCTION emp_person_rec(
865: p_employee_number IN VARCHAR2,
866: p_business_group_id IN NUMBER,
867: p_effective_date IN DATE DEFAULT hr_api.g_sys,
868: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE
869: --------------------------------------------------------------------------------
870: IS
871: l_csr RefCsr;

Line 896: p_effective_date IN DATE DEFAULT hr_api.g_sys,

892: --------------------------------------------------------------------------------
893: FUNCTION apl_person_rec(
894: p_applicant_number IN VARCHAR2,
895: p_business_group_id IN NUMBER,
896: p_effective_date IN DATE DEFAULT hr_api.g_sys,
897: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE
898: --------------------------------------------------------------------------------
899: IS
900: l_csr RefCsr;

Line 925: p_effective_date IN DATE DEFAULT hr_api.g_sys,

921: --------------------------------------------------------------------------------
922: FUNCTION emp_assignment_rec(
923: p_assignment_number IN VARCHAR2,
924: p_business_group_id IN NUMBER,
925: p_effective_date IN DATE DEFAULT hr_api.g_sys,
926: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_ASSIGNMENTS_F%ROWTYPE
927: --------------------------------------------------------------------------------
928: IS
929: l_csr RefCsr;

Line 1085: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1081: --------------------------------------------------------------------------------
1082: FUNCTION input_value_rec(
1083: p_element_type_id IN NUMBER,
1084: p_name IN VARCHAR2,
1085: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1086: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE
1087: --------------------------------------------------------------------------------
1088: IS
1089: l_unique_column_tbl UniColTbl;

Line 1120: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1116: p_element_name IN VARCHAR2,
1117: p_name IN VARCHAR2,
1118: p_business_group_id IN NUMBER DEFAULT NULL,
1119: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1120: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1121: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE
1122: --------------------------------------------------------------------------------
1123: IS
1124: l_element_type_id NUMBER;

Line 1214: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1210: p_balance_type_id IN NUMBER,
1211: p_input_value_id IN NUMBER,
1212: p_business_group_id IN NUMBER DEFAULT NULL,
1213: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1214: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1215: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE
1216: --------------------------------------------------------------------------------
1217: IS
1218: l_unique_column_tbl UniColTbl;

Line 1240: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1236: p_balance_type_id IN NUMBER,
1237: p_input_value_id IN NUMBER,
1238: p_business_group_id IN NUMBER DEFAULT NULL,
1239: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1240: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1241: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
1242: --------------------------------------------------------------------------------
1243: IS
1244: BEGIN

Line 1254: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1250: p_element_name IN VARCHAR2,
1251: p_name IN VARCHAR2,
1252: p_business_group_id IN NUMBER DEFAULT NULL,
1253: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1254: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1255: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_BALANCE_FEEDS_F%ROWTYPE
1256: --------------------------------------------------------------------------------
1257: IS
1258: l_balance_type_id NUMBER;

Line 1273: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1269: p_element_name IN VARCHAR2,
1270: p_name IN VARCHAR2,
1271: p_business_group_id IN NUMBER DEFAULT NULL,
1272: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1273: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1274: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
1275: --------------------------------------------------------------------------------
1276: IS
1277: BEGIN

Line 1350: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1346: p_formula_name IN VARCHAR2,
1347: p_formula_type_name IN VARCHAR2,
1348: p_business_group_id IN NUMBER DEFAULT NULL,
1349: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1350: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1351: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FORMULAS_F%ROWTYPE
1352: --------------------------------------------------------------------------------
1353: IS
1354: l_formula_type_id NUMBER;

Line 1427: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1423: p_element_type_id IN NUMBER,
1424: p_assignment_status_type_id IN NUMBER DEFAULT NULL,
1425: p_business_group_id IN NUMBER DEFAULT NULL,
1426: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1427: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1428: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_STATUS_PROCESSING_RULES_F%ROWTYPE
1429: --------------------------------------------------------------------------------
1430: IS
1431: l_unique_column_tbl UniColTbl;

Line 1453: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1449: p_element_type_id IN NUMBER,
1450: p_assignment_status_type_id IN NUMBER DEFAULT NULL,
1451: p_business_group_id IN NUMBER DEFAULT NULL,
1452: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1453: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1454: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
1455: --------------------------------------------------------------------------------
1456: IS
1457: BEGIN

Line 1471: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1467: p_element_type_id IN NUMBER DEFAULT NULL,
1468: p_input_value_id IN NUMBER DEFAULT NULL,
1469: p_business_group_id IN NUMBER DEFAULT NULL,
1470: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1471: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1472: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_FORMULA_RESULT_RULES_F%ROWTYPE
1473: --------------------------------------------------------------------------------
1474: IS
1475: l_unique_column_tbl UniColTbl;

Line 1503: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1499: p_element_type_id IN NUMBER DEFAULT NULL,
1500: p_input_value_id IN NUMBER DEFAULT NULL,
1501: p_business_group_id IN NUMBER DEFAULT NULL,
1502: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1503: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1504: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
1505: --------------------------------------------------------------------------------
1506: IS
1507: BEGIN

Line 1518: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1514: p_element_type_id IN NUMBER,
1515: p_classification_id IN NUMBER,
1516: p_business_group_id IN NUMBER,
1517: p_legislation_code IN VARCHAR2,
1518: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1519: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_SUB_CLASSIFICATION_RULES_F%ROWTYPE
1520: --------------------------------------------------------------------------------
1521: IS
1522: l_unique_column_tbl UniColTbl;

Line 1544: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1540: p_element_type_id IN NUMBER,
1541: p_classification_id IN NUMBER,
1542: p_business_group_id IN NUMBER,
1543: p_legislation_code IN VARCHAR2,
1544: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1545: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
1546: --------------------------------------------------------------------------------
1547: IS
1548: BEGIN

Line 1557: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1553: --------------------------------------------------------------------------------
1554: FUNCTION element_link_id(
1555: p_assignment_id IN NUMBER,
1556: p_element_type_id IN NUMBER,
1557: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1558: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
1559: --------------------------------------------------------------------------------
1560: IS
1561: l_element_link_id NUMBER;

Line 1577: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1573: FUNCTION element_link_id(
1574: p_assignment_number IN VARCHAR2,
1575: p_element_name IN VARCHAR2,
1576: p_business_group_id IN NUMBER,
1577: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1578: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
1579: --------------------------------------------------------------------------------
1580: IS
1581: l_assignment_id NUMBER;

Line 1863: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1859: --------------------------------------------------------------------------------
1860: FUNCTION period_of_service_rec(
1861: p_employee_number IN VARCHAR2,
1862: p_business_group_id IN NUMBER,
1863: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1864: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_PERIODS_OF_SERVICE%ROWTYPE
1865: --------------------------------------------------------------------------------
1866: IS
1867: l_rec PER_PERIODS_OF_SERVICE%ROWTYPE;

Line 1904: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1900: FUNCTION element_entry_rec(
1901: p_assignment_id IN VARCHAR2,
1902: p_element_type_id IN VARCHAR2,
1903: p_entry_type IN VARCHAR2 DEFAULT 'E',
1904: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1905: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE
1906: --------------------------------------------------------------------------------
1907: IS
1908: l_rec PAY_ELEMENT_ENTRIES_F%ROWTYPE;

Line 1948: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1944: p_assignment_number IN VARCHAR2,
1945: p_element_name IN VARCHAR2,
1946: p_entry_type IN VARCHAR2 DEFAULT 'E',
1947: p_business_group_id IN NUMBER,
1948: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1949: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_ENTRIES_F%ROWTYPE
1950: --------------------------------------------------------------------------------
1951: IS
1952: l_assignment_id NUMBER := emp_assignment_id(p_assignment_number,p_business_group_id);

Line 1965: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1961: -- record this function returns is inexact.
1962: p_person_id IN NUMBER,
1963: p_primary_flag IN VARCHAR2 DEFAULT 'Y',
1964: p_address_type IN VARCHAR2 DEFAULT NULL,
1965: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1966: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
1967: --------------------------------------------------------------------------------
1968: IS
1969: l_unique_column_tbl UniColTbl;

Line 1999: p_effective_date IN DATE DEFAULT hr_api.g_sys,

1995: --------------------------------------------------------------------------------
1996: FUNCTION primary_address_rec(
1997: -- This function is valid when address_type is not NULL.
1998: p_person_id IN NUMBER,
1999: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2000: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2001: --------------------------------------------------------------------------------
2002: IS
2003: BEGIN

Line 2011: p_effective_date IN DATE DEFAULT hr_api.g_sys,

2007: FUNCTION address_rec(
2008: -- This function is valid when address_type is not NULL.
2009: p_person_id IN NUMBER,
2010: p_address_type IN VARCHAR2,
2011: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2012: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2013: --------------------------------------------------------------------------------
2014: IS
2015: BEGIN

Line 2023: p_effective_date IN DATE DEFAULT hr_api.g_sys,

2019: FUNCTION emp_primary_address_rec(
2020: -- This function is valid when address_type is not NULL.
2021: p_employee_number IN VARCHAR2,
2022: p_business_group_id IN NUMBER,
2023: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2024: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2025: --------------------------------------------------------------------------------
2026: IS
2027: l_person_id NUMBER;

Line 2039: p_effective_date IN DATE DEFAULT hr_api.g_sys,

2035: -- This function is valid when address_type is not NULL.
2036: p_employee_number IN VARCHAR2,
2037: p_address_type IN VARCHAR2,
2038: p_business_group_id IN NUMBER,
2039: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2040: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2041: --------------------------------------------------------------------------------
2042: IS
2043: l_person_id NUMBER;

Line 2054: p_effective_date IN DATE DEFAULT hr_api.g_sys,

2050: FUNCTION apl_primary_address_rec(
2051: -- This function is valid when address_type is not NULL.
2052: p_applicant_number IN VARCHAR2,
2053: p_business_group_id IN NUMBER,
2054: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2055: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2056: --------------------------------------------------------------------------------
2057: IS
2058: l_person_id NUMBER;

Line 2070: p_effective_date IN DATE DEFAULT hr_api.g_sys,

2066: -- This function is valid when address_type is not NULL.
2067: p_applicant_number IN VARCHAR2,
2068: p_address_type IN VARCHAR2,
2069: p_business_group_id IN NUMBER,
2070: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2071: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2072: --------------------------------------------------------------------------------
2073: IS
2074: l_person_id NUMBER;

Line 2084: p_effective_date IN DATE DEFAULT hr_api.g_sys,

2080: --------------------------------------------------------------------------------
2081: FUNCTION personal_payment_method_rec(
2082: p_assignment_id IN NUMBER,
2083: p_priority IN NUMBER,
2084: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2085: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PERSONAL_PAYMENT_METHODS_F%ROWTYPE
2086: --------------------------------------------------------------------------------
2087: IS
2088: l_unique_column_tbl UniColTbl;

Line 2115: p_effective_date IN DATE DEFAULT hr_api.g_sys,

2111: FUNCTION personal_payment_method_rec(
2112: p_assignment_number IN VARCHAR2,
2113: p_priority IN NUMBER,
2114: p_business_group_id IN NUMBER,
2115: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2116: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_PERSONAL_PAYMENT_METHODS_F%ROWTYPE
2117: --------------------------------------------------------------------------------
2118: IS
2119: l_assignment_id NUMBER;

Line 2168: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,

2164: P_PAYROLL_ID IN NUMBER DEFAULT NULL,
2165: P_LINK_TO_ALL_PAYROLLS_FLAG IN VARCHAR2 DEFAULT 'N',
2166: P_PAY_BASIS_ID IN NUMBER DEFAULT NULL,
2167: P_BUSINESS_GROUP_ID IN NUMBER,
2168: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
2169: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_LINKS_F%ROWTYPE
2170: --------------------------------------------------------------------------------
2171: IS
2172: l_unique_column_tbl UniColTbl;

Line 2218: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,

2214: P_PAYROLL_ID IN NUMBER DEFAULT NULL,
2215: P_LINK_TO_ALL_PAYROLLS_FLAG IN VARCHAR2 DEFAULT 'N',
2216: P_PAY_BASIS_ID IN NUMBER DEFAULT NULL,
2217: P_BUSINESS_GROUP_ID IN NUMBER,
2218: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
2219: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN NUMBER
2220: --------------------------------------------------------------------------------
2221: IS
2222: BEGIN

Line 2263: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,

2259: --------------------------------------------------------------------------------
2260: FUNCTION org_pay_method_usage_rec(
2261: P_PAYROLL_ID IN NUMBER,
2262: P_ORG_PAYMENT_METHOD_ID IN NUMBER,
2263: P_EFFECTIVE_DATE IN DATE DEFAULT hr_api.g_sys,
2264: P_ERROR_WHEN_NOT_EXIST IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ORG_PAY_METHOD_USAGES_F%ROWTYPE
2265: --------------------------------------------------------------------------------
2266: IS
2267: l_unique_column_tbl UniColTbl;