1 PACKAGE CCT_PRODUCTINIT_PUB as
2 /* $Header: cctprods.pls 120.0 2005/06/02 09:08:30 appldev noship $ */
3
4 /* -----------------------------------------------------------------------
5 Activity Name : WF_ProductFromReferenceNum (branch node)
6
7 To Check if the Customer Product ID can be derived from the reference num
8 IN
9 itemtype - item type
10 itemkey - item key
11 actid - process activity instance id
12 funmode - execution mode
13 out nocopy
14 comparison result (WFSTD_YES_NO lookup code)
15 ITEM ATTRIBUTES REFERENCED
16 REFNUM - the originating reference num
17 CPID - the customer product ID
18 *-----------------------------------------------------------------------*/
19 procedure WF_ProductFromReferenceNum (
20 itemtype in varchar2
21 , itemkey in varchar2
22 , actid in number
23 , funmode in varchar2
24 , resultout in out nocopy varchar2) ;
25
26 /* -----------------------------------------------------------------------
27 Activity Name : WF_ProductFromServiceReqNum (branch node)
28
29 To Check if the Customer Product ID can be derived from the reference num
30 IN
31 itemtype - item type
32 itemkey - item key
33 actid - process activity instance id
34 funmode - execution mode
35 OUT
36 comparison result (WFSTD_YES_NO lookup code)
37 ITEM ATTRIBUTES REFERENCED
38 ServiceReqNum - the originating Service Request Number
39 CPID - the customer product ID
40 *-----------------------------------------------------------------------*/
41 procedure WF_ProductFromServiceReqNum (
42 itemtype in varchar2
43 , itemkey in varchar2
44 , actid in number
45 , funmode in varchar2
46 , resultout in out nocopy varchar2) ;
47
48 /* -----------------------------------------------------------------------
49 Activity Name : WF_ProductFromSerialNum (branch node)
50
51 To Check if the Customer Product ID can be derived from the Serial number
52 IN
53 itemtype - item type
54 itemkey - item key
55 actid - process activity instance id
56 funmode - execution mode
57 OUT
58 comparison result (WFSTD_YES_NO lookup code)
59 ITEM ATTRIBUTES REFERENCED
60 SerialNum - the originating Serial Number
61 CPID - the customer product ID
62 *-----------------------------------------------------------------------*/
63 procedure WF_ProductFromSerialNum (
64 itemtype in varchar2
65 , itemkey in varchar2
66 , actid in number
67 , funmode in varchar2
68 , resultout in out nocopy varchar2) ;
69
70 /* -----------------------------------------------------------------------
71 Activity Name : WF_InventoryItemFromRefNum (branch node)
72
73 To Check if the Inventory Item ID can be derived from the Reference number
74 IN
75 itemtype - item type
76 itemkey - item key
77 actid - process activity instance id
78 funmode - execution mode
79 OUT
80 comparison result (WFSTD_YES_NO lookup code)
81 ITEM ATTRIBUTES REFERENCED
82 ReferenceNum - the originating Serial Number
83 InventoryItemID - the product ID
84 *-----------------------------------------------------------------------*/
85 procedure WF_InventoryItemFromRefNum (
86 itemtype in varchar2
87 , itemkey in varchar2
88 , actid in number
89 , funmode in varchar2
90 , resultout in out nocopy varchar2) ;
91
92 /* -----------------------------------------------------------------------
93 Activity Name : WF_InventoryItemFromSR (branch node)
94
95 To Check if the Inventory Item ID can be derived from the Reference number
96 IN
97 itemtype - item type
98 itemkey - item key
99 actid - process activity instance id
100 funmode - execution mode
101 OUT
102 comparison result (WFSTD_YES_NO lookup code)
103 ITEM ATTRIBUTES REFERENCED
104 SR - the originating Service Request Number
105 InventoryItemID - the product ID
106 *-----------------------------------------------------------------------*/
107 procedure WF_InventoryItemFromSR (
108 itemtype in varchar2
109 , itemkey in varchar2
110 , actid in number
111 , funmode in varchar2
112 , resultout in out nocopy varchar2) ;
113
114 /* -----------------------------------------------------------------------
115 Activity Name : WF_InventoryItemFromSerNum (branch node)
116
117 To Check if the Inventory Item ID can be derived from the Reference number
118 IN
119 itemtype - item type
120 itemkey - item key
121 actid - process activity instance id
122 funmode - execution mode
123 OUT
124 comparison result (WFSTD_YES_NO lookup code)
125 ITEM ATTRIBUTES REFERENCED
126 SerNum - the originating Serial Number
127 InventoryItemID - the product ID
128 *-----------------------------------------------------------------------*/
129 procedure WF_InventoryItemFromSerNum (
130 itemtype in varchar2
131 , itemkey in varchar2
132 , actid in number
133 , funmode in varchar2
134 , resultout in out nocopy varchar2) ;
135
136 /* -----------------------------------------------------------------------
137 Activity Name : WF_ProductID_Exists (branch node)
138
139 To Check if the Customer Product ID Exists.
140 IN
141 itemtype - item type
142 itemkey - item key
143 actid - process activity instance id
144 funmode - execution mode
145 OUT
146 comparison result (WFSTD_YES_NO lookup code)
147 ITEM ATTRIBUTES REFERENCED
148 CustomerProductID - the product ID
149 *-----------------------------------------------------------------------*/
150 procedure WF_ProductID_Exists (
151 itemtype in varchar2
152 , itemkey in varchar2
153 , actid in number
154 , funmode in varchar2
155 , resultout in out nocopy varchar2) ;
156
157 /* -----------------------------------------------------------------------
158 Activity Name : WF_InventoryItemID_Exists (branch node)
159
160 To Check if the InventoryItem ID Exists.
161 IN
162 itemtype - item type
163 itemkey - item key
164 actid - process activity instance id
165 funmode - execution mode
166 OUT
167 comparison result (WFSTD_YES_NO lookup code)
168 ITEM ATTRIBUTES REFERENCED
169 InventoryItemID - the product ID
170 *-----------------------------------------------------------------------*/
171 procedure WF_InventoryItemID_Exists (
172 itemtype in varchar2
173 , itemkey in varchar2
174 , actid in number
175 , funmode in varchar2
176 , resultout in out nocopy varchar2) ;
177
178 END CCT_PRODUCTINIT_PUB;