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_TRIPS_GRP dependencies on WSH_TRIPS

Line 1: PACKAGE BODY WSH_TRIPS_GRP as

1: PACKAGE BODY WSH_TRIPS_GRP as
2: /* $Header: WSHTRGPB.pls 120.7 2007/01/05 19:23:14 parkhj noship $ */
3:
4:
5: --===================

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIPS_GRP';

4:
5: --===================
6: -- CONSTANTS
7: --===================
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIPS_GRP';
9: -- add your constants here if any
10:
11: --===================
12: -- PROCEDURES

Line 51: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

47:
48: l_api_version_number CONSTANT NUMBER := 1.0;
49: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';
50:
51: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
52: l_entity_id_tab wsh_util_core.id_tab_type;
53: --
54: trip_action_error EXCEPTION;
55:

Line 157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

153: WHEN trip_action_error THEN
154: FND_MESSAGE.SET_NAME('WSH','WSH_OI_TRIP_ACTION_ERROR');
155: --
156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
158: END IF;
159: --
160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));

Line 160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
158: END IF;
159: --
160: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
161: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_trip_IN_rec.action_code));
162: wsh_util_core.add_message(x_return_status);
163:
164: IF l_debug_on THEN

Line 259: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

255: --
256: trip_action_error EXCEPTION;
257:
258: l_trip_rows wsh_util_core.id_tab_type;
259: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
260: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
261:
262:
263: l_trip_id NUMBER := p_trip_id;

Line 260: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

256: trip_action_error EXCEPTION;
257:
258: l_trip_rows wsh_util_core.id_tab_type;
259: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
260: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
261:
262:
263: l_trip_id NUMBER := p_trip_id;
264: --

Line 352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

348: --
349: -- Debug Statements
350: --
351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
353: END IF;
354: --
355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
356: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));

Line 355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));

351: IF l_debug_on THEN
352: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
353: END IF;
354: --
355: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
356: FND_MESSAGE.SET_TOKEN('ACTION', wsh_util_core.get_action_meaning('TRIP',p_action_code));
357: wsh_util_core.add_message(x_return_status);
358:
359: --

Line 433: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

