APPS.WIP_VALIDATE SQL Statements

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

Line: 20

    FND_API.g_attr_tbl.DELETE;

Line: 37

    FND_API.g_attr_tbl(I).name     := 'last_updated_by';

Line: 39

    FND_API.g_attr_tbl(I).name     := 'last_update_date';

Line: 41

    FND_API.g_attr_tbl(I).name     := 'last_update_login';

Line: 51

    FND_API.g_attr_tbl(I).name     := 'program_update_date';

Line: 358

    FND_API.g_attr_tbl(I).name     := 'schedule_update';

Line: 471

    FND_API.g_attr_tbl(I).name     := 'last_updated_by_name';

Line: 604

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mfg_lookups
      WHERE    lookup_type = 'WIP_ENTITY'
      AND      lookup_code = p_entity_type;

Line: 648

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mtl_parameters
    WHERE    organization_code = p_organization_code;

Line: 692

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mtl_parameters
    WHERE    organization_id = p_organization_id;

Line: 737

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_system_items
      WHERE    inventory_item_id = p_primary_item_id
      AND      organization_id = p_organization_id;

Line: 782

    SELECT  'VALID'
    INTO     l_dummy
    FROM     wip_entities
    WHERE    wip_entity_id = p_wip_entity_id;

Line: 827

    SELECT  'VALID'
      INTO     l_dummy
      FROM     wip_entities
      WHERE    wip_entity_name = p_wip_entity_name
      AND      organization_id = p_organization_id;

Line: 874

    SELECT  'VALID'
      INTO     l_dummy
      FROM     bom_alternate_designators
      WHERE    alternate_designator_code = p_alternate_bom_designator
      AND      organization_id = p_organization_id;

Line: 920

    SELECT  'VALID'
      INTO     l_dummy
      FROM     bom_alternate_designators
      WHERE    alternate_designator_code = p_alternate_rout_designator
      AND      organization_id = p_organization_id;

Line: 967

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_item_revisions
      WHERE    revision = p_bom_revision
      AND      inventory_item_id = p_inventory_item_id
      AND      organization_id = p_organization_id;

Line: 1020

    SELECT 'VALID'
      INTO l_dummy
      FROM dual
      WHERE NOT EXISTS (
                        SELECT '1'
                        FROM wip_discrete_jobs
                        WHERE wip_entity_id <> p_wip_entity_id
                        AND build_sequence = p_build_sequence
                        AND Nvl(p_schedule_group_id, Nvl(schedule_group_id,-1)) = Nvl(schedule_group_id,-1)
                        AND Nvl(p_line_id, Nvl(line_id,-1)) = Nvl(line_id,-1)
                        )
      AND NOT EXISTS (
                      SELECT '1'
                      FROM wip_flow_schedules
                      WHERE wip_entity_id <> p_wip_entity_id
                      AND build_sequence = p_build_sequence
                      AND Nvl(p_schedule_group_id, Nvl(schedule_group_id,-1)) = Nvl(schedule_group_id,-1)
                      AND Nvl(p_line_id, Nvl(line_id,-1)) = Nvl(line_id,-1)
                      );

Line: 1080

    SELECT  'VALID'
      INTO     l_dummy
      FROM     wip_accounting_classes
      WHERE    class_code = p_class_code
      AND      organization_id = p_organization_id;

Line: 1126

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_secondary_inventories
      WHERE    secondary_inventory_name = p_completion_subinventory
      AND      organization_id = p_organization_id;

Line: 1171

    SELECT  'VALID'
    INTO     l_dummy
    FROM     so_demand_classes_active_v
    WHERE    demand_class = p_demand_class;

Line: 1219

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_demand
      WHERE    demand_source_delivery = p_demand_source_delivery
      AND      demand_source_line = p_demand_source_line
      AND      demand_source_header_id = p_demand_source_header_id
      AND      demand_source_type = p_demand_source_type
      AND      inventory_item_id = p_inventory_item_id;

Line: 1269

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_demand
      WHERE    demand_source_header_id = p_demand_source_header_id
      AND      inventory_item_id = p_inventory_item_id
      AND      demand_source_type = p_demand_source_type
      AND      rownum = 1;

Line: 1319

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_demand
      WHERE    demand_source_line = p_demand_source_line
      AND      demand_source_header_id = p_demand_source_header_id
      AND      demand_source_type = p_demand_source_type
      AND      inventory_item_id = p_inventory_item_id
      AND      rownum = 1;

