1 PACKAGE INV_CONSUMPTION_ADVICE_CP AUTHID CURRENT_USER AS
2 -- $Header: INVCCADS.pls 115.0 2002/12/17 01:34:23 dherring noship $
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVCCADS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Consumption Transactions Concurrent Program |
13 --| HISTORY |
14 --| 12/11/02 David Herring Created |
15 --+======================================================================--
16
17 --===================
18 -- PROCEDURES AND FUNCTIONS
19 --===================
20
21 --========================================================================
22 -- PROCEDURE : Consumption_Txn_Manager PUBLIC
23 -- PARAMETERS: x_retcode OUT NOCOPY Return status
24 -- x_errbuff OUT NOCOPY Return error message
25 -- p_batch_size IN Size of a batch
26 -- p_max_workers IN Number of workers allowed
27 -- p_vendor_id IN Specific supplier
28 -- p_vendor_site_code IN Specific supplier site
29 -- p_item_id IN Specific item
30 -- p_org_id IN Specific organization
31 --
32 -- COMMENT : This procedure will assign records to a batch id
33 --=========================================================================
34 PROCEDURE consumption_txn_manager
35 ( x_retcode OUT NOCOPY VARCHAR2
36 , x_errbuff OUT NOCOPY VARCHAR2
37 , p_batch_size IN NUMBER
38 , p_max_workers IN NUMBER
39 , p_vendor_id IN NUMBER
40 , p_vendor_site_id IN NUMBER
41 , p_item_id IN NUMBER
42 , p_org_id IN NUMBER
43 );
44
45 --========================================================================
46 -- PROCEDURE : Consumption_Txn_Worker PUBLIC
47 -- PARAMETERS: x_retcode OUT NOCOPY Return status
48 -- x_errbuff OUT NOCOPY Return error message
49 -- p_batch_id IN Batch identifier
50 --
51 -- COMMENT : This procedure will set in motion the creation of
52 -- one consumption advice
53 --=========================================================================
54 PROCEDURE consumption_txn_worker
55 ( x_retcode OUT NOCOPY VARCHAR2
56 , x_errbuff OUT NOCOPY VARCHAR2
57 , p_batch_id IN NUMBER
58 );
59
60 END INV_CONSUMPTION_ADVICE_CP;