APPS.IEX_STATUS_RULE_LINE_PKG SQL Statements

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

Line: 4

/* Insert_Row procedure */
PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

Line: 7

PROCEDURE Insert_Row(x_rowid	IN OUT NOCOPY VARCHAR2
	,p_STATUS_RULE_LINE_ID		NUMBER
	,p_PRIORITY		NUMBER
	,p_DELINQUENCY_STATUS       VARCHAR2
	,p_STATUS_RULE_ID		NUMBER
	,p_ENABLED_FLAG		VARCHAR2
	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER
    ,p_PROGRAM_ID               NUMBER
    ,p_SECURITY_GROUP_ID        NUMBER
	,p_OBJECT_VERSION_NUMBER    NUMBER
) IS
	CURSOR C IS SELECT ROWID FROM IEX_CU_STS_RL_LINES
		WHERE STATUS_RULE_LINE_ID = p_STATUS_RULE_LINE_ID;

Line: 26

	INSERT INTO IEX_CU_STS_RL_LINES
	(
		STATUS_RULE_LINE_ID
		,PRIORITY
		,DELINQUENCY_STATUS
		,STATUS_RULE_ID
		,ENABLED_FLAG
		,LAST_UPDATE_DATE
		,LAST_UPDATED_BY
		,CREATION_DATE
		,CREATED_BY
		,LAST_UPDATE_LOGIN
        ,SECURITY_GROUP_ID
        ,PROGRAM_ID
		,OBJECT_VERSION_NUMBER
	) VALUES (
		p_STATUS_RULE_LINE_ID
		,p_PRIORITY
		,p_DELINQUENCY_STATUS
		,p_STATUS_RULE_ID
		,p_ENABLED_FLAG
		,p_LAST_UPDATE_DATE
		,p_LAST_UPDATED_BY
		,p_CREATION_DATE
		,p_CREATED_BY
		,p_LAST_UPDATE_LOGIN
        ,p_SECURITY_GROUP_ID
        ,p_PROGRAM_ID
		,p_OBJECT_VERSION_NUMBER
	);

Line: 64

END Insert_Row;

Line: 66

/* Update_Row procedure */
PROCEDURE Update_Row(x_rowid	VARCHAR2
	,p_STATUS_RULE_LINE_ID		NUMBER
	,p_PRIORITY		NUMBER
	,p_DELINQUENCY_STATUS VARCHAR2
	,p_ENABLED_FLAG		VARCHAR2
	,p_STATUS_RULE_ID		NUMBER
	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER
    ,p_PROGRAM_ID               NUMBER
    ,p_SECURITY_GROUP_ID        NUMBER
	,p_OBJECT_VERSION_NUMBER    NUMBER
) IS
BEGIN
	UPDATE IEX_CU_STS_RL_LINES SET
		STATUS_RULE_LINE_ID = p_STATUS_RULE_LINE_ID
		,PRIORITY = p_PRIORITY
		,DELINQUENCY_STATUS = p_DELINQUENCY_STATUS
		,STATUS_RULE_ID = p_STATUS_RULE_ID
		,ENABLED_FLAG = p_ENABLED_FLAG
		,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
		,LAST_UPDATED_BY = p_LAST_UPDATED_BY
		,CREATION_DATE = p_CREATION_DATE
		,CREATED_BY = p_CREATED_BY
		,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
        ,SECURITY_GROUP_ID = p_SECURITY_GROUP_ID
        ,PROGRAM_ID = p_PROGRAM_ID
		,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
	 WHERE rowid = x_rowid;

Line: 102

END Update_Row;

Line: 104

/* Delete_Row procedure */
PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
BEGIN
	DELETE FROM IEX_CU_STS_RL_LINES
		WHERE rowid = x_rowid;

Line: 113

END Delete_Row;

Line: 122

	,p_LAST_UPDATE_DATE		DATE
	,p_LAST_UPDATED_BY		NUMBER
	,p_CREATION_DATE		DATE
	,p_CREATED_BY		NUMBER
	,p_LAST_UPDATE_LOGIN		NUMBER
    ,p_PROGRAM_ID               NUMBER
    ,p_SECURITY_GROUP_ID        NUMBER
	,p_OBJECT_VERSION_NUMBER    NUMBER
) IS
	CURSOR C IS SELECT * FROM IEX_CU_STS_RL_LINES
		WHERE rowid = x_rowid
		FOR UPDATE of STATUS_RULE_LINE_ID NOWAIT;

Line: 140

		FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 159

		AND ( (Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
			OR ( (Recinfo.LAST_UPDATE_DATE IS NULL)
				AND (p_LAST_UPDATE_DATE IS NULL)))
		AND ( (Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
			OR ( (Recinfo.LAST_UPDATED_BY IS NULL)
				AND (p_LAST_UPDATED_BY IS NULL)))
		AND ( (Recinfo.CREATION_DATE = p_CREATION_DATE)
			OR ( (Recinfo.CREATION_DATE IS NULL)
				AND (p_CREATION_DATE IS NULL)))
		AND ( (Recinfo.CREATED_BY = p_CREATED_BY)
			OR ( (Recinfo.CREATED_BY IS NULL)
				AND (p_CREATED_BY IS NULL)))
		AND ( (Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
			OR ( (Recinfo.LAST_UPDATE_LOGIN IS NULL)
				AND (p_LAST_UPDATE_LOGIN IS NULL)))
		AND ( (Recinfo.PROGRAM_ID = p_PROGRAM_ID)
			OR ( (Recinfo.PROGRAM_ID IS NULL)
				AND (p_PROGRAM_ID IS NULL)))
		AND ( (Recinfo.SECURITY_GROUP_ID = p_SECURITY_GROUP_ID)
			OR ( (Recinfo.SECURITY_GROUP_ID IS NULL)
				AND (p_SECURITY_GROUP_ID IS NULL)))
		AND ( (Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
			OR ( (Recinfo.OBJECT_VERSION_NUMBER IS NULL)
				AND (p_OBJECT_VERSION_NUMBER IS NULL)))
	   ) THEN
		return;