DBA Data[Home] [Help]

APPS.PA_AUTOALLOC_WF_PKG SQL Statements

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

Line: 27

	select pa_workflow_itemkey_s.nextval
	into PA_AUTOALLOC_WF_PKG.PA_item_key
	from dual;
Line: 219

        v_LAST_UPDATE_LOGIN                Number;
Line: 221

        v_LAST_UPDATED_BY                  Number;
Line: 319

    v_LAST_UPDATED_BY := WF_ENGINE.GetItemAttrNumber(itemtype => v_gl_item_type,
					  	 itemkey => v_gl_item_key,
						 aname => 'LAST_UPDATED_BY');
Line: 323

    v_LAST_UPDATE_LOGIN := WF_ENGINE.GetItemAttrNumber
						(itemtype => v_gl_item_type,
					  	 itemkey => v_gl_item_key,
						 aname => 'LAST_UPDATE_LOGIN');
Line: 483

                                   aname           => 'LAST_UPDATED_BY',
                                   avalue          => v_LAST_UPDATED_BY);
Line: 485

    WriteDebugMsg('Attribute LAST_UPDATED_BY = ' ||to_char(v_LAST_UPDATED_BY));
Line: 489

                                   aname           => 'LAST_UPDATE_LOGIN',
                                   avalue          => v_LAST_UPDATE_LOGIN);
Line: 491

    WriteDebugMsg('Attribute LAST_UPDATE_LOGIN = '
				||to_char(v_LAST_UPDATE_LOGIN));
Line: 672

	 'DF' or 'IP'  so Delete Draft before restart**/

    v_allocation_run_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
                         				p_item_key,
                         				'ALLOCATION_RUN_ID');
Line: 677

    G_Err_Stage:='Delete Draft before submitting Allocation Concurrent Process';
Line: 681

    PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,
				     v_allocation_run_id);
Line: 724

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 733

/** This function submits Concurrent Process to Update Project Summary Amounts.This is called from PA Step down Allocation Work Flow **/

PROCEDURE Submit_Conc_Sum(	p_item_type	IN	VARCHAR2,
                         	p_item_key	IN 	VARCHAR2,
                         	p_actid		IN 	NUMBER,
                         	p_funcmode	IN 	VARCHAR2,
                         	p_result	OUT  NOCOPY	VARCHAR2) Is

v_request_id            NUMBER;
Line: 834

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 914

   select run_status,target_exp_group,offset_exp_group
   into v_run_status,v_target_exp_group,v_offset_exp_group
   from pa_alloc_runs_all
   where run_id = v_allocation_run_id;
Line: 920

      PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,
				      v_allocation_run_id);
Line: 949

         GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
                    );
Line: 981

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 1055

   /** Select target_exp_group and offset_exp_group in NORMAL mode and
	rev_target_exp_group and rev_offset_exp_group in ROLLBACK mode **/

   select decode (v_operating_mode,'N',target_exp_group,
						rev_target_exp_group),
	  decode (v_operating_mode, 'N',offset_exp_group,
						rev_offset_exp_group)
   into v_target_exp_group,v_offset_exp_group
   from pa_alloc_runs_all
   where run_id = v_allocation_run_id;
Line: 1112

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 1128

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 1237

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 1274

v_last_updated_by		Number;
Line: 1275

v_last_update_login		Number;
Line: 1290

Select tl.USER_CONCURRENT_PROGRAM_NAME
From fnd_concurrent_programs_tl tl,
     fnd_concurrent_programs cp
Where cp.APPLICATION_ID = 275
AND cp.CONCURRENT_PROGRAM_NAME = p_prog_code
AND tl.CONCURRENT_PROGRAM_ID = cp.concurrent_program_id
AND tl.APPLICATION_ID = 275
AND tl.LANGUAGE = NVL(v_userenv_lang,'US');
Line: 1364

   v_last_updated_by := WF_ENGINE.GetItemAttrNumber
                       		(PA_item_type,
                         	 PA_item_key,
                         	 'LAST_UPDATED_BY');
Line: 1369

   v_last_update_login := WF_ENGINE.GetItemAttrNumber
                       		(PA_item_type,
                         	 PA_item_key,
                         	 'LAST_UPDATE_LOGIN');
Line: 1480

       WriteDebugMsg('Inserting req id = '||to_char(v_request_id)||
                            ' into histroy detail');
