1 PACKAGE INV_MGD_POS_BUCKET_MDTR AS
2 /* $Header: INVMPBKS.pls 120.0 2005/05/25 04:48:21 appldev noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVMPBKS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Inventory Position View and Export: Time Bucket Mediator |
13 --| HISTORY |
14 --| 09/05/2000 Paolo Juvara Created |
15 --+======================================================================*/
16
17
18 --===================
19 -- PROCEDURES AND FUNCTIONS
20 --===================
21
22 --========================================================================
23 -- PROCEDURE : Build_Bucket_List PUBLIC
24 -- PARAMETERS: p_organization_id organization holding the calendar
25 -- p_date_from date range from
26 -- p_date_to date range to
27 -- p_bucket_size PERIOD, WEEK, DAY or HOUR
28 -- x_bucket_tbl list of buckets
29 -- COMMENT : Builds the list of buckets in the given date range
30 -- PRE-COND : p_date_to > p_date_from
31 -- POST-COND : x_bucket_tbl is not empty
32 --========================================================================
33 PROCEDURE Build_Bucket_List
34 ( p_organization_id IN NUMBER
35 , p_date_from IN DATE
36 , p_date_to IN DATE
37 , p_bucket_size IN VARCHAR2
38 , x_bucket_tbl IN OUT NOCOPY INV_MGD_POS_UTIL.bucket_tbl_type
39 );
40
41
42 END INV_MGD_POS_BUCKET_MDTR;