[Home] [Help]
61: (reverse chronological order - newest change first)
62: ***************************************************************/
63:
64: CURSOR cur_find_deceased IS
65: SELECT b.deceased_ind FROM igs_uc_applicants a,igs_pe_hz_parties b
66: WHERE a.app_no = P_App_no AND a.oss_person_id = b.party_id;
67:
68: -- 29-MAY-2006 anwest Bug #5190520 UCTD320 - UCAS 2006 CLEARING ISSUES
69: CURSOR cur_find_trans(cp_transaction_type igs_uc_transactions.transaction_type%TYPE) IS
92:
93: CURSOR cur_find_appclear_2006 IS
94: SELECT COUNT(*) FROM igs_uc_u_cvname_2003
95: WHERE appno =
96: (SELECT LPAD((app_no||check_digit),9,0) from IGS_UC_APPLICANTS where app_no = P_App_no);
97:
98: -- Check whether there exists any applicant record for generating PE
99: CURSOR cur_applicants IS
100: SELECT COUNT(*) FROM igs_uc_applicants WHERE app_no = p_app_no;
96: (SELECT LPAD((app_no||check_digit),9,0) from IGS_UC_APPLICANTS where app_no = P_App_no);
97:
98: -- Check whether there exists any applicant record for generating PE
99: CURSOR cur_applicants IS
100: SELECT COUNT(*) FROM igs_uc_applicants WHERE app_no = p_app_no;
101:
102: -- Get the count of records exists in the choices tabel between 1 to 6 choices, for PE
103: CURSOR cur_choices IS
104: SELECT COUNT(*) FROM igs_uc_app_choices
1707: WHERE a.condition_category = cp_test_cond_cat
1708: AND a.condition_name = cp_test_cond_name;
1709:
1710: -- Cursor to convert 8-digit appno to 9 digit NUMBER with check digit for UC315 - UCAS 2006 Support
1711: CURSOR cur_appno(cp_appno igs_uc_applicants.app_no%TYPE) IS
1712: SELECT TO_NUMBER(app_no || check_digit)
1713: FROM igs_uc_applicants
1714: WHERE app_no = cp_appno;
1715:
1709:
1710: -- Cursor to convert 8-digit appno to 9 digit NUMBER with check digit for UC315 - UCAS 2006 Support
1711: CURSOR cur_appno(cp_appno igs_uc_applicants.app_no%TYPE) IS
1712: SELECT TO_NUMBER(app_no || check_digit)
1713: FROM igs_uc_applicants
1714: WHERE app_no = cp_appno;
1715:
1716: l_user_id Varchar2(20) := fnd_global.user_id;
1717: l_soc igs_uc_transactions.soc%TYPE;
2030: -- Cursor to find the system code associated with the UCAS application
2031:
2032: CURSOR c_sys_cd (cp_alt_appl_id igs_ad_appl_all.alt_appl_id%TYPE ) IS
2033: SELECT system_code
2034: FROM igs_uc_applicants
2035: WHERE TO_CHAR(app_no) = cp_alt_appl_id;
2036:
2037: l_sys_cd igs_uc_applicants.system_code%TYPE;
2038:
2033: SELECT system_code
2034: FROM igs_uc_applicants
2035: WHERE TO_CHAR(app_no) = cp_alt_appl_id;
2036:
2037: l_sys_cd igs_uc_applicants.system_code%TYPE;
2038:
2039: --Cursor to get the decision code associated with the current outcome status and the new outcome status
2040:
2041: CURSOR c_decision_cd(cp_system_code igs_uc_app_choices.system_code%TYPE,