Line: 1483

          GL_AUTO_ALLOC_WF_PKG.INSERT_BATCH_HIST_DET(
                p_REQUEST_ID        => v_request_id
               ,p_PARENT_REQUEST_ID => v_set_req_id
               ,p_STEP_NUMBER       => v_step_number
               ,p_PROGRAM_NAME_CODE => p_prog_code
               ,p_RUN_MODE          => v_operating_mode
	       ,p_allocation_type   => 'PA'
	       ,p_created_by        => 	v_created_by
	       ,p_last_updated_by   => v_last_updated_by
	       ,p_last_update_login => v_last_update_login);
Line: 1501

         GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
                    );
Line: 1523

/** This procedure deletes an allocation run given a rule_id and a run_id**/

Procedure Delete_Alloc_Run(	p_item_type 	IN 	VARCHAR2,
                         	p_item_key	IN 	VARCHAR2,
                         	p_actid		IN 	NUMBER,
                       		p_funcmode	IN 	VARCHAR2,
                         	p_result	OUT NOCOPY 	VARCHAR2) IS

v_rule_id		Number;
Line: 1542

   Set_PA_WF_Stack(p_item_type,p_item_key,'Delete_Alloc_Run');
Line: 1559

   PA_ALLOC_RUN.Delete_ALLOC_TXNS (v_rule_id,
				   v_allocation_run_id);
Line: 1573

     Wf_Core.Context('PA_AUTOALLOC_WF_PKG', 'DELETE_ALLOC_RUN', p_item_type, p_item_key);
Line: 1584

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 1590

End Delete_Alloc_Run;
Line: 1678

      GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
                    );
Line: 1752

           GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
                    );
Line: 1757

	   WriteDebugMsg('Updated Status Code Value = '||v_status_code);
Line: 1777

          GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
                    );
Line: 1782

	WriteDebugMsg('Updated Status Code Value = '||v_status_code);
Line: 1810

    GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 1895

      select run_status,run_id
      into v_run_status,v_run_id
      from PA_ALLOC_RUNS_ALL
      where rule_id = v_batch_id
      and draft_request_id = v_conc_request_id;
Line: 1909

      WriteDebugMsg('Calling GL API to update PA_ALLOCATION_RUN_ID');
Line: 1917

         WriteDebugMsg('Run ID could not be updated for request ID: '
		||to_char(v_conc_request_id)||' and step number: '||
					to_char(v_step_number));
Line: 1922

         WriteDebugMsg('GL_AUTO_ALLOC_BAT_HIST_DET updated with RUN_ID');
Line: 1940

         GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
	   		);
Line: 1970

          GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
	   		);
Line: 1988

      select run_status
      into v_run_status
      from PA_ALLOC_RUNS_ALL
      where rule_id = v_batch_id
      and release_request_id = v_conc_request_id;
Line: 2007

         GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
	   		);
Line: 2035

            GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
	   		);
Line: 2064

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 2111

   select 'RELEASED'
   into v_result
   from PA_ALLOC_RUNS_ALL
   where run_id = v_allocation_run_id
   and run_status = 'RS';
Line: 2152

    GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 2218

   select 'FAIL'
   into v_result
   From dual
   where exists (select 'Y'
		 from PA_Expenditure_Items_All EI,
		      PA_Expenditures_All ES
		 where ES.expenditure_group = v_expenditure_group
		 and EI.expenditure_item_id = ES.expenditure_id
   		 and EI.cost_distributed_flag||'' = 'N'
   		 );
Line: 2235

   GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
	   		);
Line: 2271

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 2344

            GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,v_status_code
	   		);
Line: 2381

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 2406

   select 'FAIL'
   into v_summarization_status
   from dual
   where exists
	 (select 'Exception'
         from pa_projects_for_accum
	 where request_id = p_request_id
	 and exception_flag = 'Y');
Line: 2528

     GL_AUTO_ALLOC_WF_PKG.Update_Status(v_set_req_id
                    ,v_step_number
                    ,'UFE'
                    );
Line: 3195

      SELECT TRANSLATE(LTRIM(value),',',' ')
      INTO TEMP_UTL
      FROM v$parameter
      WHERE name = 'utl_file_dir';
Line: 3201

        SELECT SUBSTRB(TEMP_UTL, 1, INSTR(TEMP_UTL,' ') - 1)
        INTO TEMP_DIR
        FROM dual ;