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 146: wsh_new_deliveries d1,

142: Cursor c_unconfirmed_del_exist(c_delivery_id number) is
143: SELECT s1.trip_id
144: FROM wsh_trip_stops s1,
145: wsh_delivery_legs dl1,
146: wsh_new_deliveries d1,
147: wsh_trip_stops s2,
148: wsh_delivery_legs dl2
149: WHERE d1.delivery_id <> c_delivery_id
150: AND s1.stop_id = dl1.pick_up_stop_id

Line 165: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag

161: --OTM R12
162: --selecting deliveries that has 'AR' status on a trip
163: CURSOR c_get_delivery_id(p_trip_id IN NUMBER) IS
164: SELECT wdl.delivery_id,
165: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
166: FROM wsh_delivery_legs wdl,
167: wsh_trip_stops wts,
168: wsh_new_deliveries wnd,
169: wsh_trips wt

Line 168: wsh_new_deliveries wnd,

164: SELECT wdl.delivery_id,
165: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER interface_flag
166: FROM wsh_delivery_legs wdl,
167: wsh_trip_stops wts,
168: wsh_new_deliveries wnd,
169: wsh_trips wt
170: WHERE wt.trip_id = p_trip_id
171: AND wts.trip_id = wt.trip_id
172: AND wt.status_code = 'OP'

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

171: AND wts.trip_id = wt.trip_id
172: AND wt.status_code = 'OP'
173: AND wdl.pick_up_stop_id = wts.stop_id
174: AND wnd.delivery_id = wdl.delivery_id
175: AND wnd.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED;
176: --END OTM R12
177: --
178: -- LSP PROJECT :
179: CURSOR c_get_client(p_delivery_id NUMBER) IS

Line 181: FROM wsh_new_deliveries

177: --
178: -- LSP PROJECT :
179: CURSOR c_get_client(p_delivery_id NUMBER) IS
180: SELECT client_id
181: FROM wsh_new_deliveries
182: WHERE delivery_id = p_delivery_id;
183: --
184: l_client_id NUMBER;
185: l_standalone_mode VARCHAR2(1);

Line 214: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;

210: l_valid_index_tab wsh_util_core.id_tab_type;
211: l_error_ids wsh_util_core.id_tab_type;
212: l_org_id_tab wsh_util_core.id_tab_type;
213: l_Client_id_tab wsh_util_core.id_tab_type; -- Modified R12.1.1 LSP PROJECT
214: l_rec_attr_tab wsh_new_deliveries_pvt.Delivery_Attr_Tbl_Type;
215: l_ship_method_code_tab WSH_NEW_DELIVERY_ACTIONS.ship_method_type;
216: l_delivery_rec_tab wsh_delivery_validations.dlvy_rec_tab_type;
217: l_dummy_id_tab wsh_util_core.id_tab_type;
218: l_dummy_doc_set_params wsh_document_sets.document_set_tab_type;

Line 232: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

228: b_cc_linefailed boolean;
229: b_cc_groupidexists boolean;
230: l_delivery_id_tab_temp wsh_util_core.id_tab_type;
231: l_delivery_id_tab_t wsh_util_core.id_tab_type;
232: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
233: l_cc_count_success NUMBER;
234: l_cc_count_group_ids NUMBER;
235: l_cc_count_rec NUMBER;
236: l_cc_group_ids wsh_util_core.id_tab_type;

Line 250: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

246: l_cc_count_grouping_rows NUMBER;
247: l_cc_trip_id wsh_util_core.id_tab_type;
248: l_cc_trip_id_tab wsh_util_core.id_tab_type;
249: --dummy tables for calling validate_constraint_mainper
250: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
251: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
252: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
253: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
254: l_cc_in_ids wsh_util_core.id_tab_type;

