APPS.LNS_FUNDING_ADVICES_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

/* Insert_Row procedure */
PROCEDURE Insert_Row(
	X_FUNDING_ADVICE_ID		IN OUT NOCOPY NUMBER
	,P_LOAN_ID		IN NUMBER
	,P_ADVICE_NUMBER		IN VARCHAR2
	,P_SUBMISSION_DATE		IN DATE
	,P_AMOUNT		IN NUMBER
	,P_CURRENCY		IN VARCHAR2
	,P_DESCRIPTION		IN VARCHAR2
	,P_DUE_DATE		IN DATE
	,P_INVOICE_ID		IN NUMBER
	,P_INVOICE_NUMBER		IN VARCHAR2
	,P_PAYMENT_METHOD		IN VARCHAR2
	,P_STATUS		IN VARCHAR2
	,P_PAYEE_ID		IN NUMBER
	,P_PAYEE_SITE_ID		IN NUMBER
	,P_SITE_CONTACT_ID		IN NUMBER
	,P_BANK_BRANCH_ID		IN NUMBER
	,P_BANK_ACCOUNT_ID		IN NUMBER
	,P_LAST_UPDATE_DATE		IN DATE
	,P_LAST_UPDATED_BY		IN NUMBER
	,P_LAST_UPDATE_LOGIN		IN NUMBER
	,P_CREATION_DATE		IN DATE
	,P_CREATED_BY		IN NUMBER
	,P_REQUEST_ID		IN NUMBER
	,P_AUTOFUNDING_FLAG		IN VARCHAR2
	,P_OBJECT_VERSION_NUMBER		IN NUMBER
	,P_FUNDING_DATE		IN DATE
) IS
BEGIN
null;

Line: 35

END Insert_Row;

Line: 37

/* Update_Row procedure */
PROCEDURE Update_Row(
	P_FUNDING_ADVICE_ID		IN NUMBER
	,P_LOAN_ID		IN NUMBER
	,P_ADVICE_NUMBER		IN VARCHAR2
	,P_SUBMISSION_DATE		IN DATE
	,P_AMOUNT		IN NUMBER
	,P_CURRENCY		IN VARCHAR2
	,P_DESCRIPTION		IN VARCHAR2
	,P_DUE_DATE		IN DATE
	,P_INVOICE_ID		IN NUMBER
	,P_INVOICE_NUMBER		IN VARCHAR2
	,P_PAYMENT_METHOD		IN VARCHAR2
	,P_STATUS		IN VARCHAR2
	,P_PAYEE_ID		IN NUMBER
	,P_PAYEE_SITE_ID		IN NUMBER
	,P_SITE_CONTACT_ID		IN NUMBER
	,P_BANK_BRANCH_ID		IN NUMBER
	,P_BANK_ACCOUNT_ID		IN NUMBER
	,P_LAST_UPDATE_DATE		IN DATE
	,P_LAST_UPDATED_BY		IN NUMBER
	,P_LAST_UPDATE_LOGIN		IN NUMBER
	,P_REQUEST_ID		IN NUMBER
	,P_AUTOFUNDING_FLAG		IN VARCHAR2
	,P_OBJECT_VERSION_NUMBER		IN NUMBER
	,P_FUNDING_DATE		IN DATE
) IS
BEGIN
null;

Line: 66

END Update_Row;

Line: 68

/* Delete_Row procedure */
PROCEDURE Delete_Row(P_FUNDING_ADVICE_ID IN NUMBER) IS
BEGIN
null;

Line: 72

END Delete_Row;

Line: 93

	,P_LAST_UPDATE_DATE		IN DATE
	,P_LAST_UPDATED_BY		IN NUMBER
	,P_LAST_UPDATE_LOGIN		IN NUMBER
	,P_CREATION_DATE		IN DATE
	,P_CREATED_BY		IN NUMBER
	,P_REQUEST_ID		IN NUMBER
	,P_AUTOFUNDING_FLAG		IN VARCHAR2
	,P_OBJECT_VERSION_NUMBER		IN NUMBER
	,P_FUNDING_DATE		IN DATE
) IS
BEGIN
null;