[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Insert_Row procedure */
PG_DEBUG NUMBER(2) ;
PROCEDURE Insert_Row(x_rowid IN OUT NOCOPY VARCHAR2
,p_SCORE_ID NUMBER
,p_SCORE_NAME VARCHAR2
,p_SECURITY_GROUP_ID NUMBER
,p_SCORE_DESCRIPTION VARCHAR2
,p_ENABLED_FLAG VARCHAR2
,p_VALID_FROM_DT DATE
,p_VALID_TO_DT DATE
,p_CAMPAIGN_SCHED_ID NUMBER
,p_JTF_OBJECT_CODE VARCHAR2
,p_CONCURRENT_PROG_NAME 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_REQUEST_ID NUMBER
,p_PROGRAM_APPLICATION_ID NUMBER
,p_PROGRAM_ID NUMBER
,p_PROGRAM_UPDATE_DATE DATE
,p_STATUS_DETERMINATION VARCHAR2
,p_WEIGHT_REQUIRED VARCHAR2
,p_SCORE_RANGE_LOW VARCHAR2
,p_SCORE_RANGE_HIGH VARCHAR2
,p_OUT_OF_RANGE_RULE VARCHAR2
) IS
CURSOR C IS SELECT ROWID FROM IEX_SCORES
WHERE SCORE_ID = p_SCORE_ID;
INSERT INTO IEX_SCORES
(
SCORE_ID
,SCORE_NAME
,SECURITY_GROUP_ID
,SCORE_DESCRIPTION
,ENABLED_FLAG
,VALID_FROM_DT
,VALID_TO_DT
,CAMPAIGN_SCHED_ID
,JTF_OBJECT_CODE
,CONCURRENT_PROG_NAME
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,REQUEST_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,STATUS_DETERMINATION
,WEIGHT_REQUIRED
,SCORE_RANGE_LOW
,SCORE_RANGE_HIGH
,OUT_OF_RANGE_RULE
) VALUES (
p_SCORE_ID
,p_SCORE_NAME
,p_SECURITY_GROUP_ID
,p_SCORE_DESCRIPTION
,p_ENABLED_FLAG
,p_VALID_FROM_DT
,p_VALID_TO_DT
,p_CAMPAIGN_SCHED_ID
,p_JTF_OBJECT_CODE
,p_CONCURRENT_PROG_NAME
,p_LAST_UPDATE_DATE
,p_LAST_UPDATED_BY
,p_CREATION_DATE
,p_CREATED_BY
,p_LAST_UPDATE_LOGIN
,p_REQUEST_ID
,p_PROGRAM_APPLICATION_ID
,p_PROGRAM_ID
,p_PROGRAM_UPDATE_DATE
,l_STATUS_DETERMINATION
,l_WEIGHT_REQUIRED
,l_SCORE_RANGE_LOW
,l_SCORE_RANGE_HIGH
,l_OUT_OF_RANGE_RULE
);
END Insert_Row;
/* Update_Row procedure */
PROCEDURE Update_Row(x_rowid VARCHAR2
,p_SCORE_ID NUMBER
,p_SCORE_NAME VARCHAR2
,p_SECURITY_GROUP_ID NUMBER
,p_SCORE_DESCRIPTION VARCHAR2
,p_ENABLED_FLAG VARCHAR2
,p_VALID_FROM_DT DATE
,p_VALID_TO_DT DATE
,p_CAMPAIGN_SCHED_ID NUMBER
,p_JTF_OBJECT_CODE VARCHAR2
,p_CONCURRENT_PROG_NAME 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_REQUEST_ID NUMBER
,p_PROGRAM_APPLICATION_ID NUMBER
,p_PROGRAM_ID NUMBER
,p_PROGRAM_UPDATE_DATE DATE
,p_STATUS_DETERMINATION VARCHAR2
,p_WEIGHT_REQUIRED VARCHAR2
,p_SCORE_RANGE_LOW VARCHAR2
,p_SCORE_RANGE_HIGH VARCHAR2
,p_OUT_OF_RANGE_RULE VARCHAR2
) IS
l_status_determination varchar2(1);
UPDATE IEX_SCORES SET
SCORE_ID = p_SCORE_ID
,SCORE_NAME = p_SCORE_NAME
,SECURITY_GROUP_ID = p_SECURITY_GROUP_ID
,SCORE_DESCRIPTION = p_SCORE_DESCRIPTION
,ENABLED_FLAG = p_ENABLED_FLAG
,VALID_FROM_DT = p_VALID_FROM_DT
,VALID_TO_DT = p_VALID_TO_DT
,CAMPAIGN_SCHED_ID = p_CAMPAIGN_SCHED_ID
,JTF_OBJECT_CODE = p_JTF_OBJECT_CODE
,CONCURRENT_PROG_NAME = p_CONCURRENT_PROG_NAME
,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
,REQUEST_ID = p_REQUEST_ID
,PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID
,PROGRAM_ID = p_PROGRAM_ID
,PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE
,STATUS_DETERMINATION = l_STATUS_DETERMINATION
,WEIGHT_REQUIRED = l_WEIGHT_REQUIRED
,SCORE_RANGE_LOW = l_SCORE_RANGE_LOW
,SCORE_RANGE_HIGH = l_SCORE_RANGE_HIGH
,OUT_OF_RANGE_RULE = l_OUT_OF_RANGE_RULE
WHERE rowid = x_rowid;
END Update_Row;
/* Delete_Row procedure */
PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
BEGIN
DELETE FROM IEX_SCORES
WHERE rowid = x_rowid;
END Delete_Row;
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATED_BY NUMBER
,p_CREATION_DATE DATE
,p_CREATED_BY NUMBER
,p_LAST_UPDATE_LOGIN NUMBER
,p_REQUEST_ID NUMBER
,p_PROGRAM_APPLICATION_ID NUMBER
,p_PROGRAM_ID NUMBER
,p_PROGRAM_UPDATE_DATE DATE
,p_STATUS_DETERMINATION VARCHAR2
,p_WEIGHT_REQUIRED VARCHAR2
,p_SCORE_RANGE_LOW VARCHAR2
,p_SCORE_RANGE_HIGH VARCHAR2
,p_OUT_OF_RANGE_RULE VARCHAR2
) IS
CURSOR C IS SELECT * FROM IEX_SCORES
WHERE rowid = x_rowid
FOR UPDATE of SCORE_ID NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
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.REQUEST_ID = p_REQUEST_ID)
OR ( (Recinfo.REQUEST_ID IS NULL)
AND (p_REQUEST_ID IS NULL)))
AND ( (Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
OR ( (Recinfo.PROGRAM_APPLICATION_ID IS NULL)
AND (p_PROGRAM_APPLICATION_ID IS NULL)))
AND ( (Recinfo.PROGRAM_ID = p_PROGRAM_ID)
OR ( (Recinfo.PROGRAM_ID IS NULL)
AND (p_PROGRAM_ID IS NULL)))
AND ( (Recinfo.STATUS_DETERMINATION = p_STATUS_DETERMINATION)
OR ( (Recinfo.STATUS_DETERMINATION IS NULL)
AND (p_STATUS_DETERMINATION IS NULL)))
AND ( (Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
OR ( (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
AND (p_PROGRAM_UPDATE_DATE IS NULL)))
) THEN
return;