APPS.WSH_TRIPS_GRP dependencies on WSH_TRIPS_GRP

Line 1: PACKAGE BODY WSH_TRIPS_GRP as

1: PACKAGE BODY WSH_TRIPS_GRP as
2: /* $Header: WSHTRGPB.pls 120.7 2007/01/05 19:23:14 parkhj noship $ */
3:
4:
5: --===================

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIPS_GRP';

4:
5: --===================
6: -- CONSTANTS
7: --===================
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_TRIPS_GRP';
9: -- add your constants here if any
10:
11: --===================
12: -- PROCEDURES

Line 51: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

47:
48: l_api_version_number CONSTANT NUMBER := 1.0;
49: l_api_name CONSTANT VARCHAR2(30):= 'Trip_Action';
50:
51: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
52: l_entity_id_tab wsh_util_core.id_tab_type;
53: --
54: trip_action_error EXCEPTION;
55:

Line 259: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

255: --
256: trip_action_error EXCEPTION;
257:
258: l_trip_rows wsh_util_core.id_tab_type;
259: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
260: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
261:
262:
263: l_trip_id NUMBER := p_trip_id;

Line 260: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;

256: trip_action_error EXCEPTION;
257:
258: l_trip_rows wsh_util_core.id_tab_type;
259: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
260: l_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
261:
262:
263: l_trip_id NUMBER := p_trip_id;
264: --

Line 837: WSH_TRIPS_GRP.get_trip_details_pvt(

833: BEGIN
834:
835: SAVEPOINT s_clean_loop_grp;
836:
837: WSH_TRIPS_GRP.get_trip_details_pvt(
838: p_trip_id => l_trip_id_tab(i),
839: x_trip_rec => l_trip_rec,
840: x_return_status => l_return_status
841: );

Line 1680: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',

1676: WSH_DEBUG_SV.pop(l_module_name);
1677: END IF;
1678: WHEN OTHERS THEN
1679: ROLLBACK TO s_trip_action_grp;
1680: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1681: l_module_name);
1682:
1683:
1684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2437: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

2433: l_carrier_id wsh_trips.carrier_id%TYPE;
2434: l_param_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
2435: l_autofirm_loadtender_trip Varchar2(10) := null;
2436:
2437: l_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2438: l_action VARCHAR2(20);
2439: l_trip_ids wsh_util_core.id_tab_type;
2440:
2441: BEGIN

Line 3404: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIPS_GRP.get_trip_details_pvt',l_module_name);

3400: END IF;
3401: --
3402: EXCEPTION
3403: WHEN OTHERS THEN
3404: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIPS_GRP.get_trip_details_pvt',l_module_name);
3405: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3406: --
3407: IF l_debug_on THEN
3408: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3414: END WSH_TRIPS_GRP;

3410: END IF;
3411: --
3412: END;
3413:
3414: END WSH_TRIPS_GRP;