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.WSH_DELIVERIES_GRP dependencies on WSH_NEW_DELIVERIES

Line 12: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

8: -- add your constants here if any
9:
10: -- Forward declaration
11: PROCEDURE Lock_Related_Entities(
12: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
13: p_action_prms IN action_parameters_rectype,
14: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
15: x_return_status OUT NOCOPY VARCHAR2
16: );

Line 56: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,

52: ( p_api_version_number IN NUMBER,
53: p_init_msg_list IN VARCHAR2,
54: p_commit IN VARCHAR2,
55: p_action_prms IN action_parameters_rectype,
56: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type ,
57: x_delivery_out_rec OUT NOCOPY Delivery_Action_Out_Rec_Type,
58: x_defaults_rec OUT NOCOPY default_parameters_rectype,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,

Line 82: WHERE entity_name = 'WSH_NEW_DELIVERIES'

78:
79: CURSOR c_dlvy_pack_slip_cur(p_delivery_id NUMBER) IS
80: SELECT sequence_number
81: FROM wsh_document_instances
82: WHERE entity_name = 'WSH_NEW_DELIVERIES'
83: AND entity_id = p_delivery_id
84: AND document_type = 'PACK_TYPE';
85:
86: -- Cursors c_pack_slip_doc_set and c_delv_trip_id_cursor added for bug 4493263

Line 125: FROM wsh_new_deliveries

121:
122:
123: Cursor c_get_delivery_org(c_delivery_id number) is
124: SELECT initial_pickup_location_id
125: FROM wsh_new_deliveries
126: WHERE delivery_id = c_delivery_id;
127:
128: Cursor c_del_assign_to_trip(c_delivery_id number) is
129: SELECT distinct t.trip_id, t.ship_method_code, t.lane_id

Line 130: FROM wsh_new_deliveries dl,

126: WHERE delivery_id = c_delivery_id;
127:
128: Cursor c_del_assign_to_trip(c_delivery_id number) is
129: SELECT distinct t.trip_id, t.ship_method_code, t.lane_id
130: FROM wsh_new_deliveries dl,
131: wsh_delivery_legs dg,
132: wsh_trip_stops st,
133: wsh_trips t
134: WHERE dl.delivery_id = c_delivery_id AND

Line 145: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag

141: --OTM R12
142: --selecting deliveries that has 'AR' status on a trip
143: CURSOR c_get_delivery_id(p_trip_id IN NUMBER) IS
144: SELECT wdl.delivery_id,
145: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
146: FROM wsh_delivery_legs wdl,
147: wsh_trip_stops wts,
148: wsh_new_deliveries wnd,
149: wsh_trips wt

Line 148: wsh_new_deliveries wnd,

144: SELECT wdl.delivery_id,
145: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
146: FROM wsh_delivery_legs wdl,
147: wsh_trip_stops wts,
148: wsh_new_deliveries wnd,
149: wsh_trips wt
150: WHERE wt.trip_id = p_trip_id
151: AND wts.trip_id = wt.trip_id
152: AND wt.status_code = 'OP'

Line 155: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;

151: AND wts.trip_id = wt.trip_id
152: AND wt.status_code = 'OP'
153: AND wdl.pick_up_stop_id = wts.stop_id
154: AND wnd.delivery_id = wdl.delivery_id
155: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;
156: --END OTM R12
157:
158: l_first NUMBER;
159: l_last NUMBER;

Line 184: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

180: l_valid_ids_tab wsh_util_core.id_tab_type;
181: l_valid_index_tab wsh_util_core.id_tab_type;
182: l_error_ids wsh_util_core.id_tab_type;
183: l_org_id_tab wsh_util_core.id_tab_type;
184: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
185: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.ship_method_type;
186: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;
187: l_dummy_id_tab wsh_util_core.id_tab_type;
188: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;

Line 202: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

198: b_cc_linefailed boolean;
199: b_cc_groupidexists boolean;
200: l_delivery_id_tab_temp wsh_util_core.id_tab_type;
201: l_delivery_id_tab_t wsh_util_core.id_tab_type;
202: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
203: l_cc_count_success NUMBER;
204: l_cc_count_group_ids NUMBER;
205: l_cc_count_rec NUMBER;
206: l_cc_group_ids wsh_util_core.id_tab_type;

Line 220: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

216: l_cc_count_grouping_rows NUMBER;
217: l_cc_trip_id wsh_util_core.id_tab_type;
218: l_cc_trip_id_tab wsh_util_core.id_tab_type;
219: --dummy tables for calling validate_constraint_mainper
220: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
221: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
222: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
223: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
224: l_cc_in_ids wsh_util_core.id_tab_type;

Line 530: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(

526: --
527: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
528: AND p_action_prms.action_code = 'DELETE'
529: ) THEN --BUG 4354579
530: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(
531: p_rec_attr_tab => p_rec_attr_tab,
532: p_caller => p_action_prms.caller,
533: p_valid_index_tab => l_valid_index_tab,
534: x_valid_ids_tab => l_valid_ids_tab,

Line 1195: update wsh_new_deliveries

1191:
1192: IF l_delivery_id_tab.count > 0 THEN
1193:
1194: FORALL i in 1..l_delivery_id_tab.count
1195: update wsh_new_deliveries
1196: set ap_batch_id = NULL
1197: where delivery_id = l_delivery_id_tab(i);
1198:
1199: END IF;

Line 1237: update wsh_new_deliveries

1233:
1234: IF l_delivery_id_tab.count > 0 THEN
1235:
1236: FORALL i in 1..l_delivery_id_tab.count
1237: update wsh_new_deliveries
1238: set ap_batch_id = NULL
1239: where delivery_id = l_delivery_id_tab(i);
1240:
1241: END IF;

Line 1400: update wsh_new_deliveries

1396:
1397: IF l_delivery_id_tab.count > 0 THEN
1398:
1399: FORALL i in 1..l_delivery_id_tab.count
1400: update wsh_new_deliveries
1401: set batch_id = NULL
1402: where delivery_id = l_delivery_id_tab(i);
1403:
1404: END IF;

Line 1861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

1857:
1858: IF (l_new_delivery_id_tab.COUNT > 0) THEN
1859:
1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1862: END IF;
1863:
1864: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1865: p_delivery_id_tab => l_new_delivery_id_tab,

Line 1864: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

1860: IF l_debug_on THEN
1861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1862: END IF;
1863:
1864: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1865: p_delivery_id_tab => l_new_delivery_id_tab,
1866: p_tms_interface_flag_tab => l_new_interface_flag_tab,
1867: x_return_status => l_return_status);
1868:

Line 2277: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

2273:
2274: WHILE i IS NOT NULL LOOP
2275:
2276: --allow delete for all 'NS' deliveries
2277: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2278: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2279: --generate allowed list of deliveries to be deleted
2280: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2281: l_counter := l_counter + 1;

Line 2278: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN

2274: WHILE i IS NOT NULL LOOP
2275:
2276: --allow delete for all 'NS' deliveries
2277: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2278: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2279: --generate allowed list of deliveries to be deleted
2280: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2281: l_counter := l_counter + 1;
2282: ELSE

Line 2291: FND_MESSAGE.SET_TOKEN('DEL_NAME',WSH_NEW_DELIVERIES_PVT.get_name(l_delivery_id_tab(i)));

2287: wsh_debug_sv.logmsg(l_module_name,'ERROR: delivery ' || l_delivery_id_tab(i) || ' cannot be deleted when it is not NS status');
2288: END IF;
2289:
2290: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DEL_DELETE_ERROR');
2291: FND_MESSAGE.SET_TOKEN('DEL_NAME',WSH_NEW_DELIVERIES_PVT.get_name(l_delivery_id_tab(i)));
2292:
2293: --we do not want the prefix error or warning for the message, so adding it with success
2294: --status will leave out the prefix. Reason being this is an error message but could be
2295: --displayed as a warning if not all deliveries fail.

Line 2355: p_entity_name => 'WSH_NEW_DELIVERIES',

2351: WSH_PACKING_SLIPS_PVT.Insert_Row(
2352: x_return_status => l_return_status,
2353: x_msg_count => l_msg_count,
2354: x_msg_data => l_msg_data,
2355: p_entity_name => 'WSH_NEW_DELIVERIES',
2356: p_entity_id => l_delivery_id_tab(1),
2357: p_application_id => 665 --FND_GLOBAL.RESP_APPL_ID
2358: p_location_id => l_pickup_loc_id,
2359: p_document_type => 'PACK_TYPE',

Line 2427: p_entity_name => 'WSH_NEW_DELIVERIES',

2423: WSH_PACKING_SLIPS_PVT.Insert_Row(
2424: x_return_status => l_return_status,
2425: x_msg_count => l_msg_count,
2426: x_msg_data => l_msg_data,
2427: p_entity_name => 'WSH_NEW_DELIVERIES',
2428: p_entity_id => p_rec_attr_tab(i).delivery_id,
2429: p_application_id => 665 /* FND_GLOBAL.RESP_APPL_ID */,
2430: --Bug 6625788 For all Iteration Same l_pickup_loc_id is passed, so sending pickup_location_id for corresponding Delivery
2431: -- p_location_id => l_pickup_loc_id,

Line 2886: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(i).delivery_id));

2882: -- If no leg exist for this Delivery,there should be a ERROR/WARNING message here
2883: -- Indicates there is no associated trip for the delivery
2884: IF l_dleg_found = 'N' THEN
2885: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NO_TRIP_FOR_DLVY');
2886: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(i).delivery_id));
2887: l_num_errors := l_num_errors + 1;
2888: l_return_status := wsh_util_core.g_ret_sts_error;
2889: wsh_util_core.add_message(l_return_status,l_module_name);
2890: IF l_debug_on THEN

