[Home] [Help]
PACKAGE: APPS.AP_WEB_OA_ACTIVE_PKG
Source
1 PACKAGE AP_WEB_OA_ACTIVE_PKG AS
2 /* $Header: apwoaacs.pls 120.7 2005/11/11 11:43:02 mvadera noship $ */
3
4 SUBTYPE language_code IS VARCHAR2(100);
5
6 FUNCTION GetApproverName (p_report_header_id IN NUMBER,
7 p_attribute_name IN VARCHAR2) RETURN VARCHAR2;
8
9 FUNCTION GetApApprover RETURN VARCHAR2;
10
11 FUNCTION GetExpensesAdmin RETURN VARCHAR2;
12
13 FUNCTION GetWFLastNotificationActivity (p_report_header_id IN NUMBER) RETURN VARCHAR2;
14
15 FUNCTION GetReportStatusCode(p_source IN VARCHAR2,
16 p_workflow_approved_flag IN VARCHAR2,
17 p_report_header_id IN NUMBER,
18 p_cache IN VARCHAR2 DEFAULT 'Y',
19 p_query_wf_activities IN VARCHAR2 DEFAULT 'Y') RETURN VARCHAR2;
20
21 FUNCTION GetBothPayStatusCode(p_report_header_id IN NUMBER,
22 p_status_code IN VARCHAR2,
23 p_amt_due_ccard_company IN NUMBER,
24 p_amt_due_employee IN NUMBER) RETURN VARCHAR2;
25
26 FUNCTION GetReportStatus(p_source IN VARCHAR2,
27 p_workflow_approved_flag IN VARCHAR2,
28 p_report_header_id IN NUMBER)
29 RETURN VARCHAR2;
30
31 FUNCTION GetCurrentApprover(p_source IN VARCHAR2,
32 p_workflow_approved_flag IN VARCHAR2,
33 p_report_header_id IN NUMBER,
34 p_status_code IN VARCHAR2 DEFAULT NULL)
35 RETURN VARCHAR2;
36
37 FUNCTION GetIncludeNotification(p_category IN VARCHAR2,
38 p_trx_id IN NUMBER)
39 RETURN VARCHAR2;
40
41 -- Indicates the various constants possible for source
42 C_NonValidatedWebExpense CONSTANT VARCHAR2(22) := 'NonValidatedWebExpense';
43 C_WebExpense CONSTANT VARCHAR2(10) := 'WebExpense';
44 C_XpenseXpress CONSTANT VARCHAR2(12) := 'XpenseXpress';
45 C_SelfService CONSTANT VARCHAR2(11) := 'SelfService';
46 C_CREDIT_CARD CONSTANT VARCHAR2(11) := 'CREDIT CARD';
47 C_BOTH_PAY CONSTANT VARCHAR2(11) := 'Both Pay';
48
49 -- Indicates the various values for workflow_approved_flag
50 C_WFSaved CONSTANT VARCHAR2(1) := 'S';
51 C_WFRejected CONSTANT VARCHAR2(1) := 'R';
52 C_WFReturned CONSTANT VARCHAR2(1) := 'T';
53 C_WFManagerApproved CONSTANT VARCHAR2(1) := 'M';
54 C_WFPayablesApproved CONSTANT VARCHAR2(1) := 'P';
55 C_WFAutoApproved CONSTANT VARCHAR2(1) := 'A';
56 C_WFMgrPayablesApproved CONSTANT VARCHAR2(1) := 'Y';
57 C_WFNotApproved CONSTANT VARCHAR2(1) := 'N';
58 --ER 1552747 - withdraw expense report
59 C_WFWithdrawn CONSTANT VARCHAR2(1) := 'W';
60 C_WFInProgress CONSTANT VARCHAR2(1) := 'I';
61
62 -- Indicates the various lookup values from lookup type EXPENSE REPORT STATUS
63 C_PENDMGR CONSTANT VARCHAR2(7) := 'PENDMGR'; -- Pending Manager Approval
64 C_MGRAPPR CONSTANT VARCHAR2(7) := 'MGRAPPR'; -- Pending Payables Approval
65 C_MGRPAYAPPR CONSTANT VARCHAR2(10) := 'MGRPAYAPPR'; -- Ready for Invoicing
66 C_RESOLUTN CONSTANT VARCHAR2(8) := 'RESOLUTN'; -- Pending Your Resolution
67 C_EMPAPPR CONSTANT VARCHAR2(7) := 'EMPAPPR'; -- Pending Employee Approval
68 C_ERROR CONSTANT VARCHAR2(5) := 'ERROR'; -- Pending Error Correction
69 C_SAVED CONSTANT VARCHAR2(5) := 'SAVED'; -- Saved
70 C_REJECTED CONSTANT VARCHAR2(8) := 'REJECTED'; -- Rejected
71 C_RETURNED CONSTANT VARCHAR2(8) := 'RETURNED'; -- Returned
72 C_INVOICED CONSTANT VARCHAR2(8) := 'INVOICED'; -- Ready for Payment
73 --ER 1552747 - withdraw expense report
74 C_WITHDRAWN CONSTANT VARCHAR2(9) := 'WITHDRAWN'; -- Withdrawn
75 C_INPROGRESS CONSTANT VARCHAR2(10) := 'INPROGRESS'; -- Reports those Implictly Saved
76
77 -- Indicates constants used for workflow
78 -- Default item type
79 C_APEXP CONSTANT VARCHAR2(5) := 'APEXP';
80
81 -- Workflow Item attribute names
82 C_APPROVER_DISPLAY_NAME CONSTANT VARCHAR2(21) := 'APPROVER_DISPLAY_NAME';
83 C_EMPLOYEE_DISPLAY_NAME CONSTANT VARCHAR2(21) := 'EMPLOYEE_DISPLAY_NAME';
84 C_PREPARER_DISPLAY_NAME CONSTANT VARCHAR2(21) := 'PREPARER_DISPLAY_NAME';
85
86 -- Workflow Activity Labels
87 C_REQUEST_EMPLOYEE_APPROVAL CONSTANT VARCHAR2(30) := 'REQUEST_EMPLOYEE_APPROVAL';
88 C_INFORM_SYSADM_AP_VALID_FAIL CONSTANT VARCHAR2(30) := 'INFORM_SYSADM_AP_VALID_FAIL';
89 C_INFORM_PREPARER_SHORTPAY CONSTANT VARCHAR2(30) := 'INFORM_PREPARER_SHORTPAY';
90 C_INFORM_PREP_NO_MANAGER_RESP CONSTANT VARCHAR2(30) := 'INFORM_PREP_NO_MANAGER_RESP';
91 C_INFORM_SYSADM_NO_APPROVER CONSTANT VARCHAR2(30) := 'INFORM_SYSADM_NO_APPROVER';
92 C_INFORM_CUSTOM_VALIDATE_ERROR CONSTANT VARCHAR2(30) := 'INFORM_CUSTOM_VALIDATE_ERROR';
93 C_POLICY_SHORTPAY_NOTICE CONSTANT VARCHAR2(30) := 'POLICY_SHORTPAY_NOTICE';
94
95 -- Workflow Activity Status
96 C_NOTIFIED CONSTANT VARCHAR(10) := 'NOTIFIED';
97
98 -- Lookup types
99 C_EXPENSE_REPORT_APPROVER CONSTANT VARCHAR2(25) := 'EXPENSE REPORT APPROVER';
100 C_EXPENSE_REPORT_STATUS CONSTANT VARCHAR2(25) := 'EXPENSE REPORT STATUS';
101
102 -- Lookup codes
103 C_AP CONSTANT VARCHAR2(2) := 'AP';
104 C_EXPADMIN CONSTANT VARCHAR2(8) := 'EXPADMIN';
105
106 END AP_WEB_OA_ACTIVE_PKG;