[Home] [Help]
PACKAGE: APPS.CSE_ASSET_CREATION_PKG
Source
1 PACKAGE cse_asset_creation_pkg AS
2 -- $Header: CSEIFACS.pls 120.6.12010000.1 2008/07/30 05:17:52 appldev ship $
3
4 g_pkg_name varchar2(30) := 'cse_asset_creation_pkg';
5
6 TYPE instance_rec IS RECORD (
7 csi_txn_id number,
8 csi_txn_type_id number,
9 csi_txn_date date,
10 mtl_txn_id number,
11 mtl_txn_date date,
12 mtl_txn_qty number,
13 rcv_txn_id number,
14 po_distribution_id number,
15 instance_id number,
16 quantity number,
17 inventory_item_id number,
18 organization_id number,
19 item varchar2(80),
20 item_description varchar2(240),
21 subinventory_code varchar2(30),
22 primary_uom_code varchar2(6),
23 serial_number varchar2(30),
24 lot_number varchar2(30),
25 pa_project_id number,
26 pa_project_task_id number,
27 location_type_code varchar2(30),
28 location_id number,
29 mtl_dist_acct_id number,
30 depreciable_flag varchar2(1),
31 redeploy_flag varchar2(1),
32 group_asset_id number,
33 asset_description varchar2(80),
34 asset_unit_cost number,
35 asset_cost number,
36 asset_category_id number,
37 book_type_code varchar2(30),
38 date_placed_in_service date,
39 asset_location_id number,
40 asset_key_ccid number,
41 deprn_expense_ccid number,
42 payables_ccid number,
43 tag_number varchar2(15),
44 model_number varchar2(40),
45 manufacturer_name varchar2(30),
46 employee_id number,
47 search_method varchar2(10),
48 source_txn_type varchar2(30),
49 fa_group_by varchar2(30),
50 po_header_id number,
51 po_number varchar2(30),
52 po_vendor_id number);
53
54 TYPE instance_tbl IS TABLE of instance_rec INDEX BY binary_integer;
55
56 TYPE fa_query_rec IS RECORD(
57 inventory_item_id number,
58 asset_id number,
59 asset_description varchar2(80),
60 book_type_code varchar2(30),
61 asset_category_id number,
62 date_placed_in_service date,
63 serial_number varchar2(80),
64 model_number varchar2(30),
65 tag_nuber varchar2(30),
66 manufacturer_name varchar2(30),
67 asset_key_ccid number,
68 search_method varchar2(10));
69
70 TYPE fixed_asset_rec IS RECORD(
71 asset_id number,
72 asset_number varchar2(30),
73 asset_category_id number,
74 asset_key_ccid number,
75 tag_number varchar2(30),
76 asset_description varchar2(240),
77 manufacturer_name varchar2(30),
78 serial_number varchar2(80),
79 model_number varchar2(80),
80 current_units number,
81 book_type_code varchar2(30),
82 date_placed_in_service date,
83 asset_cost number,
84 mass_addition_id number,
85 feeder_system_name varchar2(40),
86 reviewer_comments varchar2(240),
87 instance_asset_id number);
88
89 TYPE fixed_asset_tbl IS TABLE of fixed_asset_rec INDEX BY binary_integer;
90
91 TYPE txn_status_rec IS RECORD(
92 csi_txn_id number,
93 processed_flag varchar2(1),
94 valid_txn_flag varchar2(1),
95 error_message varchar2(2000));
96
97 TYPE txn_status_tbl IS TABLE of txn_status_rec INDEX by binary_integer;
98
99 PROCEDURE create_depreciable_assets(
100 errbuf OUT NOCOPY VARCHAR2,
101 retcode OUT NOCOPY NUMBER,
102 p_inventory_item_id IN NUMBER,
103 p_organization_id IN NUMBER);
104
105 PROCEDURE create_asset(
106 p_inst_tbl IN instance_tbl,
107 x_return_status OUT nocopy varchar2,
108 x_err_inst_rec OUT nocopy instance_rec);
109
110 PROCEDURE find_asset(
111 p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
112 p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_error_msg OUT NOCOPY VARCHAR2);
115
116 PROCEDURE adjust_asset(
117 p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
118 p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
119 p_mtl_percent IN NUMBER,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_error_msg OUT NOCOPY VARCHAR2);
122
123 END cse_asset_creation_pkg;