DBA Data[Home] [Help]

APPS.HR_JP_ID_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 727: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ALL_PAYROLLS_F%ROWTYPE

723: FUNCTION payroll_rec(
724: p_payroll_name IN VARCHAR2,
725: p_business_group_id IN NUMBER,
726: p_effective_date IN DATE DEFAULT hr_api.g_sys,
727: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ALL_PAYROLLS_F%ROWTYPE
728: --------------------------------------------------------------------------------
729: IS
730: l_csr RefCsr;
731: l_rec PAY_ALL_PAYROLLS_F%ROWTYPE;

Line 731: l_rec PAY_ALL_PAYROLLS_F%ROWTYPE;

727: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PAY_ALL_PAYROLLS_F%ROWTYPE
728: --------------------------------------------------------------------------------
729: IS
730: l_csr RefCsr;
731: l_rec PAY_ALL_PAYROLLS_F%ROWTYPE;
732: BEGIN
733: l_csr := csr_with_bus('PAY_ALL_PAYROLLS_F','PAYROLL_NAME','T',p_payroll_name,p_business_group_id,'DATETRACKED',p_effective_date);
734: fetch l_csr into l_rec;
735: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 733: l_csr := csr_with_bus('PAY_ALL_PAYROLLS_F','PAYROLL_NAME','T',p_payroll_name,p_business_group_id,'DATETRACKED',p_effective_date);

729: IS
730: l_csr RefCsr;
731: l_rec PAY_ALL_PAYROLLS_F%ROWTYPE;
732: BEGIN
733: l_csr := csr_with_bus('PAY_ALL_PAYROLLS_F','PAYROLL_NAME','T',p_payroll_name,p_business_group_id,'DATETRACKED',p_effective_date);
734: fetch l_csr into l_rec;
735: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
736: l_rec := NULL;
737: end if;