eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_ASSET_MOVE_PKG dependencies on CSI_ASSET_PVT

Line 689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;

685: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
686: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
687: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;
689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
690: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
691: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
692: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
693:

Line 690: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;

686: l_dest_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
687: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;
689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
690: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
691: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
692: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
693:
694: ---Local variables only for this spec.

Line 691: l_lookup_tbl csi_asset_pvt.lookup_tbl ;

687: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;
689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
690: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
691: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
692: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
693:
694: ---Local variables only for this spec.
695: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

Line 692: l_asset_count_rec csi_asset_pvt.asset_count_rec ;

688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;
689: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
690: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
691: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
692: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
693:
694: ---Local variables only for this spec.
695: l_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
696: l_csi_txn_rec csi_datastructures_pub.transaction_rec ;

Line 739: debug('Calling csi_asset_pvt.update_instance_asset');

735: IF l_inst_asset_rec.asset_quantity <= 0 THEN
736: l_inst_asset_rec.active_end_date := sysdate;
737: END IF;
738:
739: debug('Calling csi_asset_pvt.update_instance_asset');
740:
741: csi_asset_pvt.update_instance_asset (
742: p_api_version => 1.0,
743: p_commit => fnd_api.g_false,

Line 741: csi_asset_pvt.update_instance_asset (

737: END IF;
738:
739: debug('Calling csi_asset_pvt.update_instance_asset');
740:
741: csi_asset_pvt.update_instance_asset (
742: p_api_version => 1.0,
743: p_commit => fnd_api.g_false,
744: p_init_msg_list => fnd_api.g_false,
745: p_validation_level => fnd_api.g_valid_level_full,

Line 771: debug('Inside API csi_asset_pvt.get_instance_assets');

767: l_dest_inst_asset_query_rec.fa_asset_id := l_inst_asset_rec.fa_asset_id;
768: l_dest_inst_asset_query_rec.fa_location_id := l_inst_asset_rec.fa_location_id;
769: l_dest_inst_asset_query_rec.fa_book_type_code := l_inst_asset_rec.fa_book_type_code;
770:
771: debug('Inside API csi_asset_pvt.get_instance_assets');
772:
773: csi_asset_pvt.get_instance_assets(
774: p_api_version => 1.0,
775: p_commit => fnd_api.g_false,

Line 773: csi_asset_pvt.get_instance_assets(

769: l_dest_inst_asset_query_rec.fa_book_type_code := l_inst_asset_rec.fa_book_type_code;
770:
771: debug('Inside API csi_asset_pvt.get_instance_assets');
772:
773: csi_asset_pvt.get_instance_assets(
774: p_api_version => 1.0,
775: p_commit => fnd_api.g_false,
776: p_init_msg_list => fnd_api.g_false,
777: p_validation_level => fnd_api.g_valid_level_full,

Line 803: debug('Inside API csi_asset_pvt.update_instance_asset');

799: l_dest_inst_asset_tbl(1).object_version_number := l_dest_inst_asset_header_tbl(1).object_version_number;
800: l_dest_inst_asset_tbl(1).active_end_date := p_inst_asset_rec.active_end_date;
801: l_dest_inst_asset_tbl(1).check_for_instance_expiry := fnd_api.g_false;
802:
803: debug('Inside API csi_asset_pvt.update_instance_asset');
804: debug(' instance_asset_id : '||l_dest_inst_asset_tbl(1).instance_asset_id);
805: debug(' instance_asset_qty : '||l_dest_inst_asset_tbl(1).asset_quantity);
806:
807: csi_asset_pvt.update_instance_asset (

Line 807: csi_asset_pvt.update_instance_asset (

803: debug('Inside API csi_asset_pvt.update_instance_asset');
804: debug(' instance_asset_id : '||l_dest_inst_asset_tbl(1).instance_asset_id);
805: debug(' instance_asset_qty : '||l_dest_inst_asset_tbl(1).asset_quantity);
806:
807: csi_asset_pvt.update_instance_asset (
808: p_api_version => 1.0,
809: p_commit => fnd_api.g_false,
810: p_init_msg_list => fnd_api.g_false,
811: p_validation_level => fnd_api.g_valid_level_full,

Line 840: debug('Inside API csi_asset_pvt.create_instance_asset');

836: l_dest_inst_asset_tbl(1).check_for_instance_expiry := fnd_api.G_FALSE ;
837: l_dest_inst_asset_tbl(1).fa_sync_flag := 'Y';
838: l_dest_inst_asset_tbl(1).fa_sync_validation_reqd := fnd_api.g_false;
839:
840: debug('Inside API csi_asset_pvt.create_instance_asset');
841: debug(' fa_asset_id : '||l_dest_inst_asset_tbl(1).fa_asset_id);
842: debug(' fa_book_type_code : '||l_dest_inst_asset_tbl(1).fa_book_type_code);
843: debug(' fa_location_id : '||l_dest_inst_asset_tbl(1).fa_location_id);
844: debug(' instance_asset_qty : '||l_dest_inst_asset_tbl(1).asset_quantity);

Line 846: csi_asset_pvt.create_instance_asset (

842: debug(' fa_book_type_code : '||l_dest_inst_asset_tbl(1).fa_book_type_code);
843: debug(' fa_location_id : '||l_dest_inst_asset_tbl(1).fa_location_id);
844: debug(' instance_asset_qty : '||l_dest_inst_asset_tbl(1).asset_quantity);
845:
846: csi_asset_pvt.create_instance_asset (
847: p_api_version => 1.0,
848: p_commit => fnd_api.g_false,
849: p_init_msg_list => fnd_api.g_false,
850: p_validation_level => fnd_api.g_valid_level_full,

Line 2649: l_asset_count_rec csi_asset_pvt.asset_count_rec ;

2645: l_adj_units NUMBER ;
2646: l_units_to_be_adjusted NUMBER ;
2647: l_asset_units_avail NUMBER ;
2648: l_src_txn_object_ver_num NUMBER ;
2649: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
2650: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
2651: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
2652: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
2653: l_error_msg VARCHAR2(2000);

Line 2650: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;

2646: l_units_to_be_adjusted NUMBER ;
2647: l_asset_units_avail NUMBER ;
2648: l_src_txn_object_ver_num NUMBER ;
2649: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
2650: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
2651: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
2652: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
2653: l_error_msg VARCHAR2(2000);
2654: e_error EXCEPTION ;

Line 2651: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;

2647: l_asset_units_avail NUMBER ;
2648: l_src_txn_object_ver_num NUMBER ;
2649: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
2650: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
2651: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
2652: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
2653: l_error_msg VARCHAR2(2000);
2654: e_error EXCEPTION ;
2655:

Line 2652: l_lookup_tbl csi_asset_pvt.lookup_tbl ;

2648: l_src_txn_object_ver_num NUMBER ;
2649: l_asset_count_rec csi_asset_pvt.asset_count_rec ;
2650: l_asset_id_tbl csi_asset_pvt.asset_id_tbl ;
2651: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl ;
2652: l_lookup_tbl csi_asset_pvt.lookup_tbl ;
2653: l_error_msg VARCHAR2(2000);
2654: e_error EXCEPTION ;
2655:
2656: CURSOR src_misc_move_trans_cur

Line 2847: csi_asset_pvt.update_instance_asset (

2843: l_txn_rec.transaction_id := NULL ;
2844:
2845: debug ('Update Source Inst Asset');
2846: ---Update Source Instant Asset.
2847: csi_asset_pvt.update_instance_asset (
2848: p_api_version => 1.0
2849: ,p_commit => fnd_api.g_false
2850: ,p_init_msg_list => fnd_api.g_false
2851: ,p_validation_level => fnd_api.g_valid_level_full

Line 2901: csi_asset_pvt.get_instance_assets

2897: debug('Dest Instance ID : '||dest_misc_move_trans_rec.instance_id);
2898: debug('Dest FA Asset ID : '||instance_assets_rec.fa_asset_id );
2899: debug('Dest Book : '||instance_assets_rec.fa_book_type_code );
2900: debug('Dest FA Loc : '||instance_assets_rec.fa_location_id );
2901: csi_asset_pvt.get_instance_assets
2902: (l_api_Version,
2903: l_commit,
2904: l_init_msg_list,
2905: l_validation_Level,

Line 2939: csi_asset_pvt.update_instance_asset (

2935: ---l_txn_rec.transaction_id := NULL ;
2936: l_dest_inst_asset_rec.object_version_number := l_dest_inst_asset_header_tbl(1).object_version_number ;
2937: l_dest_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
2938:
2939: csi_asset_pvt.update_instance_asset (
2940: p_api_version => 1.0
2941: ,p_commit => fnd_api.g_false
2942: ,p_init_msg_list => fnd_api.g_false
2943: ,p_validation_level => fnd_api.g_valid_level_full

Line 2989: csi_asset_pvt.create_instance_asset (

2985: debug('Dest FA Loc : '||l_dest_inst_asset_rec.fa_location_id );
2986: debug ('Calling Create_inst_asset');
2987:
2988: --l_txn_rec.transaction_id := NULL ;
2989: csi_asset_pvt.create_instance_asset (
2990: p_api_version => 1.0
2991: ,p_commit => fnd_api.g_false
2992: ,p_init_msg_list => fnd_api.g_false
2993: ,p_validation_level => fnd_api.g_valid_level_full