[Home] [Help]
PACKAGE: APPS.CSI_FA_INSTANCE_GRP
Source
1 PACKAGE csi_fa_instance_grp AS
2 /* $Header: csigfais.pls 120.3 2005/07/05 18:24:12 brmanesh noship $ */
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),
26 external_reference varchar2(30),
27 instance_usage_code varchar2(30),
28 instance_description varchar2(240),
29 operational_status_code varchar2(30));
30
31 TYPE instance_serial_tbl IS TABLE of instance_serial_rec INDEX BY binary_integer;
32
33 PROCEDURE create_item_instance(
34 p_fixed_asset_rec IN fixed_asset_rec,
35 p_eam_rec IN eam_rec,
36 p_instance_rec IN csi_datastructures_pub.instance_rec,
37 p_instance_serial_tbl IN instance_serial_tbl,
38 p_party_tbl IN csi_datastructures_pub.party_tbl,
39 p_party_account_tbl IN csi_datastructures_pub.party_account_tbl,
40 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
41 x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
42 x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
43 x_return_status OUT nocopy varchar2,
44 x_error_message OUT nocopy varchar2);
45
46 PROCEDURE copy_item_instance(
47 p_fixed_asset_rec IN fixed_asset_rec,
48 p_instance_rec IN csi_datastructures_pub.instance_rec,
49 p_instance_serial_tbl IN instance_serial_tbl,
50 p_eam_rec IN eam_rec,
51 p_copy_parties IN varchar2,
52 p_copy_accounts IN varchar2,
53 p_copy_contacts IN varchar2,
54 p_copy_org_assignments IN varchar2,
55 p_copy_asset_assignments IN varchar2,
56 p_copy_pricing_attribs IN varchar2,
57 p_copy_ext_attribs IN varchar2,
58 p_copy_inst_children IN varchar2,
59 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
60 x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
61 x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
62 x_return_status OUT nocopy varchar2,
63 x_error_message OUT nocopy varchar2);
64
65 PROCEDURE associate_item_instance(
66 p_fixed_asset_rec IN fixed_asset_rec,
67 p_instance_tbl IN csi_datastructures_pub.instance_tbl,
68 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
69 x_instance_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
70 x_return_status OUT nocopy varchar2,
71 x_error_message OUT nocopy varchar2);
72
73 PROCEDURE update_asset_association(
74 p_instance_asset_tbl IN csi_datastructures_pub.instance_asset_tbl,
75 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
76 x_return_status OUT nocopy varchar2,
77 x_error_message OUT nocopy varchar2);
78
79 PROCEDURE create_instance_assets (
80 px_instance_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_tbl,
81 px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
82 x_return_status OUT nocopy varchar2,
83 x_error_message OUT nocopy varchar2);
84
85 END csi_fa_instance_grp;