APPS.IGS_AD_ASSIGN_REVIEW_GRP dependencies on DBMS_SQL

Line 393: l_cursor_id := dbms_sql.open_cursor;

389:
390: END IF; -- End of checking presence of exclude records
391:
392: l_cur_statement := fnd_dsql.get_text(FALSE);
393: l_cursor_id := dbms_sql.open_cursor;
394: fnd_dsql.set_cursor(l_cursor_id);
395:
396: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
397: fnd_dsql.do_binds;

Line 396: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);

392: l_cur_statement := fnd_dsql.get_text(FALSE);
393: l_cursor_id := dbms_sql.open_cursor;
394: fnd_dsql.set_cursor(l_cursor_id);
395:
396: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
397: fnd_dsql.do_binds;
398:
399: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
400: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

Line 399: dbms_sql.define_column(l_cursor_id, 1, l_person_id);

395:
396: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
397: fnd_dsql.do_binds;
398:
399: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
400: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
401: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
402: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
403:

Line 400: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

396: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
397: fnd_dsql.do_binds;
398:
399: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
400: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
401: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
402: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
403:
404:

Line 401: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);

397: fnd_dsql.do_binds;
398:
399: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
400: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
401: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
402: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
403:
404:
405: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

Line 402: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);

398:
399: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
400: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
401: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
402: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
403:
404:
405: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
406:

Line 405: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

401: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
402: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
403:
404:
405: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
406:
407: LOOP
408: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
409: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

Line 408: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;

404:
405: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
406:
407: LOOP
408: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
409: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
410: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
411: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
412: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

Line 409: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

405: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
406:
407: LOOP
408: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
409: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
410: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
411: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
412: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
413:

Line 410: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);

406:
407: LOOP
408: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
409: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
410: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
411: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
412: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
413:
414: OPEN c_arp_rec_found(l_person_id, l_admission_appl_number, l_nominated_course_cd, l_sequence_number);

Line 411: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);

407: LOOP
408: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
409: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
410: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
411: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
412: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
413:
414: OPEN c_arp_rec_found(l_person_id, l_admission_appl_number, l_nominated_course_cd, l_sequence_number);
415: FETCH c_arp_rec_found INTO c_arp_rec_found_rec;

Line 412: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

408: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
409: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
410: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
411: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
412: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
413:
414: OPEN c_arp_rec_found(l_person_id, l_admission_appl_number, l_nominated_course_cd, l_sequence_number);
415: FETCH c_arp_rec_found INTO c_arp_rec_found_rec;
416: IF c_arp_rec_found%NOTFOUND THEN

Line 461: dbms_sql.close_cursor(l_cursor_id);

457: CLOSE c_arp_rec_found;
458:
459:
460: END LOOP;
461: dbms_sql.close_cursor(l_cursor_id);
462:
463: -- No include or exclude Records for this Group Code
464: ELSE
465: CLOSE c_revgr_incl_excl;

Line 751: l_cursor_id := dbms_sql.open_cursor;

747: l_cur_statement := fnd_dsql.get_text(FALSE);
748: l_debug := fnd_dsql.get_text(TRUE);
749:
750:
751: l_cursor_id := dbms_sql.open_cursor;
752: fnd_dsql.set_cursor(l_cursor_id);
753:
754: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
755: fnd_dsql.do_binds;

Line 754: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);

750:
751: l_cursor_id := dbms_sql.open_cursor;
752: fnd_dsql.set_cursor(l_cursor_id);
753:
754: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
755: fnd_dsql.do_binds;
756:
757: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

Line 757: dbms_sql.define_column(l_cursor_id, 1, l_person_id);

753:
754: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
755: fnd_dsql.do_binds;
756:
757: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);

Line 758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

754: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
755: fnd_dsql.do_binds;
756:
757: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);
762: dbms_sql.define_column(l_cursor_id, 6, l_state, 60);

Line 759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);

755: fnd_dsql.do_binds;
756:
757: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);
762: dbms_sql.define_column(l_cursor_id, 6, l_state, 60);
763: dbms_sql.define_column(l_cursor_id, 7, l_postal_code, 60);

Line 760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);

756:
757: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);
762: dbms_sql.define_column(l_cursor_id, 6, l_state, 60);
763: dbms_sql.define_column(l_cursor_id, 7, l_postal_code, 60);
764:

