DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on FND_FLEX_VALUE_SETS

Line 1801: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FND_FLEX_VALUE_SETS%ROWTYPE

1797: END;
1798: --------------------------------------------------------------------------------
1799: FUNCTION flex_value_set_rec(
1800: p_flex_value_set_name IN VARCHAR2,
1801: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FND_FLEX_VALUE_SETS%ROWTYPE
1802: --------------------------------------------------------------------------------
1803: IS
1804: l_unique_column_tbl UniColTbl;
1805: l_csr RefCsr;

Line 1806: l_rec FND_FLEX_VALUE_SETS%ROWTYPE;

1802: --------------------------------------------------------------------------------
1803: IS
1804: l_unique_column_tbl UniColTbl;
1805: l_csr RefCsr;
1806: l_rec FND_FLEX_VALUE_SETS%ROWTYPE;
1807: BEGIN
1808: unique_tbl_constructor('FLEX_VALUE_SET_NAME','T',p_flex_value_set_name,l_unique_column_tbl);
1809:
1810: l_csr := csr('FND_FLEX_VALUE_SETS',l_unique_column_tbl);

Line 1810: l_csr := csr('FND_FLEX_VALUE_SETS',l_unique_column_tbl);

1806: l_rec FND_FLEX_VALUE_SETS%ROWTYPE;
1807: BEGIN
1808: unique_tbl_constructor('FLEX_VALUE_SET_NAME','T',p_flex_value_set_name,l_unique_column_tbl);
1809:
1810: l_csr := csr('FND_FLEX_VALUE_SETS',l_unique_column_tbl);
1811: fetch l_csr into l_rec;
1812: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1813: l_rec := NULL;
1814: end if;