DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on WSH_INTERFACE_EXT_GRP

Line 2226: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;

2222: l_wsh_defaults WSH_GLBL_VAR_STRCT_GRP.dd_default_parameters_rec_type;
2223: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
2224:
2225: -- New shipping API table types for Create_Update_Delivery_Detail
2226: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;
2227: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;
2228: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;
2229: l_dd_ct NUMBER := 1;
2230: l_msg_details VARCHAR2(3000);

Line 2227: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;

2223: l_wsh_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
2224:
2225: -- New shipping API table types for Create_Update_Delivery_Detail
2226: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;
2227: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;
2228: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;
2229: l_dd_ct NUMBER := 1;
2230: l_msg_details VARCHAR2(3000);
2231:

Line 2228: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;

2224:
2225: -- New shipping API table types for Create_Update_Delivery_Detail
2226: l_del_det_attr wsh_interface_ext_grp.delivery_details_attr_tbl_type;
2227: l_del_det_in_rec wsh_interface_ext_grp.detailinrectype;
2228: l_del_det_out_rec wsh_interface_ext_grp.detailoutrectype;
2229: l_dd_ct NUMBER := 1;
2230: l_msg_details VARCHAR2(3000);
2231:
2232: -- New shipping API table types for New Delivery_Detail_Action

Line 2234: l_action_prms wsh_interface_ext_grp.det_action_parameters_rec_type;

2230: l_msg_details VARCHAR2(3000);
2231:
2232: -- New shipping API table types for New Delivery_Detail_Action
2233: l_detail_id_tab wsh_util_core.id_tab_type;
2234: l_action_prms wsh_interface_ext_grp.det_action_parameters_rec_type;
2235: l_action_out_rec wsh_interface_ext_grp.det_action_out_rec_type;
2236:
2237: CURSOR delivery_detail_cursor(lot VARCHAR2) IS
2238: /*Bug 7037834: Replaced the NVL statements with their equivalents in the where clause of below query for performance*/

Line 2235: l_action_out_rec wsh_interface_ext_grp.det_action_out_rec_type;

2231:
2232: -- New shipping API table types for New Delivery_Detail_Action
2233: l_detail_id_tab wsh_util_core.id_tab_type;
2234: l_action_prms wsh_interface_ext_grp.det_action_parameters_rec_type;
2235: l_action_out_rec wsh_interface_ext_grp.det_action_out_rec_type;
2236:
2237: CURSOR delivery_detail_cursor(lot VARCHAR2) IS
2238: /*Bug 7037834: Replaced the NVL statements with their equivalents in the where clause of below query for performance*/
2239: /* SELECT wdd2.delivery_detail_id

Line 2680: wsh_interface_ext_grp.delivery_detail_action(

2676: IF (l_debug = 1) THEN
2677: 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);
2678: END IF;
2679:
2680: wsh_interface_ext_grp.delivery_detail_action(
2681: p_api_version_number => 1.0
2682: , p_init_msg_list => fnd_api.g_false
2683: , p_commit => fnd_api.g_false
2684: , x_return_status => ret_status

Line 2947: wsh_interface_ext_grp.create_update_delivery_detail(

2943: IF (l_debug = 1) THEN
2944: inv_log_util.TRACE('Calling Create_Update_Delivery_Detail count=' || l_del_det_attr.COUNT, l_api_name, 9);
2945: END IF;
2946:
2947: wsh_interface_ext_grp.create_update_delivery_detail(
2948: p_api_version_number => 1.0
2949: , p_init_msg_list => fnd_api.g_false
2950: , p_commit => fnd_api.g_false
2951: , x_return_status => ret_status