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.

APPS.IGS_UC_PROC_APPLICATION_DATA dependencies on DUAL

Line 416: ,x_dual_nationality => ucas_app_person_rec.dual_nationality

412: ,x_edu_qualification => ucas_app_person_rec.edu_qualification
413: ,x_ad_batch_id => ucas_app_person_rec.ad_batch_id
414: ,x_ad_interface_id => ucas_app_person_rec.ad_interface_id
415: ,x_nationality => ucas_app_person_rec.nationality
416: ,x_dual_nationality => ucas_app_person_rec.dual_nationality
417: ,x_special_needs => ucas_app_person_rec.special_needs
418: ,x_country_birth => ucas_app_person_rec.country_birth
419: );
420:

Line 614: FROM DUAL;

610:
611: -- Cursor to get the Interface ID needed while populating records into Adm Interface table.
612: CURSOR get_interface_id IS
613: SELECT igs_ad_interface_s.NEXTVAL
614: FROM DUAL;
615:
616: -- cursor to get the batch ID from sequence.
617: CURSOR get_batch_id_cur IS
618: SELECT igs_ad_interface_batch_id_s.NEXTVAL

Line 619: FROM DUAL;

615:
616: -- cursor to get the batch ID from sequence.
617: CURSOR get_batch_id_cur IS
618: SELECT igs_ad_interface_batch_id_s.NEXTVAL
619: FROM DUAL;
620:
621: -- cursor to get the batch ID from sequence.
622: CURSOR get_alt_pers_id_cur IS
623: SELECT igs_ad_api_int_s.NEXTVAL

Line 624: FROM DUAL;

620:
621: -- cursor to get the batch ID from sequence.
622: CURSOR get_alt_pers_id_cur IS
623: SELECT igs_ad_api_int_s.NEXTVAL
624: FROM DUAL;
625:
626: old_starn_rec old_starn_cur%ROWTYPE;
627: l_oss_title igs_pe_person_base_v.title%TYPE;
628: l_system_code igs_uc_ucas_control.system_code%TYPE;

Line 1718: ,x_dual_nationality => app_rec.dual_nationality

1714: ,x_edu_qualification => app_rec.edu_qualification
1715: ,x_ad_batch_id => app_rec.ad_batch_id
1716: ,x_ad_interface_id => app_rec.ad_interface_id
1717: ,x_nationality => app_rec.nationality
1718: ,x_dual_nationality => app_rec.dual_nationality
1719: ,x_special_needs => app_rec.special_needs
1720: ,x_country_birth => app_rec.country_birth
1721: );
1722: END IF;

Line 2119: -- DUALNATIONALITY validation

2115:
2116:
2117:
2118: ----------------------------
2119: -- DUALNATIONALITY validation
2120: ----------------------------
2121: IF g_error_code IS NULL THEN
2122:
2123: -- validate Dual Nationality

Line 2123: -- validate Dual Nationality

2119: -- DUALNATIONALITY validation
2120: ----------------------------
2121: IF g_error_code IS NULL THEN
2122:
2123: -- validate Dual Nationality
2124: IF new_ivstark_rec.dualnationality IS NOT NULL THEN
2125:
2126: IF g_config_cycle > 2006 THEN
2127:

Line 2124: IF new_ivstark_rec.dualnationality IS NOT NULL THEN

2120: ----------------------------
2121: IF g_error_code IS NULL THEN
2122:
2123: -- validate Dual Nationality
2124: IF new_ivstark_rec.dualnationality IS NOT NULL THEN
2125:
2126: IF g_config_cycle > 2006 THEN
2127:
2128: OPEN validate_refcodes_cur ('NC', new_ivstark_rec.dualnationality);

Line 2128: OPEN validate_refcodes_cur ('NC', new_ivstark_rec.dualnationality);

