1 PACKAGE INV_MGD_POSITIONS_PROC AS
2 -- $Header: INVSPOSS.pls 120.1 2005/06/22 05:48:00 appldev ship $
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| FILENAME |
10 --| INVSPOSS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Inventory Position View and Export Processor |
14 --| |
15 --| HISTORY |
16 --| 09/11/2000 Paolo Juvara Created |
17 --+=======================================================================+
18
19
20 --===================
21 -- PROCEDURES AND FUNCTIONS
22 --===================
23
24 --========================================================================
25 -- PROCEDURE : Build PUBLIC
26 -- PARAMETERS: p_init_msg_list standard API parameter
27 -- x_return_status standard API parameter
28 -- x_msg_count standard API parameter
29 -- x_msg_data standard API parameter
30 -- p_data_set_name data set name
31 -- p_hierarchy_id organization hierarchy
32 -- p_hierarchy_level hierarchy level
33 -- p_item_from item range from (in canonical frmt)
34 -- p_item_to item range to (in canonical frmt)
35 -- p_category_id item category
36 -- p_date_from date range from
37 -- p_date_to date range to
38 -- p_bucket_size bucket size
39 -- COMMENT : Inventory Position Build processor
40 -- PRE-COND : all organization in hierarchy share same item master
41 --========================================================================
42 PROCEDURE Build
43 ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
44 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
46 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , p_data_set_name IN VARCHAR2
48 , p_hierarchy_id IN NUMBER
49 , p_hierarchy_level IN VARCHAR2
50 , p_item_from IN VARCHAR2
51 , p_item_to IN VARCHAR2
52 , p_category_id IN NUMBER
53 , p_date_from IN VARCHAR2
54 , p_date_to IN VARCHAR2
55 , p_bucket_size IN VARCHAR2
56 );
57
58
59 --========================================================================
60 -- PROCEDURE : Purge PUBLIC
61 -- PARAMETERS: p_init_msg_list standard API parameter
62 -- x_return_status standard API parameter
63 -- x_msg_count standard API parameter
64 -- x_msg_data standard API parameter
65 -- p_purge_all Y to purge all, N otherwise
66 -- p_created_by purge data set for specific user ID
67 -- p_creation_date purge data set created before date
68 -- (in canonical format)
69 -- p_data_set_name purge specific data set name
70 -- COMMENT : Inventory Position Purge; p_purge_all takes
71 -- priority over other parameters
72 --========================================================================
73 PROCEDURE Purge
74 ( p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
75 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
77 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 , p_purge_all IN VARCHAR2
79 , p_data_set_name IN VARCHAR2
80 , p_created_by IN VARCHAR2
81 , p_creation_date IN VARCHAR2
82 );
83
84 END INV_MGD_POSITIONS_PROC;