2969:
2970:
2971: PROCEDURE GetOverrideApproverDetail(p_EmpId IN NUMBER,
2972: p_appreq IN VARCHAR2,
2973: p_ApproverId OUT NOCOPY HR_EMPLOYEES.employee_num%TYPE,
2974: p_OverrideApproverName OUT NOCOPY HR_EMPLOYEES.full_name%TYPE) IS
2975:
2976:
2977: l_DefaultCostCenter VARCHAR2(80);
2970:
2971: PROCEDURE GetOverrideApproverDetail(p_EmpId IN NUMBER,
2972: p_appreq IN VARCHAR2,
2973: p_ApproverId OUT NOCOPY HR_EMPLOYEES.employee_num%TYPE,
2974: p_OverrideApproverName OUT NOCOPY HR_EMPLOYEES.full_name%TYPE) IS
2975:
2976:
2977: l_DefaultCostCenter VARCHAR2(80);
2978: l_EmployeeNum HR_EMPLOYEES.employee_num%TYPE := 100;
2974: p_OverrideApproverName OUT NOCOPY HR_EMPLOYEES.full_name%TYPE) IS
2975:
2976:
2977: l_DefaultCostCenter VARCHAR2(80);
2978: l_EmployeeNum HR_EMPLOYEES.employee_num%TYPE := 100;
2979: l_DefaultSource VARCHAR2(30) := NULL;
2980: l_TempBoolean BOOLEAN;
2981: l_ManagerOrgId NUMBER;
2982: