390: SELECT bim_r_resp_int_header_s.NEXTVAL
391: FROM dual;
392:
393: CURSOR c_grade_id IS
394: SELECT bim_r_resp_int_grades_s.NEXTVAL
395: FROM dual;
396:
397: CURSOR c_reason_id IS
398: SELECT bim_r_resp_int_reason_s.NEXTVAL
632: END IF;
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END IF;
635:
636: --dbms_output.put_line('before inserting into bim_r_resp_int_grades '||l_local_resp_grade_count_table(i) );
637: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface header id '||l_interface_header_id );
638: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface greade id '||l_interface_grade_id );
639: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades response_grade'||l_local_resp_grade_table(i) );
640:
633: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
634: END IF;
635:
636: --dbms_output.put_line('before inserting into bim_r_resp_int_grades '||l_local_resp_grade_count_table(i) );
637: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface header id '||l_interface_header_id );
638: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface greade id '||l_interface_grade_id );
639: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades response_grade'||l_local_resp_grade_table(i) );
640:
641: INSERT INTO bim_r_resp_int_grades
634: END IF;
635:
636: --dbms_output.put_line('before inserting into bim_r_resp_int_grades '||l_local_resp_grade_count_table(i) );
637: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface header id '||l_interface_header_id );
638: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface greade id '||l_interface_grade_id );
639: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades response_grade'||l_local_resp_grade_table(i) );
640:
641: INSERT INTO bim_r_resp_int_grades
642: (
635:
636: --dbms_output.put_line('before inserting into bim_r_resp_int_grades '||l_local_resp_grade_count_table(i) );
637: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface header id '||l_interface_header_id );
638: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface greade id '||l_interface_grade_id );
639: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades response_grade'||l_local_resp_grade_table(i) );
640:
641: INSERT INTO bim_r_resp_int_grades
642: (
643: creation_date,
637: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface header id '||l_interface_header_id );
638: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface greade id '||l_interface_grade_id );
639: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades response_grade'||l_local_resp_grade_table(i) );
640:
641: INSERT INTO bim_r_resp_int_grades
642: (
643: creation_date,
644: last_update_date,
645: created_by,
666:
667: );
668:
669: END LOOP;
670: --dbms_output.put_line('after inserting into bim_r_resp_int_grades');
671: END IF;
672:
673: IF (l_response_invalid_table.COUNT > 0) THEN
674: FOR j IN 1..l_response_invalid_table.COUNT LOOP