APPS.BIM_RESPONSE_IMPORT_PUB SQL Statements

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

Line: 68

       SELECT lookup_code
       FROM   AMS_LOOKUPS
       WHERE  lookup_type = l_grade_lookup;

Line: 73

       SELECT lookup_code
       FROM   AMS_LOOKUPS
       WHERE  lookup_type = l_reason_lookup;

Line: 78

       SELECT lookup_code
       FROM   AMS_LOOKUPS
       WHERE  lookup_type = l_grade_lookup
       AND    lookup_code = l_cur_lookup_code;

Line: 84

       SELECT lookup_code
       FROM   AMS_LOOKUPS
       WHERE  lookup_type = l_reason_lookup
       AND    lookup_code = l_cur_res_code;

Line: 90

       SELECT source_code
       FROM   AMS_SOURCE_CODES
       WHERE  source_code = l_cur_source_code ;

Line: 95

       SELECT country_code
       FROM   JTF_LOC_HIERARCHIES_B
      WHERE  country_code = l_cur_country_code ;

Line: 100

        SELECT interface_header_id
        FROM   BIM_R_RESP_INT_HEADER
        WHERE  source_code = l_source_code
        AND    country = l_response_country
        AND    response_create_date = l_response_creation_date
        AND    response_source = l_response_source;

Line: 390

      SELECT bim_r_resp_int_header_s.NEXTVAL
      FROM dual;

Line: 394

      SELECT bim_r_resp_int_grades_s.NEXTVAL
      FROM dual;

Line: 398

      SELECT bim_r_resp_int_reason_s.NEXTVAL
      FROM dual;

Line: 402

      SELECT source_code_id ,source_code_for_id ,arc_source_code_for
      FROM   AMS_SOURCE_CODES
      WHERE  source_code = c_source_code;

Line: 407

      SELECT area2_code
      FROM   JTF_LOC_HIERARCHIES_B
      WHERE  country_code = c_country_code;

Line: 567

  INSERT INTO BIM_R_RESP_INT_HEADER
  (
     creation_date,
     last_update_date,
     created_by,
     last_updated_by,
     last_update_login,
     interface_header_id,
     object_id,
     object_type,
     country,
     region,
     source_code,
     source_code_id,
     response_create_date,
     landing_pad_hits,
     survey_completed,
     process_flag,
     response_source

) VALUES

(
    SYSDATE,
    SYSDATE,
    G_USER_ID,
    G_USER_ID,
    G_LOGIN_ID,
    l_interface_header_id,
    l_object_id,
    l_obj_type,
    l_response_country,
    l_region_code,
    l_source_code,
    l_source_code_id,
    l_response_creation_date,
    l_landing_pad_hits,
    l_survey_completed,
    l_process_flag,
    l_response_source

);

Line: 641

INSERT INTO bim_r_resp_int_grades
  (
     creation_date,
     last_update_date,
     created_by,
     last_updated_by,
     last_update_login,
     interface_grade_id,
     interface_header_id,
     response_grade,
     response_grade_count


) VALUES

(
    SYSDATE,
    SYSDATE,
    G_USER_ID,
    G_USER_ID,
    G_LOGIN_ID,
    l_interface_grade_id,
    l_interface_header_id,
    l_response_grade_table (i).response_grade,
    l_response_grade_table (i).response_grade_count

);

Line: 702

 INSERT INTO bim_r_resp_int_reason
  (
     creation_date,
     last_update_date,
     created_by,
     last_updated_by,
     last_update_login,
     interface_reason_id,
     interface_header_id,
     invalid_reason,
     invalid_responses

) VALUES

(
    SYSDATE,
    SYSDATE,
    G_USER_ID,
    G_USER_ID,
    G_LOGIN_ID,
    l_interface_reason_id,
    l_interface_header_id,
    l_response_invalid_table(j).invalid_reason ,
    l_response_invalid_table(j).invalid_responses

);