PACKAGE: APPS.AP_WEB_AME_PKG

Source

1 PACKAGE AP_WEB_AME_PKG AS
2 /* $Header: apwxames.pls 120.4 2006/02/24 10:25:44 sbalaji noship $ */
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 
9 FUNCTION getViolationTotal(p_report_header_id IN VARCHAR2) RETURN NUMBER;
10 
11 FUNCTION getAwardManagerID(p_award_id IN NUMBER, p_as_of_date IN DATE) RETURN NUMBER;
12 
13 FUNCTION getProjectManagerID(p_project_id IN NUMBER, p_as_of_date IN DATE) RETURN NUMBER;
14 
15 FUNCTION getTotalPerCostCenter(p_report_header_id  IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
16 			       p_line_number       IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE) RETURN NUMBER;
17 
18 FUNCTION getCostCenterOwner(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
19 			    p_cost_center IN AP_EXPENSE_REPORT_LINES.FLEX_CONCATENATED%TYPE) RETURN VARCHAR2;
20 
21 FUNCTION getViolationPercentage(p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE) RETURN NUMBER;
22 
23 FUNCTION isMissingReceiptsShortpay(p_report_header_id IN NUMBER) RETURN VARCHAR2;
24 
25 FUNCTION getAwardNumber(p_award_id IN NUMBER) RETURN VARCHAR2;
26 
27 PROCEDURE InitOieAmeNotifGT(p_report_header_id IN NUMBER,
28                             p_approver_id      IN NUMBER,
29 			    p_display_instr     OUT  NOCOPY VARCHAR2);
30 
31 PROCEDURE InitOieAmeApproverAmtGT(p_report_header_id IN NUMBER);
32 
33 END AP_WEB_AME_PKG;