APPS.AP_WEB_CUST_AME_PKG dependencies on AP_WEB_DB_EXPRPT_PKG

Line 19: FUNCTION checkAndGetApprover(p_approver_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID,

15: RETURNS
16: Return approver ID if approver <> employee or approver is null
17: else return approver's manager ID
18: *----------------------------------------------------------------------------*/
19: FUNCTION checkAndGetApprover(p_approver_id IN AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID,
20: p_employee_id IN NUMBER)
21: RETURN VARCHAR2 IS
22: l_debugInfo varchar2(240);
23: l_dir_manager_id NUMBER := NULL;

Line 71: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;

67: -------------------------------------------------------------------------
68: FUNCTION getHeaderLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2 IS
69: -------------------------------------------------------------------------
70: l_debug_info VARCHAR2(200);
71: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
72: l_employee_id NUMBER;
73: l_num_of_distinct_awards INTEGER;
74: l_num_of_awards INTEGER;
75: l_num_of_distinct_projects INTEGER;

Line 99: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_report_header_id), l_approver_id))) THEN

95:
96: -----------------------------------------------------
97: l_debug_info := 'Check whether user entered an Approver';
98: -----------------------------------------------------
99: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_report_header_id), l_approver_id))) THEN
100: l_approver_id := NULL;
101: END IF;
102:
103: IF (l_approver_id IS NOT NULL) THEN

Line 517: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;

513: -------------------------------------------------------------------------
514: FUNCTION getCostCenterApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2 IS
515: -------------------------------------------------------------------------
516: l_debug_info VARCHAR2(200);
517: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
518: l_employee_id NUMBER;
519: l_cost_center_approver_id NUMBER;
520: l_default_cost_center VARCHAR2(240);
521: l_approver_default_cost_center VARCHAR2(240);

Line 559: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_report_header_id), l_approver_id))) THEN

555: IF (l_default_cost_center = l_cost_center) THEN
556: -----------------------------------------------------
557: l_debug_info := 'Check whether user entered an Approver';
558: -----------------------------------------------------
559: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_report_header_id), l_approver_id))) THEN
560: l_approver_id := NULL;
561: END IF;
562:
563: IF (l_approver_id IS NOT NULL) THEN

Line 584: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_report_header_id), l_approver_id))) THEN

580: ELSE
581: -----------------------------------------------------
582: l_debug_info := 'Check whether user entered an Approver';
583: -----------------------------------------------------
584: IF (NOT (AP_WEB_DB_EXPRPT_PKG.GetOverrideApproverID(to_number(p_report_header_id), l_approver_id))) THEN
585: l_approver_id := NULL;
586: END IF;
587:
588: IF (l_approver_id IS NOT NULL) THEN

Line 647: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;

643: FUNCTION getTransactionRequestor(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER
644: IS
645: -------------------------------------------------------------------------
646: l_debug_info VARCHAR2(200);
647: l_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
648: l_employee_id NUMBER;
649: l_emp_active VARCHAR2(1);
650:
651: BEGIN