The following lines contain the word 'select', 'insert', 'update' or 'delete':
Cursor c2 is SELECT IEX_writeoff_objects_S.nextval from dual;
IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.insert_row');
IEX_writeoff_objects_PKG.Insert_Row(
x_rowid => v_rowid,
x_WRITEOFF_OBJECT_ID => v_writeoff_object_id,
x_WRITEOFF_ID => p_writeoff_obj_rec.WRITEOFF_ID,
x_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER,
x_CONTRACT_ID => p_writeoff_obj_rec.CONTRACT_ID,
x_CONS_INVOICE_ID => p_writeoff_obj_rec.CONS_INVOICE_ID,
x_CONS_INVOICE_LINE_ID => p_writeoff_obj_rec.CONS_INVOICE_LINE_ID,
x_TRANSACTION_ID => p_writeoff_obj_rec.TRANSACTION_ID,
x_ADJUSTMENT_AMOUNT => p_writeoff_obj_rec.ADJUSTMENT_AMOUNT,
x_ADJUSTMENT_REASON_CODE => p_writeoff_obj_rec.adjustment_reason_code,
x_RECEVIABLES_ADJUSTMENT_ID => p_writeoff_obj_rec.RECEVIABLES_ADJUSTMENT_ID,
x_REQUEST_ID => p_writeoff_obj_rec.REQUEST_ID,
x_PROGRAM_APPLICATION_ID => p_writeoff_obj_rec.PROGRAM_APPLICATION_ID,
x_PROGRAM_ID => p_writeoff_obj_rec.PROGRAM_ID,
x_PROGRAM_UPDATE_DATE => p_writeoff_obj_rec.PROGRAM_UPDATE_DATE,
x_ATTRIBUTE_CATEGORY => p_writeoff_obj_rec.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => p_writeoff_obj_rec.ATTRIBUTE1,
x_ATTRIBUTE2 => p_writeoff_obj_rec.ATTRIBUTE2,
x_ATTRIBUTE3 => p_writeoff_obj_rec.ATTRIBUTE3,
x_ATTRIBUTE4 => p_writeoff_obj_rec.ATTRIBUTE4,
x_ATTRIBUTE5 => p_writeoff_obj_rec.ATTRIBUTE5,
x_ATTRIBUTE6 => p_writeoff_obj_rec.ATTRIBUTE6,
x_ATTRIBUTE7 => p_writeoff_obj_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => p_writeoff_obj_rec.ATTRIBUTE8,
x_ATTRIBUTE9 => p_writeoff_obj_rec.ATTRIBUTE9,
x_ATTRIBUTE10 => p_writeoff_obj_rec.ATTRIBUTE10,
x_ATTRIBUTE11 => p_writeoff_obj_rec.ATTRIBUTE11,
x_ATTRIBUTE12 => p_writeoff_obj_rec.ATTRIBUTE12,
x_ATTRIBUTE13 => p_writeoff_obj_rec.ATTRIBUTE13,
x_ATTRIBUTE14 => p_writeoff_obj_rec.ATTRIBUTE14,
x_ATTRIBUTE15 => p_writeoff_obj_rec.ATTRIBUTE15,
x_CREATED_BY => FND_GLOBAL.USER_ID,
X_CREATION_DATE => SYSDATE,
x_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
x_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
x_WRITEOFF_STATUS => p_writeoff_obj_rec.WRITEOFF_STATUS,
x_WRITEOFF_TYPE_ID => p_writeoff_obj_rec.WRITEOFF_TYPE_ID,
x_WRITEOFF_TYPE => p_writeoff_obj_rec.WRITEOFF_TYPE,
x_customer_trx_id => p_writeoff_obj_rec.customer_trx_id,
x_customer_trx_line_id => p_writeoff_obj_rec.customer_trx_line_id);
IEX_DEBUG_PUB.LogMessage('After Calling iex_writeoff_objects_pkg.insert_row'||
'and writeoff_object_id => '||x_writeoff_object_id);
PROCEDURE update_writeoff_objects(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_writeoff_obj_rec IN writeoff_obj_rec_Type,
x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
,XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(60) := 'UPDATE_WRITEOFF_OBJECTS';
'IEX_writeoff_objects_PVT.update_writeoff_objects *** ');
SAVEPOINT UPDATE_WRITEOFF_OBJECTS_PVT;
IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.update_row');
IEX_writeoff_objects_PKG.Update_Row(
x_WRITEOFF_OBJECT_ID => p_writeoff_obj_rec.writeoff_object_id,
x_WRITEOFF_ID => p_writeoff_obj_rec.WRITEOFF_ID,
x_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER + 1,
x_CONTRACT_ID => p_writeoff_obj_rec.CONTRACT_ID,
x_CONS_INVOICE_ID => p_writeoff_obj_rec.CONS_INVOICE_ID,
x_CONS_INVOICE_LINE_ID => p_writeoff_obj_rec.CONS_INVOICE_LINE_ID,
x_TRANSACTION_ID => p_writeoff_obj_rec.TRANSACTION_ID,
x_ADJUSTMENT_AMOUNT => p_writeoff_obj_rec.ADJUSTMENT_AMOUNT,
x_ADJUSTMENT_REASON_CODE => p_writeoff_obj_rec.adjustment_reason_code,
x_RECEVIABLES_ADJUSTMENT_ID => p_writeoff_obj_rec.RECEVIABLES_ADJUSTMENT_ID,
x_REQUEST_ID => p_writeoff_obj_rec.REQUEST_ID,
x_PROGRAM_APPLICATION_ID => p_writeoff_obj_rec.PROGRAM_APPLICATION_ID,
x_PROGRAM_ID => p_writeoff_obj_rec.PROGRAM_ID,
x_PROGRAM_UPDATE_DATE => p_writeoff_obj_rec.PROGRAM_UPDATE_DATE,
x_ATTRIBUTE_CATEGORY => p_writeoff_obj_rec.ATTRIBUTE_CATEGORY,
x_ATTRIBUTE1 => p_writeoff_obj_rec.ATTRIBUTE1,
x_ATTRIBUTE2 => p_writeoff_obj_rec.ATTRIBUTE2,
x_ATTRIBUTE3 => p_writeoff_obj_rec.ATTRIBUTE3,
x_ATTRIBUTE4 => p_writeoff_obj_rec.ATTRIBUTE4,
x_ATTRIBUTE5 => p_writeoff_obj_rec.ATTRIBUTE5,
x_ATTRIBUTE6 => p_writeoff_obj_rec.ATTRIBUTE6,
x_ATTRIBUTE7 => p_writeoff_obj_rec.ATTRIBUTE7,
x_ATTRIBUTE8 => p_writeoff_obj_rec.ATTRIBUTE8,
x_ATTRIBUTE9 => p_writeoff_obj_rec.ATTRIBUTE9,
x_ATTRIBUTE10 => p_writeoff_obj_rec.ATTRIBUTE10,
x_ATTRIBUTE11 => p_writeoff_obj_rec.ATTRIBUTE11,
x_ATTRIBUTE12 => p_writeoff_obj_rec.ATTRIBUTE12,
x_ATTRIBUTE13 => p_writeoff_obj_rec.ATTRIBUTE13,
x_ATTRIBUTE14 => p_writeoff_obj_rec.ATTRIBUTE14,
x_ATTRIBUTE15 => p_writeoff_obj_rec.ATTRIBUTE15,
x_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
X_LAST_UPDATE_DATE => SYSDATE,
x_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
x_WRITEOFF_STATUS => p_writeoff_obj_rec.WRITEOFF_STATUS,
x_WRITEOFF_TYPE_ID => p_writeoff_obj_rec.WRITEOFF_TYPE_ID,
x_WRITEOFF_TYPE => p_writeoff_obj_rec.WRITEOFF_TYPE,
x_customer_trx_id => p_writeoff_obj_rec.customer_trx_id,
x_customer_trx_line_id => p_writeoff_obj_rec.customer_trx_line_id);
'IEX_writeoff_objects_PVT.update_writeoff_objects ** ');
ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PVT;
ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PVT;
ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PVT;
End update_writeoff_objects;
PROCEDURE delete_writeoff_objects(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
P_writeoff_object_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2 )
IS
l_api_name CONSTANT VARCHAR2(50) := 'DELETE_WRITEOFF_OBJECTS';
SAVEPOINT DELETE_WRITEOFF_OBJECTS_PVT;
iex_writeoff_objects_pkg.delete_row (p_writeoff_object_id);
ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PVT;
ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PVT;
ROLLBACK TO DELETE_WRITEOFF_OBJECTS_PVT;
End delete_writeoff_objects;