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.35.12010000.1 2008/07/30 05:17:31 appldev 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 1065: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,

1061: PROCEDURE do_inter_asset_transfer(
1062: p_src_fa_inst_dtls_rec IN fa_inst_dtls_rec,
1063: p_dest_move_trans_rec IN move_trans_rec,
1064: p_dest_fa_rec IN fa_rec,
1065: p_dest_fa_dist_rec IN cse_datastructures_pub.distribution_rec,
1066: p_transaction_units IN NUMBER,
1067: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1068: x_return_status OUT NOCOPY VARCHAR2,
1069: x_error_msg OUT NOCOPY VARCHAR2)

Line 1215: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;

1211: l_msg_count NUMBER;
1212: l_trx_error_rec csi_datastructures_pub.transaction_error_rec ;
1213: l_txn_error_id NUMBER ;
1214: l_mass_add_rec fa_mass_additions%ROWTYPE ;
1215: l_asset_query_rec cse_datastructures_pub.asset_query_rec ;
1216:
1217: BEGIN
1218:
1219: x_return_status := l_fnd_success ;

Line 2026: l_dest_fa_dist_rec cse_datastructures_pub.distribution_rec;

2022: l_src_transaction_id NUMBER;
2023: l_src_fa_inst_dtls_tbl src_fa_inst_dtls_tbl;
2024:
2025: l_dest_fa_rec fa_rec;
2026: l_dest_fa_dist_rec cse_datastructures_pub.distribution_rec;
2027: l_dest_trans_cnt number;
2028: l_dest_txn_qty number;
2029: l_hook_used pls_integer;
2030: l_dest_fa_book_type_code varchar2(15);

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

2066: l_txn_rec.source_transaction_date := l_sysdate;
2067: l_txn_rec.transaction_date := l_sysdate;
2068: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2069: l_txn_rec.transaction_quantity := 1;
2070: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2071: l_txn_rec.source_header_ref := 'CSI_TXN_ID';
2072: l_txn_rec.source_header_ref_id := p_transaction_id;
2073: l_txn_rec.object_version_number := 1;
2074:

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

2416: x_return_status := fnd_api.g_ret_sts_success;
2417:
2418: l_txn_rec.transaction_id := p_csi_txn_id;
2419: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
2420: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
2421:
2422: SELECT object_version_number
2423: INTO l_txn_rec.object_version_number
2424: FROM csi_transactions

Line 2544: l_dest_asset_query_rec cse_datastructures_pub.asset_query_rec ;

2540: l_dest_inst_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2541: l_dest_num_of_rows NUMBER;
2542: l_dest_inst_asset_query_rec csi_datastructures_pub.instance_asset_query_rec ;
2543: l_dest_transaction_type_id NUMBER;
2544: l_dest_asset_query_rec cse_datastructures_pub.asset_query_rec ;
2545: e_goto_next_trans EXCEPTION;
2546: l_commit VARCHAR2(1) ;
2547: l_init_msg_list VARCHAR2(1) ;
2548: l_validation_level NUMBER ;

Line 2565: l_distribution_tbl cse_datastructures_pub.distribution_tbl ;

2561: l_time_stamp DATE ;
2562: l_move_processed_flag VARCHAR2(1) ;
2563: l_inst_asset_failed VARCHAR2(1) ;
2564: l_return_status VARCHAR2(1) ;
2565: l_distribution_tbl cse_datastructures_pub.distribution_tbl ;
2566: l_adj_units NUMBER ;
2567: l_units_to_be_adjusted NUMBER ;
2568: l_asset_units_avail NUMBER ;
2569: l_src_txn_object_ver_num NUMBER ;

Line 2592: AND citdv.transaction_status_code = cse_datastructures_pub.G_PENDING

2588: FROM csi_inst_txn_details_v citdv,
2589: csi_item_instances_h ciih
2590: WHERE citdv.transaction_id = ciih.transaction_id
2591: AND citdv.instance_id = ciih.instance_id
2592: AND citdv.transaction_status_code = cse_datastructures_pub.G_PENDING
2593: AND NVL(ciih.old_quantity,0) > NVL(ciih.new_quantity,0)
2594: AND citdv.transaction_id = p_transaction_id
2595: AND citdv.serial_number is NULL
2596: --ORDER BY 1 ;

Line 2610: WHERE citdv.transaction_status_code = cse_datastructures_pub.G_PENDING

2606: ,citdv.inv_material_transaction_id
2607: ,citdv.source_transaction_type
2608: ,citdv.object_version_number
2609: FROM csi_inst_txn_details_v citdv
2610: WHERE citdv.transaction_status_code = cse_datastructures_pub.G_PENDING
2611: AND citdv.transaction_id = p_transaction_id
2612: AND citdv.serial_number is NOT NULL
2613: --ORDER BY 1 ;
2614: ORDER BY citdv.creation_date ;

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

