DBA Data[Home] [Help]

APPS.IEX_CASE_DEFINITIONS_PVT dependencies on IEX_CASE_DEFINITIONS_PKG

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