Line 761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);

757: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);
762: dbms_sql.define_column(l_cursor_id, 6, l_state, 60);
763: dbms_sql.define_column(l_cursor_id, 7, l_postal_code, 60);
764:
765:

Line 762: dbms_sql.define_column(l_cursor_id, 6, l_state, 60);

758: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);
762: dbms_sql.define_column(l_cursor_id, 6, l_state, 60);
763: dbms_sql.define_column(l_cursor_id, 7, l_postal_code, 60);
764:
765:
766:

Line 763: dbms_sql.define_column(l_cursor_id, 7, l_postal_code, 60);

759: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
760: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
761: dbms_sql.define_column(l_cursor_id, 5, l_country, 60);
762: dbms_sql.define_column(l_cursor_id, 6, l_state, 60);
763: dbms_sql.define_column(l_cursor_id, 7, l_postal_code, 60);
764:
765:
766:
767: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

Line 767: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

763: dbms_sql.define_column(l_cursor_id, 7, l_postal_code, 60);
764:
765:
766:
767: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
768:
769: /*for debugging*/
770: l_debug := fnd_dsql.get_text(TRUE);
771:

Line 774: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;

770: l_debug := fnd_dsql.get_text(TRUE);
771:
772:
773: LOOP
774: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
775: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

Line 775: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

771:
772:
773: LOOP
774: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
775: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
779: dbms_sql.column_value(l_cursor_id, 5, l_country);

Line 776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);

772:
773: LOOP
774: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
775: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
779: dbms_sql.column_value(l_cursor_id, 5, l_country);
780: dbms_sql.column_value(l_cursor_id, 6, l_state);

Line 777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);

773: LOOP
774: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
775: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
779: dbms_sql.column_value(l_cursor_id, 5, l_country);
780: dbms_sql.column_value(l_cursor_id, 6, l_state);
781: dbms_sql.column_value(l_cursor_id, 7, l_postal_code);

Line 778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

774: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
775: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
779: dbms_sql.column_value(l_cursor_id, 5, l_country);
780: dbms_sql.column_value(l_cursor_id, 6, l_state);
781: dbms_sql.column_value(l_cursor_id, 7, l_postal_code);
782:

Line 779: dbms_sql.column_value(l_cursor_id, 5, l_country);

775: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
779: dbms_sql.column_value(l_cursor_id, 5, l_country);
780: dbms_sql.column_value(l_cursor_id, 6, l_state);
781: dbms_sql.column_value(l_cursor_id, 7, l_postal_code);
782:
783:

Line 780: dbms_sql.column_value(l_cursor_id, 6, l_state);

776: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
779: dbms_sql.column_value(l_cursor_id, 5, l_country);
780: dbms_sql.column_value(l_cursor_id, 6, l_state);
781: dbms_sql.column_value(l_cursor_id, 7, l_postal_code);
782:
783:
784: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,

Line 781: dbms_sql.column_value(l_cursor_id, 7, l_postal_code);

777: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
778: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
779: dbms_sql.column_value(l_cursor_id, 5, l_country);
780: dbms_sql.column_value(l_cursor_id, 6, l_state);
781: dbms_sql.column_value(l_cursor_id, 7, l_postal_code);
782:
783:
784: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
785: l_nominated_course_cd,l_sequence_number);

Line 832: dbms_sql.close_cursor(l_cursor_id);

828:
829: END IF;
830: CLOSE c_arp_rec_found;
831: END LOOP;
832: dbms_sql.close_cursor(l_cursor_id);
833:
834: -- No include or exclude Records for this Group Code
835: ELSE
836: CLOSE c_revgr_addr;

Line 1124: l_cursor_id := dbms_sql.open_cursor;

1120:
1121:
1122: l_cur_statement := fnd_dsql.get_text(FALSE);
1123:
1124: l_cursor_id := dbms_sql.open_cursor;
1125: fnd_dsql.set_cursor(l_cursor_id);
1126:
1127: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1128: fnd_dsql.do_binds;

Line 1127: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);

1123:
1124: l_cursor_id := dbms_sql.open_cursor;
1125: fnd_dsql.set_cursor(l_cursor_id);
1126:
1127: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1128: fnd_dsql.do_binds;
1129:
1130: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

