[Home] [Help]
PACKAGE: APPS.CCT_OTHERATTRIBINIT_PUB
Source
1 PACKAGE CCT_OTHERATTRIBINIT_PUB as
2 /* $Header: cctothrs.pls 120.0 2005/06/02 09:51:02 appldev noship $ */
3
4
5 /* -----------------------------------------------------------------------
6 1 Activity Name : WF_SR_Exists (branch node)
7 To check if the Service Request Number already exists
8 IN
9 itemtype - item type
10 itemkey - item key
11 actid - process activity instance id
12 funmode - execution mode
13 OUT
14 comparison result (WFSTD_YES_NO lookup code)
15 ITEM ATTRIBUTES REFERENCED
16 ServiceRequestNum - the Service Request Number
17 *-----------------------------------------------------------------------*/
18 procedure WF_SR_Exists (
19 itemtype in varchar2
20 , itemkey in varchar2
21 , actid in number
22 , funmode in varchar2
23 , resultout in out nocopy varchar2) ;
24
25 /* -----------------------------------------------------------------------
26 Activity Name : WF_AccountNum_Exists (branch node)
27 To check if the Account Number already exists
28 IN
29 itemtype - item type
30 itemkey - item key
31 actid - process activity instance id
32 funmode - execution mode
33 OUT
34 comparison result (WFSTD_YES_NO lookup code)
35 ITEM ATTRIBUTES REFERENCED
36 AccountCode - the Account Number
37 *-----------------------------------------------------------------------*/
38 procedure WF_AccountNum_Exists (
39 itemtype in varchar2
40 , itemkey in varchar2
41 , actid in number
42 , funmode in varchar2
43 , resultout in out nocopy varchar2) ;
44
45 /* -----------------------------------------------------------------------
46 Activity Name : WF_ANI_Exists (branch node)
47 To check if the ANI already exists
48 IN
49 itemtype - item type
50 itemkey - item key
51 actid - process activity instance id
52 funmode - execution mode
53 OUT
54 comparison result (WFSTD_YES_NO lookup code)
55 ITEM ATTRIBUTES REFERENCED
56 ANI - the ANI
57 *-----------------------------------------------------------------------*/
58 procedure WF_ANI_Exists (
59 itemtype in varchar2
60 , itemkey in varchar2
61 , actid in number
62 , funmode in varchar2
63 , resultout in out nocopy varchar2) ;
64
65 /* -----------------------------------------------------------------------
66 Activity Name : WF_CollateralReqNum_Exists (branch node)
67 To check if the Collateral Request Number already exists
68 IN
69 itemtype - item type
70 itemkey - item key
71 actid - process activity instance id
72 funmode - execution mode
73 OUT
74 comparison result (WFSTD_YES_NO lookup code)
75 ITEM ATTRIBUTES REFERENCED
76 CollateralReqNum - Collateral Request Number
77 *-----------------------------------------------------------------------*/
78 procedure WF_CollateralReqNum_Exists (
79 itemtype in varchar2
80 , itemkey in varchar2
81 , actid in number
82 , funmode in varchar2
83 , resultout in out nocopy varchar2) ;
84 /* -----------------------------------------------------------------------
85 Activity Name : WF_ContractNum_Exists (branch node)
86 To check if the Contract Number already exists
87 IN
88 itemtype - item type
89 itemkey - item key
90 actid - process activity instance id
91 funmode - execution mode
92 OUT
93 comparison result (WFSTD_YES_NO lookup code)
94 ITEM ATTRIBUTES REFERENCED
95 ContractNum - Contract Number
96 *-----------------------------------------------------------------------*/
97 procedure WF_ContractNum_Exists (
98 itemtype in varchar2
99 , itemkey in varchar2
100 , actid in number
101 , funmode in varchar2
102 , resultout in out nocopy varchar2) ;
103 /* -----------------------------------------------------------------------
104 Activity Name : WF_EventCode_Exists (branch node)
105 To check if the Event Registration Code already exists
106 IN
107 itemtype - item type
108 itemkey - item key
109 actid - process activity instance id
110 funmode - execution mode
111 OUT
112 comparison result (WFSTD_YES_NO lookup code)
113 ITEM ATTRIBUTES REFERENCED
114 EventCode - Event Registration Code
115 *-----------------------------------------------------------------------*/
116 procedure WF_EventCode_Exists (
117 itemtype in varchar2
118 , itemkey in varchar2
119 , actid in number
120 , funmode in varchar2
121 , resultout in out nocopy varchar2) ;
122
123 /* -----------------------------------------------------------------------
124 Activity Name : WF_MarketingPIN_Exists (branch node)
125 To check if the Event Registration Code already exists
126 IN
127 itemtype - item type
128 itemkey - item key
129 actid - process activity instance id
130 funmode - execution mode
131 OUT
132 comparison result (WFSTD_YES_NO lookup code)
133 ITEM ATTRIBUTES REFERENCED
134 MarketingPIN
135 *-----------------------------------------------------------------------*/
136 procedure WF_MarketingPIN_Exists (
137 itemtype in varchar2
138 , itemkey in varchar2
139 , actid in number
140 , funmode in varchar2
141 , resultout in out nocopy varchar2) ;
142 /* -----------------------------------------------------------------------
143 Activity Name : WF_OrderNum_Exists (branch node)
144 To check if the OrderNum already exists
145 IN
146 itemtype - item type
147 itemkey - item key
148 actid - process activity instance id
149 funmode - execution mode
150 OUT
151 comparison result (WFSTD_YES_NO lookup code)
152 ITEM ATTRIBUTES REFERENCED
153 OrderNum
154 *-----------------------------------------------------------------------*/
155 procedure WF_OrderNum_Exists (
156 itemtype in varchar2
157 , itemkey in varchar2
158 , actid in number
159 , funmode in varchar2
160 , resultout in out nocopy varchar2) ;
161 /* -----------------------------------------------------------------------
162 Activity Name : WF_CustomerNum_Exists (branch node)
163 To check if the Event Registration Code already exists
164 IN
165 itemtype - item type
166 itemkey - item key
167 actid - process activity instance id
168 funmode - execution mode
169 OUT
170 comparison result (WFSTD_YES_NO lookup code)
171 ITEM ATTRIBUTES REFERENCED
172 CustomerNum
173 *-----------------------------------------------------------------------*/
174 procedure WF_CustomerNum_Exists (
175 itemtype in varchar2
176 , itemkey in varchar2
177 , actid in number
178 , funmode in varchar2
179 , resultout in out nocopy varchar2) ;
180 /* -----------------------------------------------------------------------
181 Activity Name : WF_QuoteNum_Exists (branch node)
182 To check if the QuoteNum already exists
183 IN
184 itemtype - item type
185 itemkey - item key
186 actid - process activity instance id
187 funmode - execution mode
188 OUT
189 comparison result (WFSTD_YES_NO lookup code)
190 ITEM ATTRIBUTES REFERENCED
191 QuoteNum
192 *-----------------------------------------------------------------------*/
193 procedure WF_QuoteNum_Exists (
194 itemtype in varchar2
195 , itemkey in varchar2
196 , actid in number
197 , funmode in varchar2
198 , resultout in out nocopy varchar2) ;
199 /* -----------------------------------------------------------------------
200 Activity Name : WF_ServiceKey_Exists (branch node)
201 To check if the ServiceKey already exists
202 IN
203 itemtype - item type
204 itemkey - item key
205 actid - process activity instance id
206 funmode - execution mode
207 OUT
208 comparison result (WFSTD_YES_NO lookup code)
209 ITEM ATTRIBUTES REFERENCED
210 ServiceKey
211 *-----------------------------------------------------------------------*/
212 procedure WF_ServiceKey_Exists (
213 itemtype in varchar2
214 , itemkey in varchar2
215 , actid in number
216 , funmode in varchar2
217 , resultout in out nocopy varchar2) ;
218 /* -----------------------------------------------------------------------
219 Activity Name : WF_SourceCode_Exists (branch node)
220 To check if the Source Code already exists
221 IN
222 itemtype - item type
223 itemkey - item key
224 actid - process activity instance id
225 funmode - execution mode
226 OUT
227 comparison result (WFSTD_YES_NO lookup code)
228 Source Code
229 *-----------------------------------------------------------------------*/
230 procedure WF_SourceCode_Exists (
231 itemtype in varchar2
232 , itemkey in varchar2
233 , actid in number
234 , funmode in varchar2
235 , resultout in out nocopy varchar2) ;
236
237 END CCT_OTHERATTRIBINIT_PUB;