Line: 1368

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_kanban_cards
      WHERE    kanban_card_id = p_kanban_card_id
      AND      organization_id = p_organization_id;

Line: 1413

    SELECT  'VALID'
      INTO     l_dummy
      FROM     wip_lines
      WHERE    line_code = p_line_code;

Line: 1455

    SELECT  'VALID'
      INTO     l_dummy
      FROM     wip_lines
      WHERE    line_id = p_line_id;

Line: 1497

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_material_account;

Line: 1541

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_material_overhead_account;

Line: 1586

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_material_variance_account;

Line: 1630

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_osp_account;

Line: 1674

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_osp_variance_account;

Line: 1718

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_overhead_account;

Line: 1762

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_overhead_variance_account;

Line: 1810

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_project_v mpv, mtl_parameters mp
      WHERE    mpv.project_id = p_project_id
      AND      mp.organization_id = p_organization_id
      AND      mp.project_reference_enabled = 1;

Line: 1856

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_resource_account;

Line: 1900

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_resource_variance_account;

Line: 1946

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_rtg_item_revisions
      WHERE    process_revision = p_routing_revision
      AND      inventory_item_id = p_inventory_item_id
      AND      organization_id = p_organization_id;

Line: 1992

    SELECT  'VALID'
    INTO     l_dummy
    FROM     wip_schedule_groups
    WHERE    schedule_group_id = p_schedule_group_id;

Line: 2036

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_std_cost_adj_account;

Line: 2082

      SELECT  'VALID'
        INTO     l_dummy
        FROM     pa_tasks_expend_v ptv, mtl_parameters mp
        WHERE    ptv.task_id = p_task_id
        AND      ptv.project_id = p_project_id
        AND      mp.organization_id = p_organization_id
        AND      mp.project_reference_enabled = 1
        AND      mp.project_control_level = 2;

Line: 2132

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_system_items
      WHERE    inventory_item_id = p_bom_reference_id
      AND      organization_id = p_organization_id;

Line: 2177

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_bill_of_materials
    WHERE    bill_sequence_id = p_common_bom_sequence_id;

Line: 2221

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_operational_routings
    WHERE    routing_sequence_id = p_common_rout_sequence_id;

Line: 2265

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mfg_lookups
      WHERE    lookup_type = 'SYS_YES_NO'
      AND      lookup_code = p_firm_planned_flag;

Line: 2310

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mfg_lookups
      WHERE    lookup_type = 'WIP_DISCRETE_JOB'
      AND      lookup_code = p_job_type;

Line: 2400

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_system_items
      WHERE    inventory_item_id = p_routing_reference_id
      AND      organization_id = p_organization_id;

Line: 2445

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mfg_lookups
      WHERE    lookup_type = 'WIP_JOB_STATUS'
      AND      lookup_code = p_status_type;

Line: 2490

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mfg_lookups
      WHERE    lookup_type = 'WIP_SUPPLY'
      AND      lookup_code = p_wip_supply_type;

Line: 2536

    SELECT  'VALID'
    INTO     l_dummy
    FROM     wip_repetitive_schedules
    WHERE    repetitive_schedule_id = p_repetitive_schedule_id;

Line: 2581

    SELECT  'VALID'
      INTO     l_dummy
      FROM     org_acct_periods
      WHERE    acct_period_id = p_acct_period_id
      AND      organization_id = p_organization_id;

Line: 2987

    SELECT  'VALID'
      INTO     l_dummy
      FROM     mtl_system_items
      WHERE    inventory_item_id = p_inventory_item_id
      AND      organization_id = p_organization_id;

Line: 6834

    SELECT  'VALID'
      INTO     l_dummy
      FROM     MFG_LOOKUPS
      WHERE    lookup_type = 'BOM_AUTOCHARGE_TYPE'
      AND      lookup_code = p_autocharge_type;

Line: 6883

    SELECT  'VALID'
      INTO     l_dummy
      FROM     MFG_LOOKUPS
      WHERE    lookup_type = 'CST_BASIS'
      AND      lookup_code = p_basis_type;

Line: 6932

    SELECT  'VALID'
    INTO     l_dummy
    FROM     fnd_user
    WHERE    user_name = p_created_by_name;

Line: 7179

   SELECT     'VALID'
     INTO     l_dummy
     FROM     bom_departments
     WHERE    department_code = p_department_code
     AND      organization_id = p_organization_id;

