1 PACKAGE CST_MGD_MSTR_BOOK_RPT AUTHID CURRENT_USER AS
2 -- $Header: CSTGMBKS.pls 120.12.12020000.1 2012/06/26 07:04:36 appldev ship $
3 --+=======================================================================+
4 --| Copyright (c) 1999 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| CSTGMBKS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Spec. for Inventory Master Book Report data generation |
13 --| |
14 --| HISTORY |
15 --| 07/16/1999 ksaini Created from CSTRIADS.pls |
16 --| 08/30/1999 ksaini Remove ABC Class Name and Assignment |
17 --| Group name from the temp table |
18 --| 06/22/2003 vjavli Procedure Create_Infl_Adj_Rpt removed |
19 --| since this api is not invoked by any |
20 --| of the inflation reports |
21 --| This has removed inter dependency |
22 --| between master book and inflation reports |
23 --| |
24 --| 06/01/2009 vputchal Italy and China Enhancements from SSI |
25 --| localization team. Package re-designed |
26 --| 09/07/2009 ppandit Changed datatypes for p_legal_entity, |
27 --| p_ledger_id and p_inventory_org in Italy - |
28 --| China Enhancements from SSI. Added function|
29 --| get_date_from and get_date_to, improved |
30 --| get_po_number. Used REF CURSOR for table |
31 --| insertion logic. Added p_dummy, |
32 --| p_all_or_single, get_org_details |
33 --| 09/16/2009 ppandit Added following functions for XML elements |
34 --| get_inv_org, |
35 --| get_subinv_org_from, |
36 --| get_subinv_org_to, |
37 --| get_category_set_from, |
38 --| get_category_set_to, |
39 --| get_category_from, |
40 --| get_category_to, |
41 --| get_item_from, |
42 --| get_item_to, |
43 --| get_abc_class, |
44 --| get_break_by_desc, |
45 --| get_all_or_one, |
46 --| get_icx_date, |
47 --| get_page_penultimate, |
48 --| get_suborg_details |
49 --| 09/29/2009 ppandit Added get_begin_columns, get_end_columns |
50 --| 10/05/2009 ppandit Added get_summ_beg_cols, get_summ_end_cols |
51 --+=======================================================================+
52
53 /* These are the parameters given in the concurrent program definition */
54
55 P_DETAIL VARCHAR2(10);
56 P_DATE_FROM VARCHAR2(25);
57 P_DATE_TO VARCHAR2(25);
58 P_BREAK_BY VARCHAR2(100);
59 P_FISCAL_YEAR VARCHAR2(100);
60 P_PAGE_NUMBER VARCHAR2(100);
61 P_ITEM_CODE_FROM VARCHAR2(2400);
62 P_ITEM_CODE_TO VARCHAR2(2400);
63 P_LEGAL_ENTITY NUMBER; -- Changed by ppandit for Italy and China JF Project
64 P_LEDGER_ID NUMBER; -- Changed by ppandit for Italy and China JF Project
65 P_INVENTORY_ORG NUMBER; -- Changed by ppandit for Italy and China JF Project
66 P_DUMMY VARCHAR2 (30); -- Added by ppandit for Italy and China JF Project
67 P_ALL_OR_SINGLE VARCHAR2 (30); -- Added by ppandit for Italy and China JF Project
68 P_CATEGORY_SET_ID_FROM NUMBER; -- Added by ppandit for Italy and China JF Project
69 P_CATEGORY_SET_ID_TO NUMBER; -- Added by ppandit for Italy and China JF Project
70 P_CATEGORY_STRUCTURE VARCHAR2(240);
71 P_CATEGORY_FROM VARCHAR2(240);
72 P_CATEGORY_TO VARCHAR2(240);
73 P_SUBINV_FROM VARCHAR2(100);
74 P_ABC_CLASS_ID NUMBER;
75 P_INCLUDE_ITEM_COST VARCHAR2(1);
76 P_ABC_GROUP_ID NUMBER;
77 P_SUBINV_TO VARCHAR2(100);
78 P_ORG_ID NUMBER;
79 P_DATE_FROM_FORMATTING VARCHAR2(25);
80 P_DATE_TO_FORMATTING VARCHAR2(25);
81
82 /* Global Variables */
83 GN_PRECISION_VAL NUMBER;
84 GN_ROW_COUNT NUMBER := -1;
85 GC_REQUEST_TIME VARCHAR2(30);
86 GC_RESPONSIBILITY VARCHAR2(100);
87 GC_APPLICATION VARCHAR2(240);
88 GC_REQUESTED_BY VARCHAR2(100);
89 GC_INCLUDE_COST VARCHAR2(80);
90 GC_DETAIL VARCHAR2(80);
91 GC_BREAK VARCHAR2(100);
92 GC_ABC_GROUP_NAME VARCHAR2(40);
93 GC_ABC_CLASS_NAME VARCHAR2(40);
94 GC_CATEGORY_SET_NAME_1 VARCHAR2(30);
95 GC_CATEGORY_SET_NAME_2 VARCHAR2(30);
96 GC_CURRENCY_CODE VARCHAR2(3);
97 GD_RPT_DATE_FROM DATE;
98 GD_RPT_DATE_TO DATE;
99
100 --===================
101 -- PUBLIC PROCEDURES
102 --===================
103
104 -- +==========================================================================+
105 -- PROCEDURE: create_inv_msbk_rpt
106 -- PARAMETERS:
107 -- p_org_id IN NUMBER
108 -- p_category_set_id_from IN NUMBER
109 -- p_category_set_id_to IN NUMBER
110 -- p_category_from IN VARCHAR2
111 -- p_category_to IN VARCHAR2
112 -- p_subinv_from IN VARCHAR2
113 -- p_subinv_to IN VARCHAR2
114 -- p_abc_group_id IN NUMBER
115 -- p_abc_class_id IN NUMBER
116 -- p_item_from_code IN VARCHAR2
117 -- p_item_to_code IN VARCHAR2
118 -- p_rpt_from_date IN VARCHAR2
119 -- p_rpt_to_date IN VARCHAR2
120 -- COMMENT:
121 -- This procedure is called by Inventory Master Book Report
122 -- PRE-COND: none
123 -- EXCEPTIONS: none
124 -- +==========================================================================+
125 PROCEDURE create_inv_msbk_rpt (
126 p_org_id IN NUMBER
127 ,p_category_set_id_from IN NUMBER
128 ,p_category_set_id_to IN NUMBER
129 ,p_category_from IN VARCHAR2
130 ,p_category_to IN VARCHAR2
131 ,p_subinv_from IN VARCHAR2
132 ,p_subinv_to IN VARCHAR2
133 ,p_abc_group_id IN NUMBER
134 ,p_abc_class_id IN NUMBER
135 ,p_item_from_code IN VARCHAR2
136 ,p_item_to_code IN VARCHAR2
137 ,p_rpt_from_date IN VARCHAR2
138 ,p_rpt_to_date IN VARCHAR2
139 );
140
141 /* Added for Italy Joint Project */
142 -- +==========================================================================+
143 -- FUNCTION: get_org_details
144 -- PARAMETERS:
145 -- p_org_id IN NUMBER
146 -- p_number IN NUMBER
147 -- COMMENT:
148 -- This function is called in the XML of Inventory Master Book Report
149 -- for getting the Org details
150 -- Return: VARCHAR2
151 -- PRE-COND: none
152 -- EXCEPTIONS: none
153 -- +==========================================================================+
154 FUNCTION get_org_details (p_org_id IN NUMBER, p_number IN NUMBER)
155 RETURN VARCHAR2;
156
157 -- +==========================================================================+
158 -- FUNCTION: get_suborg_details
159 -- PARAMETERS:
160 -- p_subinvname IN VARCHAR2
161 -- p_org_id IN NUMBER
162 -- p_number IN NUMBER
163 -- COMMENT:
164 -- This function is called in the XML of Inventory Master Book Report
165 -- for getting the Sub Org details
166 -- Return: VARCHAR2
167 -- PRE-COND: none
168 -- EXCEPTIONS: none
169 -- +==========================================================================+
170 FUNCTION get_suborg_details (
171 p_subinvname IN VARCHAR2
172 ,p_org_id IN NUMBER
173 ,p_number IN NUMBER
174 )
175 RETURN VARCHAR2;
176
177 -- +==========================================================================+
178 -- FUNCTION: get_begin_columns
179 -- PARAMETERS:
180 -- p_inventory_item_id IN NUMBER
181 -- p_type IN NUMBER
182 -- COMMENT:
183 -- This function is called in the XML of Inventory Master Book Report
184 -- for getting the Begin Cost, Quantity and Value when Break By is Item
185 -- and report is running for ALL Inventory Organizations
186 --
187 -- Return: NUMBER
188 -- PRE-COND: none
189 -- EXCEPTIONS: none
190 -- +==========================================================================+
191 FUNCTION get_begin_columns (
192 p_inventory_item_id IN NUMBER
193 ,p_type IN NUMBER
194 )
195 RETURN NUMBER;
196
197 -- +==========================================================================+
198 -- FUNCTION: get_end_columns
199 -- PARAMETERS:
200 -- p_inventory_item_id IN NUMBER
201 -- p_type IN NUMBER
202 -- COMMENT:
203 -- This function is called in the XML of Inventory Master Book Report
204 -- for getting the End Cost, Quantity and Value when Break By is Item
205 -- and report is running for ALL Inventory Organizations
206 --
207 -- Return: NUMBER
208 -- PRE-COND: none
209 -- EXCEPTIONS: none
210 -- +==========================================================================+
211 FUNCTION get_end_columns (
212 p_inventory_item_id IN NUMBER
213 ,p_type IN NUMBER
214 )
215 RETURN NUMBER;
216
217 -- +==========================================================================+
218 -- FUNCTION: get_summ_beg_cols
219 -- PARAMETERS:
220 -- p_inventory_item_id IN NUMBER
221 -- p_organization_id IN NUMBER
222 -- p_sub_inv_org_name IN VARCHAR2
223 -- p_sub_inv_org_id IN NUMBER
224 -- p_type IN NUMBER
225 -- COMMENT:
226 -- This function is called in the XML of Inventory Master Book Report
227 -- for getting the Begin Cost, Quantity and Value when report is running for
228 -- detail as Summary
229 --
230 -- Return: NUMBER
231 -- PRE-COND: none
232 -- EXCEPTIONS: none
233 -- +==========================================================================+
234 FUNCTION get_summ_beg_cols (
235 p_inventory_item_id IN NUMBER
236 ,p_organization_id IN NUMBER
237 ,p_sub_inv_org_name IN VARCHAR2
238 ,p_sub_inv_org_id IN NUMBER
239 ,p_type IN NUMBER
240 )
241 RETURN NUMBER;
242
243 -- +==========================================================================+
244 -- FUNCTION: get_summ_end_cols
245 -- PARAMETERS:
246 -- p_inventory_item_id IN NUMBER
247 -- p_organization_id IN NUMBER
248 -- p_sub_inv_org_name IN VARCHAR2
249 -- p_sub_inv_org_id IN NUMBER
250 -- p_type IN NUMBER
254 -- for getting the End Cost, Quantity and Value when report is running for
251 --
252 -- COMMENT:
253 -- This function is called in the XML of Inventory Master Book Report
255 -- detail as Summary
256 --
257 -- Return: NUMBER
258 -- PRE-COND: none
259 -- EXCEPTIONS: none
260 -- +==========================================================================+
261 FUNCTION get_summ_end_cols (
262 p_inventory_item_id IN NUMBER
263 ,p_organization_id IN NUMBER
264 ,p_sub_inv_org_name IN VARCHAR2
265 ,p_sub_inv_org_id IN NUMBER
266 ,p_type IN NUMBER
267 )
268 RETURN NUMBER;
269
270 -- +==========================================================================+
271 -- FUNCTION: get_break_by
272 -- PARAMETERS: NONE
273 -- COMMENT:
274 -- This function is called in the XML of Inventory Master Book Report
275 -- for getting the break by details
276 -- Return: NUMBER
277 -- PRE-COND: none
278 -- EXCEPTIONS: none
279 -- +==========================================================================+
280 FUNCTION get_break_by
281 RETURN NUMBER;
282
283 --========================================================================
284 -- FUNCTION : get_detail_param Public
285 -- PARAMETERS: None
286 -- RETURN : VARCHAR2
287 -- COMMENT : This function is called by Inventory Master Book Report to gets p_detail
288 -- EXCEPTIONS: no_data_found
289 --========================================================================
290 FUNCTION get_detail_param
291 RETURN VARCHAR2;
292
293 --========================================================================
294 -- FUNCTION : get_include_item_cost Public
295 -- PARAMETERS: None
296 -- RETURN : VARCHAR2
297 -- COMMENT : This Function is called by Inventory Master Book Report to gets the break by p_include_item_cost
298 -- EXCEPTIONS: no_data_found
299 --========================================================================
300 FUNCTION get_include_item_cost
301 RETURN VARCHAR2;
302
303 -- +========================================================================+
304 -- FUNCTION: beforereport
305 -- PARAMETERS: NONE
306 -- RETURN: BOOLEAN
307 -- COMMENT:
308 -- This function is called by XML of Inventory Master Book Report
309 -- PRE-COND: none
310 -- EXCEPTIONS: none
311 -- +==========================================================================+
312 FUNCTION beforereport
313 RETURN BOOLEAN;
314
315 -- +==========================================================================+
316 -- FUNCTION: get_abc_group_name
317 -- PARAMETERS: None
318 -- Return : VARCHAR2
319 -- COMMENT:
320 -- This function is called by Inventory Master Book Report for getting the ABC Group Name
321 -- for a given ABC Group
322 -- PRE-COND: none
323 -- EXCEPTIONS: none
324 -- +==========================================================================+
325 FUNCTION get_abc_group_name
326 RETURN VARCHAR2;
327
328 -- +==========================================================================+
329 -- FUNCTION: get_shipment_num
330 -- PARAMETERS:
331 -- p_transaction_id IN NUMBER
332 -- COMMENT:
333 -- This procedure is called by Inventory Master Book Report
334 -- RETURN: VARCHAR2
335 -- PRE-COND: none
336 -- EXCEPTIONS: none
337 -- +==========================================================================+
338 FUNCTION get_shipment_num (p_transaction_id NUMBER)
339 RETURN VARCHAR2;
340
341 -- +==========================================================================+
342 -- FUNCTION: get_waybill
343 -- PARAMETERS:
344 -- p_transaction_id IN NUMBER
345 -- COMMENT:
346 -- This procedure is called by the Inventory Master Book Report
347 -- RETURN: VARCHAR2
348 -- PRE-COND: none
349 -- EXCEPTIONS: none
350 -- +==========================================================================+
351 FUNCTION get_waybill (p_transaction_id NUMBER)
352 RETURN VARCHAR2;
353
354 -- +==========================================================================+
355 -- FUNCTION: get_po_number
356 -- PARAMETERS:
357 -- p_transaction_id IN NUMBER
358 -- p_type IN VARCHAR2
359 -- COMMENT:
360 -- This procedure is called by Inventory Master Book Report
361 -- RETURN: VARCHAR2
362 -- PRE-COND: none
363 -- EXCEPTIONS: none
364 -- +==========================================================================+
365 FUNCTION get_po_number (p_transaction_id IN NUMBER, p_type IN VARCHAR2) -- Added p_type by ppandit for Italy - China Enhancements
366 RETURN VARCHAR2;
367
368 -- +==========================================================================+
369 -- FUNCTION: get_detail_level
370 -- PARAMETERS: None
371 -- COMMENT:
372 -- This procedure is called by the Inventory Master Book Report to get the detail level
373 -- like Summary, Detail, Intermidiate
374 -- RETURN: VARCHAR2
375 -- PRE-COND: none
376 -- EXCEPTIONS: none
377 -- +==========================================================================+
378 FUNCTION get_detail_level
379 RETURN VARCHAR2;
380
381 -- +==========================================================================+
382 -- FUNCTION: get_date_from
383 -- PARAMETERS: None
384 -- COMMENT:
385 -- This procedure is called by the Inventory Master Book Report to get the Lower of Date Range
386 -- Added by ppandit for Italy and China JF Project
387 -- RETURN: VARCHAR2
388 -- +==========================================================================+
389 FUNCTION get_date_from
390 RETURN VARCHAR2;
391
392 -- +==========================================================================+
396 -- This procedure is called by the Inventory Master Book Report to get the Higher of Date Range
393 -- FUNCTION: get_date_to
394 -- PARAMETERS: None
395 -- COMMENT:
397 --
398 -- RETURN: VARCHAR2
399 -- +==========================================================================+
400 FUNCTION get_date_to
401 RETURN VARCHAR2;
402
403 -- +==========================================================================+
404 -- FUNCTION: get_trx_action
405 -- PARAMETERS: p_transaction_id
406 -- COMMENT:
407 -- This procedure is called by the Inventory Master Book Report to get the Higher of Date Range
408 -- Added by ppandit for Italy and China JF Project
409 -- RETURN: VARCHAR2
410 -- +==========================================================================+
411 FUNCTION get_trx_action (p_transaction_id IN NUMBER)
412 RETURN VARCHAR2;
413
414 -- +==========================================================================+
415 -- FUNCTION: get_include_cost
416 -- PARAMETERS: None
417 -- COMMENT:
418 -- This procedure is called by the Inventory Master Book Report which returns 'Y/N'
419 -- RETURN: VARCHAR2
420 -- PRE-COND: none
421 -- EXCEPTIONS: none
422 -- +==========================================================================+
423 FUNCTION get_include_cost
424 RETURN VARCHAR2;
425
426 -- +==========================================================================+
427 -- FUNCTION: getledger_name
428 -- PARAMETERS: None
429 -- COMMENT:
430 -- This procedure is called by Inventory Master Book Report to get the name of the Ledger
431 -- RETURN: VARCHAR2
432 -- PRE-COND: none
433 -- EXCEPTIONS: none
434 -- +==========================================================================+
435 FUNCTION getledger_name RETURN VARCHAR2;
436
437 -- +==========================================================================+
438 -- FUNCTION: get_inv_org
439 -- PARAMETERS: None
440 -- COMMENT:
441 -- This procedure is called by Inventory Master Book Report to get Inventory Org
442 -- RETURN: VARCHAR2
443 -- PRE-COND: none
444 -- EXCEPTIONS: none
445 -- +==========================================================================+
446 FUNCTION get_inv_org RETURN VARCHAR2;
447 -- +==========================================================================+
448 -- FUNCTION: get_subinv_org_from
449 -- PARAMETERS: None
450 -- COMMENT:
451 -- This procedure is called by Inventory Master Book Report Subinventory From
452 -- RETURN: VARCHAR2
453 -- PRE-COND: none
454 -- EXCEPTIONS: none
455 -- +==========================================================================+
456 FUNCTION get_subinv_org_from RETURN VARCHAR2;
457 -- +==========================================================================+
458 -- FUNCTION: get_subinv_org_to
459 -- PARAMETERS: None
460 -- COMMENT:
461 -- This procedure is called by Inventory Master Book Report Subinventory To
462 -- Return: VARCHAR2
463 -- PRE-COND: none
464 -- EXCEPTIONS: none
465 -- +==========================================================================+
466 FUNCTION get_subinv_org_to RETURN VARCHAR2;
467 -- +==========================================================================+
468 -- FUNCTION: get_category_set_from
469 -- PARAMETERS: None
470 -- COMMENT:
471 -- This procedure is called by Inventory Master Book Report Category Set From
472 -- Return: VARCHAR2
473 -- PRE-COND: none
474 -- EXCEPTIONS: none
475 -- +==========================================================================+
476 FUNCTION get_category_set_from RETURN VARCHAR2;
477 -- +==========================================================================+
478 -- FUNCTION: get_category_set_to
479 -- PARAMETERS: None
480 -- COMMENT:
481 -- This procedure is called by Inventory Master Book Report to get Category Set To
482 -- Return: VARCHAR2
483 -- PRE-COND: none
484 -- EXCEPTIONS: none
485 -- +==========================================================================+
486 FUNCTION get_category_set_to RETURN VARCHAR2;
487 -- +==========================================================================+
488 -- FUNCTION: get_category_from
489 -- PARAMETERS: None
490 -- COMMENT:
491 -- This procedure is called by Inventory Master Book Report to get Category From
492 -- Return: VARCHAR2
493 -- PRE-COND: none
494 -- EXCEPTIONS: none
495 -- +==========================================================================+
496 FUNCTION get_category_from RETURN VARCHAR2;
497 -- +==========================================================================+
498 -- FUNCTION: get_category_to
499 -- PARAMETERS: None
500 -- COMMENT:
501 -- This procedure is called by Inventory Master Book Report to get to get Category To
502 -- Return: VARCHAR2
503 -- PRE-COND: none
504 -- EXCEPTIONS: none
505 -- +==========================================================================+
506 FUNCTION get_category_to RETURN VARCHAR2;
507 -- +==========================================================================+
508 -- FUNCTION: get_item_from
509 -- PARAMETERS: None
510 -- COMMENT:
511 -- This procedure is called by Inventory Master Book Report to get Item Code From
512 -- Return: VARCHAR2
513 -- PRE-COND: none
514 -- EXCEPTIONS: none
515 -- +==========================================================================+
516 FUNCTION get_item_from RETURN VARCHAR2;
517 -- +==========================================================================+
518 -- FUNCTION: get_item_to
519 -- PARAMETERS: None
520 -- COMMENT:
521 -- This procedure is called by Inventory Master Book Report to get Item Code To
522 -- Return: VARCHAR2
523 -- PRE-COND: none
524 -- EXCEPTIONS: none
525 -- +==========================================================================+
526 FUNCTION get_item_to RETURN VARCHAR2;
530 -- COMMENT:
527 -- +==========================================================================+
528 -- FUNCTION: get_abc_class
529 -- PARAMETERS: None
531 -- This procedure is called by Inventory Master Book Report to get ABC Class
532 -- Return: VARCHAR2
533 -- PRE-COND: none
534 -- EXCEPTIONS: none
535 -- +==========================================================================+
536 FUNCTION get_abc_class RETURN VARCHAR2;
537 -- +==========================================================================+
538 -- FUNCTION: get_break_by_desc
539 -- PARAMETERS: None
540 -- COMMENT:
541 -- This procedure is called by Inventory Master Book Report to get Break By meaning
542 -- Return: VARCHAR2
543 -- PRE-COND: none
544 -- EXCEPTIONS: none
545 -- +==========================================================================+
546 FUNCTION get_break_by_desc RETURN VARCHAR2;
547 -- +==========================================================================+
548 -- FUNCTION: get_all_or_one
549 -- PARAMETERS: None
550 -- COMMENT:
551 -- This procedure is called by Inventory Master Book Report to get value of
552 -- All or One parameter
553 --
554 -- Return: VARCHAR2
555 -- PRE-COND: none
556 -- EXCEPTIONS: none
557 -- +==========================================================================+
558 FUNCTION get_all_or_one RETURN VARCHAR2;
559
560 -- +==========================================================================+
561 -- FUNCTION: get_icx_date
562 -- PARAMETERS: None
563 -- COMMENT:
564 -- This procedure is called by Inventory Master Book Report to get value of
565 -- Sysdate as per ICX Date Format
566 --
567 -- Return: VARCHAR2
568 -- PRE-COND: none
569 -- EXCEPTIONS: none
570 -- +==========================================================================+
571 FUNCTION get_icx_date RETURN VARCHAR2;
572
573 -- +==========================================================================+
574 -- FUNCTION: get_page_penultimate
575 -- PARAMETERS: None
576 -- COMMENT:
577 -- This procedure is called by Inventory Master Book Report to get value of
578 -- Page Numbering minus one
579 --
580 -- Return: NUMBER
581 -- PRE-COND: none
582 -- EXCEPTIONS: none
583 -- +==========================================================================+
584 FUNCTION get_page_penultimate RETURN NUMBER;
585
586 -- +==========================================================================+
587 -- FUNCTION: get_row_count
588 -- PARAMETERS: None
589 -- COMMENT:
590 -- This procedure is called by Inventory Master Book Report to get record count
591 --
592 -- Return: NUMBER
593 -- PRE-COND: none
594 -- EXCEPTIONS: none
595 -- +==========================================================================+
596 FUNCTION get_row_count RETURN NUMBER;
597
598 -- +==========================================================================+
599 -- FUNCTION: get_category_structure
600 -- PARAMETERS: None
601 -- COMMENT:
602 -- This procedure is called by Inventory Master Book Report to get value of
603 -- Item or Category Flexfields segments
604 --
605 -- Return: VARCHAR2
606 -- PRE-COND: none
607 -- EXCEPTIONS: none
608 -- +==========================================================================+
609 FUNCTION get_category_structure (
610 p_type IN VARCHAR2
611 ,p_cat_struct_id IN NUMBER
612 )
613 RETURN VARCHAR2;
614
615 -- +==========================================================================+
616 -- FUNCTION: get_structure_id
617 -- PARAMETERS: None
618 -- COMMENT:
619 -- This procedure is called by Inventory Master Book Report to get value of
620 -- Category Structure ID
621 --
622 -- Return: VARCHAR2
623 -- PRE-COND: none
624 -- EXCEPTIONS: none
625 -- +==========================================================================+
626 FUNCTION get_structure_id (p_category_set_id IN NUMBER) RETURN NUMBER;
627
628 END CST_MGD_MSTR_BOOK_RPT;