eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CSE_ASSET_MOVE_PKG

Source


1 PACKAGE cse_asset_move_pkg AS
2 /* $Header: CSEFAMVS.pls 120.6.12010000.1 2008/07/30 05:17:33 appldev 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     pa_project_id          number,
73     pa_project_task_id     number,
74     location_type_code     varchar2(30),
75     location_id            number,
76     mtl_dist_acct_id       number,
77     depreciable_flag       varchar2(1),
78     redeploy_flag          varchar2(1),
79     group_asset_id         number,
80     asset_description      varchar2(80),
81     asset_unit_cost        number,
82     asset_cost             number,
83     asset_category_id      number,
84     book_type_code         varchar2(30),
85     date_placed_in_service date,
86     asset_location_id      number,
87     asset_key_ccid         number,
88     deprn_expense_ccid     number,
89     payables_ccid          number,
90     tag_number             varchar2(15),
91     model_number           varchar2(40),
92     manufacturer_name      varchar2(30),
93     employee_id            number,
94     search_method          varchar2(10),
95     source_txn_type        varchar2(30),
96     fa_group_by            varchar2(30),
97     src_dst_flag           varchar2(1));
98 
99   TYPE instance_tbl IS TABLE of instance_rec INDEX BY binary_integer;
100 
101   TYPE fa_query_rec IS RECORD(
102     inventory_item_id      number,
103     asset_id               number,
104     asset_description      varchar2(80),
105     book_type_code         varchar2(30),
106     asset_category_id      number,
107     date_placed_in_service date,
108     serial_number          varchar2(80),
109     model_number           varchar2(30),
110     tag_nuber              varchar2(30),
111     manufacturer_name      varchar2(30),
112     asset_key_ccid         number,
113     search_method          varchar2(10));
114 
115   TYPE fixed_asset_rec IS RECORD(
116     asset_id               number,
117     asset_number           varchar2(30),
118     asset_category_id      number,
119     asset_key_ccid         number,
120     tag_number             varchar2(30),
121     asset_description      varchar2(240),
122     manufacturer_name      varchar2(30),
123     serial_number          varchar2(80),
124     model_number           varchar2(80),
125     current_units          number,
126     book_type_code         varchar2(30),
127     date_placed_in_service date,
128     asset_cost             number,
129     mass_addition_id       number,
130     feeder_system_name     varchar2(40),
131     reviewer_comments      varchar2(240),
132     instance_asset_id      number);
133 
134   TYPE fixed_asset_tbl IS TABLE of fixed_asset_rec INDEX BY binary_integer;
135 
136   PROCEDURE process_move_transactions(
137     x_retcode              OUT NOCOPY VARCHAR2,
138     x_errbuf               OUT NOCOPY VARCHAR2,
139     p_inventory_item_id    IN  NUMBER DEFAULT NULL);
140 
141 END cse_asset_move_pkg ;