DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on FF_FUNCTIONS

Line 1390: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FUNCTIONS%ROWTYPE

1386: p_name IN VARCHAR2,
1387: p_data_type IN VARCHAR2,
1388: p_business_group_id IN NUMBER DEFAULT NULL,
1389: p_legislation_code IN VARCHAR2 DEFAULT NULL,
1390: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN FF_FUNCTIONS%ROWTYPE
1391: --------------------------------------------------------------------------------
1392: IS
1393: l_unique_column_tbl UniColTbl;
1394: l_csr RefCsr;

Line 1395: l_rec FF_FUNCTIONS%ROWTYPE;

1391: --------------------------------------------------------------------------------
1392: IS
1393: l_unique_column_tbl UniColTbl;
1394: l_csr RefCsr;
1395: l_rec FF_FUNCTIONS%ROWTYPE;
1396: BEGIN
1397: unique_tbl_constructor('NAME','T',p_name,l_unique_column_tbl);
1398: unique_tbl_constructor('DATA_TYPE','T',p_data_type,l_unique_column_tbl);
1399: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);

Line 1401: l_csr := csr('FF_FUNCTIONS',l_unique_column_tbl);

1397: unique_tbl_constructor('NAME','T',p_name,l_unique_column_tbl);
1398: unique_tbl_constructor('DATA_TYPE','T',p_data_type,l_unique_column_tbl);
1399: bus_leg_constructor(p_business_group_id,p_legislation_code,l_unique_column_tbl);
1400:
1401: l_csr := csr('FF_FUNCTIONS',l_unique_column_tbl);
1402: fetch l_csr into l_rec;
1403: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1404: l_rec := NULL;
1405: end if;