Line 566: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(

562: --
563: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
564: AND p_action_prms.action_code = 'DELETE'
565: ) THEN --BUG 4354579
566: WSH_NEW_DELIVERIES_PVT.Lock_Delivery(
567: p_rec_attr_tab => p_rec_attr_tab,
568: p_caller => p_action_prms.caller,
569: p_valid_index_tab => l_valid_index_tab,
570: x_valid_ids_tab => l_valid_ids_tab,

Line 1235: update wsh_new_deliveries

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

Line 1277: update wsh_new_deliveries

1273:
1274: IF l_delivery_id_tab.count > 0 THEN
1275:
1276: FORALL i in 1..l_delivery_id_tab.count
1277: update wsh_new_deliveries
1278: set ap_batch_id = NULL
1279: where delivery_id = l_delivery_id_tab(i);
1280:
1281: END IF;

Line 1455: update wsh_new_deliveries

1451:
1452: IF l_delivery_id_tab.count > 0 THEN
1453:
1454: FORALL i in 1..l_delivery_id_tab.count
1455: update wsh_new_deliveries
1456: set batch_id = NULL
1457: where delivery_id = l_delivery_id_tab(i);
1458:
1459: END IF;

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

1912:
1913: IF (l_new_delivery_id_tab.COUNT > 0) THEN
1914:
1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1917: END IF;
1918:
1919: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1920: p_delivery_id_tab => l_new_delivery_id_tab,

Line 1919: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
1917: END IF;
1918:
1919: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
1920: p_delivery_id_tab => l_new_delivery_id_tab,
1921: p_tms_interface_flag_tab => l_new_interface_flag_tab,
1922: x_return_status => l_return_status);
1923:

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

2361:
2362: WHILE i IS NOT NULL LOOP
2363:
2364: --allow delete for all 'NS' deliveries
2365: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2366: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2367: --generate allowed list of deliveries to be deleted
2368: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2369: l_counter := l_counter + 1;

Line 2366: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN

