1 PACKAGE INV_CONSUMPTION_ADVICE_PROC AUTHID CURRENT_USER AS
2 /* $Header: INVRCADS.pls 115.1 2003/01/28 03:01:11 dherring noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVRCADS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Create Consumption Advice |
13 --| HISTORY |
14 --| 12/11/2002 David Herring created |
15 --+========================================================================
16
17 --===================
18 -- CONSTANTS
19 --===================
20
21 G_LOG_PROCEDURE CONSTANT NUMBER := 2;
22
23 --===================
24 -- PROCEDURES AND FUNCTIONS
25 --===================
26
27 --========================================================================
28 -- PROCEDURE : Consumption_Txn_Manager PUBLIC
29 -- PARAMETERS: p_batch_size IN Size of a batch
30 -- p_max_workers IN Number of workers allowed
31 -- p_vendor_id IN Records for supplier
32 -- p_vendor_site_id IN Records for supplier site
33 -- p_inventory_item_id IN Records for specific item
34 -- p_organization_id IN Records for specific org
35 --
36 -- COMMENT : This procedure will assign records to a batch id
37 --=========================================================================
38 PROCEDURE consumption_txn_manager
39 ( p_batch_size IN NUMBER
40 , p_max_workers IN NUMBER
41 , p_vendor_id IN NUMBER
42 , p_vendor_site_id IN NUMBER
43 , p_inventory_item_id IN NUMBER
44 , p_organization_id IN NUMBER
45 );
46
47 --========================================================================
48 -- PROCEDURE : Consumption_Txn_Worker PUBLIC
49 -- PARAMETERS: p_batch_id IN Id of records to be processed
50 --
51 -- COMMENT : This procedure will set in motion the creation of
52 -- one consumption advice
53 --=========================================================================
54 PROCEDURE consumption_txn_worker
55 ( p_batch_id IN NUMBER
56 );
57
58 END INV_CONSUMPTION_ADVICE_PROC;