Line 3479: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

3475: -- I Harmonization: rvishnuv ******* Create/Update ******
3476: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3477: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3478: PROCEDURE Validate_Delivery
3479: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3480: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3481: p_action_code IN VARCHAR2,
3482: p_caller IN VARCHAR2,
3483: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,

Line 3480: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354

3476: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3477: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3478: PROCEDURE Validate_Delivery
3479: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3480: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3481: p_action_code IN VARCHAR2,
3482: p_caller IN VARCHAR2,
3483: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
3484: x_return_status OUT NOCOPY VARCHAR2)

Line 3497: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;

3493:
3494: l_org_location_id NUMBER;
3495: -- heali for bug 2771579
3496:
3497: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3498: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3499: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3500: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3501: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;

Line 3498: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;

3494: l_org_location_id NUMBER;
3495: -- heali for bug 2771579
3496:
3497: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3498: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3499: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3500: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3501: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3502: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;

Line 3499: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;

3495: -- heali for bug 2771579
3496:
3497: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3498: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3499: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3500: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3501: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3502: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3503: --

Line 3500: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;

3496:
3497: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3498: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3499: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3500: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3501: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3502: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3503: --
3504:

Line 3501: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;

3497: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3498: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3499: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3500: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3501: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3502: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3503: --
3504:
3505:

