APPS.IEX_CASE_DEFINITIONS_PKG dependencies on IEX_CASE_DEFINITIONS_PKG

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 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 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 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 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 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;