PACKAGE: APPS.AP_WEB_AME_PKG

Source

1 PACKAGE AP_WEB_AME_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwxames.pls 120.4.12020000.2 2012/08/14 09:36:26 rveliche ship $ */
3 
4 -- Constants
5 C_AWARD_MANAGER_ROLE	       CONSTANT VARCHAR(30) := 'AM';
6 C_PROJECT_MANAGER_ROLE_TYPE  CONSTANT VARCHAR(20) := 'PROJECT MANAGER';
7 C_ACTIVE_STATUS 	     CONSTANT VARCHAR(30) := 'ACTIVE_ASSIGN';
8 -- Bug: 14360780, Contingent workes cannot be defined as project managers.
9 C_ACTIVE_CWK_STATUS	     CONSTANT VARCHAR2(30) := 'ACTIVE_CWK';
10 
11 FUNCTION getViolationTotal(p_report_header_id IN VARCHAR2) RETURN NUMBER;
12 
13 FUNCTION getAwardManagerID(p_award_id IN NUMBER, p_as_of_date IN DATE) RETURN NUMBER;
14 
15 FUNCTION getProjectManagerID(p_project_id IN NUMBER, p_as_of_date IN DATE) RETURN NUMBER;
16 
17 FUNCTION getTotalPerCostCenter(p_report_header_id  IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
18 			       p_line_number       IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN NUMBER;
19 
20 FUNCTION getCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
21 			    p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2;
22 
23 FUNCTION getViolationPercentage(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER;
24 
25 FUNCTION isMissingReceiptsShortpay(p_report_header_id IN NUMBER) RETURN VARCHAR2;
26 
27 FUNCTION getAwardNumber(p_award_id IN NUMBER) RETURN VARCHAR2;
28 
29 PROCEDURE InitOieAmeNotifGT(p_report_header_id IN NUMBER,
30                             p_approver_id      IN NUMBER,
31 			    p_display_instr     OUT  NOCOPY VARCHAR2);
32 
33 PROCEDURE InitOieAmeApproverAmtGT(p_report_header_id IN NUMBER);
34 
35 END AP_WEB_AME_PKG;