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_SHIP_METHODS_PKG dependencies on WSH_CARRIER_SHIP_METHODS

Line 1: PACKAGE BODY WSH_CARRIER_SHIP_METHODS_PKG as

1: PACKAGE BODY WSH_CARRIER_SHIP_METHODS_PKG as
2: /* $Header: WSHCSTHB.pls 115.14 2002/11/18 20:12:26 nparikh ship $ */
3:
4: --- Package Name: WSH_CARRIER_SHIP_METHODS_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SHIP_METHODS

Line 4: --- Package Name: WSH_CARRIER_SHIP_METHODS_PKG

1: PACKAGE BODY WSH_CARRIER_SHIP_METHODS_PKG as
2: /* $Header: WSHCSTHB.pls 115.14 2002/11/18 20:12:26 nparikh ship $ */
3:
4: --- Package Name: WSH_CARRIER_SHIP_METHODS_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SHIP_METHODS
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --

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

1: PACKAGE BODY WSH_CARRIER_SHIP_METHODS_PKG as
2: /* $Header: WSHCSTHB.pls 115.14 2002/11/18 20:12:26 nparikh ship $ */
3:
4: --- Package Name: WSH_CARRIER_SHIP_METHODS_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SHIP_METHODS
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_SHIP_METHODS_PKG';

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

5: --- Pupose: Table Handlers for table WSH_CARRIER_SHIP_METHODS
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_SHIP_METHODS_PKG';
10: --
11: PROCEDURE Create_Carrier_Ship_Method(
12: p_Carrier_Ship_Method_Info IN CSMRecType
13: , x_Rowid OUT NOCOPY VARCHAR2

Line 21: SELECT wsh_carrier_ship_methods_s.nextval

17: IS
18:
19: CURSOR C_Next_id
20: IS
21: SELECT wsh_carrier_ship_methods_s.nextval
22: FROM sys.dual;
23:
24: CURSOR C_New_Rowid
25: IS

Line 27: FROM WSH_CARRIER_SHIP_METHODS

23:
24: CURSOR C_New_Rowid
25: IS
26: SELECT rowid
27: FROM WSH_CARRIER_SHIP_METHODS
28: WHERE carrier_ship_method_id = x_carrier_ship_method_id;
29:
30: no_data_found EXCEPTION;
31: others EXCEPTION;

Line 107: INSERT INTO wsh_carrier_ship_methods(

103: X_Carrier_Ship_Method_Id);
104: END IF;
105: CLOSE C_Next_id;
106: END IF;
107: INSERT INTO wsh_carrier_ship_methods(
108: carrier_ship_method_id,
109: carrier_id,
110: ship_method_code,
111: freight_code,

Line 193: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

189: --
190: EXCEPTION
191: WHEN others THEN
192: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
193: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 211: FROM wsh_carrier_ship_methods

207: IS
208:
209: CURSOR C_lock_row IS
210: SELECT *
211: FROM wsh_carrier_ship_methods
212: WHERE rowid = p_rowid
213: FOR UPDATE of Carrier_Ship_Method_id NOWAIT;
214:
215: Recinfo C_lock_row%ROWTYPE;

Line 418: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Lock_Carrier_Ship_Method',l_module_name);

414: --
415: EXCEPTION
416: WHEN others THEN
417: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Lock_Carrier_Ship_Method',l_module_name);
419: --
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 502: UPDATE wsh_carrier_ship_methods

498: p_Carrier_Ship_Method_Info.attribute15);
499: END IF;
500: --
501: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
502: UPDATE wsh_carrier_ship_methods
503: SET
504: carrier_id = p_Carrier_Ship_Method_Info.Carrier_id,
505: ship_method_code = p_Carrier_Ship_Method_Info.Ship_Method_Code,
506: freight_code = p_Carrier_Ship_Method_Info.Freight_code,

Line 559: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
556: END IF;
557: --
558: WHEN others THEN
559: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
561: --
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 579: FROM wsh_carrier_ship_methods

575:
576: CURSOR C_CSM_id
577: IS
578: SELECT carrier_ship_method_id
579: FROM wsh_carrier_ship_methods
580: WHERE rowid = p_rowid;
581:
582: l_csm_id NUMBER;
583: others EXCEPTION;

Line 621: DELETE FROM wsh_carrier_ship_methods

617: l_csm_id := p_Carrier_Ship_Method_id;
618: END IF;
619:
620: IF (p_Carrier_Ship_Method_id IS NOT NULL) THEN
621: DELETE FROM wsh_carrier_ship_methods
622: WHERE carrier_ship_method_id = l_csm_id;
623: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
624: ELSE
625: RAISE others;

Line 634: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);

630: END IF;
631: --
632: EXCEPTION
633: WHEN others THEN
634: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 645: END WSH_CARRIER_SHIP_METHODS_PKG;

641: --
642: END Delete_Carrier_Ship_Method;
643:
644:
645: END WSH_CARRIER_SHIP_METHODS_PKG;