APPS.EAM_JOBCLOSE_PRIV SQL Statements

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

Line: 33

                                                                                      SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
                                                                                      INTO l_wf_event_seq
                                                                                      FROM DUAL;

Line: 75

                                                                                    l_parameter_list.DELETE;

Line: 154

      p_select_jobs         IN  NUMBER  ,
      p_exclude_reserved_jobs IN  VARCHAR2  ,
      p_uncompleted_jobs    IN VARCHAR2,
      p_exclude_pending_txn_jobs IN  VARCHAR2  ,
      p_report_type         IN  VARCHAR2 ,
      p_act_close_date      IN  VARCHAR2
)
IS
  l_returnstatus         VARCHAR2(1) ;

Line: 188

   SELECT wdj.wip_entity_id, we.wip_entity_name,
        wdj.status_type,wdj.organization_id,ewod.user_defined_status_id,ewod.workflow_type
   FROM wip_discrete_jobs wdj, wip_dj_close_temp wdct,eam_work_order_details ewod,wip_entities we
   WHERE wdct.group_id = p_group_id
   and wdct.wip_entity_id = wdj.wip_entity_id
   and wdct.organization_id  = wdj.organization_id
   and wdj.wip_entity_id = ewod.wip_entity_id
   and wdj.organization_id   = ewod.organization_id
   and wdj.wip_entity_id = we.wip_entity_id
   and wdj.organization_id   = we.organization_id;

Line: 232

															  p_event					=> 'UPDATE',
															  p_wip_entity_id				 =>l_workorder_tbl(l_wo_count).wip_entity_id,
															  p_organization_id			=>l_workorder_tbl(l_wo_count).organization_id,
															  p_last_update_date			=> SYSDATE,
															  p_last_updated_by			=> FND_GLOBAL.user_id,
															  p_last_update_login			 =>FND_GLOBAL.login_id
														     );

Line: 287

											SELECT status_type
											INTO l_new_status_type
											FROM WIP_DISCRETE_JOBS
											WHERE wip_entity_id   = l_workorder_tbl(i).wip_entity_id
											AND  organization_id = l_workorder_tbl(i).organization_id;

Line: 295

																				UPDATE EAM_WORK_ORDER_DETAILS
																				SET USER_DEFINED_STATUS_ID = l_new_status_type,
																					 last_update_date                       =   SYSDATE,
																					  last_updated_by                       =  FND_GLOBAL.user_id,
																					  last_update_login                    =  FND_GLOBAL.login_id
																				WHERE wip_entity_id   = l_workorder_tbl(i).wip_entity_id
																				AND  organization_id = l_workorder_tbl(i).organization_id;

Line: 325

																								  p_event					=> 'UPDATE',
																								  p_wip_entity_id				 =>l_workorder_tbl(i).wip_entity_id,
																								  p_organization_id			=>l_workorder_tbl(i).organization_id,
																								  p_last_update_date			=> SYSDATE,
																								  p_last_updated_by			=> FND_GLOBAL.user_id,
																								  p_last_update_login			 =>FND_GLOBAL.login_id
																							     );

Line: 365

   p_select_jobs                      IN    NUMBER,
   p_report_type                       IN     VARCHAR2,
   x_request_id                        OUT NOCOPY    NUMBER
   )
 IS
 BEGIN

       x_request_id := fnd_request.submit_request('EAM', 'EAMCDCL', '',
	to_char(p_submission_date, 'YYYY/MM/DD HH24:MI'),
	FALSE,
	to_char(p_organization_id),'','','','','','','','','',
        '','','',to_char(p_group_id),to_char(p_select_jobs),'','','',p_report_type,'',
	chr(0),'','','','','','','','','',
	'','','','','','','','','','',
	'','','','','','','','','','',
	'','','','','','','','','','',
	'','','','','','','','','','',
	'','','','','','','','','','',
	'','','','','','','','','','',
	'','','','','','','','','','');