1 PACKAGE OE_Flex_Cogs_Pub AS
2 /* $Header: OEXWCGSS.pls 120.0 2005/06/01 01:32:31 appldev noship $ */
3 --
4 -- Package
5 -- OE_Flex_Cogs_Pub
6 -- Purpose
7 --
8
9 --
10 -- PUBLIC FUNCTIONS
11 --
12
13 -- Name
14 -- START_PROCESS
15 -- Purpose
16 -- Runs the Workflow process to create the COGS Account
17 -- Arguments
18 -- Line ID
19
20 FUNCTION START_PROCESS( p_api_version_number IN NUMBER,
21 p_line_id IN NUMBER,
22 x_return_ccid OUT NOCOPY NUMBER,
23
24 x_concat_segs OUT NOCOPY VARCHAR2,
25
26 x_concat_ids OUT NOCOPY VARCHAR2,
27
28 x_concat_descrs OUT NOCOPY VARCHAR2,
29
30 x_msg_count OUT NOCOPY NUMBER,
31
32 x_msg_data OUT NOCOPY VARCHAR2)
33
34 RETURN VARCHAR2;
35
36 -- Name
37 -- GET_COST_SALE_ITEM_DERIVED
38 -- Purpose
39 -- Derives the COGS account for a line regardless of the option flag
40 -- Arguments
41 -- Internal Name for the WF Item Type
42 -- WF Item Key
43 -- ID Number of thw WF activity
44 -- Result
45
46 PROCEDURE GET_COST_SALE_ITEM_DERIVED(itemtype IN VARCHAR2,
47 itemkey IN VARCHAR2,
48 actid IN NUMBER,
49 funcmode IN VARCHAR2,
50 result OUT NOCOPY VARCHAR2);
51
52
53 -- Name
54 -- GET_MODEL_DERIVED
55 -- Purpose
56 -- Derives the COGS account for a line based on it's model line if the line is
57 -- an option line
58 -- Arguments
59 -- Internal Name for the WF Item Type
60 -- WF Item Key
61 -- ID Number of thw WF activity
62 -- Result
63
64 PROCEDURE Get_Model_Derived(itemtype IN VARCHAR2,
65 itemkey IN VARCHAR2,
66 actid IN NUMBER,
67 funcmode IN VARCHAR2,
68 result OUT NOCOPY VARCHAR2);
69
70
71 -- Name
72 -- GET_ORDER_TYPE_DERIVED
73 -- Purpose
74 -- Derives CCID from the Order Type
75 -- Arguments
76 -- Internal Name for the WF Item Type
77 -- WF Item Key
78 -- ID Number of thw WF activity
79 -- Result
80
81 PROCEDURE GET_ORDER_TYPE_DERIVED(ITEMTYPE IN VARCHAR2,
82 ITEMKEY IN VARCHAR2,
83 ACTID IN NUMBER,
84 FUNCMODE IN VARCHAR2,
85 RESULT OUT NOCOPY VARCHAR2);
86
87
88 -- Name
89 -- GET_SALESREP_REV_DERIVED
90 -- Purpose
91 -- Derives the CCID from Salesrep's revenue segment
92 -- Arguments
93 -- Internal Name for the WF Item Type
94 -- WF Item Key
95 -- ID Number of thw WF activity
96 -- Result
97
98 PROCEDURE GET_SALESREP_REV_DERIVED(ITEMTYPE IN VARCHAR2,
99 ITEMKEY IN VARCHAR2,
100 ACTID IN NUMBER,
101 FUNCMODE IN VARCHAR2,
102 RESULT OUT NOCOPY VARCHAR2);
103
104
105
106 -- Name
107 -- GET_SALESREP_ID
108 -- Purpose
109 -- Derives the salesrep's ID
110 -- Arguments
111 -- Internal Name for the WF Item Type
112 -- WF Item Key
113 -- ID Number of thw WF activity
114 -- Result
115
116 PROCEDURE GET_SALESREP_ID(ITEMTYPE IN VARCHAR2,
117 ITEMKEY IN VARCHAR2,
118 ACTID IN NUMBER,
119 FUNCMODE IN VARCHAR2,
120 RESULT OUT NOCOPY VARCHAR2);
121
122
123 -- Name
124 -- Get_Invitm_Org_Derived
125 -- Purpose
126 -- Derives COGS account for an invenrory item id and Selling operating unit
127 -- Arguments
128 -- Internal Name for the WF Item Type
129 -- WF Item Key
130 -- ID Number of thw WF activity
131 -- Result
132
133 PROCEDURE Get_Invitm_Org_Derived(ITEMTYPE IN VARCHAR2,
134 ITEMKEY IN VARCHAR2,
135 ACTID IN NUMBER,
136 FUNCMODE IN VARCHAR2,
137 RESULT OUT NOCOPY VARCHAR2);
138
139
140 -- Name
141 -- GET_TRX_TYPE
142 -- Purpose
143 -- Derives the transaction type for a commitment id
144 -- Arguments
145 -- Internal Name for the WF Item Type
146 -- WF Item Key
147 -- ID Number of thw WF activity
148 -- Result
149
150 PROCEDURE GET_TRX_TYPE(ITEMTYPE IN VARCHAR2,
151 ITEMKEY IN VARCHAR2,
152 ACTID IN NUMBER,
153 FUNCMODE IN VARCHAR2,
154 RESULT OUT NOCOPY VARCHAR2);
155
156
157 -- Name
158 -- Check_Option
159 -- Purpose
160 -- Checks if a line is an option line or not
161 -- Arguments
162 -- Internal Name for the WF Item Type
163 -- WF Item Key
164 -- ID Number of thw WF activity
165 -- Result
166
167 PROCEDURE Check_Option(itemtype IN VARCHAR2,
168 itemkey IN VARCHAR2,
169 actid IN NUMBER,
170 funcmode IN VARCHAR2,
171 result OUT NOCOPY VARCHAR2);
172
173
174 -- Name
175 -- UPGRADE_COGS_FLEX
176 -- Purpose
177 -- To upgrade an existing flexbuilder function
178 -- Arguments
179 -- Internal Name for the WF Item Type
180 -- WF Item Key
181 -- ID Number of thw WF activity
182 -- Result
183
184 PROCEDURE UPGRADE_COGS_FLEX(ITEMTYPE IN VARCHAR2,
185 ITEMKEY IN VARCHAR2,
186 ACTID IN NUMBER,
187 FUNCMODE IN VARCHAR2,
188 RESULT OUT NOCOPY VARCHAR2);
189
190 -- Name
191 -- BUILD
192 -- Purpose
193 -- Ts is a stub build function that returns a value FALSE and
194 -- sets the value of the output varriable FB_FLEX_SEGto NULL and
195 -- output error message variable FB_ERROR_MSG to the AOL error
196 -- message FLEXWK-UPGRADE FUNC MISSING. This will ensure that the
197 -- user will get an appropriate error message if they try to use
198 -- the FLEXBUILDER_UPGRADE process without creating the conversion
199 -- package successfully. o upgrade an existing flexbuilder function
200 -- Arguments
201 -- Flexfield Structure Number
202 -- Commitment ID
203 -- Customrer ID
204 -- Header ID
205 -- Option Flag
206 -- Order Category
207 -- Line ID
208 -- Order Type ID
209 -- Organization ID
210 -- Flexfield Segments
211 -- Error Message
212
213 FUNCTION BUILD (
214 fb_flex_num IN NUMBER DEFAULT 101,
215 oe_ii_commitment_id_raw IN VARCHAR2 DEFAULT NULL,
216 oe_ii_customer_id_raw IN VARCHAR2 DEFAULT NULL,
217 oe_ii_header_id_raw IN VARCHAR2 DEFAULT NULL,
218 oe_ii_option_flag_raw IN VARCHAR2 DEFAULT NULL,
219 oe_ii_order_category_raw IN VARCHAR2 DEFAULT NULL,
220 oe_ii_order_line_id_raw IN VARCHAR2 DEFAULT NULL,
221 oe_ii_order_type_id_raw IN VARCHAR2 DEFAULT NULL,
222 oe_ii_organization_id_raw IN VARCHAR2 DEFAULT NULL,
223 fb_flex_seg IN OUT NOCOPY VARCHAR2,
224 fb_error_msg IN OUT NOCOPY VARCHAR2)
225 RETURN BOOLEAN;
226
227 PROCEDURE Get_Type_From_Line
228 ( itemtype IN VARCHAR2,
229 itemkey IN VARCHAR2,
230 actid IN NUMBER,
231 funcmode IN VARCHAR2,
232 result OUT NOCOPY VARCHAR2);
233
234
235 END OE_Flex_Cogs_Pub;
236
237
238