Line 1130: dbms_sql.define_column(l_cursor_id, 1, l_person_id);

1126:
1127: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1128: fnd_dsql.do_binds;
1129:
1130: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);

Line 1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

1127: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1128: fnd_dsql.do_binds;
1129:
1130: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);
1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);

Line 1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);

1128: fnd_dsql.do_binds;
1129:
1130: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);
1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);
1136: dbms_sql.define_column(l_cursor_id, 7, l_pe_postal_code, 60);

Line 1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);

1129:
1130: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);
1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);
1136: dbms_sql.define_column(l_cursor_id, 7, l_pe_postal_code, 60);
1137:

Line 1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);

1130: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);
1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);
1136: dbms_sql.define_column(l_cursor_id, 7, l_pe_postal_code, 60);
1137:
1138:

Line 1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);

1131: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);
1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);
1136: dbms_sql.define_column(l_cursor_id, 7, l_pe_postal_code, 60);
1137:
1138:
1139: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

Line 1136: dbms_sql.define_column(l_cursor_id, 7, l_pe_postal_code, 60);

1132: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1133: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1134: dbms_sql.define_column(l_cursor_id, 5, l_pe_country, 60);
1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);
1136: dbms_sql.define_column(l_cursor_id, 7, l_pe_postal_code, 60);
1137:
1138:
1139: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1140:

Line 1139: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

1135: dbms_sql.define_column(l_cursor_id, 6, l_pe_state, 60);
1136: dbms_sql.define_column(l_cursor_id, 7, l_pe_postal_code, 60);
1137:
1138:
1139: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1140:
1141: /*for debugging*/
1142: l_debug := fnd_dsql.get_text(TRUE);
1143:

Line 1146: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;

1142: l_debug := fnd_dsql.get_text(TRUE);
1143:
1144:
1145: LOOP
1146: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1147: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

Line 1147: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

1143:
1144:
1145: LOOP
1146: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1147: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);

Line 1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);

1144:
1145: LOOP
1146: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1147: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);
1152: dbms_sql.column_value(l_cursor_id, 6, l_pe_state);

Line 1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);

1145: LOOP
1146: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1147: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);
1152: dbms_sql.column_value(l_cursor_id, 6, l_pe_state);
1153: dbms_sql.column_value(l_cursor_id, 7, l_pe_postal_code);

Line 1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

1146: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1147: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);
1152: dbms_sql.column_value(l_cursor_id, 6, l_pe_state);
1153: dbms_sql.column_value(l_cursor_id, 7, l_pe_postal_code);
1154:

Line 1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);

1147: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);
1152: dbms_sql.column_value(l_cursor_id, 6, l_pe_state);
1153: dbms_sql.column_value(l_cursor_id, 7, l_pe_postal_code);
1154:
1155:

Line 1152: dbms_sql.column_value(l_cursor_id, 6, l_pe_state);

1148: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);
1152: dbms_sql.column_value(l_cursor_id, 6, l_pe_state);
1153: dbms_sql.column_value(l_cursor_id, 7, l_pe_postal_code);
1154:
1155:
1156: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,

Line 1153: dbms_sql.column_value(l_cursor_id, 7, l_pe_postal_code);

1149: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1150: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1151: dbms_sql.column_value(l_cursor_id, 5, l_pe_country);
1152: dbms_sql.column_value(l_cursor_id, 6, l_pe_state);
1153: dbms_sql.column_value(l_cursor_id, 7, l_pe_postal_code);
1154:
1155:
1156: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
1157: l_nominated_course_cd,l_sequence_number);

Line 1206: dbms_sql.close_cursor(l_cursor_id);

1202:
1203: END IF;
1204: CLOSE c_arp_rec_found;
1205: END LOOP;
1206: dbms_sql.close_cursor(l_cursor_id);
1207:
1208: -- No include or exclude Records for this Group Code
1209: ELSE
1210: CLOSE c_revgr_addr;

Line 1433: l_cursor_id := dbms_sql.open_cursor;

1429: END IF; -- End of checking presence of exclude records
1430:
1431: l_cur_statement := fnd_dsql.get_text(FALSE);
1432:
1433: l_cursor_id := dbms_sql.open_cursor;
1434: fnd_dsql.set_cursor(l_cursor_id);
1435:
1436: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1437: fnd_dsql.do_binds;

Line 1436: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);

