[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
X_ROWID IN OUT NOCOPY VARCHAR2
,x_WORK_ITEM_ID IN NUMBER
,x_STRATEGY_ID IN NUMBER
,x_work_item_template_id IN NUMBER
,x_RESOURCE_ID IN NUMBER
,x_STATUS_CODE IN VARCHAR2
,x_execute_start IN DATE
,x_execute_end IN DATE
,x_LAST_UPDATE_LOGIN IN NUMBER
,x_CREATION_DATE IN DATE
,x_CREATED_BY IN NUMBER
,x_LAST_UPDATE_DATE DATE
,x_last_updated_by IN NUMBER
,x_OBJECT_VERSION_NUMBER IN NUMBER
,X_REQUEST_ID in NUMBER
,X_PROGRAM_APPLICATION_ID in NUMBER
,X_PROGRAM_ID in NUMBER
,X_PROGRAM_UPDATE_DATE in DATE
,x_schedule_start in DATE
,x_schedule_end in DATE
,x_strategy_temp_id in NUMBER
,x_work_item_order in NUMBER
,x_escalated_yn in CHAR
,x_pre_execution_wait IN NUMBER
,x_pre_execution_time_uom IN VARCHAR2
,x_post_execution_wait IN NUMBER
,x_execution_time_uom IN VARCHAR2
,x_xdo_temp_id IN NUMBER
,x_optional_yn IN VARCHAR2
,x_optional_wait_time IN NUMBER
,x_optional_wait_time_uom IN VARCHAR2
,x_notify_yn IN VARCHAR2
,x_escalate_yn IN CHAR
,x_escalate_wait_time NUMBER
,x_escalate_wait_time_uom VARCHAR2
,x_custom_workflow_type VARCHAR2
)
IS
cursor C is select ROWID from IEX_STRATEGY_WORK_ITEMS
where WORK_ITEM_ID = X_WORK_ITEM_ID ;
IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
INSERT INTO IEX_STRATEGY_WORK_ITEMS(
WORK_ITEM_ID
,STRATEGY_ID
,RESOURCE_ID
,STATUS_CODE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATION_DATE
,CREATED_BY
,PROGRAM_ID
,OBJECT_VERSION_NUMBER
,REQUEST_ID
,LAST_UPDATE_DATE
,WORK_ITEM_TEMPLATE_ID
,PROGRAM_APPLICATION_ID
,PROGRAM_UPDATE_DATE
,execute_start
,execute_end
,schedule_start
,schedule_end
,strategy_temp_id
,work_item_order
,escalated_yn
,pre_execution_wait
,pre_execution_time_uom
,post_execution_wait
,execution_time_uom
,xdo_temp_id
,optional_yn
,optional_wait_time
,optional_wait_time_uom
,notify_yn
,escalate_yn
,escalate_wait_time
,escalate_wait_time_uom
,custom_workflow_type
)
VALUES (
x_WORK_ITEM_ID
,x_STRATEGY_ID
,x_RESOURCE_ID
,decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, x_STATUS_CODE)
,decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATED_BY)
,decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN)
,decode( x_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_CREATION_DATE)
,decode( x_CREATED_BY, FND_API.G_MISS_NUM, NULL, x_CREATED_BY)
,decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_ID)
,decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER)
,decode( x_REQUEST_ID, FND_API.G_MISS_NUM, NULL, x_REQUEST_ID)
,decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), x_LAST_UPDATE_DATE)
,decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_TEMPLATE_ID)
,decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, x_PROGRAM_APPLICATION_ID)
,decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), x_PROGRAM_UPDATE_DATE)
,decode( x_execute_start, FND_API.G_MISS_DATE, to_date(null), x_execute_start)
,decode( x_execute_end, FND_API.G_MISS_DATE, to_date(null), x_execute_end)
,decode( x_schedule_start, FND_API.G_MISS_DATE, to_date(null), x_schedule_start )
,decode( x_schedule_end , FND_API.G_MISS_DATE, to_date(null), x_schedule_end)
,decode( x_strategy_temp_id, FND_API.G_MISS_NUM, NULL, x_strategy_temp_id)
,decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, NULL, x_WORK_ITEM_ORDER)
,decode( x_escalated_yn, FND_API.G_MISS_CHAR, NULL, x_escalated_yn)
,decode( x_pre_execution_wait, FND_API.G_MISS_NUM, NULL, x_pre_execution_wait)
,decode( x_pre_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_pre_execution_time_uom)
,decode( x_post_execution_wait, FND_API.G_MISS_NUM, NULL, x_post_execution_wait)
,decode( x_execution_time_uom, FND_API.G_MISS_CHAR, NULL, x_execution_time_uom)
,decode( x_xdo_temp_id, FND_API.G_MISS_NUM, NULL, x_xdo_temp_id)
,decode( x_optional_yn, FND_API.G_MISS_CHAR, NULL, x_optional_yn)
,decode( x_optional_wait_time, FND_API.G_MISS_NUM, NULL, x_optional_wait_time)
,decode( x_optional_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_optional_wait_time_uom)
,decode( x_notify_yn, FND_API.G_MISS_CHAR, NULL, x_notify_yn)
,decode( x_escalate_yn, FND_API.G_MISS_CHAR, NULL, x_escalate_yn)
,decode( x_escalate_wait_time, FND_API.G_MISS_NUM, NULL, x_escalate_wait_time)
,decode( x_escalate_wait_time_uom, FND_API.G_MISS_CHAR, NULL, x_escalate_wait_time_uom)
,decode( x_custom_workflow_type, FND_API.G_MISS_CHAR, NULL, x_custom_workflow_type)
);
IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
End Insert_Row;
PROCEDURE Update_Row(
x_WORK_ITEM_ID IN NUMBER
,x_STRATEGY_ID IN NUMBER
,x_work_item_template_id IN NUMBER
,x_RESOURCE_ID IN NUMBER
,x_STATUS_CODE IN VARCHAR2
,x_execute_start IN DATE
,x_execute_end IN DATE
,x_LAST_UPDATE_LOGIN IN NUMBER
,x_LAST_UPDATE_DATE DATE
,x_last_updated_by IN NUMBER
,x_OBJECT_VERSION_NUMBER IN NUMBER
,X_REQUEST_ID in NUMBER
,X_PROGRAM_APPLICATION_ID in NUMBER
,X_PROGRAM_ID in NUMBER
,X_PROGRAM_UPDATE_DATE in DATE
,x_schedule_start in DATE
,x_schedule_end in DATE
,x_strategy_temp_id in NUMBER
,x_work_item_order in NUMBER
,x_escalated_yn in CHAR
)
IS
BEGIN
-- IF PG_DEBUG < 10 THEN
IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
Update IEX_STRATEGY_WORK_ITEMS
SET
STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)
,RESOURCE_ID = decode( x_RESOURCE_ID, FND_API.G_MISS_NUM, RESOURCE_ID, x_RESOURCE_ID)
,STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, x_STATUS_CODE)
,LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY)
,LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN)
,PROGRAM_ID = decode( x_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, x_PROGRAM_ID)
,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)
,REQUEST_ID = decode( x_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, x_REQUEST_ID)
,LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE)
,WORK_ITEM_TEMPLATE_ID = decode( x_WORK_ITEM_TEMPLATE_ID, FND_API.G_MISS_NUM, WORK_ITEM_TEMPLATE_ID, x_WORK_ITEM_TEMPLATE_ID)
,PROGRAM_APPLICATION_ID = decode( x_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, x_PROGRAM_APPLICATION_ID)
,PROGRAM_UPDATE_DATE = decode( x_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, x_PROGRAM_UPDATE_DATE)
,execute_start = decode( x_execute_start, FND_API.G_MISS_DATE, execute_start, x_execute_start)
,execute_end = decode( x_execute_end, FND_API.G_MISS_DATE, execute_end, x_execute_end)
,schedule_start =decode( x_schedule_start, FND_API.G_MISS_DATE, schedule_start, x_schedule_start)
,schedule_end =decode( x_schedule_end, FND_API.G_MISS_DATE, schedule_end, x_schedule_end)
,strategy_temp_id = decode( x_strategy_temp_id , FND_API.G_MISS_NUM, strategy_temp_id , x_strategy_temp_id )
,WORK_ITEM_ORDER = decode( x_WORK_ITEM_ORDER, FND_API.G_MISS_NUM, WORK_ITEM_ORDER, x_WORK_ITEM_ORDER)
,escalated_yn = decode( x_escalated_yn, FND_API.G_MISS_CHAR, escalated_yn, x_escalated_yn)
where WORK_ITEM_ID = x_WORK_ITEM_ID;
IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
END Update_Row;
PROCEDURE Delete_Row(
x_WORK_ITEM_ID NUMBER)
IS
BEGIN
DELETE FROM IEX_STRATEGY_WORK_ITEMS
WHERE WORK_ITEM_ID = x_WORK_ITEM_ID;
END Delete_Row;
,x_LAST_UPDATE_LOGIN IN NUMBER
,x_CREATION_DATE IN DATE
,x_CREATED_BY IN NUMBER
,x_LAST_UPDATE_DATE DATE
,x_last_updated_by IN NUMBER
,x_OBJECT_VERSION_NUMBER IN NUMBER
,X_REQUEST_ID in NUMBER
,X_PROGRAM_APPLICATION_ID in NUMBER
,X_PROGRAM_ID in NUMBER
,X_PROGRAM_UPDATE_DATE in DATE
,x_schedule_start in DATE
,x_schedule_end in DATE
,x_strategy_temp_id in NUMBER
,x_work_item_order in NUMBER
)
IS
CURSOR C IS
SELECT *
FROM IEX_STRATEGY_WORK_ITEMS
WHERE WORK_ITEM_ID = x_WORK_ITEM_ID
FOR UPDATE of WORK_ITEM_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
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.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.CREATED_BY = p_CREATED_BY)
OR ( ( Recinfo.CREATED_BY IS NULL )
AND ( p_CREATED_BY IS NULL )))
AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
OR ( ( Recinfo.PROGRAM_ID IS NULL )
AND ( p_PROGRAM_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 )))
AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
OR ( ( Recinfo.REQUEST_ID IS NULL )
AND ( p_REQUEST_ID IS NULL )))
AND ( ( Recinfo.WORK_TYPE = p_WORK_TYPE)
OR ( ( Recinfo.WORK_TYPE IS NULL )
AND ( p_WORK_TYPE IS NULL )))
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.WORK_ITEM_TEMPLATE_ID = p_WORK_ITEM_TEMPLATE_ID)
OR ( ( Recinfo.WORK_ITEM_TEMPLATE_ID IS NULL )
AND ( p_WORK_ITEM_TEMPLATE_ID IS NULL )))
) then
return;
cursor c is select OBJECT_VERSION_NUMBER
from IEX_STRATEGY_WORK_ITEMS
where WORK_ITEM_ID = X_WORK_ITEM_ID
and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
for update of WORK_ITEM_ID nowait;
fnd_message.set_name('FND', 'FORM_RECORD_DELETED');