eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIPS_PVT dependencies on WSH_TRIPS

Line 1: PACKAGE BODY WSH_TRIPS_PVT AS

1: PACKAGE BODY WSH_TRIPS_PVT AS
2: /* $Header: WSHTRTHB.pls 120.3 2007/01/05 00:26:34 anxsharm ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIPS_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIPS_PVT';

1: PACKAGE BODY WSH_TRIPS_PVT AS
2: /* $Header: WSHTRTHB.pls 120.3 2007/01/05 00:26:34 anxsharm ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIPS_PVT';
6: --
7: PROCEDURE Create_Trip(
8: p_trip_info IN trip_rec_type,
9: x_rowid OUT NOCOPY varchar2,

Line 17: SELECT wsh_trips_s.nextval

13: )
14: IS
15:
16: CURSOR get_next_trip IS
17: SELECT wsh_trips_s.nextval
18: FROM sys.dual;
19:
20: -- Remove cursor get_row_id for Bug 3821688
21:

Line 23: SELECT trip_id FROM wsh_trips

19:
20: -- Remove cursor get_row_id for Bug 3821688
21:
22: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
23: SELECT trip_id FROM wsh_trips
24: WHERE name = v_trip_name;
25:
26: CURSOR check_trip_ids (v_trip_id NUMBER) IS
27: SELECT trip_id FROM wsh_trips

Line 27: SELECT trip_id FROM wsh_trips

23: SELECT trip_id FROM wsh_trips
24: WHERE name = v_trip_name;
25:
26: CURSOR check_trip_ids (v_trip_id NUMBER) IS
27: SELECT trip_id FROM wsh_trips
28: WHERE trip_id = v_trip_id;
29:
30: l_name WSH_TRIPS.NAME%TYPE;
31: l_row_check NUMBER;

Line 30: l_name WSH_TRIPS.NAME%TYPE;

26: CURSOR check_trip_ids (v_trip_id NUMBER) IS
27: SELECT trip_id FROM wsh_trips
28: WHERE trip_id = v_trip_id;
29:
30: l_name WSH_TRIPS.NAME%TYPE;
31: l_row_check NUMBER;
32: l_temp_id NUMBER;
33:
34: l_tmp_count NUMBER := 0;

Line 39: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;

35:
36: wsh_duplicate_name EXCEPTION;
37: others EXCEPTION;
38:
39: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
40: l_gc3_is_installed VARCHAR2(1); -- OTM R12, glog proj
41: --
42: --/== Workflow Changes
43: l_process_started VARCHAR2(1);

Line 178: INSERT INTO wsh_trips(

174:
175: END IF;
176:
177:
178: INSERT INTO wsh_trips(
179: trip_id,
180: name,
181: planned_flag,
182: arrive_after_trip_id,

Line 410: wsh_util_core.default_handler('WSH_TRIPS_PVT.CREATE_TRIP');

406: END IF;
407: IF check_trip_ids%ISOPEN THEN
408: CLOSE check_trip_ids;
409: END IF;
410: wsh_util_core.default_handler('WSH_TRIPS_PVT.CREATE_TRIP');
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
412: --
413: -- Debug Statements
414: --

Line 432: FROM wsh_trips

428: p_caller IN VARCHAR2) IS
429:
430: CURSOR get_trip_id_rowid (v_rowid VARCHAR2) IS
431: SELECT trip_id
432: FROM wsh_trips
433: WHERE rowid = v_rowid;
434:
435: CURSOR trip_deliveries (l_trip_id IN NUMBER) IS
436: SELECT delivery_id

Line 449: FROM WSH_TRIPS

445: --OTM R12, glog proj
446: CURSOR c_get_trip_status (p_trip_id IN NUMBER) IS
447: SELECT NVL(ignore_for_planning, 'N'),
448: tp_plan_name
449: FROM WSH_TRIPS
450: WHERE trip_id = p_trip_id;
451:
452: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
453: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

Line 452: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;

448: tp_plan_name
449: FROM WSH_TRIPS
450: WHERE trip_id = p_trip_id;
451:
452: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
453: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
454: l_gc3_is_installed VARCHAR2(1);
455: e_gc3_trip EXCEPTION;
456: --

Line 453: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;

449: FROM WSH_TRIPS
450: WHERE trip_id = p_trip_id;
451:
452: l_ignore WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
453: l_tp_plan_name WSH_TRIPS.TP_PLAN_NAME%TYPE;
454: l_gc3_is_installed VARCHAR2(1);
455: e_gc3_trip EXCEPTION;
456: --
457:

Line 625: DELETE FROM wsh_trips

621: END IF;
622: -- End of Code for DBI Project
623: --
624:
625: DELETE FROM wsh_trips
626: WHERE trip_id = l_trip_id;
627:
628: IF (SQL%NOTFOUND) THEN
629: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

Line 685: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

681: IF c_get_trip_status%ISOPEN THEN
682: CLOSE c_get_trip_status;
683: END IF;
684: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_DELETE_ERROR');
685: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
687: wsh_util_core.add_message(x_return_status);
688: --
689: -- Debug Statements

Line 701: wsh_util_core.default_handler('WSH_TRIPS_PVT.DELETE_TRIP');

697: -- OTM R12, glog proj
698: IF c_get_trip_status%ISOPEN THEN
699: CLOSE c_get_trip_status;
700: END IF;
701: wsh_util_core.default_handler('WSH_TRIPS_PVT.DELETE_TRIP');
702: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
703: --
704: -- Debug Statements
705: --

Line 720: FROM wsh_trips

716: x_return_status OUT NOCOPY VARCHAR2) IS
717:
718: CURSOR get_row_id IS
719: SELECT rowid
720: FROM wsh_trips
721: WHERE trip_id = p_trip_info.trip_id;
722:
723: l_rowid VARCHAR2(30);
724:

Line 832: UPDATE wsh_trips SET

828: x_return_status => l_wf_rs);
829: END IF;
830: */
831:
832: UPDATE wsh_trips SET
833: trip_id = p_trip_info.trip_id,
834: name = p_trip_info.name,
835: planned_flag = p_trip_info.planned_flag,
836: arrive_after_trip_id = p_trip_info.arrive_after_trip_id,

