1 PACKAGE INV_THIRD_PARTY_STOCK_CAD_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVCADVS.pls 115.1 2002/12/20 00:00:37 pseshadr noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVCADVS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Create Consumption Advice |
13 --| HISTORY |
14 --| 11/29/2002 David Herring created |
15 --+========================================================================
16
17 --===================
18 -- CONSTANTS
19 --===================
20
21 G_LOG_ERROR CONSTANT NUMBER := 5;
22 G_LOG_EXCEPTION CONSTANT NUMBER := 4;
23 G_LOG_EVENT CONSTANT NUMBER := 3;
24 G_LOG_PROCEDURE CONSTANT NUMBER := 2;
25 G_LOG_STATEMENT CONSTANT NUMBER := 1;
26
27
28 --===================
29 -- PROCEDURES AND FUNCTIONS
30 --===================
31
32 --========================================================================
33 -- PROCEDURE : Consumption_Txn_Manager PUBLIC
34 -- PARAMETERS: x_retcode OUT return status
35 -- x_errbuff OUT return error messages
36 -- p_batch_id IN Organization Hierarchy
37 --
38 -- COMMENT : This procedure will set in motion the creation of
39 -- one or more consumption advices
40 --=========================================================================
41 PROCEDURE consumption_txn_manager
42 ( x_retcode OUT NOCOPY VARCHAR2
43 , p_batch_size IN NUMBER
44 , p_max_workers IN NUMBER
45 , p_vendor_site_id IN NUMBER
46 , p_inventory_item_id IN NUMBER
47 , p_organization_id IN NUMBER
48 );
49
50 --========================================================================
51 -- PROCEDURE : Consumption_Txn_Worker PUBLIC
52 -- PARAMETERS: x_retcode OUT return status
53 -- x_errbuff OUT return error messages
54 -- p_batch_id IN Organization Hierarchy
55 --
56 -- COMMENT : This procedure will set in motion the creation of
57 -- one consumption advice
58 --=========================================================================
59 PROCEDURE cons_txn_work
60 ( x_retcode OUT NOCOPY VARCHAR2
61 , p_batch_id IN NUMBER
62 );
63
64 --========================================================================
65 -- PROCEDURE : Update_Consumption PUBLIC
66 -- PARAMETERS:
67 -- p_consumption_po_header_id PO Header Id
68 -- p_consumption_release_id Release id
69 -- p_error_code Error code if any
70 -- p_batch_id batch id from concurrent pgm
71 -- p_consumption_processed_flag E if error,else Y
72 -- p_rate exchange rate if applicable
73 -- p_transaction_date Txn Date
74 -- COMMENT : Update mtl_consumption_transactions table
75 -- This procedure is called by the Create_Consumption_Advice
76 -- procedures after creation of the
77 -- document. Update the table with the appropriate release
78 -- info or the po_header info.
79 --========================================================================
80 PROCEDURE Update_Consumption
81 ( p_consumption_po_header_id IN NUMBER
82 , p_consumption_release_id IN NUMBER
83 , p_error_code IN VARCHAR2
84 , p_batch_id IN NUMBER
85 , p_transaction_source_id IN NUMBER
86 , p_consumption_processed_flag IN VARCHAR2
87 , p_accrual_account_id IN NUMBER
88 , p_variance_account_id IN NUMBER
89 , p_charge_account_id IN NUMBER
90 );
91
92 END INV_THIRD_PARTY_STOCK_CAD_PVT;