1432:
1433: l_cursor_id := dbms_sql.open_cursor;
1434: fnd_dsql.set_cursor(l_cursor_id);
1435:
1436: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1437: fnd_dsql.do_binds;
1438:
1439: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1440: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

Line 1439: dbms_sql.define_column(l_cursor_id, 1, l_person_id);

1435:
1436: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1437: fnd_dsql.do_binds;
1438:
1439: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1440: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1441: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1442: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1443:

Line 1440: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

1436: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1437: fnd_dsql.do_binds;
1438:
1439: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1440: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1441: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1442: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1443:
1444: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

Line 1441: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);

1437: fnd_dsql.do_binds;
1438:
1439: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1440: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1441: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1442: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1443:
1444: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1445:

Line 1442: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);

1438:
1439: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1440: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1441: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1442: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1443:
1444: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1445:
1446: /*for debugging*/

Line 1444: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

1440: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1441: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1442: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1443:
1444: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1445:
1446: /*for debugging*/
1447: l_debug := fnd_dsql.get_text(TRUE);
1448:

Line 1451: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;

1447: l_debug := fnd_dsql.get_text(TRUE);
1448:
1449:
1450: LOOP
1451: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1452: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1453: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1454: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1455: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

Line 1452: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

1448:
1449:
1450: LOOP
1451: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1452: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1453: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1454: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1455: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1456:

Line 1453: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);

1449:
1450: LOOP
1451: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1452: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1453: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1454: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1455: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1456:
1457: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,

Line 1454: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);

1450: LOOP
1451: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1452: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1453: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1454: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1455: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1456:
1457: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
1458: l_nominated_course_cd,l_sequence_number);

Line 1455: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

1451: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1452: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1453: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1454: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1455: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1456:
1457: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
1458: l_nominated_course_cd,l_sequence_number);
1459: FETCH c_arp_rec_found INTO c_arp_rec_found_rec;

Line 1507: dbms_sql.close_cursor(l_cursor_id);

1503: END IF;
1504: CLOSE c_arp_rec_found;
1505:
1506: END LOOP;
1507: dbms_sql.close_cursor(l_cursor_id);
1508:
1509: -- No include or exclude Records for this Group Code
1510: ELSE
1511: CLOSE c_revgr_incl_excl;

Line 1656: l_cursor_id := dbms_sql.open_cursor;

1652:
1653:
1654: l_cur_statement := fnd_dsql.get_text(FALSE);
1655:
1656: l_cursor_id := dbms_sql.open_cursor;
1657: fnd_dsql.set_cursor(l_cursor_id);
1658:
1659: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1660: fnd_dsql.do_binds;

Line 1659: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);

1655:
1656: l_cursor_id := dbms_sql.open_cursor;
1657: fnd_dsql.set_cursor(l_cursor_id);
1658:
1659: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1660: fnd_dsql.do_binds;
1661:
1662: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1663: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

Line 1662: dbms_sql.define_column(l_cursor_id, 1, l_person_id);

1658:
1659: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1660: fnd_dsql.do_binds;
1661:
1662: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1663: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1664: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1665: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1666:

Line 1663: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

1659: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1660: fnd_dsql.do_binds;
1661:
1662: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1663: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1664: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1665: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1666:
1667: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

Line 1664: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);

1660: fnd_dsql.do_binds;
1661:
1662: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1663: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1664: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1665: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1666:
1667: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1668:

Line 1665: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);

1661:
1662: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1663: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1664: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1665: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1666:
1667: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1668:
1669: /*for debugging*/

Line 1667: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

1663: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1664: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1665: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1666:
1667: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1668:
1669: /*for debugging*/
1670: l_debug := fnd_dsql.get_text(TRUE);
1671:

Line 1674: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;

1670: l_debug := fnd_dsql.get_text(TRUE);
1671:
1672:
1673: LOOP
1674: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1675: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1676: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1677: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1678: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

Line 1675: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

1671:
1672:
1673: LOOP
1674: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1675: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1676: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1677: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1678: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1679:

Line 1676: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);

1672:
1673: LOOP
1674: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1675: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1676: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1677: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1678: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1679:
1680: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,

Line 1677: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);

1673: LOOP
1674: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1675: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1676: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1677: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1678: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1679:
1680: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
1681: l_nominated_course_cd,l_sequence_number);

