DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on HR_ASSIGNMENT_SETS

Line 783: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ASSIGNMENT_SETS%ROWTYPE

779: --------------------------------------------------------------------------------
780: FUNCTION assignment_set_rec(
781: p_assignment_set_name IN VARCHAR2,
782: p_business_group_id IN NUMBER,
783: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ASSIGNMENT_SETS%ROWTYPE
784: --------------------------------------------------------------------------------
785: IS
786: l_csr RefCsr;
787: l_rec HR_ASSIGNMENT_SETS%ROWTYPE;

Line 787: l_rec HR_ASSIGNMENT_SETS%ROWTYPE;

783: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN HR_ASSIGNMENT_SETS%ROWTYPE
784: --------------------------------------------------------------------------------
785: IS
786: l_csr RefCsr;
787: l_rec HR_ASSIGNMENT_SETS%ROWTYPE;
788: BEGIN
789: l_csr := csr_with_bus('HR_ASSIGNMENT_SETS','ASSIGNMENT_SET_NAME','T',p_assignment_set_name,p_business_group_id);
790: fetch l_csr into l_rec;
791: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 789: l_csr := csr_with_bus('HR_ASSIGNMENT_SETS','ASSIGNMENT_SET_NAME','T',p_assignment_set_name,p_business_group_id);

785: IS
786: l_csr RefCsr;
787: l_rec HR_ASSIGNMENT_SETS%ROWTYPE;
788: BEGIN
789: l_csr := csr_with_bus('HR_ASSIGNMENT_SETS','ASSIGNMENT_SET_NAME','T',p_assignment_set_name,p_business_group_id);
790: fetch l_csr into l_rec;
791: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
792: l_rec := NULL;
793: end if;