APPS.PA_BUDGET_WF SQL Statements

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

Line: 162

      PA_WORKFLOW_UTILS.Insert_WF_Processes
      (p_wf_type_code        	=> 'BUDGET'
      ,p_item_type           	=> l_item_type
      ,p_item_key           	=> l_item_key
      ,p_entity_key1         	=> to_char(p_draft_version_id)
      ,p_description         	=> NULL
      ,p_err_code            	=> p_err_code
      ,p_err_stage           	=> p_err_stage
      ,p_err_stack           	=> p_err_stack
      );

Line: 347

	SELECT 'x'
	FROM 	pa_budget_versions
	WHERE	        budget_version_id = p_draft_version_id
	FOR UPDATE NOWAIT;

Line: 439

	UPDATE pa_budget_versions
	 SET budget_status_code = 'W'
             , WF_status_code = 'REJECTED'
 	WHERE  budget_version_id = l_draft_version_id;

Line: 508

PROCEDURE Select_Budget_Approver
(itemtype			IN   	VARCHAR2
, itemkey  			IN   	VARCHAR2
, actid				IN	NUMBER
, funcmode			IN   	VARCHAR2
, resultout			OUT	NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)

IS

        CURSOR 	l_baseliner_user_csr( p_baseliner_id NUMBER )
        IS
        SELECT 	f.user_id
                , f.user_name
                , e.first_name||' '||e.last_name
        FROM	fnd_user f
	        , pa_employees e
        WHERE   f.employee_id = p_baseliner_id
        AND     f.employee_id = e.person_id
		AND     TRUNC(SYSDATE) BETWEEN f.start_date AND nvl(f.end_date, TRUNC(SYSDATE)+1);  --Added : 7688624

Line: 627

	PA_CLIENT_EXTN_BUDGET_WF.Select_Budget_Approver
	(p_item_type			=> itemtype
	,p_item_key  			=> itemkey
	,p_project_id			=> l_project_id
        ,p_budget_type_code		=> l_budget_type_code
        ,p_workflow_started_by_id	=> l_workflow_started_by_id
        ,p_fin_plan_type_id             => l_fin_plan_type_id
        ,p_version_type                 => l_version_type
        ,p_draft_version_id      => l_draft_version_id
	,p_budget_baseliner_id		=> l_baseliner_employee_id
	 );

Line: 711

	WF_CORE.CONTEXT('PA_BUDGET_WF','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

Line: 716

	WF_CORE.CONTEXT('PA_BUDGET_WF','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

Line: 721

	WF_CORE.CONTEXT('PA_BUDGET_WF','SELECT_BUDGET_APPROVER', itemtype, itemkey, to_char(actid), funcmode);

Line: 725

END Select_Budget_Approver;

Line: 1148

      SELECT  MAX(budget_version_id)
      FROM   pa_budget_versions
      WHERE project_id 		= p_project_id
      AND   budget_type_code 	= p_budget_type_code
      AND   budget_status_code 	= 'B';

Line: 1162

      SELECT budget_version_id
             , RECORD_VERSION_NUMBER
      FROM   pa_budget_versions
      WHERE  project_id   = p_project_id
      AND    current_flag   = 'Y'
      and    fin_plan_type_id  = p_fin_plan_type_id
      and    version_type = p_version_type;

Line: 1173

      SELECT RECORD_VERSION_NUMBER
      FROM   pa_budget_versions
      WHERE  budget_version_id = p_draft_version_id;

Line: 1179

      SELECT  f.user_id
      FROM	fnd_user f
      WHERE   f.user_name = (select assigned_user FROM (SELECT assigned_user
					FROM wf_item_activity_statuses
					WHERE item_key = p_item_key
					AND  activity_result_code = 'APPROVED'
					AND  assigned_user IS NOT NULL
					order by process_activity desc) WHERE rownum <2)
      AND     TRUNC(SYSDATE) BETWEEN f.start_date AND nvl(f.end_date, TRUNC(SYSDATE)+1); --Bug # 14358128

Line: 1191

       SELECT   f.user_name
                ,e.first_name||' '||e.last_name
       FROM	  fnd_user f
	        , pa_employees e
       WHERE   f.user_id = p_baseliner_id
       AND     f.employee_id = e.person_id
	AND     TRUNC(SYSDATE) BETWEEN f.start_date AND nvl(f.end_date, TRUNC(SYSDATE)+1);  --Added : Bug #14005015

Line: 1570

                             UPDATE pa_budget_versions
                             SET budget_status_code = 'W'
                               , wf_status_code = 'REJECTED'
                             WHERE budget_version_id = l_draft_version_id;

Line: 1635

                   UPDATE pa_budget_versions SET
	                   budget_status_code = 'W'
                      ,WF_status_code = 'REJECTED'
 	               WHERE  budget_version_id = l_draft_version_id;

Line: 1679

	PA_WORKFLOW_UTILS.Insert_WF_Processes
	      (p_wf_type_code        	=> 'BUDGET'
	      ,p_item_type           	=> itemtype
	      ,p_item_key           	=> itemkey
	      ,p_entity_key1         	=> to_char(l_draft_version_id)
	      ,p_entity_key2		=> to_char(l_baselined_version_id)
	      ,p_description         	=> NULL
	      ,p_err_code            	=> l_err_code
	      ,p_err_stage           	=> l_err_stage
	      ,p_err_stack           	=> l_err_stack
	      );

Line: 1702

   	 UPDATE pa_budget_versions SET
	        budget_status_code = 'W'
                , wf_status_code = NULL
	 WHERE  budget_version_id = l_draft_version_id;

Line: 1720

             UPDATE pa_budget_versions
             SET budget_status_code = 'W'
               , wf_status_code = 'REJECTED'
             WHERE budget_version_id = l_draft_version_id;

Line: 1731

	UPDATE pa_budget_versions SET
	        budget_status_code = 'W'
                , wf_status_code = NULL
	 WHERE  budget_version_id = l_draft_version_id;

Line: 1740

	UPDATE pa_budget_versions SET
	        budget_status_code = 'W'
                , wf_status_code = NULL
	 WHERE  budget_version_id = l_draft_version_id;

Line: 1748

	UPDATE pa_budget_versions SET
	        budget_status_code = 'W'
                , wf_status_code = NULL
	 WHERE  budget_version_id = l_draft_version_id;