Line: 7230

   SELECT     'VALID'
     INTO     l_dummy
     FROM     bom_departments
     WHERE    department_id = p_department_id;

Line: 7399

FUNCTION Last_Updated_By_Name ( p_last_updated_by_name IN VARCHAR2 )
RETURN BOOLEAN
IS
l_dummy                       VARCHAR2(10);

Line: 7405

    IF p_last_updated_by_name IS NULL OR
        p_last_updated_by_name = FND_API.G_MISS_CHAR
    THEN
        RETURN TRUE;

Line: 7411

    SELECT  'VALID'
    INTO     l_dummy
    FROM     fnd_user
    WHERE    user_name = p_last_updated_by_name;

Line: 7426

            FND_MESSAGE.SET_TOKEN('ATTRIBUTE','last_updated_by_name');

Line: 7439

            ,   'Last_Updated_By_Name'
            );

Line: 7445

END Last_Updated_By_Name;

Line: 7534

    SELECT  'VALID'
    INTO     l_dummy
    FROM     po_headers_all
    WHERE    po_header_id = p_po_header_id;

Line: 7582

    SELECT  'VALID'
    INTO     l_dummy
    FROM     po_lines_all
    WHERE    po_line_id = p_po_line_id;

Line: 7667

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mtl_units_of_measure
    WHERE    uom_code = p_primary_uom;

Line: 7764

    SELECT  'VALID'
      INTO     l_dummy
      FROM     MFG_LOOKUPS
      WHERE    lookup_type = p_lookup_type
      AND      lookup_code = p_process_phase;

Line: 7813

    SELECT  'VALID'
      INTO     l_dummy
      FROM     MFG_LOOKUPS
      WHERE    lookup_type = 'WIP_PROCESS_STATUS'
      AND      lookup_code = p_process_status;

Line: 7910

    SELECT  'VALID'
    INTO     l_dummy
    FROM     dual
    WHERE exists (select 'EXISTS'
                  from rcv_transactions_interface rti
                  where rti.interface_transaction_id = p_rcv_transaction_id)
      OR  exists (select 'EXISTS'
                  from rcv_transactions rt
                  where rt.transaction_id = p_rcv_transaction_id);

Line: 8123

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_resources
    WHERE    resource_code = p_resource_code
    AND      organization_id = p_organization_id;

Line: 8172

   SELECT  'VALID'
     INTO     l_dummy
     FROM     bom_resources
     WHERE    resource_id = p_resource_id;

Line: 8268

    SELECT  'VALID'
      INTO     l_dummy
      FROM     MFG_LOOKUPS
      WHERE    lookup_type = 'BOM_RESOURCE_TYPE'
      AND      lookup_code = p_resource_type;

Line: 8317

    SELECT  'VALID'
      INTO     l_dummy
      FROM     MFG_LOOKUPS
      WHERE    lookup_type = 'SYS_YES_NO'
      AND      lookup_code = p_standard_rate_flag;

Line: 8512

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_departments
    WHERE    department_code = p_fm_department_code
    AND      organization_id = p_organization_id;

Line: 8562

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_departments
    WHERE    department_id = p_fm_department_id;

Line: 8612

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mfg_lookups ml
    WHERE    ml.lookup_code = p_intraop_step_type
    AND      ml.lookup_type = 'WIP_INTRAOPERATION_STEP';

Line: 8663

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_standard_operations
    WHERE    operation_code = p_operation_code;

Line: 8906

    SELECT  'VALID'
    INTO     l_dummy
    FROM     gl_code_combinations
    WHERE    code_combination_id = p_scrap_account_id;

Line: 8956

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_departments
    WHERE    department_code = p_to_department_code
    AND      organization_id = p_organization_id;

Line: 9007

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_departments
    WHERE    department_id = p_to_department_id;

Line: 9057

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mfg_lookups ml
    WHERE    ml.lookup_code = p_to_intraop_step_type
    AND      ml.lookup_type = 'WIP_INTRAOPERATION_STEP';

Line: 9107

    SELECT  'VALID'
    INTO     l_dummy
    FROM     bom_standard_operations
    WHERE    operation_code = p_to_operation_code;

Line: 9252

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mfg_lookups ml
    WHERE    ml.lookup_code = p_transaction_type_id
    AND      ml.lookup_type = p_lookup_type;

Line: 9301

    SELECT  'VALID'
    INTO     l_dummy
    FROM     mtl_units_of_measure
    WHERE    uom_code = p_transaction_uom;