2756: l_src_inst_asset_rec.instance_asset_id := instance_assets_rec.instance_asset_id ;
2757: l_src_inst_asset_rec.asset_quantity := instance_assets_rec.asset_quantity - l_adj_units ;
2758: l_src_inst_asset_rec.object_version_number := instance_assets_rec.object_version_number ;
2759: l_src_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
2760: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2761: l_txn_rec.transaction_date := l_sysdate;
2762: l_txn_rec.source_transaction_date := l_sysdate;
2763: l_txn_rec.object_version_number := 1 ;
2764: l_txn_rec.transaction_id := NULL ;

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

2803: RAISE e_goto_next_trans ;
2804: END IF ;
2805: CLOSE dest_misc_move_trans_cur ;
2806:
2807: l_dest_inst_asset_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;
2808: l_dest_inst_asset_rec.instance_id := dest_misc_move_trans_rec.instance_id ;
2809: l_dest_inst_asset_rec.fa_asset_id := instance_assets_rec.fa_asset_id ;
2810: l_dest_inst_asset_rec.fa_book_type_code := instance_assets_rec.fa_book_type_code ;
2811: l_dest_inst_asset_rec.fa_location_id := instance_assets_rec.fa_location_id ;

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

2808: l_dest_inst_asset_rec.instance_id := dest_misc_move_trans_rec.instance_id ;
2809: l_dest_inst_asset_rec.fa_asset_id := instance_assets_rec.fa_asset_id ;
2810: l_dest_inst_asset_rec.fa_book_type_code := instance_assets_rec.fa_book_type_code ;
2811: l_dest_inst_asset_rec.fa_location_id := instance_assets_rec.fa_location_id ;
2812: l_dest_inst_asset_query_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;
2813: l_dest_inst_asset_query_rec.instance_id := dest_misc_move_trans_rec.instance_id ;
2814: l_dest_inst_asset_query_rec.fa_asset_id := instance_assets_rec.fa_asset_id ;
2815: l_dest_inst_asset_query_rec.fa_book_type_code := instance_assets_rec.fa_book_type_code ;
2816: l_dest_inst_asset_query_rec.fa_location_id := instance_assets_rec.fa_location_id ;

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

2848: l_txn_rec.transaction_quantity := l_adj_units ;
2849: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2850: l_dest_inst_asset_rec.asset_quantity := l_dest_inst_asset_header_tbl(1).asset_quantity + l_adj_units ;
2851: l_dest_inst_asset_rec.instance_asset_id := l_dest_inst_asset_header_tbl(1).instance_asset_id ;
2852: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2853: l_txn_rec.transaction_date := l_sysdate;
2854: l_txn_rec.source_transaction_date := l_sysdate;
2855: l_txn_rec.object_version_number := 1 ;
2856: ---l_txn_rec.transaction_id := NULL ;

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

2884: l_txn_rec := cse_util_pkg.init_txn_rec;
2885: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2886: l_txn_rec.transaction_quantity := l_adj_units ;
2887: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2888: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2889: l_txn_rec.transaction_date := l_sysdate;
2890: l_txn_rec.source_transaction_date := l_sysdate;
2891: l_txn_rec.object_version_number := 1;
2892:

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

2890: l_txn_rec.source_transaction_date := l_sysdate;
2891: l_txn_rec.object_version_number := 1;
2892:
2893: ---other attributes of inst_asset have already been set in query
2894: l_dest_inst_asset_rec.update_status := cse_datastructures_pub.G_IN_SERVICE ;
2895: l_dest_inst_asset_rec.object_version_number := 1 ;
2896: l_dest_inst_asset_rec.active_start_date := l_sysdate;
2897: l_dest_inst_asset_rec.asset_quantity := l_adj_units ;
2898: l_dest_inst_asset_rec.instance_asset_id := NULL ;

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

2947: l_txn_rec := cse_util_pkg.init_txn_rec;
2948: l_txn_rec.transaction_id := l_src_transaction_id ;
2949: l_txn_rec.source_group_ref_id := p_conc_request_id;
2950:
2951: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2952:
2953: l_txn_rec.object_version_number := l_src_txn_object_ver_num ;
2954:
2955: csi_transactions_pvt.update_transactions(

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

2979: l_txn_rec := cse_util_pkg.init_txn_rec;
2980: l_txn_rec.transaction_id := dest_misc_move_trans_rec.transaction_id ;
2981: l_txn_rec.source_group_ref_id := p_conc_request_id;
2982:
2983: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2984:
2985: l_txn_rec.object_version_number:= dest_misc_move_trans_rec.object_version_number ;
2986:
2987: csi_transactions_pvt.update_transactions(

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

3095: l_txn_rec := cse_util_pkg.init_txn_rec;
3096: l_txn_rec.transaction_id := serial_move_trans_rec.transaction_id ;
3097: l_txn_rec.source_group_ref_id := p_conc_request_id;
3098:
3099: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
3100:
3101: l_txn_rec.object_version_number := serial_move_trans_rec.object_version_number ;
3102:
3103: csi_transactions_pvt.update_transactions(