APPS.LNS_EVT_ACTION_HISTORY_H_PKG SQL Statements

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

Line: 4

/* Insert_Row procedure */
PROCEDURE Insert_Row(
        X_EVENT_ACTION_HISTORY_ID       IN OUT NOCOPY NUMBER
        ,P_EVENT_ACTION_ID              IN NUMBER
        ,P_LOAN_ID                      IN NUMBER
        ,P_WF_ITEMKEY           	IN VARCHAR2     DEFAULT NULL
        ,P_WF_ITEMTYPE          	IN VARCHAR2     DEFAULT NULL
        ,P_ACTIVITY_DATE                IN DATE
        ,P_CONCURRENT_REQUEST_ID        IN NUMBER 	DEFAULT NULL
        ,P_CREATED_BY           	IN NUMBER       DEFAULT NULL
        ,P_CREATION_DATE                IN DATE 	DEFAULT NULL
        ,P_LAST_UPDATED_BY              IN NUMBER       DEFAULT NULL
        ,P_LAST_UPDATE_DATE             IN DATE 	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
) IS
BEGIN
	INSERT INTO LNS_EVT_ACTION_HISTORY_H
	(
		EVENT_ACTION_HISTORY_ID
		,EVENT_ACTION_ID
		,LOAN_ID
		,WF_ITEMKEY
		,WF_ITEMTYPE
		,ACTIVITY_DATE
		,CONCURRENT_REQUEST_ID
		,CREATED_BY
		,CREATION_DATE
		,LAST_UPDATED_BY
		,LAST_UPDATE_DATE
		,LAST_UPDATE_LOGIN
		,PROGRAM_UPDATE_DATE
		,PROGRAM_APPLICATION_ID
		,PROGRAM_ID
		,REQUEST_ID
	) VALUES (
		LNS_EVT_ACTION_HISTORY_S.NEXTVAL
		,DECODE(P_EVENT_ACTION_ID, FND_API.G_MISS_NUM, NULL, P_EVENT_ACTION_ID)
		,DECODE(P_LOAN_ID, FND_API.G_MISS_NUM, NULL, P_LOAN_ID)
		,DECODE(P_WF_ITEMKEY, FND_API.G_MISS_CHAR, NULL, P_WF_ITEMKEY)
		,DECODE(P_WF_ITEMTYPE, FND_API.G_MISS_CHAR, NULL, P_WF_ITEMTYPE)
		,DECODE(P_ACTIVITY_DATE, FND_API.G_MISS_DATE, NULL, P_ACTIVITY_DATE)
		,DECODE(P_CONCURRENT_REQUEST_ID, FND_API.G_MISS_NUM, NULL, P_CONCURRENT_REQUEST_ID)
		,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

	) RETURNING
		 EVENT_ACTION_HISTORY_ID
	 INTO
		 X_EVENT_ACTION_HISTORY_ID;

Line: 64

END Insert_Row;