APPS.AP_WEB_CUST_AME_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 525: l_manager_id AP_WEB_DB_HR_INT_PKG.perEmp_supervisorID;

521: l_approver_default_cost_center VARCHAR2(240);
522: l_cost_center VARCHAR2(240);
523: l_employee_num VARCHAR2(30);
524: l_employee_name VARCHAR2(240);
525: l_manager_id AP_WEB_DB_HR_INT_PKG.perEmp_supervisorID;
526:
527: BEGIN
528:
529: -----------------------------------------------------

Line 658: l_debug_info := 'Calling AP_WEB_DB_HR_INT_PKG.IsPersonActive';

654: from ap_expense_report_headers_all
655: where report_header_id = p_report_header_id;
656:
657: --------------------------------------------------------------
658: l_debug_info := 'Calling AP_WEB_DB_HR_INT_PKG.IsPersonActive';
659: --------------------------------------------------------------
660: l_emp_active := AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id);
661: if (l_emp_active = 'Y') then
662: return l_employee_id;

Line 660: l_emp_active := AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id);

656:
657: --------------------------------------------------------------
658: l_debug_info := 'Calling AP_WEB_DB_HR_INT_PKG.IsPersonActive';
659: --------------------------------------------------------------
660: l_emp_active := AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id);
661: if (l_emp_active = 'Y') then
662: return l_employee_id;
663: else
664: --------------------------------------------------------------

Line 667: return (AP_WEB_DB_HR_INT_PKG.getFinalActiveManager(l_employee_id));

663: else
664: --------------------------------------------------------------
665: l_debug_info := 'Calling AP_WEB_EXPENSE_WF.GetManager';
666: --------------------------------------------------------------
667: return (AP_WEB_DB_HR_INT_PKG.getFinalActiveManager(l_employee_id));
668: end if;
669:
670: EXCEPTION
671: WHEN OTHERS THEN

Line 797: l_emp_active := AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id);

793: where report_header_id = p_report_header_id;
794:
795: -- Bug 14158542: Terminated employee expense reports skips the first manager for approval
796: IF l_override_approver_id IS NULL THEN
797: l_emp_active := AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id);
798:
799: IF (l_emp_active = 'N') THEN
800: return (AP_WEB_DB_HR_INT_PKG.getFinalActiveManager(l_employee_id));
801: END IF;

Line 800: return (AP_WEB_DB_HR_INT_PKG.getFinalActiveManager(l_employee_id));

796: IF l_override_approver_id IS NULL THEN
797: l_emp_active := AP_WEB_DB_HR_INT_PKG.IsPersonActive(l_employee_id);
798:
799: IF (l_emp_active = 'N') THEN
800: return (AP_WEB_DB_HR_INT_PKG.getFinalActiveManager(l_employee_id));
801: END IF;
802: END IF;
803:
804: return l_override_approver_id;