DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_SHIPPING_PARAMS_PVT

Line 126: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ ;

122: where report_set_id = c_report_set_id;
123:
124: l_org_id number;
125: l_temp_org_id number;
126: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ ;
127:
128: -- Bug 3346237:Value for parameter Defer_interface to be taken from Global Parameters table.
129: l_global_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
130: l_stop_id number;

Line 129: l_global_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

125: l_temp_org_id number;
126: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ ;
127:
128: -- Bug 3346237:Value for parameter Defer_interface to be taken from Global Parameters table.
129: l_global_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
130: l_stop_id number;
131: l_stop_location_id number;
132: l_exists number;
133: -- Bug 9002479 : increased size to 1000 from 100

Line 217: wsh_shipping_params_pvt.get(p_organization_id => l_org_id, x_param_info => l_param_info, x_return_status => l_return_status);

213: close get_org_id;
214:
215: if l_org_id is not null then
216: -- LSP PROJECT : just added parameter names in the call.
217: wsh_shipping_params_pvt.get(p_organization_id => l_org_id, x_param_info => l_param_info, x_return_status => l_return_status);
218: wsh_util_core.api_post_call(p_return_status =>l_return_status,
219: x_num_warnings =>l_num_warning,
220: x_num_errors =>l_num_errors);
221:

Line 223: wsh_shipping_params_pvt.Get_Global_Parameters(

219: x_num_warnings =>l_num_warning,
220: x_num_errors =>l_num_errors);
221:
222: -- Bug 3346237:Value for parameter Defer_interface to be taken from Global Parameters table.
223: wsh_shipping_params_pvt.Get_Global_Parameters(
224: x_param_info => l_global_info,
225: x_return_status => l_return_status);
226:
227: wsh_util_core.api_post_call(p_return_status =>l_return_status,

Line 8193: --l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;

8189: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
8190: AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
8191: AND LOC.LOCATION_ID = c_location_id;
8192:
8193: --l_global_parameters WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
8194:
8195: l_cs_trip_rec cs_trip_rec_type;
8196: l_cs_tripstops_tab cs_stop_tab_type;
8197: --l_stop_dlvy_tab stop_delivery_tab_type;