APPS.EAM_ASSET_NUM_IMPORT_PVT SQL Statements

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

Line: 128

      UPDATE  mtl_eam_asset_num_interface meani
      SET     meani.error_code = 9999,
              meani.process_flag = 'E',
              meani.error_message = 'Failed to submit worker '||p_group_id
      WHERE   meani.process_flag = 'P'
      AND     meani.batch_id = p_batch_id
      AND     meani.interface_group_id = p_group_id;

Line: 188

        SELECT  meani.current_organization_id,
                meani.inventory_item_id,
                meani.serial_number,
                count(*) as total
        FROM    MTL_EAM_ASSET_NUM_INTERFACE meani
        WHERE   meani.batch_id = p_batch_id
        AND     meani.interface_group_id IS NULL
        AND     meani.process_flag = 'P'
        AND     meani.error_code IS NULL
        AND     meani.error_message IS NULL
        GROUP BY
                meani.current_organization_id,
                meani.inventory_item_id,
                meani.serial_number;

Line: 205

       SELECT  meani.interface_header_id
       FROM    MTL_EAM_ASSET_NUM_INTERFACE meani
       WHERE   meani.batch_id = p_batch_id
       AND     meani.import_scope NOT IN (0,1,2)
       AND     meani.process_flag = 'P'
       FOR UPDATE;

Line: 216

       SELECT  meani.interface_header_id
       FROM    MTL_EAM_ASSET_NUM_INTERFACE meani
       WHERE   meani.batch_id = p_batch_id
       AND     meani.import_mode NOT IN (0,1)
       AND     meani.process_flag = 'P'
       FOR UPDATE;

Line: 226

       SELECT  meani.interface_header_id
       FROM    MTL_EAM_ASSET_NUM_INTERFACE meani
       WHERE   batch_id = p_batch_id
       AND     (current_organization_id is null
                OR  organization_code is null)
       AND     process_flag = 'P'
       FOR UPDATE;

Line: 265

    UPDATE    mtl_eam_asset_num_interface meani
    SET       meani.process_flag = 'E',
              meani.error_code = 9999,
              meani.error_message = 'Incorrect Scope Value'
    WHERE     meani.batch_id = p_batch_id
    AND       meani.import_scope NOT IN (0,1,2)
    AND       meani.process_flag = 'P';

Line: 280

          UPDATE    mtl_eam_asset_num_interface meani
          SET       meani.process_flag = 'E',
                    meani.error_code = 9999,
                    meani.error_message = 'Incorrect Scope Value'
          WHERE     CURRENT OF invalid_scope_asset_cur;

Line: 288

          UPDATE      MTL_EAM_ATTR_VAL_INTERFACE      meavi
          SET         meavi.error_number = 9999,
                      meavi.process_status = 'E',
                      meavi.error_message = 'Corresponding row in MTL_EAM_ASSET_NUM_INTERFACE has invalid Scope value'
          WHERE       meavi.process_status = 'P'
          AND         meavi.interface_header_id = invalid_scope_asset_rec.interface_header_id;

Line: 311

    UPDATE    mtl_eam_asset_num_interface meani
    SET       meani.process_flag = 'E',
              meani.error_code = 9999,
              meani.error_message = 'Incorrect Mode Value'
    WHERE     meani.batch_id = p_batch_id
    AND       meani.import_mode NOT IN (0,1)
    AND       meani.process_flag = 'P';

Line: 327

          UPDATE    mtl_eam_asset_num_interface meani
          SET       meani.process_flag = 'E',
                    meani.error_code = 9999,
                    meani.error_message = 'Incorrect Mode Value'
          WHERE     CURRENT OF invalid_mode_asset_cur;

Line: 334

          UPDATE    MTL_EAM_ATTR_VAL_INTERFACE      meavi
          SET       meavi.error_number = 9999,
                    meavi.process_status = 'E',
                    meavi.error_message = 'Corresponding row in MTL_EAM_ASSET_NUM_INTERFACE has invalid Mode value'
          WHERE     meavi.process_status = 'P'
          AND       meavi.interface_header_id = invalid_mode_asset_rec.interface_header_id;

Line: 353

    UPDATE    mtl_eam_asset_num_interface meani
    SET       organization_code= (select organization_code from mtl_parameters
               where organization_id = meani.current_organization_id
               and maint_organization_id is NOT NULL)
    WHERE     batch_id = p_batch_id
    AND       current_organization_id is not null
    AND       process_flag = 'P';

Line: 361

    UPDATE    mtl_eam_asset_num_interface meani
    SET       current_organization_id= (select organization_id from mtl_parameters
               where organization_code = meani.organization_code
               and maint_organization_id is NOT NULL)
    WHERE     batch_id = p_batch_id
    AND       current_organization_id is null
    AND       organization_code is not null
    AND       process_flag = 'P';

Line: 373

    UPDATE    mtl_eam_asset_num_interface
    SET       process_flag = 'E' ,
              error_code = 9999,
              error_message = 'Invalid Organization. Check that it is NOT NULL, EXISTS and is EAM ENABLED'
    WHERE     batch_id = p_batch_id
    AND       (current_organization_id is null
               OR  organization_code is null)
    AND       process_flag = 'P';

Line: 391

          UPDATE    mtl_eam_asset_num_interface
          SET       process_flag = 'E' ,
                    error_code = 9999,
                    error_message = 'Invalid Organization. Check that it is NOT NULL, EXISTS and is EAM ENABLED'
          WHERE     CURRENT OF null_org_asset_cur;

Line: 398

          UPDATE      MTL_EAM_ATTR_VAL_INTERFACE      meavi
          SET         meavi.error_number = 9999,
                      meavi.process_status = 'E',
                      meavi.error_message = 'Corresponding row in MTL_EAM_ASSET_NUM_INTERFACE has invalid organzation'
          WHERE       meavi.process_status = 'P'
          AND         meavi.interface_header_id = null_org_asset_rec.interface_header_id;

Line: 421

        SELECT MTL_EAM_ASSET_NUM_INTERFACE_S.nextval
        INTO  l_group_id
        FROM  dual;

Line: 426

      UPDATE  mtl_eam_asset_num_interface meani
      SET     meani.interface_group_id = l_group_id,
              meani.process_flag = 'R'
      WHERE   meani.process_flag = 'P'
      AND     meani.current_organization_id = asset.current_organization_id
      AND     meani.inventory_item_id = asset.inventory_item_id
      AND     meani.serial_number = asset.serial_number
      AND     meani.batch_id = p_batch_id
      AND     meani.interface_group_id IS NULL;