APPS.HR_JP_ID_PKG dependencies on FND_FLEX_VALUES

Line 1831: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FND_FLEX_VALUES%ROWTYPE

1827: --------------------------------------------------------------------------------
1828: FUNCTION flex_value_rec(
1829: p_flex_value_set_id IN NUMBER,
1830: p_flex_value IN VARCHAR2,
1831: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FND_FLEX_VALUES%ROWTYPE
1832: --------------------------------------------------------------------------------
1833: IS
1834: l_unique_column_tbl UniColTbl;
1835: l_csr RefCsr;

Line 1836: l_rec FND_FLEX_VALUES%ROWTYPE;

1832: --------------------------------------------------------------------------------
1833: IS
1834: l_unique_column_tbl UniColTbl;
1835: l_csr RefCsr;
1836: l_rec FND_FLEX_VALUES%ROWTYPE;
1837: BEGIN
1838: unique_tbl_constructor('FLEX_VALUE_SET_ID','N',to_char(p_flex_value_set_id),l_unique_column_tbl);
1839: unique_tbl_constructor('FLEX_VALUE','T',p_flex_value,l_unique_column_tbl);
1840:

Line 1841: l_csr := csr('FND_FLEX_VALUES',l_unique_column_tbl);

1837: BEGIN
1838: unique_tbl_constructor('FLEX_VALUE_SET_ID','N',to_char(p_flex_value_set_id),l_unique_column_tbl);
1839: unique_tbl_constructor('FLEX_VALUE','T',p_flex_value,l_unique_column_tbl);
1840:
1841: l_csr := csr('FND_FLEX_VALUES',l_unique_column_tbl);
1842: fetch l_csr into l_rec;
1843: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1844: l_rec := NULL;
1845: end if;