1 PACKAGE CSI_MASS_EDIT_PVT AUTHID CURRENT_USER as
2 /* $Header: csivmees.pls 120.5.12010000.2 2008/11/06 20:33:06 mashah ship $ */
3 -- Start of Comments
4 -- Package name : CSI_MASS_EDIT_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 g_entry_id NUMBER;
11 g_batch_name VARCHAR2(50);
12
13 TYPE NumTabType is varray(10000) of number;
14 TYPE Char30TabType is varray(10000) of varchar2(30);
15 TYPE DateTabType is varray(10000) of date;
16
17 PROCEDURE CREATE_MASS_EDIT_BATCH
18 (
19 p_api_version IN NUMBER,
20 p_commit IN VARCHAR2 := fnd_api.g_false,
21 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
22 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
23 px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
24 px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
25 px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
26 px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
27 px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
28 px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
29 px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
30 x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2
34
35 );
36
37
38 PROCEDURE update_mass_edit_batch (
39 p_api_version IN NUMBER,
40 p_commit IN VARCHAR2 := fnd_api.g_false,
41 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
42 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
43 px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
44 px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
45 px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
46 px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
47 px_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
48 px_txn_pty_acct_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
49 px_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
50 x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54
55 PROCEDURE DELETE_MASS_EDIT_BATCH
56 (
57 p_api_version IN NUMBER,
58 p_commit IN VARCHAR2 := fnd_api.g_false,
59 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
60 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
61 p_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65
66 );
67
68
69 PROCEDURE GET_MASS_EDIT_DETAILS (
70 p_api_version IN NUMBER,
71 p_commit IN VARCHAR2 := fnd_api.g_false,
72 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
73 p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
74 px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
75 x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
76 x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
77 x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
78 x_txn_ext_attrib_vals_tbl OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER ,
81 x_msg_data OUT NOCOPY VARCHAR2);
82
83 -- Validate the batch ID /Name
84 FUNCTION Is_valid_batch (
85 p_batch_name IN VARCHAR2,
86 p_batch_id IN NUMBER,
87 x_mass_edit_rec OUT NOCOPY csi_mass_edit_pub.mass_edit_rec)
88 RETURN BOOLEAN;
89
90 --validate the uniqueness of the batch name
91 PROCEDURE validate_batch_name(
92 p_batch_name IN VARCHAR2,
93 p_api_name IN VARCHAR2 ,
94 x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
95
96 --validate batchtype
97 PROCEDURE validate_batch_type(
98 p_batch_type IN VARCHAR2,
99 p_api_name IN VARCHAR2,
100 x_sub_type_id OUT NOCOPY NUMBER ,
101 x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
102
103 --validate batch status
104 PROCEDURE validate_batch_status
105 (p_batch_id IN NUMBER ,
106 x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
107
108 --Procedure to validate the mass update batch
109 PROCEDURE validate_batch (px_mass_edit_rec IN csi_mass_edit_pub.mass_edit_rec,
110 p_mode IN VARCHAR2,
111 x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl,
112 x_return_status OUT NOCOPY VARCHAR2);
113
114 PROCEDURE log_mu_error (
115 p_index IN NUMBER,
116 p_instance_id IN NUMBER,
117 p_txn_line_detail_id IN NUMBER,
118 p_error_code IN VARCHAR2,
119 x_mass_edit_error_tbl OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
120
121 PROCEDURE vld_item_instance_active (p_instance_id_tab IN NumTabType,
122 p_txn_line_detail_id_tab IN NumTabType,
123 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
124
125 PROCEDURE vld_batch_inst_same_owner(p_txn_line_id_tab IN NumTabType,
126 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
127
128 PROCEDURE vld_batch_inst_curr_owner (p_txn_line_id_tab IN NumTabType,
129 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
130
131 PROCEDURE vld_child_inst_location(p_instance_id_tab IN NumTabType,
132 p_txn_line_detail_id_tab IN NumTabType,
133 p_instance_usage_code_tab IN Char30TabType,
134 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
135
136 PROCEDURE vld_item_inst_location(p_instance_id_tab IN NumTabType,
137 p_txn_line_id_tab IN NumTabType,
138 p_location_type_code_tab IN Char30TabType,
139 p_location_id_tab IN NumTabType,
140 p_install_location_id_tab IN NumTabType,
141 p_instance_status_id_tab IN NumTabType,
142 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
143
144 PROCEDURE check_item_inst_loc_changed(p_txn_line_detail_id_tab IN NumTabType,
145 p_instance_id_tab IN NumTabType,
146 p_install_location_id_tab IN NumTabType,
147 p_location_id_tab IN NumTabType,
148 p_instance_status_id_tab IN NumTabType,
149 p_external_reference_tab IN Char30TabType,
150 p_install_date_tab IN DateTabType,
151 p_system_id_tab IN NumTabType,
152 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
153
154 PROCEDURE vld_xfer_date(p_txn_line_id_tab IN NumTabType,
155 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
156
157 PROCEDURE vld_term_date(p_txn_line_id_tab IN NumTabType,
158 px_mass_edit_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_error_tbl);
159
160 /*----------------------------------------------------*/
161 /* Procedure name: VLD_SYSTEM_ACTIVE */
162 /* Description : procedure to validate whether the */
163 /* system is active or not */
164 /*----------------------------------------------------*/
165 PROCEDURE VLD_SYSTEM_ACTIVE(
166 p_system_id IN NUMBER ,
167 p_txn_line_id IN NUMBER,
168 p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);
169
170
171 /*----------------------------------------------------*/
172 /* Procedure name: VLD_SYSTEM_CURRENT_OWNER */
173 /* Description : procedure to validate current system owner */
174 /* system is active or not */
175 /*----------------------------------------------------*/
176 PROCEDURE VLD_SYSTEM_CURRENT_OWNER(
177 p_system_id IN NUMBER ,
178 p_customer_id IN NUMBER,
179 p_txn_line_id IN NUMBER,
180 p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);
181
182 /*----------------------------------------------------*/
183 /* Procedure name: VLD_SYSTEM_LOCATION_CHGD */
184 /* Description : procedure to validate whether the location */
185 /* and contact info changed */
186 /*----------------------------------------------------*/
187 PROCEDURE VLD_SYSTEM_LOCATION_CHGD(
188 p_system_id IN NUMBER ,
189 p_txn_line_id IN NUMBER,
190 p_mu_sys_error_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_sys_error_tbl);
191
192 End CSI_MASS_EDIT_PVT;