APPS.GMS_WORKFLOW_UTILS SQL Statements

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

Line: 44

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 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
, p_description		IN	VARCHAR2 := GMS_BUDGET_PUB.G_PA_MISS_CHAR
, p_err_code            IN OUT NOCOPY	NUMBER
, p_err_stage		IN OUT NOCOPY	VARCHAR2
, p_err_stack		IN OUT NOCOPY	VARCHAR2
)

IS
--

	l_entity_key2	gms_wf_processes.entity_key2%TYPE;

Line: 66

    SAVEPOINT Insert_WF_Processes_pvt;

Line: 91

    INSERT INTO gms_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: 123

		ROLLBACK TO Insert_WF_Processes_pvt;

Line: 124

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

Line: 127

END Insert_WF_Processes;

Line: 264

   		 select application_id
   		 from fnd_responsibility
   		 where responsibility_id = x_responsibility_id;