APPS.LNS_LOAN_DOCUMENTS_PKG SQL Statements

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

Line: 4

/* Insert_Row procedure */
PROCEDURE Insert_Row(
        X_DOCUMENT_ID                   IN OUT NOCOPY NUMBER
        ,P_SOURCE_ID                    IN NUMBER
        ,P_SOURCE_TABLE                 IN VARCHAR2
        ,P_DOCUMENT_TYPE        	IN VARCHAR2
        ,P_VERSION              	IN NUMBER
        ,P_DOCUMENT_XML                 IN CLOB
        ,P_CREATION_DATE                IN DATE         DEFAULT NULL
        ,P_CREATED_BY           	IN NUMBER       DEFAULT NULL
        ,P_LAST_UPDATE_DATE             IN DATE         DEFAULT NULL
        ,P_LAST_UPDATED_BY              IN NUMBER       DEFAULT NULL
        ,P_LAST_UPDATE_LOGIN            IN NUMBER       DEFAULT NULL
        ,P_PROGRAM_UPDATE_DATE          IN DATE 	DEFAULT NULL
        ,P_PROGRAM_APPLICATION_ID       IN NUMBER 	DEFAULT NULL
        ,P_PROGRAM_ID                   IN NUMBER 	DEFAULT NULL
        ,P_REQUEST_ID                   IN NUMBER 	DEFAULT NULL
        ,P_OBJECT_VERSION_NUMBER        IN NUMBER
) IS
BEGIN
	INSERT INTO LNS_LOAN_DOCUMENTS
	(
		DOCUMENT_ID
		,SOURCE_ID
		,SOURCE_TABLE
		,DOCUMENT_TYPE
		,VERSION
		,DOCUMENT_XML
		,CREATED_BY
		,CREATION_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATE_LOGIN
		,PROGRAM_UPDATE_DATE
		,PROGRAM_APPLICATION_ID
		,PROGRAM_ID
		,REQUEST_ID
		,OBJECT_VERSION_NUMBER
	) VALUES (
		LNS_LOAN_DOCUMENTS_S.NEXTVAL
		,DECODE(P_SOURCE_ID, FND_API.G_MISS_NUM, NULL, P_SOURCE_ID)
		,DECODE(P_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, P_SOURCE_TABLE)
		,DECODE(P_DOCUMENT_TYPE, FND_API.G_MISS_CHAR, NULL, P_DOCUMENT_TYPE)
		,DECODE(P_VERSION, FND_API.G_MISS_NUM, NULL, P_VERSION)
		,P_DOCUMENT_XML
		,LNS_UTILITY_PUB.CREATED_BY
		,LNS_UTILITY_PUB.CREATION_DATE
		,LNS_UTILITY_PUB.LAST_UPDATED_BY
		,LNS_UTILITY_PUB.LAST_UPDATE_DATE
		,LNS_UTILITY_PUB.LAST_UPDATE_LOGIN
		,LNS_UTILITY_PUB.PROGRAM_UPDATE_DATE
		,LNS_UTILITY_PUB.PROGRAM_APPLICATION_ID
		,LNS_UTILITY_PUB.PROGRAM_ID
		,LNS_UTILITY_PUB.REQUEST_ID
		,DECODE(P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, P_OBJECT_VERSION_NUMBER)
	) RETURNING
		 DOCUMENT_ID
	 INTO
		 X_DOCUMENT_ID;

Line: 63

END Insert_Row;