The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_WF_Processes
(p_wf_type_code IN VARCHAR2
, p_item_type IN VARCHAR2
, p_item_key IN VARCHAR2
, p_entity_key1 IN VARCHAR2
, p_entity_key2 IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
, p_description IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
, p_err_code IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
, p_err_stage IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
, p_err_stack IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
--
l_entity_key2 pa_wf_processes.entity_key2%TYPE;
PA_DEBUG.g_err_stage := 'Procedure Insert_WF_Processes - Begin';
SAVEPOINT Insert_WF_Processes_pvt;
:ORA-01400: cannot insert NULL into (PA."PA_WF_PROCESSES.ENTITY_KEY2)
*/
-- Bug#7517187
--ELSIF (p_entity_key2 is NULL OR p_entity_key2 = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) Then
ELSIF (p_entity_key2 is NULL) Then
l_entity_key2 := '-99'; -- Bug 7170228
pa_debug.g_err_stage := 'LOG:'||'Inserting into pa_wf_processes: wf_type_code['||p_wf_type_code||']';
(x_Module => 'pa_workflow_utils.Insert_WF_Processes'
,x_Msg => pa_debug.g_err_stage
,x_Log_Level => 3);
INSERT INTO pa_wf_processes
(wf_type_code
, item_type
, item_key
, entity_key1
, entity_key2
, description
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
)
VALUES
(p_wf_type_code
, p_item_type
, p_item_key
, p_entity_key1
, l_entity_key2
, l_description
, sysdate
, fnd_global.user_id
, sysdate
, fnd_global.user_id
, fnd_global.login_id
);
PA_DEBUG.g_err_stage := 'Procedure Insert_WF_Processes - End';
ROLLBACK TO Insert_WF_Processes_pvt;
WF_CORE.CONTEXT('PA_WORKFLOW_UTILS','INSERT_WF_PROCESSES', p_item_type, p_item_key );
END Insert_WF_Processes;
select application_id
from fnd_responsibility
where responsibility_id = x_responsibility_id;
SELECT
enable_wf_flag,
workflow_item_type,
workflow_process,
wf_success_status_code,
wf_failure_status_code
FROM pa_project_statuses
WHERE
status_type = p_project_status_type
AND
project_status_code = p_project_status_code;
SELECT pa_workflow_itemkey_s.nextval
INTO l_item_key
from dual;
PA_DEBUG.g_err_stage := 'PA_WORKFLOW_UTILS.Insert_WF_Processes - Begin';
PA_WORKFLOW_UTILS.Insert_WF_Processes
(p_wf_type_code => p_wf_type_code
,p_item_type => p_item_type
,p_item_key => p_item_key
,p_entity_key1 => p_entity_key1
,p_entity_key2 => p_entity_key2
,p_description => p_description
,p_err_code => l_err_code
,p_err_stage => l_err_stage
,p_err_stack => l_err_stack
);
PA_DEBUG.g_err_stage := 'PA_WORKFLOW_UTILS.Insert_WF_Processes - End';