APPS.EAM_WO_PROCESSOR SQL Statements

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

Line: 257

      select count(*)
      into l_err_cnt
      from wip_job_schedule_interface
      where wip_entity_id = l_jobs(l_index).wip_entity_id
        and group_id = p_group_id
        and process_status <> WIP_CONSTANTS.COMPLETED;

Line: 288

    select count(*)
    into l_cnt
    from wip_discrete_jobs
    where wip_entity_id = p_wip_entity_id
      and organization_id = p_org_id
      and status_type = WIP_CONSTANTS.PEND_SCHED;

Line: 317

    update wip_discrete_jobs
    set status_type = WIP_CONSTANTS.UNRELEASED
    where wip_entity_id = p_wip_entity_id
      and organization_id = p_org_id;

Line: 323

      select class_code
      into l_class_code
      from wip_discrete_jobs
      where wip_entity_id = p_wip_entity_id
        and organization_id = p_org_id;

Line: 337

    update wip_discrete_jobs
    set status_type = p_status_type
    where wip_entity_id = p_wip_entity_id
      and organization_id = p_org_id;

Line: 349

    update wip_discrete_jobs
    set status_type = WIP_CONSTANTS.DRAFT,
	date_released = NULL
    where wip_entity_id = p_wip_entity_id
      and organization_id = p_org_id;

Line: 376

    select requested_start_date,due_date
    into l_req_start_date,l_req_due_date
    from wip_discrete_jobs
    where wip_entity_id = p_wip_entity_id
      and organization_id = p_org_id;

Line: 471

      select wip_entity_id,status_type
      from wip_job_schedule_interface
      where group_id = p_group_id;