APPS.HZ_IMP_LOAD_STAGE1 SQL Statements

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

Line: 50

        select hwm_stage into l_hwm_stage
        from hz_imp_work_units
        where batch_id = P_BATCH_ID
        and orig_system = P_OS
        and from_orig_system_ref = P_FROM_OSR;

Line: 75

    /* Update status to Complete for the work unit that just finished */
    UPDATE HZ_IMP_WORK_UNITS
      SET STATUS = 'C'
    WHERE BATCH_ID = P_BATCH_ID
      AND FROM_ORIG_SYSTEM_REF = P_FROM_OSR;

Line: 98

    UPDATE hz_imp_batch_summary
    SET import_status = 'ERROR'
    WHERE batch_id = P_BATCH_ID;

Line: 102

    UPDATE hz_imp_batch_details
    SET import_status = 'ERROR'
    WHERE batch_id = P_BATCH_ID
    AND run_number = (SELECT max(run_number)
    		      FROM hz_imp_batch_details
    		      WHERE batch_id = P_BATCH_ID);