1 PACKAGE INV_DROPSHIP_GLOBALS AUTHID CURRENT_USER AS
2 /* $Header: INVDSGLS.pls 115.2 2003/11/06 00:06:30 vipartha noship $ */
3
4 -- Record type for drop ship
5 -- Description of attributes in the record type
6
7 -- PARENT_TRANSACTION_ID - This column would indicate which is the
8 -- parent transaction record for a set of records. The parent transaction
9 -- id corresponds to the transaction id of the MMT record of the parent record
10 -- LOGICAL_TRX_TYPE_CODE -- This code indicates the transaction that
11 -- initiated the creation of the logical transations.
12 -- 1 - Drop Ship Receipt
13 -- 2 - Drop Ship Deliver
14 -- 3 - Global Procurement/ Return to vendor
15 -- 4 - Retroactive Price Update
16 -- 5 - Extenal Shipments across OUs or RMAs
17
18 -- Intercomany Cost -- Intercompany transaction cost
19 -- Intercompany Pricing Option
20 -- TRX_FLOW_HEADER_ID - Indicates the tramsaction flow that is being used
21 -- for the creation of logical transactions
22 -- LOGICAL_TRANSACTIONS_CREATED -- Indicates whether the logical
23 -- transactions have been created or deferred.
24 -- 1 - Indicates Yes created
25 -- 2 - Indicates NO nit created
26 -- LOGICAL_TRANSACTION -- Indicates whether it is a physical or logical txn.
27
28
29 TYPE logical_trx_attr_rec IS RECORD
30 (
31 transaction_id NUMBER := NULL,
32 transaction_type_id NUMBER := NULL,
33 transaction_action_id NUMBER := NULL,
34 transaction_source_type_id NUMBER := NULL,
35 parent_transaction_id NUMBER := NULL,
36 logical_trx_type_code NUMBER := NULL,
37 intercompany_cost NUMBER := NULL,
38 intercompany_pricing_option NUMBER := NULL,
39 trx_flow_header_id NUMBER := NULL,
40 logical_transactions_created NUMBER := NULL,
41 logical_transaction NUMBER := NULL,
42 intercompany_currency_code VARCHAR2(31) := NULL
43
44 );
45
46 TYPE logical_trx_attr_tbl IS TABLE OF logical_trx_attr_rec INDEX BY BINARY_INTEGER;
47
48
49 end INV_DROPSHIP_GLOBALS;