PACKAGE: APPS.CSE_ASSET_MOVE_PKG

Source

1 PACKAGE cse_asset_move_pkg AUTHID CURRENT_USER AS
2 /* $Header: CSEFAMVS.pls 120.8 2011/05/31 23:22:07 devijay ship $ */
3 
4   TYPE move_trans_rec IS RECORD (
5     transaction_id               NUMBER,
6     transaction_type_id          NUMBER,
7     instance_id                  NUMBER,
8     primary_units                NUMBER,
9     serial_number                VARCHAR2(30),
10     inv_material_transaction_id  NUMBER,
11     source_transaction_type      VARCHAR2(30),
12     inv_item_id                  NUMBER,
13     inv_org_id                   NUMBER,
14     shipment_number              VARCHAR2(30),
15     inv_organization_id          NUMBER,
16     inv_subinventory_name        VARCHAR2(10),
17     location_id                  NUMBER,
18     location_type_code           VARCHAR2(30),
19     transaction_date             DATE,
20     transaction_quantity         NUMBER,
21     object_version_number        NUMBER,
22     operation_status_code        VARCHAR2(30),
23     instance_usage_code          VARCHAR2(30),
24     source_index                 BINARY_INTEGER,
25     serial_control_code          number);
26 
27   TYPE move_trans_tbl IS TABLE OF move_trans_rec INDEX BY BINARY_INTEGER ;
28 
29   TYPE txn_context IS RECORD (
30     csi_txn_id             number,
31     csi_txn_type_id        number,
32     csi_txn_date           date,
33     mtl_txn_id             number,
34     mtl_txn_type_id        number,
35     mtl_txn_action_id      number,
36     mtl_txn_src_type_id    number,
37     mtl_txn_date           date,
38     mtl_txn_src_id         number,
39     mtl_src_trx_line_id    number,
40     mtl_xfer_txn_id        number,
41     inventory_item_id      number,
42     organization_id        number,
43     item                   varchar2(120),
44     item_description       varchar2(540),
45     primary_quantity       number,
46     primary_uom_code       varchar2(6),
47     depreciable_flag       varchar2(1),
48     src_serial_code        number,
49     dst_serial_code        number,
50     src_lot_code           number,
51     dst_lot_code           number);
52 
53   TYPE instance_rec IS RECORD (
54     csi_txn_id             number,
55     csi_txn_type_id        number,
56     csi_txn_date           date,
57     mtl_txn_id             number,
58     mtl_txn_date           date,
59     mtl_txn_qty            number,
60     rcv_txn_id             number,
61     po_distribution_id     number,
62     instance_id            number,
63     quantity               number,
64     inventory_item_id      number,
65     organization_id        number,
66     item                   varchar2(80),
67     item_description       varchar2(240),
68     subinventory_code      varchar2(30),
69     primary_uom_code       varchar2(6),
70     serial_number          varchar2(30),
71     --lot_number             varchar2(30),
72     lot_number             varchar2(80), --bug 10322621
73     pa_project_id          number,
74     pa_project_task_id     number,
75     location_type_code     varchar2(30),
76     location_id            number,
77     mtl_dist_acct_id       number,
78     depreciable_flag       varchar2(1),
79     redeploy_flag          varchar2(1),
80     group_asset_id         number,
81     asset_description      varchar2(80),
82     asset_unit_cost        number,
83     asset_cost             number,
84     asset_category_id      number,
85     book_type_code         varchar2(30),
86     date_placed_in_service date,
87     asset_location_id      number,
88     asset_key_ccid         number,
89     deprn_expense_ccid     number,
90     payables_ccid          number,
91     tag_number             varchar2(15),
92     model_number           varchar2(40),
93     manufacturer_name      varchar2(360), -- Bug 11878668
94     --manufacturer_name      varchar2(30),
95     employee_id            number,
96     search_method          varchar2(10),
97     source_txn_type        varchar2(30),
98     fa_group_by            varchar2(30),
99     src_dst_flag           varchar2(1));
100 
101   TYPE instance_tbl IS TABLE of instance_rec INDEX BY binary_integer;
102 
103   TYPE fa_query_rec IS RECORD(
104     inventory_item_id      number,
105     asset_id               number,
106     asset_description      varchar2(80),
107     book_type_code         varchar2(30),
108     asset_category_id      number,
109     date_placed_in_service date,
110     serial_number          varchar2(80),
111     model_number           varchar2(30),
112     tag_nuber              varchar2(30),
113     manufacturer_name      varchar2(360), -- Bug 11878668
114     --manufacturer_name      varchar2(30),
115     asset_key_ccid         number,
116     search_method          varchar2(10));
117 
118   TYPE fixed_asset_rec IS RECORD(
119     asset_id               number,
120     asset_number           varchar2(30),
121     asset_category_id      number,
122     asset_key_ccid         number,
123     tag_number             varchar2(30),
124     asset_description      varchar2(240),
125     manufacturer_name      varchar2(360), -- Bug 11878668
126     --manufacturer_name      varchar2(30),
127     serial_number          varchar2(80),
128     model_number           varchar2(80),
129     current_units          number,
130     book_type_code         varchar2(30),
131     date_placed_in_service date,
132     asset_cost             number,
133     mass_addition_id       number,
134     feeder_system_name     varchar2(40),
135     reviewer_comments      varchar2(240),
136     instance_asset_id      number);
137 
138   TYPE fixed_asset_tbl IS TABLE of fixed_asset_rec INDEX BY binary_integer;
139 
140   PROCEDURE process_move_transactions(
141     x_retcode              OUT NOCOPY VARCHAR2,
142     x_errbuf               OUT NOCOPY VARCHAR2,
143     p_inventory_item_id    IN  NUMBER DEFAULT NULL);
144 
145 END cse_asset_move_pkg ;