APPS.HR_JP_ID_PKG dependencies on PAY_INPUT_VALUES_F

Line 1086: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE

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;
1090: l_csr RefCsr;

Line 1091: l_rec PAY_INPUT_VALUES_F%ROWTYPE;

1087: --------------------------------------------------------------------------------
1088: IS
1089: l_unique_column_tbl UniColTbl;
1090: l_csr RefCsr;
1091: l_rec PAY_INPUT_VALUES_F%ROWTYPE;
1092: BEGIN
1093: unique_tbl_constructor('ELEMENT_TYPE_ID','N',to_char(p_element_type_id),l_unique_column_tbl);
1094: unique_tbl_constructor('NAME','T',p_name,l_unique_column_tbl);
1095:

Line 1096: l_csr := csr('PAY_INPUT_VALUES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

1092: BEGIN
1093: unique_tbl_constructor('ELEMENT_TYPE_ID','N',to_char(p_element_type_id),l_unique_column_tbl);
1094: unique_tbl_constructor('NAME','T',p_name,l_unique_column_tbl);
1095:
1096: l_csr := csr('PAY_INPUT_VALUES_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
1097: fetch l_csr into l_rec;
1098: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1099: l_rec := NULL;
1100: end if;

Line 1121: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_INPUT_VALUES_F%ROWTYPE

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;
1125: BEGIN