[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row
===============================================================================*/
PROCEDURE Insert_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_Rowid IN OUT NOCOPY VARCHAR2,
p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
CURSOR C IS SELECT rowid FROM IGC_CC_ROUTING_CTRLS_ALL
WHERE org_id = p_org_id;
SAVEPOINT Insert_Row_Pvt ;
INSERT INTO IGC_CC_ROUTING_CTRLS_ALL(
ORG_ID,
CC_TYPE,
CC_STATE,
CC_CAN_PRPR_APPRV_FLAG,
CC_CAN_PRPR_ENCMBR_FLAG,
WF_APPROVAL_ITEMTYPE,
WF_APPROVAL_PROCESS,
DEFAULT_APPROVAL_PATH_ID,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
CREATION_DATE,
LAST_UPDATED_BY,
CREATED_BY )
VALUES (
p_ORG_ID,
p_CC_TYPE,
p_CC_STATE,
p_CC_CAN_PRPR_APPRV_FLAG,
p_CC_CAN_PRPR_ENCMBR_FLAG,
p_WF_APPROVAL_ITEMTYPE,
p_WF_APPROVAL_PROCESS,
p_DEFAULT_APPROVAL_PATH_ID,
p_LAST_UPDATE_DATE,
p_LAST_UPDATE_LOGIN,
p_CREATION_DATE,
p_LAST_UPDATED_BY,
p_CREATED_BY
);
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
ROLLBACK TO Insert_Row_Pvt ;
END Insert_Row;
p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE,
p_row_locked OUT NOCOPY VARCHAR2
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
SELECT *
FROM IGC_CC_ROUTING_CTRLS_ALL
WHERE rowid = p_Rowid
FOR UPDATE of ORG_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_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN )
OR ( (Recinfo.LAST_UPDATE_LOGIN IS NULL)
AND (p_LAST_UPDATE_LOGIN IS NULL)))
AND ( (Recinfo.CREATION_DATE = p_CREATION_DATE )
OR ( (Recinfo.CREATION_DATE IS NULL)
AND (p_CREATION_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.CREATED_BY = p_CREATED_BY )
OR ( (Recinfo.CREATED_BY IS NULL)
AND (p_CREATED_BY IS NULL)))
) then
return;
PROCEDURE Update_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_Rowid IN OUT NOCOPY VARCHAR2,
p_ORG_ID IGC_CC_ROUTING_CTRLS_ALL.ORG_ID%TYPE,
p_CC_TYPE IGC_CC_ROUTING_CTRLS_ALL.CC_TYPE%TYPE,
p_CC_STATE IGC_CC_ROUTING_CTRLS_ALL.CC_STATE%TYPE,
p_CC_CAN_PRPR_APPRV_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_APPRV_FLAG%TYPE,
p_CC_CAN_PRPR_ENCMBR_FLAG IGC_CC_ROUTING_CTRLS_ALL.CC_CAN_PRPR_ENCMBR_FLAG%TYPE,
p_wf_approval_itemtype IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_ITEMTYPE%TYPE,
p_wf_approval_process IGC_CC_ROUTING_CTRLS_ALL.WF_APPROVAL_PROCESS%TYPE,
p_DEFAULT_APPROVAL_PATH_ID IGC_CC_ROUTING_CTRLS_ALL.DEFAULT_APPROVAL_PATH_ID%TYPE,
p_LAST_UPDATE_DATE IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_DATE%TYPE,
p_LAST_UPDATE_LOGIN IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATE_LOGIN%TYPE,
p_CREATION_DATE IGC_CC_ROUTING_CTRLS_ALL.CREATION_DATE%TYPE,
p_LAST_UPDATED_BY IGC_CC_ROUTING_CTRLS_ALL.LAST_UPDATED_BY%TYPE,
p_CREATED_BY IGC_CC_ROUTING_CTRLS_ALL.CREATED_BY%TYPE
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
SAVEPOINT Update_Row_Pvt ;
UPDATE IGC_CC_ROUTING_CTRLS_ALL
SET
ORG_ID = p_ORG_ID,
CC_TYPE = p_CC_TYPE,
CC_STATE = p_CC_STATE,
CC_CAN_PRPR_APPRV_FLAG = p_CC_CAN_PRPR_APPRV_FLAG,
CC_CAN_PRPR_ENCMBR_FLAG = p_CC_CAN_PRPR_ENCMBR_FLAG,
WF_APPROVAL_ITEMTYPE = p_wf_approval_itemtype,
WF_APPROVAL_PROCESS = p_wf_approval_process,
DEFAULT_APPROVAL_PATH_ID = p_DEFAULT_APPROVAL_PATH_ID,
LAST_UPDATE_DATE = p_LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN,
CREATION_DATE = p_CREATION_DATE,
LAST_UPDATED_BY = p_LAST_UPDATED_BY,
CREATED_BY = p_CREATED_BY
WHERE rowid = p_Rowid;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
ROLLBACK TO Update_Row_Pvt ;
END Update_Row;
PROCEDURE Delete_Row(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_Rowid VARCHAR2) IS
l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
SAVEPOINT Delete_Row_Pvt ;
DELETE FROM IGC_CC_ROUTING_CTRLS_ALL
WHERE rowid = p_Rowid;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
ROLLBACK TO Delete_Row_Pvt ;
END Delete_Row;