APPS.IGIGITCH SQL Statements

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

Line: 4

   PROCEDURE Update_Header_Status(p_it_header_id IN NUMBER) IS
     l_total_recs    NUMBER;

Line: 10

     SELECT count(*)
     INTO   l_total_recs
     FROM   igi_itr_charge_lines
     WHERE  it_header_id = p_it_header_id;

Line: 17

     SELECT count(*)
     INTO   l_total_status
     FROM   igi_itr_charge_lines
     WHERE  it_header_id = p_it_header_id
     AND    status_flag IN ('L', 'A');

Line: 26

        UPDATE igi_itr_charge_headers
        SET    submit_flag = 'C'
        WHERE  it_header_id = p_it_header_id;

Line: 31

   END Update_Header_Status;