DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TRIPS_GRP

Line 90: x_def_rec IN OUT NOCOPY WSH_TRIPS_GRP.default_parameters_rectype,

86: END get_stop_seq_mode;
87:
88: PROCEDURE Get_Trip_Defaults(p_trip_id in NUMBER,
89: p_trip_name in VARCHAR2 DEFAULT NULL,
90: x_def_rec IN OUT NOCOPY WSH_TRIPS_GRP.default_parameters_rectype,
91: x_return_Status OUT NOCOPY varchar2 ) IS
92:
93: cursor get_pickup_stop (c_trip_id number) is
94: select distinct st.stop_id, st.stop_location_id

Line 1034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

1030: --
1031: -- Debug Statements
1032: --
1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
1035: END IF;
1036: --
1037: wsh_trips_grp.get_trip_details_pvt
1038: (p_trip_id => p_trip_id,

Line 1037: wsh_trips_grp.get_trip_details_pvt

1033: IF l_debug_on THEN
1034: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
1035: END IF;
1036: --
1037: wsh_trips_grp.get_trip_details_pvt
1038: (p_trip_id => p_trip_id,
1039: x_trip_rec => l_trip_rec,
1040: x_return_status => l_return_status);
1041:

Line 1280: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

1276: --
1277: -- Debug Statements
1278: --
1279: IF l_debug_on THEN
1280: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
1281: END IF;
1282: --
1283: wsh_trips_grp.get_trip_details_pvt
1284: (p_trip_id => p_in_rec.trip_id,

Line 1283: wsh_trips_grp.get_trip_details_pvt

1279: IF l_debug_on THEN
1280: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);
1281: END IF;
1282: --
1283: wsh_trips_grp.get_trip_details_pvt
1284: (p_trip_id => p_in_rec.trip_id,
1285: x_trip_rec => l_trip_rec,
1286: x_return_status => l_return_status);
1287: --

Line 1525: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,

1521: --
1522: --========================================================================
1523: PROCEDURE generateRoutingResponse
1524: (
1525: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
1526: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
1527: x_return_status OUT NOCOPY VARCHAR2
1528: )
1529: IS

Line 2563: l_grp_trip_rec WSH_TRIPS_GRP.TRIP_PUB_REC_TYPE;

2559: l_stop_rec WSH_TRIP_STOPS_PVT.TRIP_STOP_REC_TYPE;
2560: l_pub_stop_rec WSH_TRIP_STOPS_PUB.TRIP_STOP_PUB_REC_TYPE;
2561: l_trip_rec WSH_TRIPS_PVT.TRIP_REC_TYPE;
2562: l_pub_trip_rec WSH_TRIPS_PUB.TRIP_PUB_REC_TYPE;
2563: l_grp_trip_rec WSH_TRIPS_GRP.TRIP_PUB_REC_TYPE;
2564: --l_return_status VARCHAR2(30);
2565: l_fte_flag VARCHAR2(1):= 'N';
2566: --
2567: l_debug_on BOOLEAN;

Line 8232: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

8228:
8229: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8230: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8231:
8232: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8233: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8234: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
8235:
8236: l_msg_count NUMBER;

Line 8234: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

8230: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8231:
8232: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8233: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8234: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
8235:
8236: l_msg_count NUMBER;
8237: l_msg_data VARCHAR2(2000);
8238: l_return_message VARCHAR2(2000);

Line 8654: -- Call WSH_TRIPS_GRP.create_update_trip to update trip if required

8650: END IF;
8651:
8652: --IF (l_cs_result_tab(rec_cnt).rank = 1) THEN
8653: -- Has to update trip
8654: -- Call WSH_TRIPS_GRP.create_update_trip to update trip if required
8655:
8656: -- AG
8657: l_trip_info_tab.DELETE;
8658: --l_trip_in_rec.caller := 'FTE_CARRIER_SELECTION_FORM';

Line 8688: WSH_TRIPS_GRP.Create_Update_Trip(

8684: -- AG
8685: l_trip_info_tab(1).routing_rule_id := l_cs_result_tab(rec_cnt).rule_id;
8686: l_trip_info_tab(1).append_flag := 'Y';
8687:
8688: WSH_TRIPS_GRP.Create_Update_Trip(
8689: p_api_version_number => 1.0,
8690: p_init_msg_list => l_init_msg_list,
8691: p_commit => l_commit,
8692: x_return_status => l_return_status,