8: -------------
9: --========================================================================
10: -- PROCEDURE : Create_Update_Stop FTE wrapper
11: --
12: -- COMMENT : Wrapper around WSH_TRIP_STOPS_GRP.Create_Update
13: -- Passes in all the parameters reqd (record type input changed to
14: -- number of parameters which are collected, assigned to a record
15: -- and call WSH_TRIP_STOPS_GRP.Create_Update
16: --========================================================================
11: --
12: -- COMMENT : Wrapper around WSH_TRIP_STOPS_GRP.Create_Update
13: -- Passes in all the parameters reqd (record type input changed to
14: -- number of parameters which are collected, assigned to a record
15: -- and call WSH_TRIP_STOPS_GRP.Create_Update
16: --========================================================================
17:
18: PROCEDURE Create_Update_Stop
19: (
111: ) IS
112:
113: --
114: p_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
118:
119: l_stop_seq_rec FTE_MLS_WRAPPER.stop_seq_rec;
112:
113: --
114: p_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
115: p_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
116: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
117: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
118:
119: l_stop_seq_rec FTE_MLS_WRAPPER.stop_seq_rec;
120: p_commit VARCHAR2(1);
400: p_defer_interface_flag IN VARCHAR2 DEFAULT 'Y')
401:
402: IS
403:
404: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
405:
406: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
407: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
408: p_commit VARCHAR2(1);
402: IS
403:
404: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
405:
406: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
407: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
408: p_commit VARCHAR2(1);
409:
410: --
3117: x_msg_data OUT NOCOPY VARCHAR2
3118: ) IS
3119:
3120:
3121: l_wsh_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
3122: l_wsh_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
3123: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
3124: l_commit VARCHAR2(1);
3125:
3118: ) IS
3119:
3120:
3121: l_wsh_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
3122: l_wsh_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
3123: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
3124: l_commit VARCHAR2(1);
3125:
3126:
3472: --
3473: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'PROCESS_STOPS';
3474:
3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
3476: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
3477: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3478: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3479:
3480: l_index NUMBER;
3473: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'PROCESS_STOPS';
3474:
3475: l_stop_info WSH_TRIP_STOPS_PVT.Trip_Stop_Rec_Type;
3476: l_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
3477: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3478: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3479:
3480: l_index NUMBER;
3481:
3725: PROCEDURE CREATE_UPDATE_STOP(
3726: p_api_version_number IN NUMBER,
3727: p_init_msg_list IN VARCHAR2,
3728: p_commit IN VARCHAR2,
3729: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
3730: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
3731: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
3732: x_return_status OUT NOCOPY VARCHAR2,
3733: x_msg_count OUT NOCOPY NUMBER,
3727: p_init_msg_list IN VARCHAR2,
3728: p_commit IN VARCHAR2,
3729: p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
3730: p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
3731: x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
3732: x_return_status OUT NOCOPY VARCHAR2,
3733: x_msg_count OUT NOCOPY NUMBER,
3734: x_msg_data OUT NOCOPY VARCHAR2) IS
3735:
3736: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3737: --
3738: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
3739:
3740: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
3741: l_rec_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
3742:
3743: l_number_of_warnings NUMBER;
3744: l_number_of_errors NUMBER;