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 CSE_DATASTRUCTURES_PUB

Line 5: g_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec ;

1: PACKAGE BODY cse_asset_move_pkg AS
2: /* $Header: CSEFAMVB.pls 120.44.12020000.7 2013/02/01 10:51:47 mvaradam ship $ */
3:
4: l_debug varchar2(1) := NVL(fnd_profile.value('CSE_DEBUG_OPTION'),'N');
5: g_asset_attrib_rec cse_datastructures_pub.asset_attrib_rec ;
6:
7: TYPE fa_inst_dtls_rec IS RECORD (
8: transaction_id NUMBER,
9: instance_id NUMBER,

Line 277: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

273: l_txn_rec := cse_util_pkg.init_txn_rec;
274: l_txn_rec.transaction_id := p_src_move_trans_tbl(1).transaction_id ;
275: l_txn_rec.source_group_ref_id := p_conc_request_id;
276:
277: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
278: --For Intransit InterOrg Transfers, source txn can have multiple
279: --dest transactions, in this case we will be updating source
280: --txn multiple times , so get the latest object version.
281:

Line 341: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

337: l_txn_rec := cse_util_pkg.init_txn_rec;
338: l_txn_rec.transaction_id := p_dest_move_trans_tbl(j).transaction_id ;
339: l_txn_rec.source_group_ref_id := p_conc_request_id;
340:
341: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
342:
343: l_txn_rec.object_version_number:= p_dest_move_trans_tbl(j).object_version_number ;
344:
345: debug('Inside API csi_transactions_pvt.update_transactions');

Line 688: l_dest_asset_tbl cse_datastructures_pub.asset_query_tbl;

684: --Specific to the API's here
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 ;

Line 765: l_dest_inst_asset_query_rec.update_status := cse_datastructures_pub.g_in_service;

761:
762: --Call get_inst_asset API
763: l_dest_inst_asset_query_rec := cse_util_pkg.init_instance_asset_query_rec;
764:
765: l_dest_inst_asset_query_rec.update_status := cse_datastructures_pub.g_in_service;
766: l_dest_inst_asset_query_rec.instance_id := l_inst_asset_rec.instance_id;
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;

Line 828: l_dest_inst_asset_tbl(1).update_status := cse_datastructures_pub.G_IN_SERVICE ;

824: RAISE fnd_api.g_exc_error;
825: END IF;
826: ELSE
827: ---Create a new destination Instance
828: l_dest_inst_asset_tbl(1).update_status := cse_datastructures_pub.G_IN_SERVICE ;
829: l_dest_inst_asset_tbl(1).object_version_number := 1 ;
830: l_dest_inst_asset_tbl(1).instance_id := l_inst_asset_rec.instance_id ;
831: l_dest_inst_asset_tbl(1).fa_asset_id := l_inst_asset_rec.fa_asset_id ;
832: l_dest_inst_asset_tbl(1).fa_location_id := l_inst_asset_rec.fa_location_id ;

Line 880: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,

876:
877: PROCEDURE do_dist_transfer (
878: p_src_fa_inst_dtls_rec IN fa_inst_dtls_rec,
879: p_dest_move_trans_rec IN move_trans_rec,
880: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,
881: p_transaction_units IN NUMBER,
882: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
883: x_return_status OUT NOCOPY VARCHAR2,
884: x_error_msg OUT NOCOPY VARCHAR2 )

Line 900: l_asset_attrib_rec CSE_DATASTRUCTURES_PUB.asset_attrib_rec;

896: l_upd_csi_i_assets VARCHAR2(1);
897: l_hook_used number;
898: l_fnd_success VARCHAR2(1);
899: l_fnd_error VARCHAR2(1);
900: l_asset_attrib_rec CSE_DATASTRUCTURES_PUB.asset_attrib_rec;
901:
902: temp_str VARCHAR2(512);
903: l_src_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;
904: l_dest_inst_asset_rec csi_datastructures_pub.instance_asset_rec ;

Line 1080: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,

1076: PROCEDURE do_inter_asset_transfer(
1077: p_src_fa_inst_dtls_rec IN fa_inst_dtls_rec,
1078: p_dest_move_trans_rec IN move_trans_rec,
1079: p_dest_fa_rec IN fa_rec,
1080: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,
1081: p_transaction_units IN NUMBER,
1082: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1083: x_return_status OUT NOCOPY VARCHAR2,
1084: x_error_msg OUT NOCOPY VARCHAR2)

Line 1230: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;

1226: l_msg_count NUMBER;
1227: l_trx_error_rec csi_datastructures_pub.transaction_error_rec ;
1228: l_txn_error_id NUMBER ;
1229: l_mass_add_rec fa_mass_additions%ROWTYPE ;
1230: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
1231:
1232: BEGIN
1233:
1234: x_return_status := l_fnd_success ;

Line 2089: l_dest_fa_dist_rec cse_datastructures_pub.distribution_rec;

2085: l_src_transaction_id NUMBER;
2086: l_src_fa_inst_dtls_tbl src_fa_inst_dtls_tbl;
2087:
2088: l_dest_fa_rec fa_rec;
2089: l_dest_fa_dist_rec cse_datastructures_pub.distribution_rec;
2090: l_dest_trans_cnt number;
2091: l_dest_txn_qty number;
2092: l_hook_used pls_integer;
2093: l_dest_fa_book_type_code varchar2(15);

Line 2133: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;

2129: l_txn_rec.source_transaction_date := l_sysdate;
2130: l_txn_rec.transaction_date := l_sysdate;
2131: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2132: l_txn_rec.transaction_quantity := 1;
2133: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2134: l_txn_rec.source_header_ref := 'CSI_TXN_ID';
2135: l_txn_rec.source_header_ref_id := p_transaction_id;
2136: l_txn_rec.object_version_number := 1;
2137:

Line 2499: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;

2495:
2496: l_txn_rec.transaction_id := p_csi_txn_id;
2497: l_txn_rec.source_group_ref := fnd_api.g_miss_char;
2498: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
2499: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
2500:
2501: SELECT object_version_number
2502: INTO l_txn_rec.object_version_number
2503: FROM csi_transactions

Line 2623: l_dest_asset_query_rec cse_datastructures_pub.asset_query_rec ;

2619: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2620: l_dest_num_of_rows NUMBER;
2621: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
2622: l_dest_transaction_type_id NUMBER;
2623: l_dest_asset_query_rec cse_datastructures_pub.asset_query_rec ;
2624: e_goto_next_trans EXCEPTION;
2625: l_commit VARCHAR2(1) ;
2626: l_init_msg_list VARCHAR2(1) ;
2627: l_validation_level NUMBER ;

Line 2644: l_distribution_tbl cse_datastructures_pub.distribution_tbl ;

2640: l_time_stamp DATE ;
2641: l_move_processed_flag VARCHAR2(1) ;
2642: l_inst_asset_failed VARCHAR2(1) ;
2643: l_return_status VARCHAR2(1) ;
2644: l_distribution_tbl cse_datastructures_pub.distribution_tbl ;
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 ;

Line 2671: AND citdv.transaction_status_code = cse_datastructures_pub.G_PENDING

2667: FROM csi_inst_txn_details_v citdv,
2668: csi_item_instances_h ciih
2669: WHERE citdv.transaction_id = ciih.transaction_id
2670: AND citdv.instance_id = ciih.instance_id
2671: AND citdv.transaction_status_code = cse_datastructures_pub.G_PENDING
2672: AND NVL(ciih.old_quantity,0) > NVL(ciih.new_quantity,0)
2673: AND citdv.transaction_id = p_transaction_id
2674: AND citdv.serial_number is NULL
2675: --ORDER BY 1 ;

Line 2689: WHERE citdv.transaction_status_code = cse_datastructures_pub.G_PENDING

2685: ,citdv.inv_material_transaction_id
2686: ,citdv.source_transaction_type
2687: ,citdv.object_version_number
2688: FROM csi_inst_txn_details_v citdv
2689: WHERE citdv.transaction_status_code = cse_datastructures_pub.G_PENDING
2690: AND citdv.transaction_id = p_transaction_id
2691: AND citdv.serial_number is NOT NULL
2692: --ORDER BY 1 ;
2693: ORDER BY citdv.creation_date ;

Line 2839: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

2835: l_src_inst_asset_rec.instance_asset_id := instance_assets_rec.instance_asset_id ;
2836: l_src_inst_asset_rec.asset_quantity := instance_assets_rec.asset_quantity - l_adj_units ;
2837: l_src_inst_asset_rec.object_version_number := instance_assets_rec.object_version_number ;
2838: l_src_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
2839: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2840: l_txn_rec.transaction_date := l_sysdate;
2841: l_txn_rec.source_transaction_date := l_sysdate;
2842: l_txn_rec.object_version_number := 1 ;
2843: l_txn_rec.transaction_id := NULL ;

Line 2886: l_dest_inst_asset_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;

2882: RAISE e_goto_next_trans ;
2883: END IF ;
2884: CLOSE dest_misc_move_trans_cur ;
2885:
2886: l_dest_inst_asset_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;
2887: l_dest_inst_asset_rec.instance_id := dest_misc_move_trans_rec.instance_id ;
2888: l_dest_inst_asset_rec.fa_asset_id := instance_assets_rec.fa_asset_id ;
2889: l_dest_inst_asset_rec.fa_book_type_code := instance_assets_rec.fa_book_type_code ;
2890: l_dest_inst_asset_rec.fa_location_id := instance_assets_rec.fa_location_id ;

Line 2891: l_dest_inst_asset_query_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;

2887: l_dest_inst_asset_rec.instance_id := dest_misc_move_trans_rec.instance_id ;
2888: l_dest_inst_asset_rec.fa_asset_id := instance_assets_rec.fa_asset_id ;
2889: l_dest_inst_asset_rec.fa_book_type_code := instance_assets_rec.fa_book_type_code ;
2890: l_dest_inst_asset_rec.fa_location_id := instance_assets_rec.fa_location_id ;
2891: l_dest_inst_asset_query_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;
2892: l_dest_inst_asset_query_rec.instance_id := dest_misc_move_trans_rec.instance_id ;
2893: l_dest_inst_asset_query_rec.fa_asset_id := instance_assets_rec.fa_asset_id ;
2894: l_dest_inst_asset_query_rec.fa_book_type_code := instance_assets_rec.fa_book_type_code ;
2895: l_dest_inst_asset_query_rec.fa_location_id := instance_assets_rec.fa_location_id ;

Line 2931: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

2927: l_txn_rec.transaction_quantity := l_adj_units ;
2928: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2929: l_dest_inst_asset_rec.asset_quantity := l_dest_inst_asset_header_tbl(1).asset_quantity + l_adj_units ;
2930: l_dest_inst_asset_rec.instance_asset_id := l_dest_inst_asset_header_tbl(1).instance_asset_id ;
2931: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2932: l_txn_rec.transaction_date := l_sysdate;
2933: l_txn_rec.source_transaction_date := l_sysdate;
2934: l_txn_rec.object_version_number := 1 ;
2935: ---l_txn_rec.transaction_id := NULL ;

Line 2967: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;

2963: l_txn_rec := cse_util_pkg.init_txn_rec;
2964: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2965: l_txn_rec.transaction_quantity := l_adj_units ;
2966: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2967: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2968: l_txn_rec.transaction_date := l_sysdate;
2969: l_txn_rec.source_transaction_date := l_sysdate;
2970: l_txn_rec.object_version_number := 1;
2971:

Line 2973: l_dest_inst_asset_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;

2969: l_txn_rec.source_transaction_date := l_sysdate;
2970: l_txn_rec.object_version_number := 1;
2971:
2972: ---other attributes of inst_asset have already been set in query
2973: l_dest_inst_asset_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;
2974: l_dest_inst_asset_rec.object_version_number := 1 ;
2975: l_dest_inst_asset_rec.active_start_date := l_sysdate;
2976: l_dest_inst_asset_rec.asset_quantity := l_adj_units ;
2977: l_dest_inst_asset_rec.instance_asset_id := NULL ;

Line 3030: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

3026: l_txn_rec := cse_util_pkg.init_txn_rec;
3027: l_txn_rec.transaction_id := l_src_transaction_id ;
3028: l_txn_rec.source_group_ref_id := p_conc_request_id;
3029:
3030: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3031:
3032: l_txn_rec.object_version_number := l_src_txn_object_ver_num ;
3033:
3034: csi_transactions_pvt.update_transactions(

Line 3062: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

3058: l_txn_rec := cse_util_pkg.init_txn_rec;
3059: l_txn_rec.transaction_id := dest_misc_move_trans_rec.transaction_id ;
3060: l_txn_rec.source_group_ref_id := p_conc_request_id;
3061:
3062: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3063:
3064: l_txn_rec.object_version_number:= dest_misc_move_trans_rec.object_version_number ;
3065:
3066: csi_transactions_pvt.update_transactions(

Line 3178: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

3174: l_txn_rec := cse_util_pkg.init_txn_rec;
3175: l_txn_rec.transaction_id := serial_move_trans_rec.transaction_id ;
3176: l_txn_rec.source_group_ref_id := p_conc_request_id;
3177:
3178: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3179:
3180: l_txn_rec.object_version_number := serial_move_trans_rec.object_version_number ;
3181:
3182: csi_transactions_pvt.update_transactions(