1 PACKAGE CSI_ITEM_INSTANCE_VUHK AUTHID CURRENT_USER AS
2 /* $Header: csivhiis.pls 120.0 2005/05/24 17:39:48 appldev noship $ */
3 --
4 PROCEDURE create_item_instance_pre
5 (
6 p_api_version IN NUMBER
7 ,p_commit IN VARCHAR2 := fnd_api.g_false
8 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
9 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
10 ,p_instance_rec IN csi_datastructures_pub.instance_rec
11 ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
12 ,p_party_tbl IN csi_datastructures_pub.party_tbl
13 ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
14 ,p_pricing_attrib_tbl IN csi_datastructures_pub.pricing_attribs_tbl
15 ,p_org_assignments_tbl IN csi_datastructures_pub.organization_units_tbl
16 ,p_asset_assignment_tbl IN csi_datastructures_pub.instance_asset_tbl
17 ,p_txn_rec IN csi_datastructures_pub.transaction_rec
18 ,x_return_status OUT NOCOPY VARCHAR2
19 ,x_msg_count OUT NOCOPY NUMBER
20 ,x_msg_data OUT NOCOPY VARCHAR2
21 );
22 --
23 PROCEDURE create_item_instance_post
24 (
25 p_api_version IN NUMBER
26 ,p_commit IN VARCHAR2 := fnd_api.g_false
27 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
28 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
29 ,p_instance_rec IN csi_datastructures_pub.instance_rec
30 ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
31 ,p_party_tbl IN csi_datastructures_pub.party_tbl
32 ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
33 ,p_pricing_attrib_tbl IN csi_datastructures_pub.pricing_attribs_tbl
34 ,p_org_assignments_tbl IN csi_datastructures_pub.organization_units_tbl
35 ,p_asset_assignment_tbl IN csi_datastructures_pub.instance_asset_tbl
36 ,p_txn_rec IN csi_datastructures_pub.transaction_rec
37 ,x_return_status OUT NOCOPY VARCHAR2
38 ,x_msg_count OUT NOCOPY NUMBER
39 ,x_msg_data OUT NOCOPY VARCHAR2
40 );
41 --
42 PROCEDURE update_item_instance_pre
43 (
44 p_api_version IN NUMBER
45 ,p_commit IN VARCHAR2 := fnd_api.g_false
46 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
47 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
48 ,p_instance_rec IN csi_datastructures_pub.instance_rec
49 ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
50 ,p_party_tbl IN csi_datastructures_pub.party_tbl
51 ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
52 ,p_pricing_attrib_tbl IN csi_datastructures_pub.pricing_attribs_tbl
53 ,p_org_assignments_tbl IN csi_datastructures_pub.organization_units_tbl
54 ,p_asset_assignment_tbl IN csi_datastructures_pub.instance_asset_tbl
55 ,p_txn_rec IN csi_datastructures_pub.transaction_rec
56 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
57 ,x_return_status OUT NOCOPY VARCHAR2
58 ,x_msg_count OUT NOCOPY NUMBER
59 ,x_msg_data OUT NOCOPY VARCHAR2
60 );
61 --
62 PROCEDURE update_item_instance_post
63 (
64 p_api_version IN NUMBER
65 ,p_commit IN VARCHAR2 := fnd_api.g_false
66 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
68 ,p_instance_rec IN csi_datastructures_pub.instance_rec
69 ,p_ext_attrib_values_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
70 ,p_party_tbl IN csi_datastructures_pub.party_tbl
71 ,p_account_tbl IN csi_datastructures_pub.party_account_tbl
72 ,p_pricing_attrib_tbl IN csi_datastructures_pub.pricing_attribs_tbl
73 ,p_org_assignments_tbl IN csi_datastructures_pub.organization_units_tbl
74 ,p_asset_assignment_tbl IN csi_datastructures_pub.instance_asset_tbl
75 ,p_txn_rec IN csi_datastructures_pub.transaction_rec
76 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
77 ,x_return_status OUT NOCOPY VARCHAR2
78 ,x_msg_count OUT NOCOPY NUMBER
79 ,x_msg_data OUT NOCOPY VARCHAR2
80 );
81 --
82 PROCEDURE expire_item_instance_pre
83 (
84 p_api_version IN NUMBER
85 ,p_commit IN VARCHAR2 := fnd_api.g_false
86 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
87 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88 ,p_instance_rec IN csi_datastructures_pub.instance_rec
89 ,p_expire_children IN VARCHAR2 := fnd_api.g_false
90 ,p_txn_rec IN csi_datastructures_pub.transaction_rec
91 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
92 ,x_return_status OUT NOCOPY VARCHAR2
93 ,x_msg_count OUT NOCOPY NUMBER
94 ,x_msg_data OUT NOCOPY VARCHAR2
95 );
96 --
97 PROCEDURE expire_item_instance_post
98 (
99 p_api_version IN NUMBER
100 ,p_commit IN VARCHAR2 := fnd_api.g_false
101 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
102 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
103 ,p_instance_rec IN csi_datastructures_pub.instance_rec
104 ,p_expire_children IN VARCHAR2 := fnd_api.g_false
105 ,p_txn_rec IN csi_datastructures_pub.transaction_rec
106 ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_msg_count OUT NOCOPY NUMBER
109 ,x_msg_data OUT NOCOPY VARCHAR2
110 );
111 --
112 END CSI_ITEM_INSTANCE_VUHK;