APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on IGS_UC_APP_RESULTS_PKG

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'