The following lines contain the word 'select', 'insert', 'update' or 'delete':
Cursor c2 is SELECT IEX_WRITEOFFS_S.nextval from dual;
IEX_WRITEOFFS_PKG.Insert_Row(
x_rowid => v_rowid,
p_WRITEOFF_ID => v_WRITEOFF_ID,
p_PARTY_ID => p_writeoffs_rec.PARTY_ID,
p_DELINQUENCY_ID => p_writeoffs_rec.DELINQUENCY_ID,
p_CAS_ID => p_writeoffs_rec.CAS_ID,
p_CUST_ACCOUNT_ID => p_writeoffs_rec.CUST_ACCOUNT_ID,
p_DISPOSITION_CODE => p_writeoffs_rec.DISPOSITION_CODE,
p_OBJECT_ID => p_writeoffs_rec.OBJECT_ID,
p_OBJECT_CODE => p_writeoffs_rec.OBJECT_CODE,
p_WRITEOFF_TYPE => p_writeoffs_rec.WRITEOFF_TYPE,
p_ACTIVE_FLAG => v_ACTIVE_FLAG,
p_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER,
p_WRITEOFF_REASON => p_writeoffs_rec.WRITEOFF_REASON,
p_WRITEOFF_AMOUNT => p_writeoffs_rec.WRITEOFF_AMOUNT,
p_WRITEOFF_CURRENCY_CODE => p_writeoffs_rec.WRITEOFF_CURRENCY_CODE,
p_WRITEOFF_DATE => p_writeoffs_rec.WRITEOFF_DATE,
p_WRITEOFF_REQUEST_DATE => p_writeoffs_rec.WRITEOFF_REQUEST_DATE,
p_WRITEOFF_PROCESS => p_writeoffs_rec.WRITEOFF_PROCESS,
p_WRITEOFF_SCORE => p_writeoffs_rec.WRITEOFF_SCORE,
p_BAD_DEBT_REASON => p_writeoffs_rec.BAD_DEBT_REASON,
p_LEASING_CODE => p_writeoffs_rec.LEASING_CODE,
p_REPOSSES_SCH_DATE => p_writeoffs_rec.REPOSSES_SCH_DATE,
p_REPOSSES_COMP_DATE => p_writeoffs_rec.REPOSSES_COMP_DATE,
p_CREDIT_HOLD_YN => p_writeoffs_rec.CREDIT_HOLD_YN,
p_APPROVER_ID => p_writeoffs_rec.APPROVER_ID,
p_EXTERNAL_AGENT_ID => p_writeoffs_rec.EXTERNAL_AGENT_ID,
p_PROCEDURE_CODE => p_writeoffs_rec.PROCEDURE_CODE,
p_CHECKLIST_CODE => p_writeoffs_rec.CHECKLIST_CODE,
p_REQUEST_ID => p_writeoffs_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_writeoffs_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_writeoffs_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_writeoffs_rec.PROGRAM_UPDATE_DATE,
p_ATTRIBUTE_CATEGORY => p_writeoffs_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_writeoffs_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_writeoffs_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_writeoffs_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_writeoffs_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_writeoffs_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_writeoffs_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_writeoffs_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_writeoffs_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_writeoffs_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_writeoffs_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_writeoffs_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_writeoffs_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_writeoffs_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_writeoffs_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_writeoffs_rec.ATTRIBUTE15,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => SYSDATE,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => p_writeoffs_rec.LAST_UPDATE_LOGIN
,p_CREDIT_HOLD_REQUEST_FLAG => p_writeoffs_rec.CREDIT_HOLD_REQUEST_FLAG
,p_CREDIT_HOLD_APPROVED_FLAG => p_writeoffs_rec.CREDIT_HOLD_APPROVED_FLAG
,p_SERVICE_HOLD_REQUEST_FLAG => p_writeoffs_rec.SERVICE_HOLD_REQUEST_FLAG
,p_SERVICE_HOLD_APPROVED_FLAG => p_writeoffs_rec.SERVICE_HOLD_APPROVED_FLAG
,p_SUGGESTION_APPROVED_FLAG => p_writeoffs_rec.SUGGESTION_APPROVED_FLAG
,p_CUSTOMER_SITE_USE_ID => p_writeoffs_rec.CUSTOMER_SITE_USE_ID
,p_ORG_ID => p_writeoffs_rec.ORG_ID
,p_CONTRACT_ID => p_writeoffs_rec.CONTRACT_ID
,p_CONTRACT_NUMBER => p_writeoffs_rec.CONTRACT_NUMBER
);
'Insert_Row and WRITEOFF_ID is => '||x_WRITEOFF_ID);
PROCEDURE Update_writeoffs(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_writeoffs_Rec IN writeoffs_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(30) := 'UPDATE_WRITEOFFS';
IEX_DEBUG_PUB.LogMessage ('Update_writeoffs: ' || '********* start of Procedure =>'||
'IEX_WRITEOFFS_PVT.update_WRITEOFFS ******** ');
SAVEPOINT UPDATE_WRITEOFFS_PVT;
IEX_DEBUG_PUB.LogMessage ('IEX_WRITEOFFS_PVT.update_WRITEOFFS, before calling IEX_WRITEOFFS_PKG.Update_Row');
IEX_WRITEOFFS_PKG.Update_Row(
p_WRITEOFF_ID => p_writeoffs_rec.WRITEOFF_ID,
p_PARTY_ID => p_writeoffs_rec.PARTY_ID,
p_DELINQUENCY_ID => p_writeoffs_rec.DELINQUENCY_ID,
p_CAS_ID => p_writeoffs_rec.CAS_ID,
p_CUST_ACCOUNT_ID => p_writeoffs_rec.CUST_ACCOUNT_ID,
p_DISPOSITION_CODE => p_writeoffs_rec.DISPOSITION_CODE,
p_OBJECT_ID => p_writeoffs_rec.OBJECT_ID,
p_OBJECT_CODE => p_writeoffs_rec.OBJECT_CODE,
p_WRITEOFF_TYPE => p_writeoffs_rec.WRITEOFF_TYPE,
p_ACTIVE_FLAG => p_writeoffs_rec.ACTIVE_FLAG,
p_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER + 1,
p_WRITEOFF_REASON => p_writeoffs_rec.WRITEOFF_REASON,
p_WRITEOFF_AMOUNT => p_writeoffs_rec.WRITEOFF_AMOUNT,
p_WRITEOFF_CURRENCY_CODE => p_writeoffs_rec.WRITEOFF_CURRENCY_CODE,
p_WRITEOFF_DATE => p_writeoffs_rec.WRITEOFF_DATE,
p_WRITEOFF_REQUEST_DATE => p_writeoffs_rec.WRITEOFF_REQUEST_DATE,
p_WRITEOFF_PROCESS => p_writeoffs_rec.WRITEOFF_PROCESS,
p_WRITEOFF_SCORE => p_writeoffs_rec.WRITEOFF_SCORE,
p_BAD_DEBT_REASON => p_writeoffs_rec.BAD_DEBT_REASON,
p_LEASING_CODE => p_writeoffs_rec.LEASING_CODE,
p_REPOSSES_SCH_DATE => p_writeoffs_rec.REPOSSES_SCH_DATE,
p_REPOSSES_COMP_DATE => p_writeoffs_rec.REPOSSES_COMP_DATE,
p_CREDIT_HOLD_YN => p_writeoffs_rec.CREDIT_HOLD_YN,
p_APPROVER_ID => p_writeoffs_rec.APPROVER_ID,
p_EXTERNAL_AGENT_ID => p_writeoffs_rec.EXTERNAL_AGENT_ID,
p_PROCEDURE_CODE => p_writeoffs_rec.PROCEDURE_CODE,
p_CHECKLIST_CODE => p_writeoffs_rec.CHECKLIST_CODE,
p_REQUEST_ID => p_writeoffs_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => p_writeoffs_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => p_writeoffs_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => p_writeoffs_rec.PROGRAM_UPDATE_DATE,
p_ATTRIBUTE_CATEGORY => p_writeoffs_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => p_writeoffs_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => p_writeoffs_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => p_writeoffs_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => p_writeoffs_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => p_writeoffs_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => p_writeoffs_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => p_writeoffs_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => p_writeoffs_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => p_writeoffs_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => p_writeoffs_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => p_writeoffs_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => p_writeoffs_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => p_writeoffs_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => p_writeoffs_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => p_writeoffs_rec.ATTRIBUTE15,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATE_LOGIN => p_writeoffs_rec.LAST_UPDATE_LOGIN
,p_CREDIT_HOLD_REQUEST_FLAG => p_writeoffs_rec.CREDIT_HOLD_REQUEST_FLAG
,p_CREDIT_HOLD_APPROVED_FLAG => p_writeoffs_rec.CREDIT_HOLD_APPROVED_FLAG
,p_SERVICE_HOLD_REQUEST_FLAG => p_writeoffs_rec.SERVICE_HOLD_REQUEST_FLAG
,p_SERVICE_HOLD_APPROVED_FLAG => p_writeoffs_rec.SERVICE_HOLD_APPROVED_FLAG
,p_SUGGESTION_APPROVED_FLAG => p_writeoffs_rec.SUGGESTION_APPROVED_FLAG
,p_CUSTOMER_SITE_USE_ID => p_writeoffs_rec.CUSTOMER_SITE_USE_ID
,p_ORG_ID => p_writeoffs_rec.ORG_ID
,p_CONTRACT_ID => p_writeoffs_rec.CONTRACT_ID
,p_CONTRACT_NUMBER => p_writeoffs_rec.CONTRACT_NUMBER
);
IEX_DEBUG_PUB.LogMessage ('IEX_WRITEOFFS_PVT.update_WRITEOFFS is successfull');
IEX_DEBUG_PUB.LogMessage ('Update_writeoffs: ' || '********* END of Procedure =>'||
'IEX_WRITEOFFS_PVT.update_WRITEOFFS ******** ');
End Update_writeoffs;
PROCEDURE Delete_writeoffs(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
P_writeoff_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(30) := 'DELETE_WRITEOFFS';
IEX_DEBUG_PUB.LogMessage ('Delete_writeoffs: ' || '********* Start of Procedure =>'||
'IEX_WRITEOFFS_PVT.DELETE_WRITEOFFS ******** ');
SAVEPOINT DELETE_WRITEOFFS_PVT;
IEX_WRITEOFFS_PKG.Delete_Row(
p_WRITEOFF_ID => p_WRITEOFF_ID);
IEX_DEBUG_PUB.LogMessage ('Delete_writeoffs: ' || '********* End of Procedure =>'||
'IEX_WRITEOFFS_PVT.DELETE_WRITEOFFS ******** ');
End Delete_writeoffs;