DBA Data[Home] [Help]

APPS.WSH_CARRIER_VEHICLE_TYPES_PKG dependencies on WSH_CARRIER_VEHICLE_TYPES

Line 1: package body WSH_CARRIER_VEHICLE_TYPES_PKG as

1: package body WSH_CARRIER_VEHICLE_TYPES_PKG as
2: /* $Header: WSHVTTHB.pls 115.0 2003/06/26 10:58:48 msutar noship $ */
3:
4: --- Package Name: WSH_CARRIER_VEHICLE_TYPES_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_VEHICLE_TYPES_PKG

Line 4: --- Package Name: WSH_CARRIER_VEHICLE_TYPES_PKG

1: package body WSH_CARRIER_VEHICLE_TYPES_PKG as
2: /* $Header: WSHVTTHB.pls 115.0 2003/06/26 10:58:48 msutar noship $ */
3:
4: --- Package Name: WSH_CARRIER_VEHICLE_TYPES_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_VEHICLE_TYPES_PKG
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --

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

1: package body WSH_CARRIER_VEHICLE_TYPES_PKG as
2: /* $Header: WSHVTTHB.pls 115.0 2003/06/26 10:58:48 msutar noship $ */
3:
4: --- Package Name: WSH_CARRIER_VEHICLE_TYPES_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_VEHICLE_TYPES_PKG
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_VEHICLE_TYPES_PKG';

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

5: --- Pupose: Table Handlers for table WSH_CARRIER_VEHICLE_TYPES_PKG
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_VEHICLE_TYPES_PKG';
10: --
11: procedure Create_Carrier_Vehicle_Type (
12: P_Carrier_Vehicle_Info IN CVTRecType,
13: X_ROWID OUT NOCOPY VARCHAR2,

Line 91: WSH_DEBUG_SV.log(l_module_name,'Inserting into WSH_CARRIER_VEHICLE_TYPES');

87: --
88: -- Debug Statements
89: --
90: IF l_debug_on THEN
91: WSH_DEBUG_SV.log(l_module_name,'Inserting into WSH_CARRIER_VEHICLE_TYPES');
92: END IF;
93:
94: insert into WSH_CARRIER_VEHICLE_TYPES (
95: CARRIER_ID,

Line 94: insert into WSH_CARRIER_VEHICLE_TYPES (

90: IF l_debug_on THEN
91: WSH_DEBUG_SV.log(l_module_name,'Inserting into WSH_CARRIER_VEHICLE_TYPES');
92: END IF;
93:
94: insert into WSH_CARRIER_VEHICLE_TYPES (
95: CARRIER_ID,
96: VEHICLE_TYPE_ID,
97: ASSIGNED_FLAG,
98: ATTRIBUTE_CATEGORY,

Line 157: x_procedure := 'Inserting into WSH_CARRIER_VEHICLE_TYPES table';

153: exception
154: WHEN OTHERS THEN
155: x_return_status := 'E';
156: x_exception_msg := 'WHEN OTHERS Exception Raise';
157: x_procedure := 'Inserting into WSH_CARRIER_VEHICLE_TYPES table';
158: x_position := 0;
159: x_sqlerr := sqlerrm;
160: x_sql_code := sqlcode;
161: --

Line 254: WSH_DEBUG_SV.log(l_module_name,'Updating into WSH_CARRIER_VEHICLE_TYPES');

250: --
251: -- Debug Statements
252: --
253: IF l_debug_on THEN
254: WSH_DEBUG_SV.log(l_module_name,'Updating into WSH_CARRIER_VEHICLE_TYPES');
255: END IF;
256:
257: update WSH_CARRIER_VEHICLE_TYPES set
258: VEHICLE_TYPE_ID = P_Carrier_Vehicle_Info.VEHICLE_TYPE_ID,

Line 257: update WSH_CARRIER_VEHICLE_TYPES set

253: IF l_debug_on THEN
254: WSH_DEBUG_SV.log(l_module_name,'Updating into WSH_CARRIER_VEHICLE_TYPES');
255: END IF;
256:
257: update WSH_CARRIER_VEHICLE_TYPES set
258: VEHICLE_TYPE_ID = P_Carrier_Vehicle_Info.VEHICLE_TYPE_ID,
259: ASSIGNED_FLAG = P_Carrier_Vehicle_Info.ASSIGNED_FLAG,
260: ATTRIBUTE_CATEGORY = P_Carrier_Vehicle_Info.ATTRIBUTE_CATEGORY,
261: ATTRIBUTE1 = P_Carrier_Vehicle_Info.ATTRIBUTE1,

Line 296: x_procedure := 'Updating into WSH_CARRIER_VEHICLE_TYPES table';

292:
293: exception
294: WHEN UPDATE_FAILED THEN
295: x_exception_msg := 'Update Failed Exception';
296: x_procedure := 'Updating into WSH_CARRIER_VEHICLE_TYPES table';
297: x_position := 0;
298: x_sqlerr := sqlerrm;
299: x_sql_code := sqlcode;
300: --

Line 311: x_procedure := 'Updating into WSH_CARRIER_VEHICLE_TYPES table';

307: --
308: WHEN OTHERS THEN
309: x_return_status := 'E';
310: x_exception_msg := 'WHEN OTHERS Exception Raise';
311: x_procedure := 'Updating into WSH_CARRIER_VEHICLE_TYPES table';
312: x_position := 0;
313: x_sqlerr := sqlerrm;
314: x_sql_code := sqlcode;
315: --

Line 348: from WSH_CARRIER_VEHICLE_TYPES

344: ATTRIBUTE12,
345: ATTRIBUTE13,
346: ATTRIBUTE14,
347: ATTRIBUTE15
348: from WSH_CARRIER_VEHICLE_TYPES
349: where ROWID = P_ROWID
350: for update of CARRIER_ID nowait;
351:
352: recinfo c%rowtype;

Line 478: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_VEHICLE_TYPES_PKG.Lock_Carrier_Vehicle_Type');

474: return;
475: exception
476: WHEN others THEN
477: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
478: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_VEHICLE_TYPES_PKG.Lock_Carrier_Vehicle_Type');
479: --
480: -- Debug Statements
481: --
482: IF l_debug_on THEN

Line 489: end WSH_CARRIER_VEHICLE_TYPES_PKG;

485: END IF;
486: --
487: end Lock_Carrier_Vehicle_Type;
488:
489: end WSH_CARRIER_VEHICLE_TYPES_PKG;