Line 956: wsh_util_core.default_handler('WSH_TRIPS_PVT.UPDATE_TRIP');

952: --
953:
954:
955: WHEN others THEN
956: wsh_util_core.default_handler('WSH_TRIPS_PVT.UPDATE_TRIP');
957: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
958:
959: --
960: -- Debug Statements

Line 1053: FROM wsh_trips

1049: RANK_ID,
1050: CONSIGNEE_CARRIER_AC_NO,
1051: ROUTING_RULE_ID,
1052: APPEND_FLAG
1053: FROM wsh_trips
1054: WHERE rowid = p_rowid
1055: FOR UPDATE OF trip_id NOWAIT;
1056:
1057: Recinfo lock_row%ROWTYPE;

Line 1060: l_ignore_flag WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;--OTM R12, glog proj

1056:
1057: Recinfo lock_row%ROWTYPE;
1058:
1059: l_gc3_is_installed VARCHAR2(1); -- OTM R12, glog proj
1060: l_ignore_flag WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;--OTM R12, glog proj
1061:
1062: --
1063: l_debug_on BOOLEAN;
1064: --

Line 1452: FROM wsh_trips

1448: RANK_ID,
1449: CONSIGNEE_CARRIER_AC_NO,
1450: ROUTING_RULE_ID,
1451: APPEND_FLAG
1452: FROM wsh_trips
1453: WHERE trip_id = p_trip_id;
1454:
1455: others EXCEPTION;
1456:

Line 1457: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;

1453: WHERE trip_id = p_trip_id;
1454:
1455: others EXCEPTION;
1456:
1457: l_ignore_for_planning WSH_TRIPS.IGNORE_FOR_PLANNING%TYPE;
1458: l_gc3_is_installed VARCHAR2(1); -- OTM R12, glog proj
1459:
1460: --
1461: l_debug_on BOOLEAN;

Line 1524: wsh_util_core.default_handler('WSH_TRIPS_PVT.POPULATE_RECORD');

1520: END IF;
1521: --
1522: EXCEPTION
1523: WHEN others THEN
1524: wsh_util_core.default_handler('WSH_TRIPS_PVT.POPULATE_RECORD');
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1526:
1527: --
1528: -- Debug Statements

Line 1545: FROM wsh_trips

1541: ) RETURN VARCHAR2 IS
1542:
1543: CURSOR get_name IS
1544: SELECT name
1545: FROM wsh_trips
1546: WHERE trip_id = p_trip_id;
1547:
1548: x_name VARCHAR2(30);
1549:

Line 1609: wsh_util_core.default_handler('WSH_TRIPS_PVT.GET_NAME');

1605:
1606: EXCEPTION
1607:
1608: WHEN others THEN
1609: wsh_util_core.default_handler('WSH_TRIPS_PVT.GET_NAME');
1610: --
1611: -- Debug Statements
1612: --
1613: IF l_debug_on THEN

Line 1786: FROM wsh_trips

1782: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.'
1783: || 'lock_trip_no_compare';
1784: CURSOR c_lock_trip IS
1785: SELECT trip_id
1786: FROM wsh_trips
1787: WHERE trip_id = p_trip_id
1788: FOR UPDATE NOWAIT;
1789:
1790: BEGIN

Line 1828: wsh_util_core.default_handler('WSH_TRIPS_PVT.lock_trip_no_compare',l_module_name);

1824: RAISE;
1825:
1826: WHEN OTHERS THEN
1827: --
1828: wsh_util_core.default_handler('WSH_TRIPS_PVT.lock_trip_no_compare',l_module_name);
1829: --
1830: IF l_debug_on THEN
1831: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1832: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1838: END WSH_TRIPS_PVT;

1834: --
1835: RAISE;
1836: END lock_trip_no_compare;
1837:
1838: END WSH_TRIPS_PVT;