APPS.WSH_EXCEPTIONS_GRP dependencies on WSH_EXCEPTIONS_PUB

Line 39: x_exceptions_tab OUT NOCOPY WSH_EXCEPTIONS_PUB.XC_TAB_TYPE

35: p_logging_entity_id IN NUMBER,
36: p_logging_entity_name IN VARCHAR2,
37:
38: -- program specific out parameters
39: x_exceptions_tab OUT NOCOPY WSH_EXCEPTIONS_PUB.XC_TAB_TYPE
40: ) IS
41:
42: CURSOR Get_Trip_Exceptions (v_trip_id NUMBER) IS
43: SELECT exception_id, exception_name, status

Line 253: l_exceptions_tab WSH_EXCEPTIONS_PUB.xc_tab_type;

249: -- Standard call to check for call compatibility
250: l_api_version CONSTANT NUMBER := 1.0;
251: l_api_name CONSTANT VARCHAR2(30):= 'Change_Status';
252:
253: l_exceptions_tab WSH_EXCEPTIONS_PUB.xc_tab_type;
254: l_temp_tab WSH_EXCEPTIONS_PUB.xc_tab_type;
255: l_count NUMBER;
256: l_new_status VARCHAR2(30);
257: l_old_status VARCHAR2(30);

Line 254: l_temp_tab WSH_EXCEPTIONS_PUB.xc_tab_type;

250: l_api_version CONSTANT NUMBER := 1.0;
251: l_api_name CONSTANT VARCHAR2(30):= 'Change_Status';
252:
253: l_exceptions_tab WSH_EXCEPTIONS_PUB.xc_tab_type;
254: l_temp_tab WSH_EXCEPTIONS_PUB.xc_tab_type;
255: l_count NUMBER;
256: l_new_status VARCHAR2(30);
257: l_old_status VARCHAR2(30);
258: l_success_count NUMBER;

Line 554: p_exception_rec IN OUT NOCOPY WSH_EXCEPTIONS_PUB.XC_ACTION_REC_TYPE

550: x_msg_data OUT NOCOPY VARCHAR2,
551: x_return_status OUT NOCOPY VARCHAR2,
552:
553: -- Program specific parameters
554: p_exception_rec IN OUT NOCOPY WSH_EXCEPTIONS_PUB.XC_ACTION_REC_TYPE
555: ) IS
556:
557: -- cursor to validate stop_location
558: CURSOR C1(c_trip_id NUMBER) IS

Line 1277: p_exception_rec IN WSH_EXCEPTIONS_PUB.XC_ACTION_REC_TYPE,

1273: x_msg_data OUT NOCOPY VARCHAR2,
1274: x_return_status OUT NOCOPY VARCHAR2,
1275:
1276: -- Program specific parameters
1277: p_exception_rec IN WSH_EXCEPTIONS_PUB.XC_ACTION_REC_TYPE,
1278: p_action IN VARCHAR2
1279: ) IS
1280:
1281: -- cursor to validate the exception name

Line 1874: p_exception_rec IN OUT NOCOPY WSH_EXCEPTIONS_PUB.XC_ACTION_REC_TYPE,

1870: x_msg_data OUT NOCOPY VARCHAR2,
1871: x_return_status OUT NOCOPY VARCHAR2,
1872:
1873: -- Program specific parameters
1874: p_exception_rec IN OUT NOCOPY WSH_EXCEPTIONS_PUB.XC_ACTION_REC_TYPE,
1875: p_action IN VARCHAR2
1876: ) IS
1877:
1878: l_action VARCHAR2(20);