DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PAY_ELEMENT_SETS

Line 399: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_SETS%ROWTYPE

395: FUNCTION element_set_rec(
396: p_element_set_name IN VARCHAR2,
397: p_business_group_id IN NUMBER DEFAULT NULL,
398: p_legislation_code IN VARCHAR2 DEFAULT NULL,
399: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_SETS%ROWTYPE
400: --------------------------------------------------------------------------------
401: IS
402: l_csr RefCsr;
403: l_rec PAY_ELEMENT_SETS%ROWTYPE;

Line 403: l_rec PAY_ELEMENT_SETS%ROWTYPE;

399: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_SETS%ROWTYPE
400: --------------------------------------------------------------------------------
401: IS
402: l_csr RefCsr;
403: l_rec PAY_ELEMENT_SETS%ROWTYPE;
404: BEGIN
405: l_csr := csr_with_bus_leg('PAY_ELEMENT_SETS','ELEMENT_SET_NAME','T',p_element_set_name,p_business_group_id,p_legislation_code);
406: fetch l_csr into l_rec;
407: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 405: l_csr := csr_with_bus_leg('PAY_ELEMENT_SETS','ELEMENT_SET_NAME','T',p_element_set_name,p_business_group_id,p_legislation_code);

401: IS
402: l_csr RefCsr;
403: l_rec PAY_ELEMENT_SETS%ROWTYPE;
404: BEGIN
405: l_csr := csr_with_bus_leg('PAY_ELEMENT_SETS','ELEMENT_SET_NAME','T',p_element_set_name,p_business_group_id,p_legislation_code);
406: fetch l_csr into l_rec;
407: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
408: l_rec := NULL;
409: end if;