1 PACKAGE INV_MGD_POSITIONS_CP AS
2 -- $Header: INVCPOSS.pls 120.1 2005/06/21 06:25:23 appldev ship $
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVCPOSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Concurrent programs implementation for Inventory Position View |
13 --| and Export |
14 --| |
15 --| HISTORY |
16 --| 09/01/2000 Paolo Juvara Created |
17 --+=======================================================================+
18
19 --===================
20 -- TYPES
21 --===================
22 -- add your type declarations here if any
23
24 --===================
25 -- CONSTANTS
26 --===================
27 -- add your constants here if any
28
29 --===================
30 -- PUBLIC VARIABLES
31 --===================
32 -- add your public global variables here if any
33
34 --===================
35 -- PROCEDURES AND FUNCTIONS
36 --===================
37
38 --========================================================================
39 -- PROCEDURE : Build PUBLIC
40 -- PARAMETERS: x_errbuf error buffer
41 -- x_retcode 0 success, 1 warning, 2 error
42 -- p_data_set_name data set name
43 -- p_hierarchy_id organization hierarchy
44 -- p_hierarchy_level hierarchy level
45 -- p_item_from item range from
46 -- p_item_to item range to
47 -- p_category_id item category
48 -- p_date_from date range from
49 -- p_date_to date range to
50 -- p_bucket_size bucket size
51 -- COMMENT : Inventory Position Build concurrent program
52 --========================================================================
53 PROCEDURE Build
54 ( x_errbuff OUT NOCOPY VARCHAR2
55 , x_retcode OUT NOCOPY NUMBER
56 , p_data_set_name IN VARCHAR2
57 , p_hierarchy_id IN NUMBER
58 , p_hierarchy_level IN VARCHAR2
59 , p_item_from IN VARCHAR2
60 , p_item_to IN VARCHAR2
61 , p_category_id IN NUMBER
62 , p_date_from IN VARCHAR2
63 , p_date_to IN VARCHAR2
64 , p_bucket_size IN VARCHAR2
65 );
66
67
68 --========================================================================
69 -- PROCEDURE : Purge PUBLIC
70 -- PARAMETERS: x_errbuf error buffer
71 -- x_retcode 0 success, 1 warning, 2 error
72 -- p_purge_all Y to purge all, N otherwise
73 -- p_data_set_name purge specific data set name
74 -- p_created_by purge data set for specific user ID
75 -- p_creation_date purge data set created before date
76 -- COMMENT : Inventory Position Purge concurrent program; p_purge_all takes
77 -- priority over other parameters
78 --========================================================================
79 PROCEDURE Purge
80 ( x_errbuff OUT NOCOPY VARCHAR2
81 , x_retcode OUT NOCOPY NUMBER
82 , p_purge_all IN VARCHAR2
83 , p_data_set_name IN VARCHAR2
84 , p_created_by IN VARCHAR2
85 , p_creation_date IN VARCHAR2
86 );
87
88 END INV_MGD_POSITIONS_CP;