APPS.HR_JP_ID_PKG dependencies on FF_FORMULAS_F

Line 1351: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FORMULAS_F%ROWTYPE

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;
1355: l_unique_column_tbl UniColTbl;

Line 1357: l_rec FF_FORMULAS_F%ROWTYPE;

1353: IS
1354: l_formula_type_id NUMBER;
1355: l_unique_column_tbl UniColTbl;
1356: l_csr RefCsr;
1357: l_rec FF_FORMULAS_F%ROWTYPE;
1358: BEGIN
1359: l_formula_type_id := formula_type_id(p_formula_type_name,p_error_when_not_exist);
1360: unique_tbl_constructor('FORMULA_TYPE_ID','N',to_char(l_formula_type_id),l_unique_column_tbl);
1361: unique_tbl_constructor('FORMULA_NAME','T',p_formula_name,l_unique_column_tbl);

Line 1364: l_csr := csr('FF_FORMULAS_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);

1360: unique_tbl_constructor('FORMULA_TYPE_ID','N',to_char(l_formula_type_id),l_unique_column_tbl);
1361: unique_tbl_constructor('FORMULA_NAME','T',p_formula_name,l_unique_column_tbl);
1362: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);
1363:
1364: l_csr := csr('FF_FORMULAS_F',l_unique_column_tbl,'DATETRACKED',p_effective_date);
1365: fetch l_csr into l_rec;
1366: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1367: l_rec := NULL;
1368: end if;