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_DELIVERY_LEGS_GRP dependencies on WSH_DELIVERY_LEGS

Line 1: PACKAGE BODY WSH_DELIVERY_LEGS_GRP as

1: PACKAGE BODY WSH_DELIVERY_LEGS_GRP as
2: /* $Header: WSHDGGPB.pls 120.9 2007/01/05 00:48:12 anxsharm noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_GRP';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_GRP';

1: PACKAGE BODY WSH_DELIVERY_LEGS_GRP as
2: /* $Header: WSHDGGPB.pls 120.9 2007/01/05 00:48:12 anxsharm noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_GRP';
6: --
7:
8: -- forward declaration
9: PROCEDURE Get_Disabled_List (

Line 10: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

6: --
7:
8: -- forward declaration
9: PROCEDURE Get_Disabled_List (
10: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
11: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
12: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
13: , x_return_status OUT NOCOPY VARCHAR2
14: );

Line 12: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

8: -- forward declaration
9: PROCEDURE Get_Disabled_List (
10: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
11: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
12: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
13: , x_return_status OUT NOCOPY VARCHAR2
14: );
15:
16: PROCEDURE Delivery_Leg_Action(

Line 51: from wsh_Delivery_legs child, wsh_Delivery_legs parent

47: WHERE delivery_id = p_delivery_id;
48:
49: CURSOR get_parent_leg(p_delivery_leg_id in number) is
50: select parent.delivery_leg_id, parent.delivery_id
51: from wsh_Delivery_legs child, wsh_Delivery_legs parent
52: where child.delivery_leg_id = p_delivery_leg_id
53: and child.parent_delivery_leg_id = parent.delivery_leg_id;
54:
55: CURSOR c_get_delivery_id (p_delivery_leg_id IN NUMBER) IS

Line 56: SELECT delivery_leg_id, delivery_id from wsh_Delivery_legs

52: where child.delivery_leg_id = p_delivery_leg_id
53: and child.parent_delivery_leg_id = parent.delivery_leg_id;
54:
55: CURSOR c_get_delivery_id (p_delivery_leg_id IN NUMBER) IS
56: SELECT delivery_leg_id, delivery_id from wsh_Delivery_legs
57: WHERE delivery_leg_id = p_delivery_leg_id;
58:
59: CURSOR get_delivery_from_leg(p_leg_id in number) IS
60: SELECT delivery_id

Line 61: FROM wsh_delivery_legs

57: WHERE delivery_leg_id = p_delivery_leg_id;
58:
59: CURSOR get_delivery_from_leg(p_leg_id in number) IS
60: SELECT delivery_id
61: FROM wsh_delivery_legs
62: WHERE delivery_leg_id = p_leg_id;
63:
64: -- Cursor c_bol_doc_set added for bug 4493263
65: CURSOR c_bol_doc_set IS

Line 273: WSH_DELIVERY_LEGS_PVT.Lock_Delivery_Leg(

269: SAVEPOINT action_genbol_sp;
270:
271: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1) THEN
272:
273: WSH_DELIVERY_LEGS_PVT.Lock_Delivery_Leg(
274: p_rowid => p_rec_attr_tab(l_index).rowid,
275: p_delivery_leg_info => p_rec_attr_tab(l_index));
276:
277: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

Line 370: WSH_DELIVERY_LEGS wdl

366: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_BOL_NUM_LVL) = 1) THEN
367: SELECT count(*)
368: INTO l_bol_number
369: FROM WSH_DOCUMENT_INSTANCES wdi,
370: WSH_DELIVERY_LEGS wdl
371: WHERE wdi.entity_id = wdl.delivery_leg_id
372: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
373: AND wdi.status <> 'CANCELLED'
374: AND wdl.delivery_leg_id = l_delivery_leg_id;--p_rec_attr_tab(l_index).delivery_leg_id;

Line 372: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

368: INTO l_bol_number
369: FROM WSH_DOCUMENT_INSTANCES wdi,
370: WSH_DELIVERY_LEGS wdl
371: WHERE wdi.entity_id = wdl.delivery_leg_id
372: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
373: AND wdi.status <> 'CANCELLED'
374: AND wdl.delivery_leg_id = l_delivery_leg_id;--p_rec_attr_tab(l_index).delivery_leg_id;
375:
376: IF (l_bol_number > 0 ) THEN

Line 394: p_entity_name => 'WSH_DELIVERY_LEGS',

390: WSH_BOLS_PVT.Insert_Row(
391: x_return_status => l_return_status,
392: x_msg_count => l_msg_count,
393: x_msg_data => l_msg_data,
394: p_entity_name => 'WSH_DELIVERY_LEGS',
395: x_entity_id => l_delivery_leg_id,
396: p_application_id => 665 ,
397: p_location_id => p_action_prms.p_Pick_Up_Location_Id,
398: p_document_type => 'BOL',

Line 435: WSH_DELIVERY_LEGS wdl

431:
432: SELECT count(*)
433: INTO l_bol_number
434: FROM WSH_DOCUMENT_INSTANCES wdi,
435: WSH_DELIVERY_LEGS wdl
436: WHERE wdi.entity_id = wdl.delivery_leg_id
437: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
438: AND wdi.status <> 'CANCELLED'
439: AND wdl.delivery_leg_id = l_delivery_leg_id;

Line 437: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'

433: INTO l_bol_number
434: FROM WSH_DOCUMENT_INSTANCES wdi,
435: WSH_DELIVERY_LEGS wdl
436: WHERE wdi.entity_id = wdl.delivery_leg_id
437: AND wdi.entity_name = 'WSH_DELIVERY_LEGS'
438: AND wdi.status <> 'CANCELLED'
439: AND wdl.delivery_leg_id = l_delivery_leg_id;
440:
441: IF l_debug_on THEN

Line 491: WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION(

487: l_action_out_rec.x_trip_id := x_action_out_rec.x_trip_id;
488: l_action_out_rec.x_trip_name := x_action_out_rec.x_trip_name;
489: l_action_out_rec.x_delivery_id := x_action_out_rec.x_delivery_id;
490:
491: WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION(
492: p_api_version_number => p_api_version_number,
493: p_init_msg_list => FND_API.G_FALSE,
494: p_commit => FND_API.G_FALSE,
495: p_rec_attr_tab => p_rec_attr_tab,

Line 754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');

750:
751:
752: WHEN OTHERS THEN
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');
755: FND_MSG_PUB.Count_And_Get (
756: p_count => x_msg_count,
757: p_data => x_msg_data,
758: p_encoded => FND_API.G_FALSE);

Line 783: -- COMMENT : Updates a record in wsh_delivery_legs table with information

779: -- p_delivery_leg_tab Table of Attributes for the delivery leg entity
780: -- x_out_rec for future usage.
781: -- VERSION : current version 1.0
782: -- initial version 1.0
783: -- COMMENT : Updates a record in wsh_delivery_legs table with information
784: -- specified in p_delivery_leg_tab. Please note that as per perfomance
785: -- standards, if you need to update a field to null, then use the
786: -- fnd_api.g_miss_(num/char/date) value for that field. If a field
787: -- has a null value, it will not be updated.

Line 793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,

789: PROCEDURE Update_Delivery_Leg(
790: p_api_version_number IN NUMBER,
791: p_init_msg_list IN VARCHAR2,
792: p_commit IN VARCHAR2,
793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,

Line 794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,

790: p_api_version_number IN NUMBER,
791: p_init_msg_list IN VARCHAR2,
792: p_commit IN VARCHAR2,
793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,
798: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,

791: p_init_msg_list IN VARCHAR2,
792: p_commit IN VARCHAR2,
793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,
798: x_msg_data OUT NOCOPY VARCHAR2) IS
799:

Line 804: l_delivery_leg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;

800: l_api_version_number CONSTANT NUMBER := 1.0;
801: l_api_name CONSTANT VARCHAR2(30) := 'Update_Delivery_Leg';
802: l_debug_on BOOLEAN;
803: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_DELIVERY_LEGS';
804: l_delivery_leg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;
805:
806: l_return_status VARCHAR2(1);
807: l_num_warnings NUMBER;
808: l_num_errors NUMBER;

Line 812: wsh_new_deliveries d, wsh_delivery_legs l, wsh_trip_stops s

808: l_num_errors NUMBER;
809:
810: cursor c_is_final_leg (p_dleg_id in number) is
811: select d.delivery_id from
812: wsh_new_deliveries d, wsh_delivery_legs l, wsh_trip_stops s
813: where l.delivery_id = d.delivery_id
814: and d.ultimate_dropoff_location_id = s.stop_location_id
815: and l.drop_off_stop_id = s.stop_id
816: and l.delivery_leg_id = p_dleg_id;

Line 895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg',WSH_DEBUG_SV.C_PROC_LEVEL);

891:
892: END IF;
893:
894: IF l_debug_on THEN
895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg',WSH_DEBUG_SV.C_PROC_LEVEL);
896: END IF;
897: WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg(
898: p_rowid => NULL,
899: p_delivery_leg_info => l_delivery_leg_rec,

Line 897: WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg(

893:
894: IF l_debug_on THEN
895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg',WSH_DEBUG_SV.C_PROC_LEVEL);
896: END IF;
897: WSH_DELIVERY_LEGS_PVT.Update_Delivery_Leg(
898: p_rowid => NULL,
899: p_delivery_leg_info => l_delivery_leg_rec,
900: x_return_status => l_return_status);
901:

Line 941: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);

937:
938: IF c_is_final_leg%isopen THEN
939: close c_is_final_leg;
940: END IF;
941: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
942: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 953: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

949: END Update_Delivery_Leg;
950:
951:
952: PROCEDURE Get_Disabled_List (
953: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
954: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
955: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
956: , x_return_status OUT NOCOPY VARCHAR2
957: ) IS

Line 955: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type

951:
952: PROCEDURE Get_Disabled_List (
953: p_del_leg_rec IN WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
954: , p_action IN VARCHAR2 DEFAULT 'UPDATE'
955: , x_del_leg_rec OUT NOCOPY WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type
956: , x_return_status OUT NOCOPY VARCHAR2
957: ) IS
958:
959: cursor c_get_leg_record(p_dleg_id in number) IS

Line 1030: FROM wsh_delivery_legs where

1026: ORIGIN_STOP_ID ,
1027: DESTINATION_STOP_ID ,
1028: ROWID ,
1029: PARENT_DELIVERY_LEG_ID
1030: FROM wsh_delivery_legs where
1031: delivery_leg_id = p_dleg_id;
1032:
1033: l_api_version_number CONSTANT NUMBER := 1.0;
1034: l_api_name CONSTANT VARCHAR2(30) := 'Get_Disabled_List';

Line 1037: l_dleg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;

1033: l_api_version_number CONSTANT NUMBER := 1.0;
1034: l_api_name CONSTANT VARCHAR2(30) := 'Get_Disabled_List';
1035: l_debug_on BOOLEAN;
1036: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Get_Disabled_List';
1037: l_dleg_rec WSH_DELIVERY_LEGS_PVT.Delivery_Leg_Rec_Type;
1038:
1039: Begin
1040:
1041: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 1403: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.get_disabled_list',l_module_name);

1399:
1400: EXCEPTION
1401:
1402: WHEN others THEN
1403: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.get_disabled_list',l_module_name);
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1405: --
1406: IF c_get_leg_record%isopen THEN
1407: CLOSE c_get_leg_record;

Line 1416: END WSH_DELIVERY_LEGS_GRP;

1412: END IF;
1413:
1414: END get_disabled_list;
1415:
1416: END WSH_DELIVERY_LEGS_GRP;