DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 459: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE

455: FUNCTION classification_rec(
456: p_classification_name IN VARCHAR2,
457: p_business_group_id IN NUMBER DEFAULT NULL,
458: p_legislation_code IN VARCHAR2 DEFAULT NULL,
459: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE
460: --------------------------------------------------------------------------------
461: IS
462: l_csr RefCsr;
463: l_rec PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE;

Line 463: l_rec PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE;

459: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE
460: --------------------------------------------------------------------------------
461: IS
462: l_csr RefCsr;
463: l_rec PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE;
464: BEGIN
465: l_csr := csr_with_bus_leg('PAY_ELEMENT_CLASSIFICATIONS','CLASSIFICATION_NAME','T',p_classification_name,p_business_group_id,p_legislation_code);
466: fetch l_csr into l_rec;
467: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 465: l_csr := csr_with_bus_leg('PAY_ELEMENT_CLASSIFICATIONS','CLASSIFICATION_NAME','T',p_classification_name,p_business_group_id,p_legislation_code);

461: IS
462: l_csr RefCsr;
463: l_rec PAY_ELEMENT_CLASSIFICATIONS%ROWTYPE;
464: BEGIN
465: l_csr := csr_with_bus_leg('PAY_ELEMENT_CLASSIFICATIONS','CLASSIFICATION_NAME','T',p_classification_name,p_business_group_id,p_legislation_code);
466: fetch l_csr into l_rec;
467: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
468: l_rec := NULL;
469: end if;