2362: WHILE i IS NOT NULL LOOP
2363:
2364: --allow delete for all 'NS' deliveries
2365: IF (NVL(p_rec_attr_tab(i).tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
2366: = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2367: --generate allowed list of deliveries to be deleted
2368: l_new_delivery_id_tab(l_counter) := l_delivery_id_tab(i);
2369: l_counter := l_counter + 1;
2370: ELSE

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

2375: wsh_debug_sv.logmsg(l_module_name,'ERROR: delivery ' || l_delivery_id_tab(i) || ' cannot be deleted when it is not NS status');
2376: END IF;
2377:
2378: FND_MESSAGE.SET_NAME('WSH','WSH_OTM_DEL_DELETE_ERROR');
2379: FND_MESSAGE.SET_TOKEN('DEL_NAME',WSH_NEW_DELIVERIES_PVT.get_name(l_delivery_id_tab(i)));
2380:
2381: --we do not want the prefix error or warning for the message, so adding it with success
2382: --status will leave out the prefix. Reason being this is an error message but could be
2383: --displayed as a warning if not all deliveries fail.

Line 2443: p_entity_name => 'WSH_NEW_DELIVERIES',

2439: WSH_PACKING_SLIPS_PVT.Insert_Row(
2440: x_return_status => l_return_status,
2441: x_msg_count => l_msg_count,
2442: x_msg_data => l_msg_data,
2443: p_entity_name => 'WSH_NEW_DELIVERIES',
2444: p_entity_id => l_delivery_id_tab(1),
2445: p_application_id => 665 --FND_GLOBAL.RESP_APPL_ID
2446: p_location_id => l_pickup_loc_id,
2447: p_document_type => 'PACK_TYPE',

Line 2515: p_entity_name => 'WSH_NEW_DELIVERIES',

2511: WSH_PACKING_SLIPS_PVT.Insert_Row(
2512: x_return_status => l_return_status,
2513: x_msg_count => l_msg_count,
2514: x_msg_data => l_msg_data,
2515: p_entity_name => 'WSH_NEW_DELIVERIES',
2516: p_entity_id => p_rec_attr_tab(i).delivery_id,
2517: p_application_id => 665 /* FND_GLOBAL.RESP_APPL_ID */,
2518: --Bug 6625788 For all Iteration Same l_pickup_loc_id is passed, so sending pickup_location_id for corresponding Delivery
2519: -- p_location_id => l_pickup_loc_id,

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

2970: -- If no leg exist for this Delivery,there should be a ERROR/WARNING message here
2971: -- Indicates there is no associated trip for the delivery
2972: IF l_dleg_found = 'N' THEN
2973: FND_MESSAGE.SET_NAME('WSH','WSH_BOL_NO_TRIP_FOR_DLVY');
2974: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(i).delivery_id));
2975: l_num_errors := l_num_errors + 1;
2976: l_return_status := wsh_util_core.g_ret_sts_error;
2977: wsh_util_core.add_message(l_return_status,l_module_name);
2978: IF l_debug_on THEN

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

3563: -- I Harmonization: rvishnuv ******* Create/Update ******
3564: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3565: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3566: PROCEDURE Validate_Delivery
3567: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3568: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3569: p_action_code IN VARCHAR2,
3570: p_caller IN VARCHAR2,
3571: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,

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

3564: --Bug 5191354: For the action UPDATE, validating the delivery attributes only when the corresponding
3565: -- input parameter contains some value (other then fnd_api.g_miss_num/fnd_api.g_miss_char/fnd_api.g_miss_date).
3566: PROCEDURE Validate_Delivery
3567: (x_rec_attr_tab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
3568: p_in_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type, --Bug 5191354
3569: p_action_code IN VARCHAR2,
3570: p_caller IN VARCHAR2,
3571: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
3572: x_return_status OUT NOCOPY VARCHAR2)

Line 3592: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;

3588:
3589: l_org_location_id NUMBER;
3590: -- heali for bug 2771579
3591:
3592: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3593: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3594: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3595: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3596: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;

Line 3593: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;

3589: l_org_location_id NUMBER;
3590: -- heali for bug 2771579
3591:
3592: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3593: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3594: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3595: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3596: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3597: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;

Line 3594: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;

3590: -- heali for bug 2771579
3591:
3592: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3593: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3594: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3595: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3596: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3597: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3598: --

Line 3595: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;

3591:
3592: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3593: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3594: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3595: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3596: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3597: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3598: --
3599:

Line 3596: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;

3592: l_net_weight WSH_NEW_DELIVERIES.NET_WEIGHT%TYPE;
3593: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3594: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3595: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3596: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3597: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3598: --
3599:
3600:

Line 3597: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;

3593: l_gross_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE;
3594: l_volume WSH_NEW_DELIVERIES.VOLUME%TYPE;
3595: l_volume_uom_code WSH_NEW_DELIVERIES.VOLUME_UOM_CODE%TYPE;
3596: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
3597: l_initial_pickup_location_id WSH_NEW_DELIVERIES.initial_pickup_location_id%TYPE;
3598: --
3599:
3600:
3601: l_assigned_to_trip VARCHAR2(1);

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

4554: -- p_rec_attr_tab Table of attributes for the delivery entity
4555: -- x_del_out_rec_tab Table of delivery_id, and name of new deliveries,
4556: -- VERSION : current version 1.0
4557: -- initial version 1.0
4558: -- COMMENT : Creates or updates a record in wsh_new_deliveries table with information
4559: -- specified in p_delivery_info
4560: --========================================================================
4561: PROCEDURE Create_Update_Delivery
4562: ( p_api_version_number IN NUMBER,

Line 4566: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

4562: ( p_api_version_number IN NUMBER,
4563: p_init_msg_list IN VARCHAR2,
4564: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4565: p_in_rec IN del_In_Rec_Type,
4566: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
4567: x_del_out_rec_tab OUT NOCOPY Del_Out_Tbl_Type,
4568: x_return_status OUT NOCOPY VARCHAR2,
4569: x_msg_count OUT NOCOPY NUMBER,
4570: x_msg_data OUT NOCOPY VARCHAR2)

Line 4587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4583: l_msg_count NUMBER;
4584: l_msg_data VARCHAR2(32767);
4585:
4586: --
4587: l_rec_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4588: l_index_tab wsh_util_core.id_tab_type;
4589: --
4590: l_input_param_flag BOOLEAN := TRUE;
4591: --

Line 4613: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4609: l_cc_count_grouping_rows NUMBER;
4610: l_cc_trip_id wsh_util_core.id_tab_type;
4611: l_cc_trip_id_tab wsh_util_core.id_tab_type;
4612: b_cc_linefailed boolean;
4613: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4614: l_cc_count_success NUMBER;
4615:
4616: --dummy tables for calling validate_constraint_mainper
4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

Line 4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4613: l_rec_attr_tab_temp WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4614: l_cc_count_success NUMBER;
4615:
4616: --dummy tables for calling validate_constraint_mainper
4617: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4618: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
4619: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
4620: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
4621: l_cc_in_ids wsh_util_core.id_tab_type;

Line 4630: FROM wsh_new_deliveries

4626: --Compatibility Changes
4627:
4628: CURSOR c_getorgcarriersmc(p_delid NUMBER) IS
4629: SELECT organization_id, name, ship_method_code, carrier_id
4630: FROM wsh_new_deliveries
4631: WHERE delivery_id = p_delid
4632: and ignore_for_planning<>'Y';
4633:
4634: l_wh_type VARCHAR2(3);

Line 4635: l_organization_id wsh_new_deliveries.organization_id%TYPE;

4631: WHERE delivery_id = p_delid
4632: and ignore_for_planning<>'Y';
4633:
4634: l_wh_type VARCHAR2(3);
4635: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4636: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4637: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4638: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4639: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;

Line 4636: l_smc wsh_new_deliveries.ship_method_code%TYPE;

4632: and ignore_for_planning<>'Y';
4633:
4634: l_wh_type VARCHAR2(3);
4635: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4636: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4637: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4638: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4639: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4640: l_tmp_del_ids wsh_util_core.id_tab_type;

Line 4637: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;

4633:
4634: l_wh_type VARCHAR2(3);
4635: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4636: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4637: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4638: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4639: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4640: l_tmp_del_ids wsh_util_core.id_tab_type;
4641:

Line 4638: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;

4634: l_wh_type VARCHAR2(3);
4635: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4636: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4637: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4638: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4639: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4640: l_tmp_del_ids wsh_util_core.id_tab_type;
4641:
4642: -- Pack J: LCSS Rate Delivery.

Line 4639: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;

4635: l_organization_id wsh_new_deliveries.organization_id%TYPE;
4636: l_smc wsh_new_deliveries.ship_method_code%TYPE;
4637: l_carrier_id wsh_new_deliveries.carrier_id%TYPE;
4638: l_ignore_for_planning wsh_new_deliveries.ignore_for_planning%TYPE;
4639: l_tmp_ignore wsh_new_deliveries.ignore_for_planning%TYPE;
4640: l_tmp_del_ids wsh_util_core.id_tab_type;
4641:
4642: -- Pack J: LCSS Rate Delivery.
4643: l_exception_id NUMBER;

Line 5022: WSH_NEW_DELIVERIES_PVT.Create_Delivery(

5018:
5019:
5020:
5021: --
5022: WSH_NEW_DELIVERIES_PVT.Create_Delivery(
5023: p_delivery_info => l_rec_attr_tab(l_index),
5024: x_rowid => x_del_out_rec_tab(l_index).rowid,
5025: x_delivery_id => x_del_out_rec_tab(l_index).delivery_id,
5026: x_name => x_del_out_rec_tab(l_index).name,

Line 5176: WSH_NEW_DELIVERIES_PVT.Update_Delivery(

5172: x_num_errors => l_num_errors);
5173:
5174:
5175:
5176: WSH_NEW_DELIVERIES_PVT.Update_Delivery(
5177: p_rowid => l_rec_attr_tab(l_index).rowid,
5178: p_delivery_info => l_rec_attr_tab(l_index),
5179: x_return_status => l_return_status);
5180: --

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

6041: IF l_debug_on THEN
6042: WSH_DEBUG_SV.log(l_module_name,'WSH_DEL_ASSIGNED_ERROR');
6043: END IF;
6044: --
6045: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
6046: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6047: wsh_util_core.add_message(x_return_status,l_module_name);
6048: IF l_debug_on THEN
6049: WSH_DEBUG_SV.log(l_module_name,'x_return_status',

Line 6079: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,

6075: -- The below procedue will be obsoleted after patchset I.
6076:
6077: PROCEDURE map_grp_to_pvt(
6078: p_pub_rec IN delivery_pub_rec_type,
6079: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
6080: x_return_status OUT NOCOPY VARCHAR2)
6081: IS
6082: --
6083: l_debug_on BOOLEAN;

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

6261: -- x_delivery_id - delivery_Id of new delivery,
6262: -- x_name - Name of delivery
6263: -- VERSION : current version 1.0
6264: -- initial version 1.0
6265: -- COMMENT : Creates or updates a record in wsh_new_deliveries table
6266: -- with information specified in p_delivery_info
6267: --========================================================================
6268:
6269: PROCEDURE Create_Update_Delivery(

Line 6290: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;

6286: --
6287: l_message VARCHAR2(50);
6288: l_num_errors NUMBER;
6289: l_num_warnings NUMBER;
6290: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
6291: l_delivery_in_rec Del_In_Rec_Type;
6292: l_del_out_rec_tab Del_Out_Tbl_Type;
6293: l_return_status VARCHAR2(1);
6294: l_commit VARCHAR2(100) := FND_API.G_FALSE;

Line 6745: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,

6741: Created : Patchset I
6742: ----------------------------------------------------------------------- */
6743:
6744: PROCEDURE Lock_Related_Entities(
6745: p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
6746: p_action_prms IN action_parameters_rectype,
6747: x_valid_ids_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
6748: x_return_status OUT NOCOPY VARCHAR2
6749: ) IS

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

6813: l_stop_rows.delete;
6814:
6815: IF p_rec_attr_tab(l_index).name is null
6816: THEN
6817: l_dlvy_name := wsh_new_deliveries_pvt.get_name(p_rec_attr_tab(l_index).delivery_id);
6818: ELSE
6819: l_dlvy_name := p_rec_attr_tab(l_index).name;
6820: END IF;
6821: