DBA Data[Home] [Help]

APPS.BIM_RESPONSE_IMPORT_PUB dependencies on BIM_R_RESP_INT_GRADES

Line 394: SELECT bim_r_resp_int_grades_s.NEXTVAL

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

Line 636: --dbms_output.put_line('before inserting into bim_r_resp_int_grades '||l_local_resp_grade_count_table(i) );

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:

Line 637: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface header id '||l_interface_header_id );

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

Line 638: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades interface greade id '||l_interface_grade_id );

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: (

Line 639: -- dbms_output.put_line('before inserting into bim_r_resp_int_grades response_grade'||l_local_resp_grade_table(i) );

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,

Line 641: INSERT INTO bim_r_resp_int_grades

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,

Line 670: --dbms_output.put_line('after inserting into bim_r_resp_int_grades');

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