1 PACKAGE CST_MGD_MSTR_BOOK_RPT AUTHID CURRENT_USER AS
2 -- $Header: CSTGMBKS.pls 115.4 2003/06/23 04:48:29 vjavli 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 |
23 --| reports |
24 --+=======================================================================+
25
26 --===================
27 -- PUBLIC PROCEDURES
28 --===================
29
30 PROCEDURE Create_Inv_Msbk_Rpt
31 ( p_org_id IN NUMBER
32 , p_category_set_id IN NUMBER := NULL
33 , p_category_from IN VARCHAR2 := NULL
34 , p_category_to IN VARCHAR2 := NULL
35 , p_subinv_from IN VARCHAR2 := NULL
36 , p_subinv_to IN VARCHAR2 := NULL
37 , p_abc_group_id IN NUMBER := NULL
38 , p_abc_class_id IN NUMBER := NULL
39 , p_item_from_code IN VARCHAR2 := NULL
40 , p_item_to_code IN VARCHAR2 := NULL
41 , p_rpt_from_date IN VARCHAR2
42 , p_rpt_to_date IN VARCHAR2
43 );
44
45
46 END CST_MGD_MSTR_BOOK_RPT;