APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APP_RESULTS

Line 7363: CURSOR old_starpqr_cur(p_appno igs_uc_app_results.app_no%TYPE,

7359:
7360:
7361:
7362: -- check for corresponding record in main table.
7363: CURSOR old_starpqr_cur(p_appno igs_uc_app_results.app_no%TYPE,
7364: p_sub_id igs_uc_app_results.subject_id%TYPE) IS
7365: SELECT uapr.rowid,
7366: uapr.*
7367: FROM igs_uc_app_results uapr

Line 7364: p_sub_id igs_uc_app_results.subject_id%TYPE) IS

7360:
7361:
7362: -- check for corresponding record in main table.
7363: CURSOR old_starpqr_cur(p_appno igs_uc_app_results.app_no%TYPE,
7364: p_sub_id igs_uc_app_results.subject_id%TYPE) IS
7365: SELECT uapr.rowid,
7366: uapr.*
7367: FROM igs_uc_app_results uapr
7368: WHERE uapr.app_no = p_appno

Line 7367: FROM igs_uc_app_results uapr

7363: CURSOR old_starpqr_cur(p_appno igs_uc_app_results.app_no%TYPE,
7364: p_sub_id igs_uc_app_results.subject_id%TYPE) IS
7365: SELECT uapr.rowid,
7366: uapr.*
7367: FROM igs_uc_app_results uapr
7368: WHERE uapr.app_no = p_appno
7369: AND uapr.subject_id = p_sub_id;
7370:
7371:

Line 7386: CURSOR get_appno_cur(cp_appno igs_uc_app_results.app_no%TYPE) IS

7382: FROM igs_uc_istrpqr_ints
7383: WHERE record_status = 'N';
7384:
7385: -- get all the records for an applicant
7386: CURSOR get_appno_cur(cp_appno igs_uc_app_results.app_no%TYPE) IS
7387: SELECT rowid
7388: FROM igs_uc_app_results
7389: WHERE app_no = cp_appno;
7390:

Line 7388: FROM igs_uc_app_results

7384:
7385: -- get all the records for an applicant
7386: CURSOR get_appno_cur(cp_appno igs_uc_app_results.app_no%TYPE) IS
7387: SELECT rowid
7388: FROM igs_uc_app_results
7389: WHERE app_no = cp_appno;
7390:
7391: CURSOR validate_subject (p_subject igs_uc_app_results.subject_id%TYPE) IS
7392: SELECT rowid

Line 7391: CURSOR validate_subject (p_subject igs_uc_app_results.subject_id%TYPE) IS

7387: SELECT rowid
7388: FROM igs_uc_app_results
7389: WHERE app_no = cp_appno;
7390:
7391: CURSOR validate_subject (p_subject igs_uc_app_results.subject_id%TYPE) IS
7392: SELECT rowid
7393: ,subject_id
7394: ,year
7395: ,sitting

Line 7472: igs_uc_app_results_pkg.delete_row(get_appno_rec.rowid);

7468:
7469: -- Delete all the qualification records for the applicant before inserting.
7470: FOR get_appno_rec IN get_appno_cur(new_appl_rec.appno)
7471: LOOP
7472: igs_uc_app_results_pkg.delete_row(get_appno_rec.rowid);
7473: END LOOP;
7474:
7475: -- Get all the reocords from interface table with status = 'N'
7476: FOR new_ivstarpqr_rec IN new_ivstarpqr_cur(new_appl_rec.appno)

Line 7737: igs_uc_app_results_pkg.insert_row (

7733: IF old_starpqr_rec.rowid IS NULL THEN -- i.e. new record.
7734:
7735: BEGIN
7736: -- call the TBH to update the record
7737: igs_uc_app_results_pkg.insert_row (
7738: x_rowid => old_starpqr_rec.rowid
7739: ,x_app_result_id => old_starpqr_rec.app_result_id -- since it would also be NULL when record does not exist.
7740: ,x_app_id => appl_det_rec.app_id
7741: ,x_app_no => new_ivstarpqr_rec.appno

Line 7769: igs_uc_app_results_pkg.update_row (

7765:
7766: BEGIN
7767:
7768: -- call the TBH to update the record
7769: igs_uc_app_results_pkg.update_row (
7770: x_rowid => old_starpqr_rec.rowid
7771: ,x_app_result_id => old_starpqr_rec.app_result_id
7772: ,x_app_id => old_starpqr_rec.app_id
7773: ,x_app_no => old_starpqr_rec.app_no

Line 7859: igs_uc_app_results_pkg.delete_row(get_appno_rec.rowid);

7855: IF l_appno_failed THEN
7856: -- Delete all the qualification records for the applicant before inserting.
7857: FOR get_appno_rec IN get_appno_cur(new_appl_rec.appno)
7858: LOOP
7859: igs_uc_app_results_pkg.delete_row(get_appno_rec.rowid);
7860: END LOOP;
7861:
7862: -- update INTS records for this appno which are successful to set error_code=2001
7863: UPDATE igs_uc_istrpqr_ints SET error_code = '2001'