DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on WSH_INTERFACE_EXT_GRP

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 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