[Home] [Help]
PACKAGE: APPS.CSE_ASSET_CREATION_PKG
Source
1 PACKAGE cse_asset_creation_pkg AUTHID CURRENT_USER AS
2 -- $Header: CSEIFACS.pls 120.8 2011/11/01 23:24:32 devijay 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 lot_number varchar2(80), -- bug 10322621
26 pa_project_id number,
27 pa_project_task_id number,
28 location_type_code varchar2(30),
29 location_id number,
30 mtl_dist_acct_id number,
31 depreciable_flag varchar2(1),
32 redeploy_flag varchar2(1),
33 group_asset_id number,
34 asset_description varchar2(80),
35 asset_unit_cost number,
36 asset_cost number,
37 asset_category_id number,
38 book_type_code varchar2(30),
39 date_placed_in_service date,
40 asset_location_id number,
41 asset_key_ccid number,
42 deprn_expense_ccid number,
43 payables_ccid number,
44 tag_number varchar2(15),
45 model_number varchar2(40),
46 manufacturer_name varchar2(30),
47 employee_id number,
48 search_method varchar2(10),
49 source_txn_type varchar2(30),
50 fa_group_by varchar2(30),
51 po_header_id number,
52 po_number varchar2(30),
53 po_vendor_id number);
54
55 TYPE instance_tbl IS TABLE of instance_rec INDEX BY binary_integer;
56
57 TYPE fa_query_rec IS RECORD(
58 inventory_item_id number,
59 asset_id number,
60 asset_description varchar2(80),
61 book_type_code varchar2(30),
62 asset_category_id number,
63 date_placed_in_service date,
64 serial_number varchar2(80),
65 model_number varchar2(30),
66 tag_nuber varchar2(30),
67 manufacturer_name varchar2(30),
68 asset_key_ccid number,
69 search_method varchar2(10));
70
71 TYPE fixed_asset_rec IS RECORD(
72 asset_id number,
73 asset_number varchar2(30),
74 asset_category_id number,
75 asset_key_ccid number,
76 tag_number varchar2(30),
77 asset_description varchar2(240),
78 manufacturer_name varchar2(30),
79 serial_number varchar2(80),
80 model_number varchar2(80),
81 current_units number,
82 book_type_code varchar2(30),
83 date_placed_in_service date,
84 asset_cost number,
85 mass_addition_id number,
86 feeder_system_name varchar2(40),
87 reviewer_comments varchar2(240),
88 instance_asset_id number);
89
90 TYPE fixed_asset_tbl IS TABLE of fixed_asset_rec INDEX BY binary_integer;
91
92 TYPE txn_status_rec IS RECORD(
93 csi_txn_id number,
94 processed_flag varchar2(1),
95 valid_txn_flag varchar2(1),
96 error_message varchar2(2000));
97
98 TYPE txn_status_tbl IS TABLE of txn_status_rec INDEX by binary_integer;
99
100 PROCEDURE create_depreciable_assets(
101 errbuf OUT NOCOPY VARCHAR2,
102 retcode OUT NOCOPY NUMBER,
103 p_inventory_item_id IN NUMBER,
104 p_organization_id IN NUMBER);
105
106 PROCEDURE create_asset(
107 p_inst_tbl IN instance_tbl,
108 x_return_status OUT nocopy varchar2,
109 x_err_inst_rec OUT nocopy instance_rec);
110
111 PROCEDURE find_asset(
112 p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
113 p_distribution_tbl OUT NOCOPY cse_datastructures_pub.distribution_tbl,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_error_msg OUT NOCOPY VARCHAR2);
116
117 PROCEDURE adjust_asset(
118 p_asset_query_rec IN OUT NOCOPY cse_datastructures_pub.asset_query_rec,
119 p_mass_add_rec IN OUT NOCOPY fa_mass_additions%ROWTYPE,
120 p_mtl_percent IN NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_error_msg OUT NOCOPY VARCHAR2);
123
124 PROCEDURE complete_csi_txn(
125 p_csi_txn_id IN number,
126 x_return_status OUT nocopy varchar2,
127 x_error_message OUT nocopy varchar2);
128
129 END cse_asset_creation_pkg;