1 PACKAGE WSH_FLEX_PKG_COGS AUTHID CURRENT_USER AS
2 /* $Header: WSHWFDFS.pls 115.1 99/07/16 08:24:44 porting shi $ */
3 --
4 -- Package
5 -- WSH_FLEX_PKG_COGS
6 -- Purpose
7 -- Will contain routines to generate the default Cost of Goods Sold Accounting
8 -- flexfield combination(COGS Account)
9 -- History
10 -- 7-AUG-97 ADATTA CREATED
11 --
12
13 --
14 -- PUBLIC VARIABLES
15 --
16
17 --
18 -- PUBLIC FUNCTIONS
19 --
20
21 -- Name
22 -- START_PROCESS
23 -- Purpose
24 -- Runs the Workflow process to create the COGS Account
25 -- Arguments
26 -- Customer ID
27 -- Flexfield Structure Number
28 -- Line Detail ID
29 -- Option Flag
30 -- Order Line Header ID
31 -- Order Line ID
32 -- Picking Line Detail ID
33 -- Order Type ID
34 -- Organization ID
35 -- Code Combination ID
36
37 FUNCTION START_PROCESS(X_COMMITMENT_ID IN NUMBER,
38 X_CUSTOMER_ID IN NUMBER,
39 X_OPTION_FLAG IN VARCHAR2,
40 X_ORDER_CATEGORY IN VARCHAR2,
41 X_LINE_DETAIL_ID IN NUMBER,
42 X_ORDER_LINE_HEADER_ID IN NUMBER,
43 X_ORDER_LINE_ID IN NUMBER,
44 X_PICKING_LINE_DTL_ID IN NUMBER,
45 X_ORDER_TYPE_ID IN NUMBER,
46 X_ORG_ID IN NUMBER,
47 X_FLEX_NUMBER IN NUMBER,
48 X_RETURN_CCID IN OUT NUMBER,
49 X_CONCAT_SEGS IN OUT VARCHAR2,
50 X_CONCAT_IDS IN OUT VARCHAR2,
51 X_CONCAT_DESCRS IN OUT VARCHAR2,
52 X_ERRMSG IN OUT VARCHAR2)
53 RETURN BOOLEAN;
54
55 -- Name
56 -- GET_COST_SALE_ITEM_DERIVED
57 -- Purpose
58 -- Derives the COGS account for a line regardless of the option flag
59 -- Arguments
60 -- Internal Name for the WF Item Type
61 -- WF Item Key
62 -- ID Number of thw WF activity
63 -- Result
64
65 PROCEDURE GET_COST_SALE_ITEM_DERIVED(ITEMTYPE IN VARCHAR2,
66 ITEMKEY IN VARCHAR2,
67 ACTID IN NUMBER,
68 FUNCMODE IN VARCHAR2,
69 RESULT OUT VARCHAR2);
70
71 -- Name
72 -- GET_COST_SALE_MODEL_DERIVED
73 -- Purpose
74 -- Derives the COGS account for a model
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_COST_SALE_MODEL_DERIVED(ITEMTYPE IN VARCHAR2,
82 ITEMKEY IN VARCHAR2,
83 ACTID IN NUMBER,
84 FUNCMODE IN VARCHAR2,
85 RESULT OUT VARCHAR2);
86
87 -- Name
88 -- GET_ORDER_TYPE_DERIVED
89 -- Purpose
90 -- Derives CCID from the Order Type
91 -- Arguments
92 -- Internal Name for the WF Item Type
93 -- WF Item Key
94 -- ID Number of thw WF activity
95 -- Result
96
97 PROCEDURE GET_ORDER_TYPE_DERIVED(ITEMTYPE IN VARCHAR2,
98 ITEMKEY IN VARCHAR2,
99 ACTID IN NUMBER,
100 FUNCMODE IN VARCHAR2,
101 RESULT OUT VARCHAR2);
102
103 -- Name
104 -- GET_SALESREP_REV_DERIVED
105 -- Purpose
106 -- Derives the CCID from Salesrep's revenue segment
107 -- Arguments
108 -- Internal Name for the WF Item Type
109 -- WF Item Key
110 -- ID Number of thw WF activity
111 -- Result
112
113 PROCEDURE GET_SALESREP_REV_DERIVED(ITEMTYPE IN VARCHAR2,
114 ITEMKEY IN VARCHAR2,
115 ACTID IN NUMBER,
116 FUNCMODE IN VARCHAR2,
117 RESULT OUT VARCHAR2);
118
119
120 -- Name
121 -- GET_SALESREP_ID
122 -- Purpose
123 -- Derives the salesrep's ID
124 -- Arguments
125 -- Internal Name for the WF Item Type
126 -- WF Item Key
127 -- ID Number of thw WF activity
128 -- Result
129
130 PROCEDURE GET_SALESREP_ID(ITEMTYPE IN VARCHAR2,
131 ITEMKEY IN VARCHAR2,
132 ACTID IN NUMBER,
133 FUNCMODE IN VARCHAR2,
134 RESULT OUT VARCHAR2);
135
136 -- Name
137 -- GET_COST_SALE
138 -- Purpose
139 -- Derives COGS account for an invenrory item id and organization id
140 -- Arguments
141 -- Internal Name for the WF Item Type
142 -- WF Item Key
143 -- ID Number of thw WF activity
144 -- Result
145
146 PROCEDURE GET_COST_SALE(ITEMTYPE IN VARCHAR2,
147 ITEMKEY IN VARCHAR2,
148 ACTID IN NUMBER,
149 FUNCMODE IN VARCHAR2,
150 RESULT OUT VARCHAR2);
151
152 -- Name
153 -- GET_INV_ITEM_ID
154 -- Purpose
155 -- Derives inventory item id from order line id
156 -- Arguments
157 -- Internal Name for the WF Item Type
158 -- WF Item Key
159 -- ID Number of thw WF activity
160 -- Result
161
162 PROCEDURE GET_INV_ITEM_ID(ITEMTYPE IN VARCHAR2,
163 ITEMKEY IN VARCHAR2,
164 ACTID IN NUMBER,
165 FUNCMODE IN VARCHAR2,
166 RESULT OUT VARCHAR2);
167
168 -- Name
169 -- GET_TRX_TYPE
170 -- Purpose
171 -- Derives the transaction type for a commitment id
172 -- Arguments
173 -- Internal Name for the WF Item Type
174 -- WF Item Key
175 -- ID Number of thw WF activity
176 -- Result
177
178 PROCEDURE GET_TRX_TYPE(ITEMTYPE IN VARCHAR2,
179 ITEMKEY IN VARCHAR2,
180 ACTID IN NUMBER,
181 FUNCMODE IN VARCHAR2,
182 RESULT OUT VARCHAR2);
183
184 -- Name
185 -- GET_OPERATING_UNIT
186 -- Purpose
187 -- Derives the selling opoerating unit
188 -- Arguments
189 -- Internal Name for the WF Item Type
190 -- WF Item Key
191 -- ID Number of thw WF activity
192 -- Result
193
194 PROCEDURE GET_OPERATING_UNIT(ITEMTYPE IN VARCHAR2,
195 ITEMKEY IN VARCHAR2,
196 ACTID IN NUMBER,
197 FUNCMODE IN VARCHAR2,
198 RESULT OUT VARCHAR2);
199
200 -- Name
201 -- GET_PARENT_LINE
202 -- Purpose
203 -- Derives a parent line id for a order line id
204 -- Arguments
205 -- Internal Name for the WF Item Type
206 -- WF Item Key
207 -- ID Number of thw WF activity
208 -- Result
209
210 PROCEDURE GET_PARENT_LINE(ITEMTYPE IN VARCHAR2,
211 ITEMKEY IN VARCHAR2,
212 ACTID IN NUMBER,
213 FUNCMODE IN VARCHAR2,
214 RESULT OUT VARCHAR2);
215 END WSH_FLEX_PKG_COGS;