429: ( p_api_version_number IN NUMBER,
430: p_init_msg_list IN VARCHAR2,
431: p_commit IN VARCHAR2,
432: p_action_prms IN action_parameters_rectype,
433: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
434: x_trip_out_rec OUT NOCOPY tripActionOutRecType,
435: x_def_rec OUT NOCOPY default_parameters_rectype,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,

Line 447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

443: l_valid_id_tab wsh_util_core.id_tab_type;
444: l_dummy_ids wsh_util_core.id_tab_type;
445: l_valid_index_tab wsh_util_core.id_tab_type;
446: l_error_ids wsh_util_core.id_tab_type;
447: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
448: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
449: l_dummy_doc_param WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
450: l_api_version_number CONSTANT NUMBER := 1.0;
451: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';

Line 475: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

471: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
472: l_msg_count NUMBER;
473: l_msg_data VARCHAR2(2000);
474:
475: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
476: l_trip_id_tab_temp wsh_util_core.id_tab_type;
477: l_cc_count_success NUMBER;
478: b_cc_linefailed BOOLEAN;
479:

Line 483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

479:
480: --dummy tables for calling validate_constraint_wrapper
481: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
482: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
483: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
484: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
485: l_cc_in_ids wsh_util_core.id_tab_type;
486: l_cc_fail_ids wsh_util_core.id_tab_type;
487:

Line 504: wsh_trips wt

500: SELECT wdl.delivery_id, wt.name
501: FROM wsh_trip_stops wts,
502: wsh_Delivery_legs wdl,
503: wsh_new_deliveries wnd,
504: wsh_trips wt
505: WHERE wt.trip_id = p_trip_id
506: AND wts.trip_id = p_trip_id
507: AND wdl.pick_up_stop_id = wts.stop_id
508: AND wnd.delivery_id = wdl.delivery_id

Line 619: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.generateRoutingResponse',WSH_DEBUG_SV.C_PROC_LEVEL);

615: IF p_action_prms.action_code = 'GENERATE-ROUTING-RESPONSE'
616: THEN
617: --{
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.generateRoutingResponse',WSH_DEBUG_SV.C_PROC_LEVEL);
620: END IF;
621: --
622: WSH_TRIPS_ACTIONS.generateRoutingResponse
623: (

Line 622: WSH_TRIPS_ACTIONS.generateRoutingResponse

618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.generateRoutingResponse',WSH_DEBUG_SV.C_PROC_LEVEL);
620: END IF;
621: --
622: WSH_TRIPS_ACTIONS.generateRoutingResponse
623: (
624: p_action_prms => p_action_prms,
625: p_rec_attr_tab => p_rec_attr_tab,
626: x_return_status => l_return_status

Line 708: WSH_TRIPS_PVT.lock_trip(p_rec_attr_tab => p_rec_attr_tab,

704: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN
705: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
706: AND p_action_prms.action_code = 'DELETE'
707: ) THEN --BUG 4354579
708: WSH_TRIPS_PVT.lock_trip(p_rec_attr_tab => p_rec_attr_tab,
709: p_caller => p_action_prms.caller,
710: p_valid_index_tab => l_valid_index_tab,
711: x_valid_ids_tab => x_trip_out_rec.valid_ids_tab,
712: x_return_status => l_return_status);

Line 725: WSH_TRIPS_ACTIONS.Get_Trip_Defaults(p_trip_id => l_trip_id_tab(1),

721: END IF;
722:
723: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_CONFIRM_DEFAULT_LVL) = 1 THEN
724:
725: WSH_TRIPS_ACTIONS.Get_Trip_Defaults(p_trip_id => l_trip_id_tab(1),
726: p_trip_name => p_action_prms.trip_name,
727: x_def_rec => x_def_rec,
728: x_return_status => l_return_status);
729:

Line 837: WSH_TRIPS_GRP.get_trip_details_pvt(

833: BEGIN
834:
835: SAVEPOINT s_clean_loop_grp;
836:
837: WSH_TRIPS_GRP.get_trip_details_pvt(
838: p_trip_id => l_trip_id_tab(i),
839: x_trip_rec => l_trip_rec,
840: x_return_status => l_return_status
841: );

Line 893: WSH_TRIPS_ACTIONS.plan (

889:
890:
891: IF p_action_prms.action_code IN ('FIRM','PLAN','UNPLAN') THEN
892:
893: WSH_TRIPS_ACTIONS.plan (
894: p_trip_rows => l_trip_id_tab,
895: p_action => p_action_prms.action_code,
896: x_return_status => l_return_status
897: );

Line 945: WSH_TRIPS_ACTIONS.Confirm_Trip(

941: ELSE
942: l_intransit_flag := p_action_prms.autointransit_flag;
943: END IF;
944:
945: WSH_TRIPS_ACTIONS.Confirm_Trip(
946: p_trip_id => l_trip_id_tab(1),
947: p_action_flag => p_action_prms.action_flag,
948: p_intransit_flag => p_action_prms.autointransit_flag,
949: p_close_flag => p_action_prms.autoclose_flag,

Line 1013: WSH_TRIPS_ACTIONS.Trip_weight_volume(

1009: WSH_WV_UTILS.G_RESET_WV := 'Y'; -- set to Y to enable the update
1010: END IF;
1011: -- End of OTM R12 : packing ECO
1012:
1013: WSH_TRIPS_ACTIONS.Trip_weight_volume(
1014: p_trip_rows => l_trip_id_tab,
1015: p_override_flag => p_action_prms.override_flag,
1016: p_start_departure_date => p_action_prms.actual_date,
1017: x_return_status => l_return_status,

Line 1246: WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION(

1242: END IF;
1243: RAISE FND_API.G_EXC_ERROR;
1244: END IF;
1245:
1246: WSH_TRIPS_ACTIONS.PROCESS_CARRIER_SELECTION(
1247: p_init_msg_list => FND_API.G_FALSE,
1248: p_trip_id_tab => l_trip_id_tab,
1249: p_caller => p_action_prms.caller, -- WSH_FSTRX / WSH_PUB / WSH_GROUP/ FTE
1250: x_msg_count => l_msg_count,

Line 1282: WSH_TRIPS_ACTIONS.Remove_Consolidation(

1278:
1279: END IF;
1280:
1281:
1282: WSH_TRIPS_ACTIONS.Remove_Consolidation(
1283: p_trip_id_tab => l_trip_id_tab,
1284: p_unassign_all => l_unassign_all,
1285: p_caller => p_action_prms.caller,
1286: x_return_status => l_return_status);

Line 1680: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',

1676: WSH_DEBUG_SV.pop(l_module_name);
1677: END IF;
1678: WHEN OTHERS THEN
1679: ROLLBACK TO s_trip_action_grp;
1680: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1681: l_module_name);
1682:
1683:
1684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1726: x_pvt_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,

1722:
1723: --Harmonization Project **heali
1724: PROCEDURE map_tripgrp_to_pvt(
1725: p_grp_trip_rec IN TRIP_PUB_REC_TYPE,
1726: x_pvt_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,
1727: x_return_status OUT NOCOPY VARCHAR2) IS
1728:
1729: l_debug_on BOOLEAN;
1730: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'MAP_TRIPPUB_TO_GRP';

Line 1820: (p_trip_info_tab IN OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

1816: --
1817: END map_tripgrp_to_pvt;
1818:
1819: PROCEDURE Validate_Trip
1820: (p_trip_info_tab IN OUT NOCOPY WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
1821: p_action_code IN VARCHAR2,
1822: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type,
1823: x_return_status OUT NOCOPY VARCHAR2,
1824: p_caller IN VARCHAR2 DEFAULT NULL) IS

Line 1831: FROM wsh_trips

1827: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_TRIP';
1828:
1829: CURSOR get_trip_info(p_trip_id NUMBER) IS
1830: SELECT consolidation_allowed, vehicle_item_id, vehicle_organization_id, ship_method_code, carrier_id, service_level, mode_of_transport, lane_id
1831: FROM wsh_trips
1832: WHERE trip_id= p_trip_id;
1833:
1834: l_db_trip_info WSH_TRIPS_PVT.trip_rec_type;
1835:

Line 1834: l_db_trip_info WSH_TRIPS_PVT.trip_rec_type;

1830: SELECT consolidation_allowed, vehicle_item_id, vehicle_organization_id, ship_method_code, carrier_id, service_level, mode_of_transport, lane_id
1831: FROM wsh_trips
1832: WHERE trip_id= p_trip_id;
1833:
1834: l_db_trip_info WSH_TRIPS_PVT.trip_rec_type;
1835:
1836: l_ship_method_code varchar2(32764);
1837: l_num_errors NUMBER := 0;
1838: l_num_warnings NUMBER := 0;

Line 2373: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

2369: PROCEDURE Create_Update_Trip(
2370: p_api_version_number IN NUMBER,
2371: p_init_msg_list IN VARCHAR2,
2372: p_commit IN VARCHAR2,
2373: p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
2374: p_In_rec IN tripInRecType,
2375: x_Out_Tab OUT NOCOPY trip_Out_Tab_Type,
2376: x_return_status OUT NOCOPY VARCHAR2,
2377: x_msg_count OUT NOCOPY NUMBER,

Line 2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2391: l_sp_disabled_list VARCHAR2(30) := 'get_disabled_list';
2392: l_return_status VARCHAR2(1);
2393:
2394: x_valid_index_tab wsh_util_core.id_tab_type;
2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2398:
2399: --Compatibility Changes

Line 2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2392: l_return_status VARCHAR2(1);
2393:
2394: x_valid_index_tab wsh_util_core.id_tab_type;
2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2398:
2399: --Compatibility Changes
2400: l_cc_validate_result VARCHAR2(1);

Line 2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

2393:
2394: x_valid_index_tab wsh_util_core.id_tab_type;
2395: l_p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2396: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2397: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2398:
2399: --Compatibility Changes
2400: l_cc_validate_result VARCHAR2(1);
2401: l_cc_failed_records WSH_FTE_COMP_CONSTRAINT_PKG.failed_line_tab_type;

Line 2407: l_trip_info_tab_temp WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2403: l_cc_line_groups WSH_FTE_COMP_CONSTRAINT_PKG.line_group_tab_type;
2404: l_msg_count NUMBER;
2405: l_msg_data VARCHAR2(2000);
2406:
2407: l_trip_info_tab_temp WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2408: l_cc_count_success NUMBER;
2409: b_cc_linefailed BOOLEAN;
2410:
2411: --dummy tables for calling validate_constraint_wrapper

Line 2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2410:
2411: --dummy tables for calling validate_constraint_wrapper
2412: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2413: l_cc_det_attr_tab WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type;
2414: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2415: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2416: l_cc_in_ids wsh_util_core.id_tab_type;
2417: l_cc_fail_ids wsh_util_core.id_tab_type;
2418:

Line 2422: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt

2418:
2419: --Compatibility Changes
2420: CURSOR c_getorgcarriersmc (p_tripid NUMBER) IS
2421: SELECT wnd.organization_id, wnd.name, wt.ship_method_code, wt.carrier_id
2422: FROM wsh_new_deliveries wnd, wsh_trip_stops wts, wsh_delivery_legs wdl, wsh_trips wt
2423: WHERE wnd.delivery_id=wdl.delivery_id
2424: and wdl.pick_up_stop_id=wts.stop_id
2425: and wt.trip_id = p_tripid
2426: and wt.trip_id=wts.trip_id

Line 2432: l_smc wsh_trips.ship_method_code%TYPE;

2428: and rownum=1;
2429:
2430: l_wh_type VARCHAR2(3);
2431: l_organization_id wsh_new_deliveries.organization_id%TYPE;
2432: l_smc wsh_trips.ship_method_code%TYPE;
2433: l_carrier_id wsh_trips.carrier_id%TYPE;
2434: l_param_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2435: l_autofirm_loadtender_trip Varchar2(10) := null;
2436:

Line 2433: l_carrier_id wsh_trips.carrier_id%TYPE;

2429:
2430: l_wh_type VARCHAR2(3);
2431: l_organization_id wsh_new_deliveries.organization_id%TYPE;
2432: l_smc wsh_trips.ship_method_code%TYPE;
2433: l_carrier_id wsh_trips.carrier_id%TYPE;
2434: l_param_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2435: l_autofirm_loadtender_trip Varchar2(10) := null;
2436:
2437: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

Line 2437: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

2433: l_carrier_id wsh_trips.carrier_id%TYPE;
2434: l_param_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2435: l_autofirm_loadtender_trip Varchar2(10) := null;
2436:
2437: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2438: l_action VARCHAR2(20);
2439: l_trip_ids wsh_util_core.id_tab_type;
2440:
2441: BEGIN

Line 2672: WSH_TRIPS_PVT.CREATE_TRIP (

2668: WHILE l_index IS NOT NULL LOOP
2669: BEGIN
2670: SAVEPOINT l_trip;
2671: IF (p_in_rec.action_code = 'CREATE' ) THEN
2672: WSH_TRIPS_PVT.CREATE_TRIP (
2673: p_trip_info => l_trip_info_tab(x_valid_index_tab(l_index)),
2674: x_rowid => x_out_Tab(l_index).rowid,
2675: x_trip_id => x_out_Tab(l_index).trip_id,
2676: x_name => x_out_Tab(l_index).trip_name,

Line 2694: FROM WSH_TRIPS

2690: INTO
2691: l_trip_info_tab(x_valid_index_tab(l_index)).ROUTING_RULE_ID,
2692: l_trip_info_tab(x_valid_index_tab(l_index)).APPEND_FLAG,
2693: l_trip_info_tab(x_valid_index_tab(l_index)).RANK_ID
2694: FROM WSH_TRIPS
2695: WHERE ROWID = l_trip_info_tab(x_valid_index_tab(l_index)).rowid;
2696: END IF;
2697:
2698: WSH_TRIPS_PVT.UPDATE_TRIP(

Line 2698: WSH_TRIPS_PVT.UPDATE_TRIP(

2694: FROM WSH_TRIPS
2695: WHERE ROWID = l_trip_info_tab(x_valid_index_tab(l_index)).rowid;
2696: END IF;
2697:
2698: WSH_TRIPS_PVT.UPDATE_TRIP(
2699: p_rowid => l_trip_info_tab(x_valid_index_tab(l_index)).rowid,
2700: p_trip_info => l_trip_info_tab(x_valid_index_tab(l_index)),
2701: x_return_status => l_return_status);
2702:

Line 2741: wsh_trips_actions.Plan(p_trip_rows => l_trip_ids,

2737: l_action:='UNPLAN';
2738: END IF;
2739: IF l_action is not null THEN
2740: l_trip_ids(1):=l_trip_info_tab(x_valid_index_tab(l_index)).trip_id;
2741: wsh_trips_actions.Plan(p_trip_rows => l_trip_ids,
2742: p_action => l_action,
2743: x_return_status => l_return_status);
2744:
2745: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,

Line 2955: -- COMMENT : Creates or updates a record in wsh_trips table with information

2951: -- p_trip_IN_rec Input Attributes for the trip entity
2952: -- p_trip_OUT_rec Output Attributes for the trip entity
2953: -- VERSION : current version 1.0
2954: -- initial version 1.0
2955: -- COMMENT : Creates or updates a record in wsh_trips table with information
2956: -- specified in p_trip_info
2957: --========================================================================
2958:
2959: PROCEDURE Create_Update_Trip_New

Line 2976: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

2972: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP_NEW';
2973:
2974: l_num_errors NUMBER;
2975: l_num_warnings NUMBER;
2976: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2977: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2978: l_out_tab trip_out_tab_type;
2979: l_commit VARCHAR2(1):='F';
2980: BEGIN

Line 2977: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2973:
2974: l_num_errors NUMBER;
2975: l_num_warnings NUMBER;
2976: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2977: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2978: l_out_tab trip_out_tab_type;
2979: l_commit VARCHAR2(1):='F';
2980: BEGIN
2981: -- Standard call to check for call compatibility

Line 3105: -- COMMENT : Creates or updates a record in wsh_trips table with information

3101: -- x_trip_id Trip id of new trip
3102: -- x_trip_name Trip name of new trip
3103: -- VERSION : current version 1.0
3104: -- initial version 1.0
3105: -- COMMENT : Creates or updates a record in wsh_trips table with information
3106: -- specified in p_trip_info
3107: --========================================================================
3108:
3109: PROCEDURE Create_Update_Trip

Line 3128: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;

3124: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP';
3125:
3126: l_num_errors NUMBER;
3127: l_num_warnings NUMBER;
3128: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
3129: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3130: l_out_tab trip_out_tab_type;
3131: l_in_rec TripInRecType;
3132: l_commit VARCHAR2(1):='F';

Line 3129: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

3125:
3126: l_num_errors NUMBER;
3127: l_num_warnings NUMBER;
3128: l_pvt_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
3129: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
3130: l_out_tab trip_out_tab_type;
3131: l_in_rec TripInRecType;
3132: l_commit VARCHAR2(1):='F';
3133: BEGIN

Line 3252: x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,

3248:
3249: -- API to get Trip Details
3250: PROCEDURE get_trip_details_pvt
3251: (p_trip_id IN NUMBER,
3252: x_trip_rec OUT NOCOPY WSH_TRIPS_PVT.TRIP_REC_TYPE,
3253: x_return_status OUT NOCOPY VARCHAR2) IS
3254:
3255: CURSOR c_old_trip_details(v_trip_id IN NUMBER) IS
3256: SELECT TRIP_ID,

Line 3309: FROM wsh_trips

3305: PROGRAM_UPDATE_DATE,
3306: REQUEST_ID,
3307: nvl(SHIPMENTS_TYPE_FLAG, 'O'), -- J inbound logistics jckwok
3308: OPERATOR
3309: FROM wsh_trips
3310: WHERE trip_id = v_trip_id;
3311:
3312: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;
3313:

Line 3312: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;

3308: OPERATOR
3309: FROM wsh_trips
3310: WHERE trip_id = v_trip_id;
3311:
3312: l_stops_trip_rec WSH_TRIPS_PVT.trip_rec_type;
3313:
3314: --
3315: l_debug_on BOOLEAN;
3316: --

Line 3404: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIPS_GRP.get_trip_details_pvt',l_module_name);

3400: END IF;
3401: --
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIPS_GRP.get_trip_details_pvt',l_module_name);
3405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3406: --
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3414: END WSH_TRIPS_GRP;

3410: END IF;
3411: --
3412: END;
3413:
3414: END WSH_TRIPS_GRP;