APPS.IGW_EDI_PROCESSING SQL Statements

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

Line: 15

    SELECT ece_output_runs_s.nextval
    FROM   dual;

Line: 19

    select substr(abstract,1,200)
    from   igw_prop_abstracts
    where  proposal_id = p_proposal_id
    and    abstract_type_code = 'C.1'
    and    abstract_type = 'IGW_ABSTRACT_TYPES';

Line: 42

    update igw_proposals_all
    set narrative_type_code = p_narrative_type_code,
        narrative_submission_code = p_narrative_submission_code
    where proposal_id = p_proposal_id;

Line: 49

     select proposal_form_number
     into   l_proposal_form_number
     from   igw_budgets
     where  proposal_id = p_proposal_id
     and    final_version_flag = 'Y';

Line: 158

  PROCEDURE update_edi_date  ( x_proposal_id IN  NUMBER) is
  Begin
    update igw_proposals set edi_generated_date = SYSDATE
    where  proposal_id = x_proposal_id;

Line: 162

  End update_edi_date;