Line 1678: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

1674: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1675: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1676: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1677: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1678: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1679:
1680: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
1681: l_nominated_course_cd,l_sequence_number);
1682: FETCH c_arp_rec_found INTO c_arp_rec_found_rec;

Line 1731: dbms_sql.close_cursor(l_cursor_id);

1727: END IF;
1728: CLOSE c_arp_rec_found;
1729:
1730: END LOOP;
1731: dbms_sql.close_cursor(l_cursor_id);
1732:
1733: -- No include or exclude Records for this Group Code
1734: ELSE
1735: CLOSE c_revgr_addr;

Line 1875: l_cursor_id := dbms_sql.open_cursor;

1871:
1872:
1873: l_cur_statement := fnd_dsql.get_text(FALSE);
1874:
1875: l_cursor_id := dbms_sql.open_cursor;
1876: fnd_dsql.set_cursor(l_cursor_id);
1877:
1878: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1879: fnd_dsql.do_binds;

Line 1878: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);

1874:
1875: l_cursor_id := dbms_sql.open_cursor;
1876: fnd_dsql.set_cursor(l_cursor_id);
1877:
1878: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1879: fnd_dsql.do_binds;
1880:
1881: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1882: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

Line 1881: dbms_sql.define_column(l_cursor_id, 1, l_person_id);

1877:
1878: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1879: fnd_dsql.do_binds;
1880:
1881: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1882: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1883: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1884: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1885:

Line 1882: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);

1878: dbms_sql.parse(l_cursor_id, l_cur_statement, dbms_sql.native);
1879: fnd_dsql.do_binds;
1880:
1881: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1882: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1883: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1884: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1885:
1886: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

Line 1883: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);

1879: fnd_dsql.do_binds;
1880:
1881: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1882: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1883: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1884: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1885:
1886: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1887:

Line 1884: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);

1880:
1881: dbms_sql.define_column(l_cursor_id, 1, l_person_id);
1882: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1883: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1884: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1885:
1886: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1887:
1888: /*for debugging*/

Line 1886: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);

1882: dbms_sql.define_column(l_cursor_id, 2, l_admission_appl_number);
1883: dbms_sql.define_column(l_cursor_id, 3, l_nominated_course_cd, 6);
1884: dbms_sql.define_column(l_cursor_id, 4, l_sequence_number);
1885:
1886: l_num_of_rows := dbms_sql.EXECUTE(l_cursor_id);
1887:
1888: /*for debugging*/
1889: l_debug := fnd_dsql.get_text(TRUE);
1890:

Line 1893: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;

1889: l_debug := fnd_dsql.get_text(TRUE);
1890:
1891:
1892: LOOP
1893: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1894: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1895: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1896: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1897: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

Line 1894: dbms_sql.column_value(l_cursor_id, 1, l_person_id);

1890:
1891:
1892: LOOP
1893: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1894: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1895: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1896: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1897: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1898:

Line 1895: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);

1891:
1892: LOOP
1893: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1894: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1895: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1896: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1897: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1898:
1899: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,

Line 1896: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);

1892: LOOP
1893: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1894: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1895: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1896: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1897: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1898:
1899: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
1900: l_nominated_course_cd,l_sequence_number);

Line 1897: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);

1893: EXIT WHEN dbms_sql.FETCH_ROWS(l_cursor_id) = 0;
1894: dbms_sql.column_value(l_cursor_id, 1, l_person_id);
1895: dbms_sql.column_value(l_cursor_id, 2, l_admission_appl_number);
1896: dbms_sql.column_value(l_cursor_id, 3, l_nominated_course_cd);
1897: dbms_sql.column_value(l_cursor_id, 4, l_sequence_number);
1898:
1899: OPEN c_arp_rec_found(l_person_id,l_admission_appl_number,
1900: l_nominated_course_cd,l_sequence_number);
1901: FETCH c_arp_rec_found INTO c_arp_rec_found_rec;

Line 1950: dbms_sql.close_cursor(l_cursor_id);

1946: END IF;
1947: CLOSE c_arp_rec_found;
1948:
1949: END LOOP;
1950: dbms_sql.close_cursor(l_cursor_id);
1951:
1952: -- No include or exclude Records for this Group Code
1953: ELSE
1954: CLOSE c_revgr_addr;