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 1032: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_GRP.GET_TRIP_DETAILS_PVT',WSH_DEBUG_SV.C_PROC_LEVEL);

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

Line 1035: wsh_trips_grp.get_trip_details_pvt

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

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

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

Line 1281: wsh_trips_grp.get_trip_details_pvt

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

Line 1523: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,

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

Line 2561: l_grp_trip_rec WSH_TRIPS_GRP.TRIP_PUB_REC_TYPE;

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

Line 8221: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;

8217:
8218: l_commit VARCHAR2(100) := FND_API.G_FALSE;
8219: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8220:
8221: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8222: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8223: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
8224:
8225: l_msg_count NUMBER;

Line 8223: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;

8219: l_init_msg_list VARCHAR2(100) := FND_API.G_FALSE;
8220:
8221: l_trip_in_rec WSH_TRIPS_GRP.tripInRecType;
8222: l_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
8223: l_trip_out_rec_tab WSH_TRIPS_GRP.Trip_Out_Tab_Type;
8224:
8225: l_msg_count NUMBER;
8226: l_msg_data VARCHAR2(2000);
8227: l_return_message VARCHAR2(2000);

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

8639: END IF;
8640:
8641: --IF (l_cs_result_tab(rec_cnt).rank = 1) THEN
8642: -- Has to update trip
8643: -- Call WSH_TRIPS_GRP.create_update_trip to update trip if required
8644:
8645: -- AG
8646: l_trip_info_tab.DELETE;
8647: --l_trip_in_rec.caller := 'FTE_CARRIER_SELECTION_FORM';

Line 8677: WSH_TRIPS_GRP.Create_Update_Trip(

8673: -- AG
8674: l_trip_info_tab(1).routing_rule_id := l_cs_result_tab(rec_cnt).rule_id;
8675: l_trip_info_tab(1).append_flag := 'Y';
8676:
8677: WSH_TRIPS_GRP.Create_Update_Trip(
8678: p_api_version_number => 1.0,
8679: p_init_msg_list => l_init_msg_list,
8680: p_commit => l_commit,
8681: x_return_status => l_return_status,