APPS.IEX_CASES_PKG dependencies on IEX_CASES_ALL_B

Line 51: cursor C is select ROWID from IEX_CASES_ALL_B

47: X_LAST_UPDATE_DATE in DATE,
48: X_LAST_UPDATED_BY in NUMBER,
49: X_LAST_UPDATE_LOGIN in NUMBER
50: ) is
51: cursor C is select ROWID from IEX_CASES_ALL_B
52: where CAS_ID = X_CAS_ID ;
53:
54:
55: BEGIN

Line 60: insert into IEX_CASES_ALL_B (

56: -- IF PG_DEBUG < 10 THEN
57: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
58: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PKG.INSERT_ROW ******** ');
59: END IF;
60: insert into IEX_CASES_ALL_B (
61: CAS_ID,
62: CASE_NUMBER,
63: ACTIVE_FLAG,
64: PARTY_ID,

Line 207: from IEX_CASES_ALL_B

203: X_CAS_ID in NUMBER,
204: X_OBJECT_VERSION_NUMBER in NUMBER
205: ) is
206: cursor c is select OBJECT_VERSION_NUMBER
207: from IEX_CASES_ALL_B
208: where CAS_ID = X_CAS_ID
209: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
210: for update of CAS_ID nowait;
211: recinfo c%rowtype;

Line 313: from IEX_CASES_ALL_B

309: ATTRIBUTE12 ,
310: ATTRIBUTE13 ,
311: ATTRIBUTE14 ,
312: ATTRIBUTE15
313: from IEX_CASES_ALL_B
314: where CAS_ID = X_CAS_ID
315: for update of CAS_ID nowait;
316: recinfo c%rowtype;
317:

Line 459: update IEX_CASES_ALL_B set

455: -- IF PG_DEBUG < 10 THEN
456: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
457: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PKG.UPDATE_ROW ******** ');
458: END IF;
459: update IEX_CASES_ALL_B set
460: CASE_NUMBER = decode( x_CASE_NUMBER, FND_API.G_MISS_CHAR, CASE_NUMBER, x_CASE_NUMBER),
461: ACTIVE_FLAG = decode( x_ACTIVE_FLAG, FND_API.G_MISS_CHAR, ACTIVE_FLAG, x_ACTIVE_FLAG),
462: PARTY_ID = decode( X_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, X_PARTY_ID),
463: ORIG_CAS_ID = decode( X_ORIG_CAS_ID, FND_API.G_MISS_NUM, ORIG_CAS_ID, X_ORIG_CAS_ID),

Line 537: delete from IEX_CASES_ALL_B

533: if (sql%notfound) then
534: raise no_data_found;
535: end if;
536:
537: delete from IEX_CASES_ALL_B
538: where CAS_ID = X_CAS_ID;
539:
540: if (sql%notfound) then
541: raise no_data_found;

Line 555: from IEX_CASES_ALL_B B

551: begin
552: delete from IEX_CASES_TL T
553: where not exists
554: (select NULL
555: from IEX_CASES_ALL_B B
556: where B.CAS_ID = T.CAS_ID
557: );
558:
559: update IEX_CASES_TL T