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.IEX_CASE_DEFINITIONS_PVT dependencies on IEX_CASE_DEFINITIONS

Line 1: PACKAGE BODY IEX_case_definitions_PVT as

1: PACKAGE BODY IEX_case_definitions_PVT as
2: /* $Header: iexvcdfb.pls 120.1 2006/05/30 17:54:09 scherkas noship $ */
3: -- Start of Comments
4: -- Package name : IEX_case_definitions_PVT
5: -- Purpose :

Line 4: -- Package name : IEX_case_definitions_PVT

1: PACKAGE BODY IEX_case_definitions_PVT as
2: /* $Header: iexvcdfb.pls 120.1 2006/05/30 17:54:09 scherkas noship $ */
3: -- Start of Comments
4: -- Package name : IEX_case_definitions_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_CASE_DEFINITIONS_PVT';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_CASE_DEFINITIONS_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvcdfb.pls';
13:
14:
15: -- Hint: Primary key needs to be returned.

Line 36: v_case_definition_id iex_case_definitions.case_definition_id%TYPE;

32: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CASE_DEFINITIONS';
33: l_api_version_number CONSTANT NUMBER := 2.0;
34:
35: v_rowid VARCHAR2(24);
36: v_case_definition_id iex_case_definitions.case_definition_id%TYPE;
37: v_active_flag iex_case_definitions.active_flag%TYPE;
38: v_object_version_number iex_case_definitions.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;
40: BEGIN

Line 37: v_active_flag iex_case_definitions.active_flag%TYPE;

33: l_api_version_number CONSTANT NUMBER := 2.0;
34:
35: v_rowid VARCHAR2(24);
36: v_case_definition_id iex_case_definitions.case_definition_id%TYPE;
37: v_active_flag iex_case_definitions.active_flag%TYPE;
38: v_object_version_number iex_case_definitions.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN

Line 38: v_object_version_number iex_case_definitions.object_version_number%TYPE;

34:
35: v_rowid VARCHAR2(24);
36: v_case_definition_id iex_case_definitions.case_definition_id%TYPE;
37: v_active_flag iex_case_definitions.active_flag%TYPE;
38: v_object_version_number iex_case_definitions.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 39: Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;

35: v_rowid VARCHAR2(24);
36: v_case_definition_id iex_case_definitions.case_definition_id%TYPE;
37: v_active_flag iex_case_definitions.active_flag%TYPE;
38: v_object_version_number iex_case_definitions.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
43: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ******** ');

Line 43: IEX_DEBUG_PUB.LogMessage ('* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ');

39: Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
43: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ******** ');
44: END IF;
45: -- Standard Start of API savepoint
46: SAVEPOINT CREATE_case_definitions_PVT;
47:

Line 109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');

105: END IF;
106:
107: -- IF PG_DEBUG < 10 THEN
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');
110: END IF;
111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)
112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(
113: x_rowid =>v_rowid,

Line 111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)

107: -- IF PG_DEBUG < 10 THEN
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');
110: END IF;
111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)
112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(
113: x_rowid =>v_rowid,
114: x_CASE_DEFINITION_ID => v_CASE_DEFINITION_ID,
115: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,

Line 112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(

108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');
110: END IF;
111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)
112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(
113: x_rowid =>v_rowid,
114: x_CASE_DEFINITION_ID => v_CASE_DEFINITION_ID,
115: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,
116: x_COLUMN_VALUE => p_case_definition_rec.COLUMN_VALUE,

Line 151: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row and case definition id => '||x_CASE_DEFINITION_ID);

147: -- Hint: Primary key should be returned.
148: x_CASE_DEFINITION_ID := v_CASE_DEFINITION_ID;
149: -- IF PG_DEBUG < 10 THEN
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row and case definition id => '||x_CASE_DEFINITION_ID);
152: END IF;
153:
154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
155: RAISE FND_API.G_EXC_ERROR;

Line 176: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ');

172: p_data => x_msg_data
173: );
174: -- IF PG_DEBUG < 10 THEN
175: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
176: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ******** ');
177: END IF;
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN
180: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 229: l_object_version_number iex_case_definitions.object_version_number%TYPE:=p_case_definition_rec.object_version_number;

225:
226: IS
227: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CASE_DEFINITIONS';
228: l_api_version_number CONSTANT NUMBER := 2.0;
229: l_object_version_number iex_case_definitions.object_version_number%TYPE:=p_case_definition_rec.object_version_number;
230: BEGIN
231: -- IF PG_DEBUG < 10 THEN
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Update_case_definitions ******** ');

Line 233: IEX_DEBUG_PUB.LogMessage ('* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Update_case_definitions ');

229: l_object_version_number iex_case_definitions.object_version_number%TYPE:=p_case_definition_rec.object_version_number;
230: BEGIN
231: -- IF PG_DEBUG < 10 THEN
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Update_case_definitions ******** ');
234: END IF;
235: -- Standard Start of API savepoint
236: SAVEPOINT UPDATE_case_definitions_PVT;
237:

Line 262: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Update_Row)

258: --
259: -- Api body
260: --
261:
262: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Update_Row)
263: -- call locking table handler
264: -- IF PG_DEBUG < 10 THEN
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');

Line 266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');

262: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Update_Row)
263: -- call locking table handler
264: -- IF PG_DEBUG < 10 THEN
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');
267: END IF;
268: IEX_CASE_DEFINITIONS_PKG.lock_row (
269: p_case_definition_rec.CASE_DEFINITION_ID,
270: l_object_version_number

Line 268: IEX_CASE_DEFINITIONS_PKG.lock_row (

264: -- IF PG_DEBUG < 10 THEN
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');
267: END IF;
268: IEX_CASE_DEFINITIONS_PKG.lock_row (
269: p_case_definition_rec.CASE_DEFINITION_ID,
270: l_object_version_number
271: );
272: -- IF PG_DEBUG < 10 THEN

Line 274: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');

270: l_object_version_number
271: );
272: -- IF PG_DEBUG < 10 THEN
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');
275: END IF;
276: IEX_CASE_DEFINITIONS_PKG.Update_Row(
277: x_CASE_DEFINITION_ID => p_case_definition_rec.CASE_DEFINITION_ID,
278: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,

Line 276: IEX_CASE_DEFINITIONS_PKG.Update_Row(

272: -- IF PG_DEBUG < 10 THEN
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');
275: END IF;
276: IEX_CASE_DEFINITIONS_PKG.Update_Row(
277: x_CASE_DEFINITION_ID => p_case_definition_rec.CASE_DEFINITION_ID,
278: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,
279: x_COLUMN_VALUE =>p_case_definition_rec.COLUMN_VALUE,
280: x_ACTIVE_FLAG =>p_case_definition_rec.ACTIVE_FLAG,

Line 336: IEX_DEBUG_PUB.LogMessage ('* end of Procedure =>IEX_CASE_DEFINITIONS_PVT.update_case_definitions ');

332: p_data => x_msg_data
333: );
334: -- IF PG_DEBUG < 10 THEN
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
336: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_DEFINITIONS_PVT.update_case_definitions ******** ');
337: END IF;
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN
340: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 418: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Delete_Row)

414: --
415: -- Api body
416: --
417:
418: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Delete_Row)
419: IEX_CASE_DEFINITIONS_PKG.Delete_Row(
420: X_CASE_DEFINITION_ID => p_CASE_DEFINITION_ID);
421: --
422: -- End of API body

Line 419: IEX_CASE_DEFINITIONS_PKG.Delete_Row(

415: -- Api body
416: --
417:
418: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Delete_Row)
419: IEX_CASE_DEFINITIONS_PKG.Delete_Row(
420: X_CASE_DEFINITION_ID => p_CASE_DEFINITION_ID);
421: --
422: -- End of API body
423: --

Line 473: End IEX_case_definitions_PVT;

469: ,X_RETURN_STATUS => X_RETURN_STATUS);
470: End Delete_case_definitions;
471:
472:
473: End IEX_case_definitions_PVT;