Line 3502: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;

3498: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3499: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3500: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3501: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3502: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3503: --
3504:
3505:
3506: l_assigned_to_trip VARCHAR2(1);

Line 4385: -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information

4381: -- p_rec_attr_tab Table of attributes for the delivery entity
4382: -- x_del_out_rec_tab Table of delivery_id, and name of new deliveries,
4383: -- VERSION : current version 1.0
4384: -- initial version 1.0
4385: -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
4386: -- specified in p_delivery_info
4387: --========================================================================
4388: PROCEDURE Create_Update_Delivery
4389: ( p_api_version_number IN NUMBER,

Line 4393: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4389: ( p_api_version_number IN NUMBER,
4390: p_init_msg_list IN VARCHAR2,
4391: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4392: p_in_rec IN del_In_Rec_Type,
4393: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4394: x_del_out_rec_tab OUT NOCOPY Del_Out_Tbl_Type,
4395: x_return_status OUT NOCOPY VARCHAR2,
4396: x_msg_count OUT NOCOPY NUMBER,
4397: x_msg_data OUT NOCOPY VARCHAR2)

Line 4414: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4410: l_msg_count NUMBER;
4411: l_msg_data VARCHAR2(32767);
4412:
4413: --
4414: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4415: l_index_tab wsh_util_core.id_tab_type;
4416: --
4417: l_input_param_flag BOOLEAN := TRUE;
4418: --

Line 4440: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4436: l_cc_count_grouping_rows NUMBER;
4437: l_cc_trip_id wsh_util_core.id_tab_type;
4438: l_cc_trip_id_tab wsh_util_core.id_tab_type;
4439: b_cc_linefailed boolean;
4440: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4441: l_cc_count_success NUMBER;
4442:
4443: --dummy tables for calling validate_constraint_mainper
4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

Line 4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4440: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4441: l_cc_count_success NUMBER;
4442:
4443: --dummy tables for calling validate_constraint_mainper
4444: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4445: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4446: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4447: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4448: l_cc_in_ids wsh_util_core.id_tab_type;

Line 4457: FROM wsh_new_deliveries

4453: --Compatibility Changes
4454:
4455: CURSOR c_getorgcarriersmc(p_delid NUMBER) IS
4456: SELECT organization_id, name, ship_method_code, carrier_id
4457: FROM wsh_new_deliveries
4458: WHERE delivery_id = p_delid
4459: and ignore_for_planning<>'Y';
4460:
4461: l_wh_type VARCHAR2(3);

Line 4462: l_organization_id wsh_new_deliveries.organization_id%TYPE;

4458: WHERE delivery_id = p_delid
4459: and ignore_for_planning<>'Y';
4460:
4461: l_wh_type VARCHAR2(3);
4462: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4463: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4464: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4465: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4466: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;

Line 4463: l_smc wsh_new_deliveries.ship_method_code%TYPE;

4459: and ignore_for_planning<>'Y';
4460:
4461: l_wh_type VARCHAR2(3);
4462: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4463: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4464: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4465: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4466: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4467: l_tmp_del_ids wsh_util_core.id_tab_type;

Line 4464: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;

4460:
4461: l_wh_type VARCHAR2(3);
4462: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4463: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4464: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4465: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4466: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4467: l_tmp_del_ids wsh_util_core.id_tab_type;
4468:

Line 4465: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;

4461: l_wh_type VARCHAR2(3);
4462: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4463: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4464: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4465: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4466: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4467: l_tmp_del_ids wsh_util_core.id_tab_type;
4468:
4469: -- Pack J: LCSS Rate Delivery.

Line 4466: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;

4462: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4463: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4464: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4465: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4466: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4467: l_tmp_del_ids wsh_util_core.id_tab_type;
4468:
4469: -- Pack J: LCSS Rate Delivery.
4470: l_exception_id NUMBER;

Line 4847: WSH_NEW_DELIVERIES_PVT.Create_Delivery(

4843:
4844:
4845:
4846: --
4847: WSH_NEW_DELIVERIES_PVT.Create_Delivery(
4848: p_delivery_info => l_rec_attr_tab(l_index),
4849: x_rowid => x_del_out_rec_tab(l_index).rowid,
4850: x_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
4851: x_name => x_del_out_rec_tab(l_index).name,

Line 5001: WSH_NEW_DELIVERIES_PVT.Update_Delivery(

4997: x_num_errors => l_num_errors);
4998:
4999:
5000:
5001: WSH_NEW_DELIVERIES_PVT.Update_Delivery(
5002: p_rowid => l_rec_attr_tab(l_index).rowid,
5003: p_delivery_info => l_rec_attr_tab(l_index),
5004: x_return_status => l_return_status);
5005: --

Line 5865: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));

5861: IF l_debug_on THEN
5862: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_ASSIGNED_ERROR');
5863: END IF;
5864: --
5865: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
5866: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5867: wsh_util_core.add_message(x_return_status,l_module_name);
5868: IF l_debug_on THEN
5869: WSH_DEBUG_SV.log(l_module_name,'x_return_status',

Line 5899: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,

5895: -- The below procedue will be obsoleted after patchset I.
5896:
5897: PROCEDURE map_grp_to_pvt(
5898: p_pub_rec IN delivery_pub_rec_type,
5899: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
5900: x_return_status OUT NOCOPY VARCHAR2)
5901: IS
5902: --
5903: l_debug_on BOOLEAN;

Line 6085: -- COMMENT : Creates or updates a record in wsh_new_deliveries table

6081: -- x_delivery_id - delivery_Id of new delivery,
6082: -- x_name - Name of delivery
6083: -- VERSION : current version 1.0
6084: -- initial version 1.0
6085: -- COMMENT : Creates or updates a record in wsh_new_deliveries table
6086: -- with information specified in p_delivery_info
6087: --========================================================================
6088:
6089: PROCEDURE Create_Update_Delivery(

Line 6110: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;

6106: --
6107: l_message VARCHAR2(50);
6108: l_num_errors NUMBER;
6109: l_num_warnings NUMBER;
6110: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
6111: l_delivery_in_rec Del_In_Rec_Type;
6112: l_del_out_rec_tab Del_Out_Tbl_Type;
6113: l_return_status VARCHAR2(1);
6114: l_commit VARCHAR2(100) := FND_API.G_FALSE;

Line 6565: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

6561: Created : Patchset I
6562: ----------------------------------------------------------------------- */
6563:
6564: PROCEDURE Lock_Related_Entities(
6565: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
6566: p_action_prms IN action_parameters_rectype,
6567: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
6568: x_return_status OUT NOCOPY VARCHAR2
6569: ) IS

Line 6637: l_dlvy_name := wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(l_index).delivery_id);

6633: l_stop_rows.delete;
6634:
6635: IF p_rec_attr_tab(l_index).name is null
6636: THEN
6637: l_dlvy_name := wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(l_index).delivery_id);
6638: ELSE
6639: l_dlvy_name := p_rec_attr_tab(l_index).name;
6640: END IF;
6641: