APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_UC_OLD_OUSTAT

Line 760: smaddali checking if record exists before inserting into igs_uc_old_oustat if so then update ,

756: Known limitations,enhancements,remarks:
757: Change History
758: Who When What
759: smaddali initialising l_rowid to null for bug 2626178
760: smaddali checking if record exists before inserting into igs_uc_old_oustat if so then update ,
761: else insert. Also added code to get unit set cd for point of entry and use it in finding
762: matching admissions application, for bug 2630219
763: ayedubat 24-MAR-2003 Added the Logic to identify the Applications Choices modified by UCAS which already went UF
764: and institution asking for change in Course, Entry Month, Entry Year or Point of Entry for

Line 1009: CURSOR c_old_oustat ( cp_app_no igs_uc_old_oustat.app_no%TYPE,

1005: c_dec_int_rec c_dec_int%ROWTYPE;
1006:
1007: --smaddali added this cursor for bug 2630219
1008: -- Check if old outcome status record exists for the passed application choice
1009: CURSOR c_old_oustat ( cp_app_no igs_uc_old_oustat.app_no%TYPE,
1010: cp_choice_no igs_uc_old_oustat.choice_no%TYPE ) IS
1011: SELECT ou.ROWID , ou.*
1012: FROM igs_uc_old_oustat ou
1013: WHERE app_no = cp_app_no AND

Line 1010: cp_choice_no igs_uc_old_oustat.choice_no%TYPE ) IS

1006:
1007: --smaddali added this cursor for bug 2630219
1008: -- Check if old outcome status record exists for the passed application choice
1009: CURSOR c_old_oustat ( cp_app_no igs_uc_old_oustat.app_no%TYPE,
1010: cp_choice_no igs_uc_old_oustat.choice_no%TYPE ) IS
1011: SELECT ou.ROWID , ou.*
1012: FROM igs_uc_old_oustat ou
1013: WHERE app_no = cp_app_no AND
1014: choice_no = cp_choice_no ;

Line 1012: FROM igs_uc_old_oustat ou

1008: -- Check if old outcome status record exists for the passed application choice
1009: CURSOR c_old_oustat ( cp_app_no igs_uc_old_oustat.app_no%TYPE,
1010: cp_choice_no igs_uc_old_oustat.choice_no%TYPE ) IS
1011: SELECT ou.ROWID , ou.*
1012: FROM igs_uc_old_oustat ou
1013: WHERE app_no = cp_app_no AND
1014: choice_no = cp_choice_no ;
1015: c_old_oustat_rec c_old_oustat%ROWTYPE ;
1016:

Line 1511: igs_uc_old_oustat_pkg.insert_row (

1507: OPEN c_old_oustat(c_new_app_ch_rec.app_no , c_new_app_ch_rec.choice_no ) ;
1508: FETCH c_old_oustat INTO c_old_oustat_rec ;
1509: IF c_old_oustat%NOTFOUND THEN
1510: l_rowid := NULL ;
1511: igs_uc_old_oustat_pkg.insert_row (
1512: X_ROWID => l_rowid
1513: ,X_APP_NO => c_new_app_ch_rec.app_no
1514: ,X_CHOICE_NO => c_new_app_ch_rec.choice_no
1515: ,X_OLD_OUTCOME_STATUS => c_cancel_appl_rec.adm_outcome_status

Line 1522: igs_uc_old_oustat_pkg.update_row (

1518: ,X_DECISION_MAKE_ID => c_cancel_appl_rec.decision_make_id
1519: ,X_MODE => 'R'
1520: ) ;
1521: ELSE
1522: igs_uc_old_oustat_pkg.update_row (
1523: X_ROWID => c_old_oustat_rec.ROWID
1524: ,X_APP_NO => c_old_oustat_rec.app_no
1525: ,X_CHOICE_NO => c_old_oustat_rec.choice_no
1526: ,X_OLD_OUTCOME_STATUS => c_cancel_appl_rec.adm_outcome_status

Line 1853: igs_uc_old_oustat_pkg.insert_row (

1849: FETCH c_old_oustat INTO c_old_oustat_rec ;
1850: IF c_old_oustat%NOTFOUND THEN
1851: --smaddali initialising l_rowid to null for bug 2626178
1852: l_rowid := NULL ;
1853: igs_uc_old_oustat_pkg.insert_row (
1854: X_ROWID => l_rowid
1855: ,X_APP_NO => c_new_app_ch_rec.app_no
1856: ,X_CHOICE_NO => c_new_app_ch_rec.choice_no
1857: ,X_OLD_OUTCOME_STATUS => c_obsol_appl_rec.adm_outcome_status

Line 1864: igs_uc_old_oustat_pkg.update_row (

1860: ,X_DECISION_MAKE_ID => c_obsol_appl_rec.decision_make_id
1861: ,X_MODE => 'R'
1862: ) ;
1863: ELSE
1864: igs_uc_old_oustat_pkg.update_row (
1865: X_ROWID => c_old_oustat_rec.ROWID
1866: ,X_APP_NO => c_old_oustat_rec.app_no
1867: ,X_CHOICE_NO => c_old_oustat_rec.choice_no
1868: ,X_OLD_OUTCOME_STATUS => c_obsol_appl_rec.adm_outcome_status