182:
183: --{Trip update parameters
184: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
185: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
186: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
187: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
188: --}
189:
190:
183: --{Trip update parameters
184: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
185: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
186: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
187: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
188: --}
189:
190:
191: CURSOR get_trip IS
343:
344: --{Trip update parameters
345: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
346: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
347: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
348: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
349: --}
350:
351:
344: --{Trip update parameters
345: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
346: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
347: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
348: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
349: --}
350:
351:
352: CURSOR GET_TENDER_STATUS IS
754:
755: --{Trip update parameters
756: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
757: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
758: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
759: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
760: --}
761:
762:
755: --{Trip update parameters
756: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
757: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
758: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
759: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
760: --}
761:
762:
763: CURSOR get_trip IS
1310:
1311: --{Trip update parameters
1312: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1313: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1314: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1315: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1316: --}
1317:
1318:
1311: --{Trip update parameters
1312: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
1313: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
1314: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
1315: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
1316: --}
1317:
1318:
1319: BEGIN
2302:
2303: --{Trip update parameters
2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2306: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2307: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2308: --}
2309:
2310:
2303: --{Trip update parameters
2304: p_trip_info_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2305: p_trip_info WSH_TRIPS_PVT.Trip_Rec_Type;
2306: p_trip_in_rec WSH_TRIPS_GRP.TripInRecType;
2307: x_out_tab WSH_TRIPS_GRP.trip_Out_tab_type;
2308: --}
2309:
2310:
2311: