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_PKG dependencies on IEX_CASE_DEFINITIONS

Line 1: PACKAGE BODY IEX_CASE_DEFINITIONS_PKG as

1: PACKAGE BODY IEX_CASE_DEFINITIONS_PKG as
2: /* $Header: iextcdfb.pls 120.0 2004/01/24 03:21:18 appldev noship $*/
3: -- Start of Comments
4: -- Package name : IEX_CASE_DEFINITIONS_PKG
5: -- Purpose :

Line 4: -- Package name : IEX_CASE_DEFINITIONS_PKG

1: PACKAGE BODY IEX_CASE_DEFINITIONS_PKG as
2: /* $Header: iextcdfb.pls 120.0 2004/01/24 03:21:18 appldev noship $*/
3: -- Start of Comments
4: -- Package name : IEX_CASE_DEFINITIONS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_CASE_DEFINITIONS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextcdfb.pls';
13:
14: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 52: cursor C is select ROWID from IEX_CASE_DEFINITIONS

48: X_LAST_UPDATE_DATE in DATE,
49: X_LAST_UPDATED_BY in NUMBER,
50: X_LAST_UPDATE_LOGIN in NUMBER
51: ) is
52: cursor C is select ROWID from IEX_CASE_DEFINITIONS
53: where CASE_DEFINITION_ID = X_CASE_DEFINITION_ID ;
54:
55:
56: BEGIN

Line 59: IEX_DEBUG_PUB.LogMessage ('* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ');

55:
56: BEGIN
57: -- IF PG_DEBUG < 10 THEN
58: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
59: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ******** ');
60: END IF;
61: insert into IEX_CASE_DEFINITIONS (
62: CASE_DEFINITION_ID,
63: CAS_ID,

Line 61: insert into IEX_CASE_DEFINITIONS (

57: -- IF PG_DEBUG < 10 THEN
58: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
59: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ******** ');
60: END IF;
61: insert into IEX_CASE_DEFINITIONS (
62: CASE_DEFINITION_ID,
63: CAS_ID,
64: OBJECT_VERSION_NUMBER,
65: COLUMN_NAME,

Line 142: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ');

138: end if;
139: close c;
140: -- IF PG_DEBUG < 10 THEN
141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
142: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ******** ');
143: END IF;
144:
145: End Insert_Row;
146:

Line 183: IEX_DEBUG_PUB.LogMessage ('* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ');

179: IS
180: BEGIN
181: -- IF PG_DEBUG < 10 THEN
182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
183: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');
184: END IF;
185: Update IEX_CASE_DEFINITIONS
186: SET
187: TABLE_NAME = decode( x_TABLE_NAME, FND_API.G_MISS_CHAR, TABLE_NAME, x_TABLE_NAME),

Line 185: Update IEX_CASE_DEFINITIONS

181: -- IF PG_DEBUG < 10 THEN
182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
183: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');
184: END IF;
185: Update IEX_CASE_DEFINITIONS
186: SET
187: TABLE_NAME = decode( x_TABLE_NAME, FND_API.G_MISS_CHAR, TABLE_NAME, x_TABLE_NAME),
188: COLUMN_NAME = decode( x_COLUMN_NAME, FND_API.G_MISS_CHAR, COLUMN_NAME, x_COLUMN_NAME),
189: COLUMN_VALUE = decode( x_COLUMN_VALUE, FND_API.G_MISS_CHAR, COLUMN_VALUE, x_COLUMN_VALUE),

Line 223: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ');

219: RAISE NO_DATA_FOUND;
220: End If;
221: -- IF PG_DEBUG < 10 THEN
222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
223: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');
224: END IF;
225: END Update_Row;
226:
227: PROCEDURE Delete_Row(

Line 231: DELETE FROM IEX_CASE_DEFINITIONS

227: PROCEDURE Delete_Row(
228: X_CASE_DEFINITION_ID NUMBER)
229: IS
230: BEGIN
231: DELETE FROM IEX_CASE_DEFINITIONS
232: WHERE CASE_DEFINITION_ID = X_CASE_DEFINITION_ID;
233: If (SQL%NOTFOUND) then
234: RAISE NO_DATA_FOUND;
235: End If;

Line 243: from IEX_CASE_DEFINITIONS

239: X_CASE_DEFINITION_ID in NUMBER,
240: X_OBJECT_VERSION_NUMBER in NUMBER
241: ) is
242: cursor c is select OBJECT_VERSION_NUMBER
243: from IEX_CASE_DEFINITIONS
244: where CASE_DEFINITION_ID = X_CASE_DEFINITION_ID
245: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
246: for update of CASE_DEFINITION_ID nowait;
247: recinfo c%rowtype;

Line 253: IEX_DEBUG_PUB.LogMessage ('* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ');

249:
250: begin
251: -- IF PG_DEBUG < 10 THEN
252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
253: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ******** ');
254: END IF;
255: open c;
256: fetch c into recinfo;
257: if (c%notfound) then

Line 273: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ');

269: app_exception.raise_exception;
270: end if;
271: -- IF PG_DEBUG < 10 THEN
272: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
273: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ******** ');
274: END IF;
275: end LOCK_ROW;
276:
277: /*PROCEDURE Lock_Row(

Line 314: FROM IEX_CASE_DEFINITIONS

310:
311: IS
312: CURSOR C IS
313: SELECT *
314: FROM IEX_CASE_DEFINITIONS
315: WHERE CASE_DEFINITION_ID = p_CASE_DEFINITION_ID
316: FOR UPDATE of CASE_DEFINITION_ID NOWAIT;
317: Recinfo C%ROWTYPE;
318: BEGIN

Line 430: End IEX_CASE_DEFINITIONS_PKG;

426: APP_EXCEPTION.RAISE_EXCEPTION;
427: End If;
428: END Lock_Row;
429: */
430: End IEX_CASE_DEFINITIONS_PKG;