[Home] [Help]
PACKAGE: APPS.INV_CONSUMPTION_TXN_PVT
Source
1 PACKAGE INV_CONSUMPTION_TXN_PVT AUTHID CURRENT_USER AS
2 /* $Header: INVVRETS.pls 120.1 2006/04/27 14:30:39 rajkrish noship $ */
3 --+=======================================================================+
4 --| Copyright (c) 2003 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVVRETS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Create Records in MTL_CONSUMPTION_TRANSACTIONS |
13 --| HISTORY |
14 --| 07/22/2003 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 : Price Update Insert PUBLIC
29 -- PARAMETERS: p_transaction_id IN unique id and link to mmt
30 -- p_consumption_po_header_id IN consumption advice (global)
31 -- p_consumption_release_id IN consumption advice (local)
32 -- p_transaction_quantity IN quantity retroactively priced
33 --
34 -- COMMENT : This procedure will insert records
35 -- : into mtl_consumption_transactions
36 --=========================================================================
37 PROCEDURE price_update_insert
38 ( p_transaction_id IN NUMBER
39 , p_consumption_po_header_id IN NUMBER
40 , p_consumption_release_id IN NUMBER
41 , p_transaction_quantity IN NUMBER
42 , p_po_distribution_id IN NUMBER
43 , x_msg_count OUT NOCOPY NUMBER
44 , x_msg_data OUT NOCOPY VARCHAR2
45 , x_return_status OUT NOCOPY VARCHAR2
46 );
47
48 END INV_CONSUMPTION_TXN_PVT;