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_CARRIER_SERVICES_PKG dependencies on WSH_CARRIER_SERVICES

Line 1: PACKAGE BODY WSH_CARRIER_SERVICES_PKG as

1: PACKAGE BODY WSH_CARRIER_SERVICES_PKG as
2: /* $Header: WSHCVTHB.pls 120.4 2006/05/29 07:10:47 jnpinto noship $ */
3:
4: --- Package Name: WSH_CARRIER_SERVICES_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SERVICES

Line 4: --- Package Name: WSH_CARRIER_SERVICES_PKG

1: PACKAGE BODY WSH_CARRIER_SERVICES_PKG as
2: /* $Header: WSHCVTHB.pls 120.4 2006/05/29 07:10:47 jnpinto noship $ */
3:
4: --- Package Name: WSH_CARRIER_SERVICES_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SERVICES
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --

Line 5: --- Pupose: Table Handlers for table WSH_CARRIER_SERVICES

1: PACKAGE BODY WSH_CARRIER_SERVICES_PKG as
2: /* $Header: WSHCVTHB.pls 120.4 2006/05/29 07:10:47 jnpinto noship $ */
3:
4: --- Package Name: WSH_CARRIER_SERVICES_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SERVICES
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_SERVICES_PKG';

Line 9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_SERVICES_PKG';

5: --- Pupose: Table Handlers for table WSH_CARRIER_SERVICES
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_SERVICES_PKG';
10: --
11: PROCEDURE Create_Carrier_Service
12: (
13: p_Carrier_Service_Info IN CSRecType DEFAULT NULL

Line 27: SELECT wsh_carrier_services_s.nextval

23: IS
24:
25: CURSOR C_Next_id
26: IS
27: SELECT wsh_carrier_services_s.nextval
28: FROM sys.dual;
29:
30:
31: CURSOR C_New_Rowid(p_carrier_service_id NUMBER)

Line 34: FROM WSH_CARRIER_SERVICES

30:
31: CURSOR C_New_Rowid(p_carrier_service_id NUMBER)
32: IS
33: SELECT rowid
34: FROM WSH_CARRIER_SERVICES
35: WHERE carrier_service_id = p_carrier_service_id;
36:
37: l_rowid rowid;
38: l_smc NUMBER;

Line 249: l_procedure := 'Inserting Into Wsh_Carrier_Services';

245:
246: END IF;
247:
248: l_position := 20;
249: l_procedure := 'Inserting Into Wsh_Carrier_Services';
250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.log(l_module_name,'Inserting into wsh_carrier_services');
253: END IF;

Line 252: WSH_DEBUG_SV.log(l_module_name,'Inserting into wsh_carrier_services');

248: l_position := 20;
249: l_procedure := 'Inserting Into Wsh_Carrier_Services';
250:
251: IF l_debug_on THEN
252: WSH_DEBUG_SV.log(l_module_name,'Inserting into wsh_carrier_services');
253: END IF;
254:
255: INSERT INTO wsh_carrier_services(
256: carrier_service_id,

Line 255: INSERT INTO wsh_carrier_services(

251: IF l_debug_on THEN
252: WSH_DEBUG_SV.log(l_module_name,'Inserting into wsh_carrier_services');
253: END IF;
254:
255: INSERT INTO wsh_carrier_services(
256: carrier_service_id,
257: carrier_id,
258: mode_of_transport,
259: enabled_flag,

Line 387: l_procedure := 'Checking rowid Into Wsh_Carrier_Services';

383: p_Carrier_Service_Info.UPDATE_MOT_SL
384: );
385:
386: l_position := 30;
387: l_procedure := 'Checking rowid Into Wsh_Carrier_Services';
388:
389: OPEN C_New_Rowid(l_carrier_service_id);
390: FETCH C_New_Rowid INTO x_rowid;
391: IF (C_New_Rowid%NOTFOUND) THEN

Line 497: FROM wsh_carrier_services

493: ALLOW_CONTINUOUS_MOVE,
494: MAX_CM_DH_TIME,
495: ORIGIN_DSTN_SURCHARGE_LEVEL,
496: UPDATE_MOT_SL
497: FROM wsh_carrier_services
498: WHERE rowid = p_rowid
499: FOR UPDATE of Carrier_Service_id NOWAIT;
500:
501: CURSOR C_lookup_row IS

Line 1066: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SERVICES_PKG.Lock_Carrier_Service',l_module_name);

1062: CLOSE C_lookup_row;
1063: END IF;
1064:
1065: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1066: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SERVICES_PKG.Lock_Carrier_Service',l_module_name);
1067: --
1068: IF l_debug_on THEN
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1070: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1122: FROM WSH_CARRIERS car,WSH_CARRIER_SERVICES carser

1118: and LOOKUP_CODE = p_ship_method_code;
1119:
1120: CURSOR C_freight_code(x_rowid VARCHAR2) IS
1121: SELECT freight_code
1122: FROM WSH_CARRIERS car,WSH_CARRIER_SERVICES carser
1123: WHERE carser.carrier_id = car.carrier_id
1124: and carser.rowid=x_rowid;
1125:
1126: l_freight_code VARCHAR(100);

Line 1156: l_procedure := 'Updating WSH_CARRIER_SERVICES';

1152: --
1153: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1154:
1155: l_position := 10;
1156: l_procedure := 'Updating WSH_CARRIER_SERVICES';
1157:
1158: UPDATE wsh_carrier_services
1159: SET
1160: service_level = p_Carrier_Service_Info.Service_level,

Line 1158: UPDATE wsh_carrier_services

1154:
1155: l_position := 10;
1156: l_procedure := 'Updating WSH_CARRIER_SERVICES';
1157:
1158: UPDATE wsh_carrier_services
1159: SET
1160: service_level = p_Carrier_Service_Info.Service_level,
1161: mode_of_transport = p_Carrier_Service_Info.mode_of_transport,
1162: min_sl_time = p_Carrier_Service_Info.min_sl_time,

Line 1428: END WSH_CARRIER_SERVICES_PKG;

1424:
1425: END Car_Ser_Unassign_AllOrg;
1426:
1427:
1428: END WSH_CARRIER_SERVICES_PKG;