2124: IF new_ivstark_rec.dualnationality IS NOT NULL THEN
2125:
2126: IF g_config_cycle > 2006 THEN
2127:
2128: OPEN validate_refcodes_cur ('NC', new_ivstark_rec.dualnationality);
2129: FETCH validate_refcodes_cur INTO l_valid;
2130:
2131: IF validate_refcodes_cur%NOTFOUND THEN
2132: g_error_code := '1016';

Line 2139: OPEN validate_ref_apr_cur (new_ivstark_rec.dualnationality);

2135: CLOSE validate_refcodes_cur;
2136:
2137: ELSE
2138:
2139: OPEN validate_ref_apr_cur (new_ivstark_rec.dualnationality);
2140: FETCH validate_ref_apr_cur INTO l_valid;
2141:
2142: IF validate_ref_apr_cur%NOTFOUND THEN
2143: g_error_code := '1016';

Line 2153: --- end of Dual Nationality validation

2149:
2150: END IF;
2151:
2152: END IF;
2153: --- end of Dual Nationality validation
2154:
2155:
2156: ----------------------------
2157: -- MAIN PROCESSING Begins

Line 2293: ,x_dual_nationality => new_ivstark_rec.dualnationality

2289: ,x_edu_qualification => old_stark_rec.edu_qualification
2290: ,x_ad_batch_id => old_stark_rec.ad_batch_id
2291: ,x_ad_interface_id => old_stark_rec.ad_interface_id
2292: ,x_nationality => new_ivstark_rec.nationality
2293: ,x_dual_nationality => new_ivstark_rec.dualnationality
2294: ,x_special_needs => new_ivstark_rec.specialneeds
2295: ,x_country_birth => new_ivstark_rec.countrybirth
2296: );
2297:

Line 3537: ,x_dual_nationality => get_appl_dets_rec.dual_nationality

3533: ,x_edu_qualification => get_appl_dets_rec.edu_qualification
3534: ,x_ad_batch_id => get_appl_dets_rec.ad_batch_id
3535: ,x_ad_interface_id => get_appl_dets_rec.ad_interface_id
3536: ,x_nationality => get_appl_dets_rec.nationality
3537: ,x_dual_nationality => get_appl_dets_rec.dual_nationality
3538: ,x_special_needs => get_appl_dets_rec.special_needs
3539: ,x_country_birth => get_appl_dets_rec.country_birth
3540: );
3541:

Line 4237: ,x_dual_nationality => old_start_rec.dual_nationality

4233: ,x_edu_qualification => new_ivstart_rec.eduqual
4234: ,x_ad_batch_id => old_start_rec.ad_batch_id
4235: ,x_ad_interface_id => old_start_rec.ad_interface_id
4236: ,x_nationality => old_start_rec.nationality
4237: ,x_dual_nationality => old_start_rec.dual_nationality
4238: ,x_special_needs => old_start_rec.special_needs
4239: ,x_country_birth => old_start_rec.country_birth
4240: );
4241:

Line 4494: ,x_dual_nationality => old_qual_rec.dual_nationality

4490: ,x_edu_qualification => old_qual_rec.edu_qualification
4491: ,x_ad_batch_id => old_qual_rec.ad_batch_id
4492: ,x_ad_interface_id => old_qual_rec.ad_interface_id
4493: ,x_nationality => old_qual_rec.nationality
4494: ,x_dual_nationality => old_qual_rec.dual_nationality
4495: ,x_special_needs => old_qual_rec.special_needs
4496: ,x_country_birth => old_qual_rec.country_birth
4497: );
4498:

Line 4765: ,x_dual_nationality => old_stmt_rec.dual_nationality

4761: ,x_edu_qualification => old_stmt_rec.edu_qualification
4762: ,x_ad_batch_id => old_stmt_rec.ad_batch_id
4763: ,x_ad_interface_id => old_stmt_rec.ad_interface_id
4764: ,x_nationality => old_stmt_rec.nationality
4765: ,x_dual_nationality => old_stmt_rec.dual_nationality
4766: ,x_special_needs => old_stmt_rec.special_needs
4767: ,x_country_birth => old_stmt_rec.country_birth
4768: );
4769: