1 PACKAGE INV_THIRD_PARTY_STOCK_PVT AS
2 -- $Header: INVVTPSS.pls 120.2.12010000.1 2008/07/24 01:53:01 appldev ship $ --
3 --+=======================================================================+
4 --| Copyright (c) 2002 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVVTPSS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Consignment Financial Document API |
13 --| HISTORY |
14 --| 09/30/2002 pseshadr Created |
15 -- JUl-29-2002 rajkrish FP-J projects updates
16 --+========================================================================
17
18
19 --===================
20 -- PROCEDURES AND FUNCTIONS
21 --===================
22
23 --========================================================================
24 -- PROCEDURE : Process_Financial_Info PUBLIC
25 -- PARAMETERS: p_mtl_transaction_id Material transaction id issue
26 -- p_rct_transaction_id Material transaction rct side
27 -- p_transaction_source_type_id Txn source Type
28 -- p_transaction_action_id Txn action
29 -- p_inventory_item_id item
30 -- p_owning_organization_id owning organization
31 -- p_owning_tp_type owning tp type
32 -- p_organization_id Inv. organization
33 -- p_transaction_quantity Transaction Quantity
34 -- p_transaction_source_id Txn source
35 -- p_item_revision Revision
36 -- x_po_price PO price
37 -- x_account_id Accrual Account
38 -- x_rate Exchange Rate
39 -- x_rate_type Exchange Rate type
40 -- x_rate_date Exchange rate date
41 -- x_currency_code Currency Code
42 -- x_message_count
43 -- x_message_data
44 -- x_return_status status
45 -- p_secondary_transaction_qty Transaction quantity
46 -- in secondary uom
47 -- COMMENT : Process Finanical information for consigned transactions
48 -- This procedure is invoked by the Inventory TM during
49 -- the insert of consigned transactions from MMTT to MMT
50 --========================================================================
51 PROCEDURE Process_Financial_Info
52 ( p_mtl_transaction_id IN NUMBER
53 , p_rct_transaction_id IN NUMBER
54 , p_transaction_source_type_id IN NUMBER
55 , p_transaction_action_id IN NUMBER
56 , p_inventory_item_id IN NUMBER
57 , p_owning_organization_id IN NUMBER
58 , p_xfr_owning_organization_id IN NUMBER
59 , p_organization_id IN NUMBER
60 , p_transaction_quantity IN NUMBER
61 , p_transaction_date IN DATE
62 , p_transaction_source_id IN OUT NOCOPY NUMBER
63 , p_item_revision IN VARCHAR2 DEFAULT NULL
64 , x_po_price OUT NOCOPY NUMBER
65 , x_account_id OUT NOCOPY NUMBER
66 , x_rate OUT NOCOPY NUMBER
67 , x_rate_type OUT NOCOPY VARCHAR2
68 , x_rate_date OUT NOCOPY DATE
69 , x_currency_code OUT NOCOPY VARCHAR2
70 , x_msg_count OUT NOCOPY NUMBER
71 , x_msg_data OUT NOCOPY VARCHAR2
72 , x_return_status OUT NOCOPY VARCHAR2
73 , p_secondary_transaction_qty IN NUMBER --INVCONV
74 );
75
76 --========================================================================
77 -- PROCEDURE : Process_Financial_Info OVERLOAD API
78 -- PARAMETERS: p_mtl_transaction_id Material transaction id issue
79 -- p_rct_transaction_id Material transaction rct side
80 -- p_transaction_source_type_id Txn source Type
81 -- p_transaction_action_id Txn action
82 -- p_inventory_item_id item
83 -- p_owning_organization_id owning organization
84 -- p_owning_tp_type owning tp type
85 -- p_organization_id Inv. organization
86 -- p_transaction_quantity Transaction Quantity
87 -- p_transaction_source_id Txn source
88 -- p_item_revision RevisionS
89 -- p_calling_action
90 -- Will be used to differentiate if the
91 -- calling program is DIAGNOSTICS or not
92 -- x_po_price PO price
93 -- x_account_id Accrual Account
94 -- x_rate Exchange Rate
95 -- x_rate_type Exchange Rate type
96 -- x_rate_date Exchange rate date
97 -- x_currency_code Currency Code
98 -- x_message_count
99 -- x_message_data
100 -- x_return_status status
101 -- COMMENT : This procedure will be used by the
102 -- INV Consigned Inventory Diagnostics program
103 -- This procedure will inturn invoke the process_financial_info
104 -- to validate the moqd data waiting for ownership transfer
105 -- transaction process.
106 -- The process_financial_info API will also be modified
107 -- to make sure that it does not insert/update
108 -- any records as such and just perform and return
109 -- the validation results
110
111 -- This API will inturn the call the original API
112 -- Process_Financial_Info
113 --========================================================================
114 PROCEDURE Process_Financial_Info
115 ( p_mtl_transaction_id IN NUMBER
116 , p_rct_transaction_id IN NUMBER
117 , p_transaction_source_type_id IN NUMBER
118 , p_transaction_action_id IN NUMBER
119 , p_inventory_item_id IN NUMBER
120 , p_owning_organization_id IN NUMBER
121 , p_xfr_owning_organization_id IN NUMBER
122 , p_organization_id IN NUMBER
123 , p_transaction_quantity IN NUMBER
124 , p_transaction_date IN DATE
125 , p_transaction_source_id IN OUT NOCOPY NUMBER
126 , p_item_revision IN VARCHAR2 DEFAULT NULL
127 , p_calling_action IN VARCHAR2
128 , x_po_price OUT NOCOPY NUMBER
129 , x_account_id OUT NOCOPY NUMBER
130 , x_rate OUT NOCOPY NUMBER
131 , x_rate_type OUT NOCOPY VARCHAR2
132 , x_rate_date OUT NOCOPY DATE
133 , x_currency_code OUT NOCOPY VARCHAR2
134 , x_msg_count OUT NOCOPY NUMBER
135 , x_msg_data OUT NOCOPY VARCHAR2
136 , x_return_status OUT NOCOPY VARCHAR2
137 , x_error_code OUT NOCOPY VARCHAR2
138 , x_po_header_id OUT NOCOPY NUMBER
139 , x_purchasing_UOM OUT NOCOPY VARCHAR2
140 , x_primary_UOM OUT NOCOPY VARCHAR2
141 );
142
143
144 END INV_THIRD_PARTY_STOCK_PVT;