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_PROC_APPLICATION_DATA dependencies on IGS_UC_APP_STATS

Line 1847: -- To Update Sent_to_HESA flag in IGS_UC_APP_STATS when Domicile APR value gets updated in Applicant's table.

1843: FROM igs_uc_ref_country
1844: WHERE country_code = p_code;
1845:
1846:
1847: -- To Update Sent_to_HESA flag in IGS_UC_APP_STATS when Domicile APR value gets updated in Applicant's table.
1848: -- This is because Domicile code is stored in Applicants table and need to be exported to OSS along with other
1849: -- details held in IGS_UC_APP_STATS table through Export HESA data to OSS porcess.
1850: CURSOR Cur_app_stats (cp_appno igs_uc_app_stats.app_no%TYPE) IS
1851: SELECT stat.rowid,

Line 1849: -- details held in IGS_UC_APP_STATS table through Export HESA data to OSS porcess.

1845:
1846:
1847: -- To Update Sent_to_HESA flag in IGS_UC_APP_STATS when Domicile APR value gets updated in Applicant's table.
1848: -- This is because Domicile code is stored in Applicants table and need to be exported to OSS along with other
1849: -- details held in IGS_UC_APP_STATS table through Export HESA data to OSS porcess.
1850: CURSOR Cur_app_stats (cp_appno igs_uc_app_stats.app_no%TYPE) IS
1851: SELECT stat.rowid,
1852: stat.*
1853: FROM igs_uc_app_stats stat

Line 1850: CURSOR Cur_app_stats (cp_appno igs_uc_app_stats.app_no%TYPE) IS

1846:
1847: -- To Update Sent_to_HESA flag in IGS_UC_APP_STATS when Domicile APR value gets updated in Applicant's table.
1848: -- This is because Domicile code is stored in Applicants table and need to be exported to OSS along with other
1849: -- details held in IGS_UC_APP_STATS table through Export HESA data to OSS porcess.
1850: CURSOR Cur_app_stats (cp_appno igs_uc_app_stats.app_no%TYPE) IS
1851: SELECT stat.rowid,
1852: stat.*
1853: FROM igs_uc_app_stats stat
1854: WHERE app_no = cp_appno;

Line 1853: FROM igs_uc_app_stats stat

1849: -- details held in IGS_UC_APP_STATS table through Export HESA data to OSS porcess.
1850: CURSOR Cur_app_stats (cp_appno igs_uc_app_stats.app_no%TYPE) IS
1851: SELECT stat.rowid,
1852: stat.*
1853: FROM igs_uc_app_stats stat
1854: WHERE app_no = cp_appno;
1855:
1856: -- jchakrab added for Bug 5481963 - 06-Sep-2006
1857: -- Retrieves choice records for an applicant in configured cycle and current institution

Line 2306: igs_uc_app_stats_pkg.update_row(

2302: IF new_ivstark_rec.apr <> old_stark_rec.domicile_apr THEN
2303:
2304: FOR Cur_app_stats_rec IN Cur_app_stats (new_ivstark_rec.appno)
2305: LOOP
2306: igs_uc_app_stats_pkg.update_row(
2307: x_rowid => Cur_app_stats_rec.rowid
2308: ,x_app_stat_id => Cur_app_stats_rec.app_stat_id
2309: ,x_app_id => Cur_app_stats_rec.app_id
2310: ,x_app_no => Cur_app_stats_rec.app_no

Line 5081: FROM igs_uc_app_stats uast

5077: -- check for corresponding record in main table.
5078: CURSOR old_starx_cur(p_appno igs_uc_app_choices.app_no%TYPE) IS
5079: SELECT uast.rowid,
5080: uast.*
5081: FROM igs_uc_app_stats uast
5082: WHERE uast.app_no = p_appno;
5083:
5084: -- validate ethnic value
5085: CURSOR validate_ethnic (p_ethnic igs_uc_istarx_ints.ethnic%TYPE) IS

Line 5220: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls

5216:
5217: BEGIN
5218:
5219: -- call the TBH to update the record
5220: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls
5221: (
5222: x_rowid => old_starx_rec.rowid -- would be NULL since no existing rec found
5223: ,x_app_stat_id => old_starx_rec.app_stat_id -- since this will be NULL since no existing rec found.
5224: ,x_app_id => appl_det_rec.app_id

Line 5261: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls

5257: ELSE -- update
5258:
5259: BEGIN
5260: -- call the TBH to update the record
5261: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls
5262: (
5263: x_rowid => old_starx_rec.rowid
5264: ,x_app_stat_id => old_starx_rec.app_stat_id
5265: ,x_app_id => old_starx_rec.app_id

Line 5390: FROM igs_uc_app_stats uast

5386: -- check for corresponding record in main table.
5387: CURSOR old_starh_cur(p_appno igs_uc_app_choices.app_no%TYPE) IS
5388: SELECT uast.rowid,
5389: uast.*
5390: FROM igs_uc_app_stats uast
5391: WHERE uast.app_no = p_appno;
5392:
5393: -- validate ethnic value
5394: CURSOR validate_ethnic (p_ethnic igs_uc_istarh_ints.ethnic%TYPE) IS

Line 5417: l_socialeconomic igs_uc_app_stats.starh_socio_economic%TYPE;

5413:
5414: appl_det_rec get_appl_dets%ROWTYPE;
5415: old_starh_rec old_starh_cur%ROWTYPE;
5416: l_valid VARCHAR2(1);
5417: l_socialeconomic igs_uc_app_stats.starh_socio_economic%TYPE;
5418:
5419:
5420: BEGIN
5421:

Line 5533: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls

5529:
5530: BEGIN
5531:
5532: -- call the TBH to update the record
5533: igs_uc_app_stats_pkg.insert_row -- IGSXI07B.pls
5534: (
5535: x_rowid => old_starh_rec.rowid
5536: ,x_app_stat_id => old_starh_rec.app_stat_id -- can be used as this value will be NULL during insert as no rec exists.
5537: ,x_app_id => appl_det_rec.app_id

Line 5574: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls

5570: ELSE -- update
5571:
5572: BEGIN
5573: -- call the TBH to update the record
5574: igs_uc_app_stats_pkg.update_row -- IGSXI07B.pls
5575: (
5576: x_rowid => old_starh_rec.rowid
5577: ,x_app_stat_id => old_starh_rec.app_stat_id
5578: ,x_app_id => old_starh_rec.app_id