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.INV_LPN_TRX_PUB dependencies on WSH_INTERFACE

Line 2432: l_shipping_attr wsh_interface.changedattributetabtype;

2428: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2429: l_progress VARCHAR2(500) := '0';
2430:
2431: -- Vaiables for call to Update_Shipping_Attributes
2432: l_shipping_attr wsh_interface.changedattributetabtype;
2433: l_invpcinrectype wsh_integration.invpcinrectype;
2434:
2435: -- Types needed for WSH_WMS_LPN_GRP.Delivery_Detail_Action
2436: l_wsh_lpn_id_tbl wsh_util_core.id_tab_type;

Line 2443: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;

2439: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
2440: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
2441:
2442: -- New shipping API table types for Create_Update_Delivery_Detail
2443: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;
2444: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;
2445: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;
2446: l_dd_ct NUMBER := 1;
2447: l_msg_details VARCHAR2(3000);

Line 2444: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;

2440: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
2441:
2442: -- New shipping API table types for Create_Update_Delivery_Detail
2443: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;
2444: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;
2445: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;
2446: l_dd_ct NUMBER := 1;
2447: l_msg_details VARCHAR2(3000);
2448:

Line 2445: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;

2441:
2442: -- New shipping API table types for Create_Update_Delivery_Detail
2443: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;
2444: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;
2445: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;
2446: l_dd_ct NUMBER := 1;
2447: l_msg_details VARCHAR2(3000);
2448:
2449: -- New shipping API table types for New Delivery_Detail_Action

Line 2451: l_action_prms wsh_interface_ext_grp.det_action_parameters_rec_type;

2447: l_msg_details VARCHAR2(3000);
2448:
2449: -- New shipping API table types for New Delivery_Detail_Action
2450: l_detail_id_tab wsh_util_core.id_tab_type;
2451: l_action_prms wsh_interface_ext_grp.det_action_parameters_rec_type;
2452: l_action_out_rec wsh_interface_ext_grp.det_action_out_rec_type;
2453:
2454: CURSOR delivery_detail_cursor(lot VARCHAR2) IS
2455: /*Bug 7037834: Replaced the NVL statements with their equivalents in the where clause of below query for performance*/

Line 2452: l_action_out_rec wsh_interface_ext_grp.det_action_out_rec_type;

2448:
2449: -- New shipping API table types for New Delivery_Detail_Action
2450: l_detail_id_tab wsh_util_core.id_tab_type;
2451: l_action_prms wsh_interface_ext_grp.det_action_parameters_rec_type;
2452: l_action_out_rec wsh_interface_ext_grp.det_action_out_rec_type;
2453:
2454: CURSOR delivery_detail_cursor(lot VARCHAR2) IS
2455: /*Bug 7037834: Replaced the NVL statements with their equivalents in the where clause of below query for performance*/
2456: /* SELECT wdd2.delivery_detail_id

Line 2923: wsh_interface_ext_grp.delivery_detail_action(

2919: IF (l_debug = 1) THEN
2920: inv_log_util.TRACE('Calling Delivery_Detail_Action ddid='||l_detail_id_tab(1)||' qty='||l_action_prms.split_quantity||' qty2='||l_action_prms.split_quantity2, l_api_name, 1);
2921: END IF;
2922:
2923: wsh_interface_ext_grp.delivery_detail_action(
2924: p_api_version_number => 1.0
2925: , p_init_msg_list => fnd_api.g_false
2926: , p_commit => fnd_api.g_false
2927: , x_return_status => ret_status

Line 3013: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr

3009:
3010: -- Bug 3386829: Need to repopualte the picked quantity for shipping api
3011: l_shipping_attr(1).picked_quantity := l_split_quantity;
3012: l_shipping_attr(1).picked_quantity2 := l_split_quantity2;
3013: wsh_interface.update_shipping_attributes(p_source_code => 'INV', p_changed_attributes => l_shipping_attr
3014: , x_return_status => ret_status);
3015:
3016: IF (ret_status <> fnd_api.g_ret_sts_success) THEN
3017: IF (l_debug = 1) THEN

Line 3209: wsh_interface_ext_grp.create_update_delivery_detail(

3205: IF (l_debug = 1) THEN
3206: inv_log_util.TRACE('Calling Create_Update_Delivery_Detail count=' || l_del_det_attr.COUNT, l_api_name, 9);
3207: END IF;
3208:
3209: wsh_interface_ext_grp.create_update_delivery_detail(
3210: p_api_version_number => 1.0
3211: , p_init_msg_list => fnd_api.g_false
3212: , p_commit => fnd_api.g_false
3213: , x_return_status => ret_status

Line 4470: AND rti.processing_status_code = 'WSH_INTERFACED'

4466:
4467: SELECT Count(1) INTO l_rtv_exist FROM
4468: rcv_transactions_interface rti,mtl_material_transactions_temp mmtt
4469: WHERE rti.interface_transaction_id = mmtt.source_line_id
4470: AND rti.processing_status_code = 'WSH_INTERFACED'
4471: AND rti.group_id = mmtt.transaction_source_name
4472: AND mmtt.transaction_temp_id = v_mmtt.transaction_temp_id ;
4473:
4474: END IF ;

Line 5351: AND rti.processing_status_code = 'WSH_INTERFACED'

5347:
5348: CURSOR c_rtv_exists (p_lpn_id NUMBER ,p_organization_id NUMBER ) IS --RTV Change 16197273
5349: SELECT interface_transaction_id FROM rcv_transactions_interface rti,wms_lpn_contents wlc
5350: WHERE rti.interface_transaction_id = wlc.source_header_id
5351: AND rti.processing_status_code = 'WSH_INTERFACED'
5352: AND rti.to_organization_id = wlc.organization_id
5353: AND wlc.parent_lpn_id = p_lpn_id
5354: AND ROWNUM < 2 ;
5355: