DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_UTIL_CORE

Line 83: x_del_to_unassign OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

79: PROCEDURE valid_delivery_on_trip
80: (p_stop_id IN NUMBER,
81: p_trip_id IN NUMBER,
82: p_stop_sequence_number IN NUMBER,
83: x_del_to_unassign OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
84: x_return_status OUT NOCOPY VARCHAR2);
85:
86: PROCEDURE get_new_sequence_number
87: (x_stop_sequence_number IN OUT NOCOPY NUMBER,

Line 101: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,

97: p_stop_rec_tab IN stop_rec_tab_type,
98: p_action IN VARCHAR2,
99: p_caller IN VARCHAR2,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
102: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
103: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type);
104:
105:

Line 102: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,

98: p_action IN VARCHAR2,
99: p_caller IN VARCHAR2,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
102: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
103: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type);
104:
105:
106: --

Line 103: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type);

99: p_caller IN VARCHAR2,
100: x_return_status OUT NOCOPY VARCHAR2,
101: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
102: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
103: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type);
104:
105:
106: --
107: -- Bug 2678363 - Added p_in_rec as a parameter instead of p_action

Line 150: id_tbl wsh_util_core.id_tab_type,

146: --
147: TYPE dlvy_rec_type
148: IS RECORD
149: (
150: id_tbl wsh_util_core.id_tab_type,
151: name_tbl wsh_util_core.Column_Tab_Type,
152: statusCode_tbl wsh_util_core.Column_Tab_Type,
153: orgId_tbl wsh_util_core.id_tab_type
154: );

Line 151: name_tbl wsh_util_core.Column_Tab_Type,

147: TYPE dlvy_rec_type
148: IS RECORD
149: (
150: id_tbl wsh_util_core.id_tab_type,
151: name_tbl wsh_util_core.Column_Tab_Type,
152: statusCode_tbl wsh_util_core.Column_Tab_Type,
153: orgId_tbl wsh_util_core.id_tab_type
154: );
155: --

Line 152: statusCode_tbl wsh_util_core.Column_Tab_Type,

148: IS RECORD
149: (
150: id_tbl wsh_util_core.id_tab_type,
151: name_tbl wsh_util_core.Column_Tab_Type,
152: statusCode_tbl wsh_util_core.Column_Tab_Type,
153: orgId_tbl wsh_util_core.id_tab_type
154: );
155: --
156: --

Line 153: orgId_tbl wsh_util_core.id_tab_type

149: (
150: id_tbl wsh_util_core.id_tab_type,
151: name_tbl wsh_util_core.Column_Tab_Type,
152: statusCode_tbl wsh_util_core.Column_Tab_Type,
153: orgId_tbl wsh_util_core.id_tab_type
154: );
155: --
156: --
157: TYPE chkclose_out_rec_type

Line 172: initial_pu_err_dlvy_id_tbl wsh_util_core.id_tab_type,

168: stop_sequence_number NUMBER,
169: initial_pu_dlvy_recTbl dlvy_rec_type,
170: -- Deliveries starting from this stop, which can be set to in-transit.
171: --
172: initial_pu_err_dlvy_id_tbl wsh_util_core.id_tab_type,
173: -- Deliveries starting from this stop, which cannot be set to in-transit.
174: --
175: ultimate_do_dlvy_recTbl dlvy_rec_type,
176: -- Deliveries ending at this stop, which can be closed.