APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_TRIPS_PVT

Line 532: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

528: l_valid_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
529: l_num_warning NUMBER := 0;
530: l_num_errors NUMBER := 0;
531: l_return_status VARCHAR2(500);
532: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
533: l_stop_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
534: l_api_version_number CONSTANT NUMBER := 1.0;
535: l_api_name CONSTANT VARCHAR2(30):= 'Stop_Action';
536: l_counter NUMBER;

Line 562: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

558: l_cc_stop_id_tab wsh_util_core.id_tab_type;
559: l_cc_count_success NUMBER;
560: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
561: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
562: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
563: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
564: l_cc_in_ids wsh_util_core.id_tab_type;
565: l_cc_fail_ids wsh_util_core.id_tab_type;
566: l_msg_count NUMBER;

Line 1923: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;

1919: l_action VARCHAR2(100);
1920: l_return_status VARCHAR2(1);
1921: x_msg_count NUMBER;
1922: x_msg_data varchar2(3000);
1923: l_trip_rec WSH_TRIPS_PVT.trip_rec_type;
1924: l_isWshLocation BOOLEAN DEFAULT FALSE;
1925:
1926: WSH_STOP_VALIDATION EXCEPTION;
1927: e_mixed_stop_error EXCEPTION;

Line 2334: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;

2330:
2331: --dummy tables for calling validate_constraint_mainper
2332: l_cc_del_attr_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2333: l_cc_det_attr_tab wsh_glbl_var_strct_grp.Delivery_Details_Attr_Tbl_Type;
2334: l_cc_trip_attr_tab WSH_TRIPS_PVT.Trip_Attr_Tbl_Type;
2335: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
2336: l_cc_in_ids wsh_util_core.id_tab_type;
2337: l_cc_fail_ids wsh_util_core.id_tab_type;
2338:

Line 3971: WSH_TRIPS_PVT.lock_trip_no_compare(

3967:
3968: IF l_trip_status = 'OP'
3969: THEN
3970: -- {
3971: WSH_TRIPS_PVT.lock_trip_no_compare(
3972: p_trip_id => l_trip_id
3973: );
3974:
3975: ELSIF l_trip_status = 'IT'

Line 3983: WSH_TRIPS_PVT.lock_trip_no_compare(

3979: IF c_unclosed_other_stops%NOTFOUND
3980: THEN
3981: CLOSE c_unclosed_other_stops;
3982:
3983: WSH_TRIPS_PVT.lock_trip_no_compare(
3984: p_trip_id => l_trip_id
3985: );
3986: ELSE
3987: IF l_debug_on THEN