[Home] [Help]
PACKAGE: APPS.IA_WF_UTIL_PKG
Source
1 PACKAGE IA_WF_UTIL_PKG AS
2 /* $Header: IAWFUTLS.pls 120.0 2005/06/04 00:02:04 appldev noship $ */
3
4 -- iAssets' Common Constants
5 FUNCTION ApplicationShortName return VARCHAR2;
6
7 -- Definition of Profile Option Names
8 FUNCTION ProfileDebugMode return VARCHAR2;
9 FUNCTION ProfileRuleID return VARCHAR2;
10 FUNCTION ProfileSystemAdministrator return VARCHAR2;
11
12 -- Approval Status for AME
13
14 -- Request Type
15 FUNCTION RequestTypeAssetList return VARCHAR2;
16 FUNCTION RequestTypeTransfer return VARCHAR2;
17 FUNCTION RequestTypeRetire return VARCHAR2;
18
19 -- Approval History Status
20 FUNCTION ApprovalStatusSubmitted return VARCHAR2;
21 FUNCTION ApprovalStatusPendingApproval return VARCHAR2;
22 FUNCTION ApprovalStatusDelegated return VARCHAR2;
23 FUNCTION ApprovalStatusApproved return VARCHAR2;
24 FUNCTION ApprovalStatusFinallyApproved return VARCHAR2;
25 FUNCTION ApprovalStatusRejected return VARCHAR2;
26
27 -- Header Status
28 FUNCTION HeaderStatusSubmitted return VARCHAR2;
29 FUNCTION HeaderStatusPendingApproval return VARCHAR2;
30 FUNCTION HeaderStatusApproved return VARCHAR2;
31 FUNCTION HeaderStatusRejected return VARCHAR2;
32 FUNCTION HeaderStatusPendingError return VARCHAR2;
33 FUNCTION HeaderStatusPost return VARCHAR2;
34
35 -- Line Status
36 FUNCTION LineStatusNew return VARCHAR2;
37 FUNCTION LineStatusPending return VARCHAR2;
38 FUNCTION LineStatusPost return VARCHAR2;
39 FUNCTION LineStatusOnReview return VARCHAR2;
40 FUNCTION LineStatusOnHold return VARCHAR2;
41 FUNCTION LineStatusRejected return VARCHAR2;
42 FUNCTION LineStatusPosted return VARCHAR2;
43
44
45 -- Responsibility Type for AME
46
47 FUNCTION RespTypeRequest return VARCHAR2;
48 FUNCTION RespTypeAll return VARCHAR2;
49
50 -- Approval Type for AME
51
52 FUNCTION ApprovalTypeAll return VARCHAR2;
53 FUNCTION ApprovalTypeReleasing return VARCHAR2;
54 FUNCTION ApprovalTypeDestination return VARCHAR2;
55 FUNCTION ApprovalTypeNone return VARCHAR2;
56
57 FUNCTION LOVTypeReleasing return VARCHAR2;
58 FUNCTION LOVTypeDestination return VARCHAR2;
59
60 -- Approval Method for AME
61
62 FUNCTION ApprovalMethodHierarchy return VARCHAR2;
63 FUNCTION ApprovalMethodCostCenter return VARCHAR2;
64
65 -- Transaction Type for AME
66
67 -- FUNCTION AME_LOV_TransactionType return VARCHAR2;
68 FUNCTION AME_RELEASE_TransactionType return VARCHAR2;
69 FUNCTION AME_RECEIVE_TransactionType return VARCHAR2;
70
71
72 -- Approval Groups for AME
73 -- HierarchyBasedRelGroup VARCHAR2(30) := 'IA_APPROVAL_HRCH_REL';
74 -- HierarchyBasedRecGroup CONSTANT VARCHAR2(30) := 'IA_APPROVAL_HRCH_REC';
75 -- CostCenterBasedGroup CONSTANT VARCHAR2(30) := 'IA_APPROVAL_CC'; -- Both releasing and receiving are applied
76
77 FUNCTION HierarchyBasedRelGroup return VARCHAR2;
78 FUNCTION HierarchyBasedRecGroup return VARCHAR2;
79 FUNCTION CostCenterBasedGroup return VARCHAR2;
80
81 -- Transaction Type for Workflow
82 -- WF_TransactionType CONSTANT VARCHAR2(15) := 'IA_TRX';
83
84 FUNCTION WF_TransactionType return VARCHAR2;
85 FUNCTION WF_MainProcess return VARCHAR2;
86
87 -- The folloging global variables will be set in each session by calling its corresponding function.
88 DebugModeEnabledFlag BOOLEAN := NULL;
89 ApplicationID NUMBER(15) := NULL;
90 RuleID NUMBER(15) := NULL;
91 TransferEnabled VARCHAR2(1) := NULL;
92 TransactionDateAllowed VARCHAR2(1) := NULL;
93 ResponsibilityType VARCHAR2(30) := NULL;
94 SuperUserApprovalRequired VARCHAR2(1) := NULL;
95 ApprovalType VARCHAR2(30) := NULL;
96 ApprovalMethod VARCHAR2(30) := NULL;
97
98 PROCEDURE InitializeServerMessage;
99 PROCEDURE InitializeDebugMessage;
100
101 /*
102 PROCEDURE RaiseException(
103 p_calling_fn IN VARCHAR2,
104 p_debug_info IN VARCHAR2 DEFAULT ''
105 );
106 */
107
108 PROCEDURE AddDebugMessage(
109 p_calling_fn IN VARCHAR2,
110 p_parameter1 IN VARCHAR2 DEFAULT '',
111 p_parameter2 IN VARCHAR2 DEFAULT ''
112 );
113
114 PROCEDURE AddWFDebugMessage(
115 p_request_id IN VARCHAR2,
116 p_calling_fn IN VARCHAR2,
117 p_parameter1 IN VARCHAR2 DEFAULT '',
118 p_parameter2 IN VARCHAR2 DEFAULT ''
119 );
120
121 FUNCTION GetApplicationID return NUMBER;
122
123 FUNCTION DebugModeEnabled return BOOLEAN;
124
125 FUNCTION GetRuleID
126 return NUMBER;
127
128 FUNCTION GetRuleID(p_responsibility_id IN NUMBER)
129 return NUMBER;
130
131 FUNCTION GetSystemAdministrator
132 return VARCHAR2;
133
134 FUNCTION IsTransferEnabled(p_rule_id IN NUMBER
135 ,p_book_type_code IN VARCHAR2)
136 return VARCHAR2;
137
138 FUNCTION IsTransactionDateAllowed(p_rule_id IN NUMBER
139 ,p_book_type_code IN VARCHAR2)
140 return VARCHAR2;
141
142
143 FUNCTION GetResponsibilityType(p_rule_id IN NUMBER
144 ,p_book_type_code IN VARCHAR2)
145 return VARCHAR2;
146
147 FUNCTION IsSuperUserApprovalRequired(p_rule_id IN NUMBER
148 ,p_book_type_code IN VARCHAR2)
149 return VARCHAR2;
150
151
152 FUNCTION GetApprovalType(p_rule_id IN NUMBER
153 ,p_book_type_code IN VARCHAR2)
154 return VARCHAR2;
155
156
157 FUNCTION GetApprovalMethod(p_rule_id IN NUMBER
158 ,p_book_type_code IN VARCHAR2)
159 return VARCHAR2;
160
161 FUNCTION ResetRuleSetup(p_rule_id IN NUMBER
162 ,p_book_type_code IN VARCHAR2)
163 return BOOLEAN;
164
165 FUNCTION GetLookupMeaning(p_lookup_type IN VARCHAR2
166 ,p_lookup_code IN VARCHAR2)
167 return VARCHAR2;
168
169
170 FUNCTION InitializeProfile(p_user_id IN NUMBER
171 ,p_responsibility_id IN NUMBER)
172 return BOOLEAN;
173
174
175 END IA_WF_UTIL_PKG;