1 PACKAGE AP_WEB_CUST_AME_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwamecs.pls 120.5 2006/02/24 06:57:17 sbalaji noship $ */
3
4 FUNCTION getHeaderLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2;
5
6 FUNCTION getLineLevelApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
7 p_dist_line_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN VARCHAR2;
8
9 FUNCTION getCustomCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
10 p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2;
11
12 FUNCTION getCostCenterApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN VARCHAR2;
13
14 FUNCTION getCCBusinessManager(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
15 p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2;
16
17 FUNCTION getTransactionRequestor(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER;
18
19 FUNCTION getProjectApprover(p_project_id IN VARCHAR2) RETURN NUMBER;
20
21 FUNCTION getAwardApprover(p_award_id IN VARCHAR2) RETURN NUMBER;
22
23 FUNCTION getDistCostCenterApprover(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
24 p_cost_center IN VARCHAR2) RETURN NUMBER;
25
26 FUNCTION getJobSupervisorApprover(p_item_class IN VARCHAR2,
27 p_report_header_id IN NUMBER,
28 p_item_id IN VARCHAR2
29 ) RETURN NUMBER;
30
31 END AP_WEB_CUST_AME_PKG;