APPS.CSE_FA_TXN_PKG dependencies on CSI_ASSET_PVT

Line 190: l_lookup_tbl csi_asset_pvt.lookup_tbl;

186: px_inst_asset_rec IN OUT nocopy csi_datastructures_pub.instance_asset_rec,
187: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
188: x_return_status OUT nocopy varchar2)
189: IS
190: l_lookup_tbl csi_asset_pvt.lookup_tbl;
191: l_asset_count_rec csi_asset_pvt.asset_count_rec;
192: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
193: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
194:

Line 191: l_asset_count_rec csi_asset_pvt.asset_count_rec;

187: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
188: x_return_status OUT nocopy varchar2)
189: IS
190: l_lookup_tbl csi_asset_pvt.lookup_tbl;
191: l_asset_count_rec csi_asset_pvt.asset_count_rec;
192: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
193: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
194:
195: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 192: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

188: x_return_status OUT nocopy varchar2)
189: IS
190: l_lookup_tbl csi_asset_pvt.lookup_tbl;
191: l_asset_count_rec csi_asset_pvt.asset_count_rec;
192: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
193: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
194:
195: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
196: l_msg_count number;

Line 193: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

189: IS
190: l_lookup_tbl csi_asset_pvt.lookup_tbl;
191: l_asset_count_rec csi_asset_pvt.asset_count_rec;
192: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
193: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
194:
195: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
196: l_msg_count number;
197: l_msg_data varchar2(2000);

Line 203: csi_asset_pvt.create_instance_asset(

199: x_return_status := fnd_api.g_ret_sts_success;
200:
201: px_inst_asset_rec.fa_sync_flag := 'Y';
202:
203: csi_asset_pvt.create_instance_asset(
204: p_api_version => 1.0 ,
205: p_commit => fnd_api.g_false,
206: p_init_msg_list => fnd_api.g_true,
207: p_validation_level => fnd_api.g_valid_level_full,

Line 233: l_lookup_tbl csi_asset_pvt.lookup_tbl;

229: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
230: x_return_status OUT nocopy varchar2)
231: IS
232:
233: l_lookup_tbl csi_asset_pvt.lookup_tbl;
234: l_asset_count_rec csi_asset_pvt.asset_count_rec;
235: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
236: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
237:

Line 234: l_asset_count_rec csi_asset_pvt.asset_count_rec;

230: x_return_status OUT nocopy varchar2)
231: IS
232:
233: l_lookup_tbl csi_asset_pvt.lookup_tbl;
234: l_asset_count_rec csi_asset_pvt.asset_count_rec;
235: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
236: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
237:
238: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 235: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

231: IS
232:
233: l_lookup_tbl csi_asset_pvt.lookup_tbl;
234: l_asset_count_rec csi_asset_pvt.asset_count_rec;
235: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
236: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
237:
238: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
239: l_msg_count number;

Line 236: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

232:
233: l_lookup_tbl csi_asset_pvt.lookup_tbl;
234: l_asset_count_rec csi_asset_pvt.asset_count_rec;
235: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
236: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
237:
238: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
239: l_msg_count number;
240: l_msg_data varchar2(2000);

Line 254: csi_asset_pvt.update_instance_asset (

250: INTO px_inst_asset_rec.object_version_number
251: FROM csi_i_assets
252: WHERE instance_asset_id = px_inst_asset_rec.instance_asset_id;
253:
254: csi_asset_pvt.update_instance_asset (
255: p_api_version => 1.0,
256: p_commit => fnd_api.g_false,
257: p_init_msg_list => fnd_api.g_true,
258: p_validation_level => fnd_api.g_valid_level_full,

Line 324: csi_asset_pvt.get_instance_assets(

320: l_inst_asset_qry_rec.fa_book_type_code := p_inst_asset_rec.fa_book_type_code;
321: l_inst_asset_qry_rec.fa_location_id := p_inst_asset_rec.fa_location_id;
322: l_inst_asset_qry_rec.update_status := 'IN_SERVICE';
323:
324: csi_asset_pvt.get_instance_assets(
325: p_api_version => 1.0,
326: p_commit => fnd_api.g_false,
327: p_init_msg_list => fnd_api.g_true,
328: p_validation_level => fnd_api.g_valid_level_full,

Line 451: l_lookup_tbl csi_asset_pvt.lookup_tbl;

447: x_return_status OUT nocopy varchar2)
448: IS
449: l_old_asset_qty number;
450: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
451: l_lookup_tbl csi_asset_pvt.lookup_tbl;
452: l_asset_count_rec csi_asset_pvt.asset_count_rec;
453: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
454: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
455:

Line 452: l_asset_count_rec csi_asset_pvt.asset_count_rec;

448: IS
449: l_old_asset_qty number;
450: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
451: l_lookup_tbl csi_asset_pvt.lookup_tbl;
452: l_asset_count_rec csi_asset_pvt.asset_count_rec;
453: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
454: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
455:
456: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 453: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;

449: l_old_asset_qty number;
450: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
451: l_lookup_tbl csi_asset_pvt.lookup_tbl;
452: l_asset_count_rec csi_asset_pvt.asset_count_rec;
453: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
454: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
455:
456: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
457: l_msg_count number;

Line 454: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;

450: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec;
451: l_lookup_tbl csi_asset_pvt.lookup_tbl;
452: l_asset_count_rec csi_asset_pvt.asset_count_rec;
453: l_asset_id_tbl csi_asset_pvt.asset_id_tbl;
454: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
455:
456: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
457: l_msg_count number;
458: l_msg_data varchar2(2000);

Line 535: csi_asset_pvt.get_instance_assets(

531: l_inst_asset_qry_rec.fa_asset_id := p_asset_id;
532: l_inst_asset_qry_rec.fa_book_type_code := p_book_type_code;
533: l_inst_asset_qry_rec.update_status := 'IN_SERVICE';
534:
535: csi_asset_pvt.get_instance_assets(
536: p_api_version => 1.0,
537: p_commit => fnd_api.g_false,
538: p_init_msg_list => fnd_api.g_true,
539: p_validation_level => fnd_api.g_valid_level_full,

Line 674: csi_asset_pvt.get_instance_assets(

670: l_inst_asset_qry_rec.fa_book_type_code := p_book_type_code;
671: l_inst_asset_qry_rec.update_status := 'RETIRED';
672: l_inst_asset_qry_rec.fa_location_id := dist_rec.location_id;
673:
674: csi_asset_pvt.get_instance_assets(
675: p_api_version => 1.0,
676: p_commit => fnd_api.g_false,
677: p_init_msg_list => fnd_api.g_true,
678: p_validation_level => fnd_api.g_valid_level_full,