[Home] [Help]
PACKAGE: APPS.CSI_FA_INSTANCE_GRP
Source
1 PACKAGE csi_fa_instance_grp AUTHID CURRENT_USER AS
2 /* $Header: csigfais.pls 120.5 2012/01/25 19:07:29 smbalara ship $ */
3
4 g_pkg_name constant varchar2(30) := 'csi_fa_instance_grp';
5
6 TYPE fixed_asset_rec IS RECORD (
7 asset_id number,
8 book_type_code varchar2(15),
9 asset_location_id number,
10 asset_quantity number,
11 fa_sync_flag varchar2(1),
12 fa_sync_validation_reqd varchar2(1));
13
14 TYPE eam_rec IS RECORD (
15 category_id number,
16 asset_criticality_code varchar2(30),
17 owning_department_id number,
18 wip_accounting_class_code varchar2(10),
19 area_id number,
20 parent_instance_id number);
21
22 TYPE instance_serial_rec IS RECORD (
23 instance_number varchar2(30),
24 serial_number varchar2(30),
25 --lot_number varchar2(30), --bug 10279935
26 lot_number varchar2(80),
27 external_reference varchar2(30),
28 instance_usage_code varchar2(30),
29 instance_description varchar2(240),
30 operational_status_code varchar2(30));
31
32 TYPE instance_serial_tbl IS TABLE of instance_serial_rec INDEX BY binary_integer;
33
34 PROCEDURE create_item_instance(
35 p_fixed_asset_rec IN fixed_asset_rec,
36 p_eam_rec IN eam_rec,
37 p_instance_rec IN csi_datastructures_pub.instance_rec,
38 p_instance_serial_tbl IN instance_serial_tbl,
39 p_party_tbl IN csi_datastructures_pub.party_tbl,
40 p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
41 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
42 x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
43 x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
44 x_return_status OUT nocopy varchar2,
45 x_error_message OUT nocopy varchar2);
46
47 PROCEDURE copy_item_instance(
48 p_fixed_asset_rec IN fixed_asset_rec,
49 p_instance_rec IN csi_datastructures_pub.instance_rec,
50 p_instance_serial_tbl IN instance_serial_tbl,
51 p_eam_rec IN eam_rec,
52 p_copy_parties IN varchar2,
53 p_copy_accounts IN varchar2,
54 p_copy_contacts IN varchar2,
55 p_copy_org_assignments IN varchar2,
56 p_copy_asset_assignments IN varchar2,
57 p_copy_pricing_attribs IN varchar2,
58 p_copy_ext_attribs IN varchar2,
59 p_copy_inst_children IN varchar2,
60 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
61 x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
62 x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
63 x_return_status OUT nocopy varchar2,
64 x_error_message OUT nocopy varchar2);
65
66 PROCEDURE associate_item_instance(
67 p_fixed_asset_rec IN fixed_asset_rec,
68 p_instance_tbl IN csi_datastructures_pub.instance_tbl,
69 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
70 x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
71 x_return_status OUT nocopy varchar2,
72 x_error_message OUT nocopy varchar2);
73
74 PROCEDURE update_asset_association(
75 p_instance_asset_tbl IN csi_datastructures_pub.instance_asset_tbl,
76 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
77 x_return_status OUT nocopy varchar2,
78 x_error_message OUT nocopy varchar2);
79
80 PROCEDURE create_instance_assets (
81 px_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
82 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
83 x_return_status OUT nocopy varchar2,
84 x_error_message OUT nocopy varchar2);
85
86 END csi_fa_instance_grp;