1 PACKAGE EAM_ASSET_OPERATION_TXN_PVT AUTHID CURRENT_USER AS
2 /* $Header: EAMVACHS.pls 120.3 2005/08/03 05:59:58 ksiddhar noship $ */
3 /*
4 * This package is used for the ASSET CHECKIN/CHECKOUT transaction logging AND validation .
5 * It defines procedures which take quality collection plans and meter readings as input
6 * during checkin/checkoutand perform the respective operations.
7 *
8 */
9
10
11
12 -- This function returns the employeeid who checked-in the instance for the last transaction
13
14 FUNCTION get_created_by
15 (
16 p_instance_id IN number
17 )
18 return number;
19
20
21 -- This procedure commits the transaction details into eam_asset_operation_txn
22
23 PROCEDURE insert_txn(
24
25 p_api_version IN number := 1.0,
26 p_init_msg_list IN varchar2 := fnd_api.g_false,
27 p_commit IN varchar2 := fnd_api.g_false,
28 p_validation_level IN number := fnd_api.g_valid_level_full,
29 p_txn_date IN date := sysdate,
30 p_txn_type IN number,
31 p_instance_id IN number,
32 p_comments IN varchar2 := NULL,
33 p_qa_collection_id IN number := NULL,
34 p_operable_flag IN number,
35 p_employee_id IN number,
36 p_eam_ops_quality_tbl IN eam_asset_operation_txn_pub.eam_quality_tbl_type,
37 p_meter_reading_rec_tbl IN eam_asset_operation_txn_pub.meter_reading_rec_tbl_type,
38 p_counter_properties_tbl IN eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl,
39 p_attribute_category IN varchar2 := NULL,
40 p_attribute1 IN varchar2 := NULL,
41 p_attribute2 IN varchar2 := NULL,
42 p_attribute3 IN varchar2 := NULL,
43 p_attribute4 IN varchar2 := NULL,
44 p_attribute5 IN varchar2 := NULL,
45 p_attribute6 IN varchar2 := NULL,
46 p_attribute7 IN varchar2 := NULL,
47 p_attribute8 IN varchar2 := NULL,
48 p_attribute9 IN varchar2 := NULL,
49 p_attribute10 IN varchar2 := NULL,
50 p_attribute11 IN varchar2 := NULL,
51 p_attribute12 IN varchar2 := NULL,
52 p_attribute13 IN varchar2 := NULL,
53 p_attribute14 IN varchar2 := NULL,
54 p_attribute15 IN varchar2 := NULL,
55 x_return_status OUT NOCOPY varchar2,
56 x_msg_count OUT NOCOPY number,
57 x_msg_data OUT NOCOPY varchar2
58 );
59
60 -- This procedure validates the transaction details
61
62 PROCEDURE validate_txn(
63
64 p_api_version IN number := 1.0,
65 p_init_msg_list IN varchar2 := fnd_api.g_false,
66 p_validation_level IN number := fnd_api.g_valid_level_full,
67 p_txn_date IN date := sysdate,
68 p_txn_type IN number,
69 p_instance_id IN number,
70 p_operable_flag IN number,
71 p_employee_id IN number,
72 x_return_status OUT NOCOPY varchar2,
73 x_msg_count OUT NOCOPY number,
74 x_msg_data OUT NOCOPY varchar2
75
76 );
77
78
79 --This procedure accepts the transaction details from CheckIn/CheckOut UI
80
81 PROCEDURE process_checkinout_txn(
82
83 p_api_version IN number := 1.0,
84 p_init_msg_list IN varchar2 := fnd_api.g_false,
85 p_commit IN varchar2 := fnd_api.g_false,
86 p_validation_level IN number := fnd_api.g_valid_level_full,
87 p_txn_date IN date := sysdate,
88 p_txn_type IN number,
89 p_instance_id IN number,
90 p_comments IN varchar2 := NULL,
91 p_qa_collection_id IN number := NULL,
92 p_operable_flag IN number,
93 p_employee_id IN number,
94 p_attribute_category IN varchar2 := NULL,
95 p_attribute1 IN varchar2 := NULL,
96 p_attribute2 IN varchar2 := NULL,
97 p_attribute3 IN varchar2 := NULL,
98 p_attribute4 IN varchar2 := NULL,
99 p_attribute5 IN varchar2 := NULL,
100 p_attribute6 IN varchar2 := NULL,
101 p_attribute7 IN varchar2 := NULL,
102 p_attribute8 IN varchar2 := NULL,
103 p_attribute9 IN varchar2 := NULL,
104 p_attribute10 IN varchar2 := NULL,
105 p_attribute11 IN varchar2 := NULL,
106 p_attribute12 IN varchar2 := NULL,
107 p_attribute13 IN varchar2 := NULL,
108 p_attribute14 IN varchar2 := NULL,
109 p_attribute15 IN varchar2 := NULL,
110 x_return_status OUT NOCOPY varchar2,
111 x_msg_count OUT NOCOPY number,
112 x_msg_data OUT NOCOPY varchar2
113 );
114
115 -- This Procedure calls the quality api to insert quality plans
116
117 PROCEDURE insert_quality_plans
118 (
119
120 p_eam_ops_quality_tbl IN eam_asset_operation_txn_pub.eam_quality_tbl_type,
121 p_instance_id IN number,
122 p_txn_date IN date,
123 p_comments IN varchar2,
124 p_operable_flag IN number,
125 p_organization_id IN number,
126 p_employee_id IN number,
127 p_asset_group_id IN number,
128 p_asset_number IN varchar2,
129 p_asset_instance_number IN varchar2,
130 p_txn_number IN number,
131 x_return_status OUT NOCOPY varchar2,
132 x_msg_count OUT NOCOPY number,
133 x_msg_data OUT NOCOPY varchar2
134 );
135
136
137 -- This Procedure calls the meter reading api to insert meter readings
138
139 PROCEDURE insert_meter_readings
140 (
141 p_eam_meter_reading_tbl IN eam_asset_operation_txn_pub.meter_reading_rec_tbl_type,
142 p_counter_properties_tbl IN eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl,
143 p_instance_id IN number,
144 p_txn_id IN number,
145 x_return_status OUT NOCOPY varchar2,
146 x_msg_count OUT NOCOPY number,
147 x_msg_data OUT NOCOPY varchar2
148
149 );
150
151
152
153 END EAM_ASSET_OPERATION_TXN_PVT;