APPS.PA_WORKFLOW_UTILS SQL Statements

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

Line: 50

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;

Line: 72

       PA_DEBUG.g_err_stage := 'Procedure Insert_WF_Processes - Begin';

Line: 92

    SAVEPOINT Insert_WF_Processes_pvt;

Line: 105

        :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

Line: 134

            pa_debug.g_err_stage := 'LOG:'||'Inserting into pa_wf_processes: wf_type_code['||p_wf_type_code||']';

Line: 138

                (x_Module       => 'pa_workflow_utils.Insert_WF_Processes'
                ,x_Msg          => pa_debug.g_err_stage
                ,x_Log_Level    => 3);

Line: 143

    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
		 	);

Line: 171

       PA_DEBUG.g_err_stage := 'Procedure Insert_WF_Processes - End';

Line: 183

		ROLLBACK TO Insert_WF_Processes_pvt;

Line: 184

		WF_CORE.CONTEXT('PA_WORKFLOW_UTILS','INSERT_WF_PROCESSES', p_item_type, p_item_key );

Line: 187

END Insert_WF_Processes;

Line: 422

   		 select application_id
   		 from fnd_responsibility
   		 where responsibility_id = x_responsibility_id;

Line: 462

     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;

Line: 620

	      SELECT pa_workflow_itemkey_s.nextval
		INTO l_item_key
		from dual;

Line: 731

                           PA_DEBUG.g_err_stage := 'PA_WORKFLOW_UTILS.Insert_WF_Processes - Begin';

Line: 738

			  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
			     );

Line: 750

                           PA_DEBUG.g_err_stage := 'PA_WORKFLOW_UTILS.Insert_WF_Processes - End';