eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_UC_LOAD_HERCULES_DATA dependencies on IGS_UC_ISTRPQR_INTS

Line 8906: igs_uc_istrpqr_ints with record status N

8902: /******************************************************************
8903: Created By : smaddali
8904: Date Created By : 11-Jun-03
8905: Purpose : loads each record in the hercules view ivstarpqr into the interface table
8906: igs_uc_istrpqr_ints with record status N
8907: Known limitations,enhancements,remarks:
8908: Change History
8909: Who When What
8910: smaddali 4-sep-03 Modified logic to base loading on ivqualification.timestamp and

Line 8939: l_appno igs_uc_istrpqr_ints.appno%TYPE;

8935: l_count NUMBER ;
8936:
8937: l_appno_qual igs_uc_ivqualification_2003_v.appno%TYPE;
8938: l_checkdigit_qual NUMBER;
8939: l_appno igs_uc_istrpqr_ints.appno%TYPE;
8940: l_checkdigit NUMBER;
8941:
8942: BEGIN
8943: -- set syncronization required to false

Line 8966: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL

8962: get_appno(c_ivqual_rec.appno, NULL, l_appno_qual, l_checkdigit_qual);
8963:
8964: -- smaddali added code to obsolete existing records in starpqr interface table with status N for this applicant, for bug#3122898
8965: -- Obsolete all records in interface table for this applicant with status N
8966: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL
8967: WHERE record_status = 'N' AND appno = l_appno_qual ;
8968:
8969: -- set all records in interface table for this applicant with status L to processed status
8970: UPDATE igs_uc_istrpqr_ints SET record_status = 'D' , error_code = NULL

Line 8970: UPDATE igs_uc_istrpqr_ints SET record_status = 'D' , error_code = NULL

8966: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL
8967: WHERE record_status = 'N' AND appno = l_appno_qual ;
8968:
8969: -- set all records in interface table for this applicant with status L to processed status
8970: UPDATE igs_uc_istrpqr_ints SET record_status = 'D' , error_code = NULL
8971: WHERE record_status = 'L' AND appno = l_appno_qual ;
8972:
8973: -- create interface records for each record in the hercules view whose timestamp > old timestamp
8974: FOR c_ivstarpqr_rec IN c_ivstarpqr(c_ivqual_rec.appno) LOOP

Line 8984: INSERT INTO igs_uc_istrpqr_ints ( appno,

8980: -- Determine actual appno
8981: get_appno(c_ivstarpqr_rec.appno, NULL, l_appno, l_checkdigit);
8982:
8983: -- copy hercules record into interface table with record status N
8984: INSERT INTO igs_uc_istrpqr_ints ( appno,
8985: subjectid,
8986: eblresult,
8987: eblamended,
8988: claimedresult,

Line 9058: igs_uc_istrpqr_ints with record status N

9054: Date Created By : 25-MAY-2006
9055: Purpose : Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
9056: Loads each record in the hercules view
9057: ivstarpqr into the interface table
9058: igs_uc_istrpqr_ints with record status N
9059:
9060: Known limitations,enhancements,remarks:
9061: Change History
9062: Who When What

Line 9089: l_appno igs_uc_istrpqr_ints.appno%TYPE;

9085: l_count NUMBER ;
9086:
9087: l_appno_qual igs_uc_ivqualification_2003_v.appno%TYPE;
9088: l_checkdigit_qual NUMBER;
9089: l_appno igs_uc_istrpqr_ints.appno%TYPE;
9090: l_checkdigit NUMBER;
9091:
9092: BEGIN
9093: -- set syncronization required to false

Line 9116: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL

9112: get_appno(c_ivqual_rec.appno, NULL, l_appno_qual, l_checkdigit_qual);
9113:
9114: -- smaddali added code to obsolete existing records in starpqr interface table with status N for this applicant, for bug#3122898
9115: -- Obsolete all records in interface table for this applicant with status N
9116: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL
9117: WHERE record_status = 'N' AND appno = l_appno_qual ;
9118:
9119: -- set all records in interface table for this applicant with status L to processed status
9120: UPDATE igs_uc_istrpqr_ints SET record_status = 'D' , error_code = NULL

Line 9120: UPDATE igs_uc_istrpqr_ints SET record_status = 'D' , error_code = NULL

9116: UPDATE igs_uc_istrpqr_ints SET record_status = 'O' , error_code = NULL
9117: WHERE record_status = 'N' AND appno = l_appno_qual ;
9118:
9119: -- set all records in interface table for this applicant with status L to processed status
9120: UPDATE igs_uc_istrpqr_ints SET record_status = 'D' , error_code = NULL
9121: WHERE record_status = 'L' AND appno = l_appno_qual ;
9122:
9123: -- create interface records for each record in the hercules view whose timestamp > old timestamp
9124: FOR c_ivstarpqr_rec IN c_ivstarpqr(c_ivqual_rec.appno) LOOP

Line 9134: INSERT INTO igs_uc_istrpqr_ints ( appno,

9130: -- Determine actual appno
9131: get_appno(c_ivstarpqr_rec.appno, NULL, l_appno, l_checkdigit);
9132:
9133: -- copy hercules record into interface table with record status N
9134: INSERT INTO igs_uc_istrpqr_ints ( appno,
9135: subjectid,
9136: eblresult,
9137: eblamended,
9138: claimedresult,