DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 755: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_CONSOLIDATION_SETS%ROWTYPE

751: --------------------------------------------------------------------------------
752: FUNCTION consolidation_set_rec(
753: p_consolidation_set_name IN VARCHAR2,
754: p_business_group_id IN NUMBER,
755: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_CONSOLIDATION_SETS%ROWTYPE
756: --------------------------------------------------------------------------------
757: IS
758: l_csr RefCsr;
759: l_rec PAY_CONSOLIDATION_SETS%ROWTYPE;

Line 759: l_rec PAY_CONSOLIDATION_SETS%ROWTYPE;

755: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_CONSOLIDATION_SETS%ROWTYPE
756: --------------------------------------------------------------------------------
757: IS
758: l_csr RefCsr;
759: l_rec PAY_CONSOLIDATION_SETS%ROWTYPE;
760: BEGIN
761: l_csr := csr_with_bus('PAY_CONSOLIDATION_SETS','CONSOLIDATION_SET_NAME','T',p_consolidation_set_name,p_business_group_id);
762: fetch l_csr into l_rec;
763: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 761: l_csr := csr_with_bus('PAY_CONSOLIDATION_SETS','CONSOLIDATION_SET_NAME','T',p_consolidation_set_name,p_business_group_id);

757: IS
758: l_csr RefCsr;
759: l_rec PAY_CONSOLIDATION_SETS%ROWTYPE;
760: BEGIN
761: l_csr := csr_with_bus('PAY_CONSOLIDATION_SETS','CONSOLIDATION_SET_NAME','T',p_consolidation_set_name,p_business_group_id);
762: fetch l_csr into l_rec;
763: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
764: l_rec := NULL;
765: end if;