APPS.BIM_RESPONSE_IMPORT_PUB dependencies on BIM_R_RESP_INT_REASON

Line 398: SELECT bim_r_resp_int_reason_s.NEXTVAL

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
399: FROM dual;
400:
401: CURSOR c_source_code_ids (c_source_code IN Varchar2) IS
402: SELECT source_code_id ,source_code_for_id ,arc_source_code_for

Line 698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);

694: END IF;
695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason

Line 699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );

695: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
696: END IF;
697:
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason
703: (

Line 700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );

696: END IF;
697:
698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason
703: (
704: creation_date,

Line 702: INSERT INTO bim_r_resp_int_reason

698: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason '||l_interface_reason_id);
699: --dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid reason'||l_local_resp_invalid_table(j) );
700: -- dbms_output.put_line('before inserting into bim_r_resp_int_reason invalid responses'||l_local_resp_inv_count_table(j) );
701:
702: INSERT INTO bim_r_resp_int_reason
703: (
704: creation_date,
705: last_update_date,
706: created_by,

Line 731: --dbms_output.put_line('end inserting into bim_r_resp_int_reason');

727: );
728:
729: END LOOP;
730:
731: --dbms_output.put_line('end inserting into bim_r_resp_int_reason');
732: END IF;
733:
734: -- Check for commit
735: IF FND_API.to_boolean(p_commit) THEN