DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 926: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_ASSIGNMENTS_F%ROWTYPE

922: FUNCTION emp_assignment_rec(
923: p_assignment_number IN VARCHAR2,
924: p_business_group_id IN NUMBER,
925: p_effective_date IN DATE DEFAULT hr_api.g_sys,
926: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_ASSIGNMENTS_F%ROWTYPE
927: --------------------------------------------------------------------------------
928: IS
929: l_csr RefCsr;
930: l_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;

Line 930: l_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;

926: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_ASSIGNMENTS_F%ROWTYPE
927: --------------------------------------------------------------------------------
928: IS
929: l_csr RefCsr;
930: l_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
931: BEGIN
932: l_csr := csr_with_bus('PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_NUMBER','T',p_assignment_number,p_business_group_id,'DATETRACKED',p_effective_date);
933: fetch l_csr into l_rec;
934: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 932: l_csr := csr_with_bus('PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_NUMBER','T',p_assignment_number,p_business_group_id,'DATETRACKED',p_effective_date);

928: IS
929: l_csr RefCsr;
930: l_rec PER_ALL_ASSIGNMENTS_F%ROWTYPE;
931: BEGIN
932: l_csr := csr_with_bus('PER_ALL_ASSIGNMENTS_F','ASSIGNMENT_NUMBER','T',p_assignment_number,p_business_group_id,'DATETRACKED',p_effective_date);
933: fetch l_csr into l_rec;
934: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
935: l_rec := NULL;
936: end if;