APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_TRIP_STOPS_VALIDATIONS

Line 20: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,

16: x_return_status OUT NOCOPY VARCHAR2
17: );
18:
19: PROCEDURE Add_to_Delete_List(
20: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,
21: p_caller IN VARCHAR2,
22: x_stop_delete_tab OUT NOCOPY wsh_util_core.id_tab_type,
23: x_trip_affected_tab OUT NOCOPY wsh_util_core.id_tab_type,
24: x_return_status OUT NOCOPY VARCHAR2) ;

Line 520: l_stop_rec_tab wsh_trip_stops_validations.stop_rec_tab_type;

516: l_error_ids wsh_util_core.id_tab_type;
517: l_dummy_ids wsh_util_core.id_tab_type;
518: l_dummy_doc_param WSH_DOCUMENT_SETS.DOCUMENT_SET_TAB_TYPE;
519: l_num NUMBER;
520: l_stop_rec_tab wsh_trip_stops_validations.stop_rec_tab_type;
521: l_first NUMBER;
522: l_next NUMBER;
523: l_last NUMBER;
524: l_stop_id NUMBER;

Line 572: l_delete_tmp_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;

568: --Compatibility Changes
569: l_stop_delete_tab wsh_util_core.id_tab_type;
570: l_trip_affected_tab wsh_util_core.id_tab_type;
571: l_success_trip_tab wsh_util_core.id_tab_type;
572: l_delete_tmp_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
573: l_delete_t WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
574:
575: CURSOR c_check_trip_close (p_trip_id IN NUMBER) IS
576: SELECT trip_id

Line 573: l_delete_t WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;

569: l_stop_delete_tab wsh_util_core.id_tab_type;
570: l_trip_affected_tab wsh_util_core.id_tab_type;
571: l_success_trip_tab wsh_util_core.id_tab_type;
572: l_delete_tmp_tab WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
573: l_delete_t WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab;
574:
575: CURSOR c_check_trip_close (p_trip_id IN NUMBER) IS
576: SELECT trip_id
577: FROM WSH_TRIPS

Line 735: WSH_TRIP_STOPS_validations.Is_Action_Enabled(

731: --
732: END IF;
733:
734: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
735: WSH_TRIP_STOPS_validations.Is_Action_Enabled(
736: p_stop_rec_tab => l_stop_rec_tab,
737: p_action => p_action_prms.action_code,
738: p_caller => p_action_prms.caller,
739: x_return_status => l_return_status,

Line 1930: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

1926: WSH_STOP_VALIDATION EXCEPTION;
1927: e_mixed_stop_error EXCEPTION;
1928:
1929: -- J-Stop Sequence Change-CSUN
1930: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
1931:
1932: l_stop_id NUMBER;
1933:
1934: BEGIN

Line 2126: WSH_TRIP_STOPS_validations.validate_sequence_number (

2122: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND
2123: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1 ) THEN
2124:
2125: IF (l_status_code = 'OP') THEN
2126: WSH_TRIP_STOPS_validations.validate_sequence_number (
2127: p_stop_id => p_rec_attr_tab(l_index).stop_id,
2128: p_stop_sequence_number => p_rec_attr_tab(l_index).stop_sequence_number,
2129: p_trip_id => p_rec_attr_tab(l_index).trip_id,
2130: p_status_code => l_status_code,

Line 2384: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;

2380: l_stop_id NUMBER;
2381: l_stop_index NUMBER :=0;
2382: --bug 2796095
2383: l_status_code VARCHAR2(100);
2384: l_stop_details_rec WSH_TRIP_STOPS_VALIDATIONS.stop_details;
2385: l_handle_internal_stops BOOLEAN;
2386: l_reset_stop_sequence BOOLEAN;
2387:
2388: get_physical_loc_err EXCEPTION;

Line 2508: WSH_TRIP_STOPS_validations.get_disabled_list(

2504: WSH_DEBUG_SV.log(l_module_name,'stop_id,trip_id',p_rec_attr_tab(l_index).stop_id||','||
2505: p_rec_attr_tab(l_index).trip_id);
2506: END IF;
2507:
2508: WSH_TRIP_STOPS_validations.get_disabled_list(
2509: p_stop_rec => p_rec_attr_tab(l_index),
2510: p_parent_entity_id => p_rec_attr_tab(l_index).trip_id,
2511: p_in_rec => p_in_rec,
2512: x_return_status => l_return_status,

Line 4114: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,

4110:
4111:
4112:
4113: PROCEDURE Add_to_Delete_List(
4114: p_stop_tab IN WSH_TRIP_STOPS_VALIDATIONS.stop_details_tab,
4115: p_caller IN VARCHAR2,
4116: x_stop_delete_tab OUT NOCOPY wsh_util_core.id_tab_type,
4117: x_trip_affected_tab OUT NOCOPY wsh_util_core.id_tab_type,
4118: x_return_status OUT NOCOPY VARCHAR2)

Line 4257: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.Add_to_Delete_List',l_module_name);

4253: IF c_linked_stop%ISOPEN THEN
4254: close c_linked_stop;
4255: END IF;
4256:
4257: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.Add_to_Delete_List',l_module_name);
4258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4261: END IF;