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_AD_INT_RECONSIDER dependencies on IGS_AD_PS_APPL_INST_ALL

Line 5: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

1: PACKAGE BODY igs_ad_int_reconsider AS
2: /* $Header: IGSADD6B.pls 120.3 2006/05/26 07:17:44 pfotedar noship $ */
3:
4: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
5: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
6: p_person_id HZ_PARTIES.party_id%TYPE,
7: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
8: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
9: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,

Line 8: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

4: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
5: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
6: p_person_id HZ_PARTIES.party_id%TYPE,
7: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
8: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
9: p_nominated_course_cd IGS_AD_PS_APPL_ALL.nominated_course_cd%TYPE,
10: p_start_dt DATE)
11: RETURN BOOLEAN AS
12:

Line 422: p_nominated_course_cd IGS_AD_PS_APPL_INST_ALL.nominated_course_cd%TYPE,

418:
419: FUNCTION copy_application_child_records (p_person_id HZ_PARTIES.party_id%TYPE,
420: p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
421: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
422: p_nominated_course_cd IGS_AD_PS_APPL_INST_ALL.nominated_course_cd%TYPE,
423: p_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE)
424: RETURN BOOLEAN IS
425:
426: -- other institutitons

Line 423: p_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE)

419: FUNCTION copy_application_child_records (p_person_id HZ_PARTIES.party_id%TYPE,
420: p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
421: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
422: p_nominated_course_cd IGS_AD_PS_APPL_INST_ALL.nominated_course_cd%TYPE,
423: p_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE)
424: RETURN BOOLEAN IS
425:
426: -- other institutitons
427:

Line 1041: CURSOR c_intvw_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

1037: AND nominated_course_cd = cp_nominated_course_cd
1038: AND sequence_number = cp_sequence_number
1039: AND admission_appl_number = cp_admission_appl_number;
1040:
1041: CURSOR c_intvw_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1042: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1043: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nomINATED_COURSE_CD%TYPE,
1044: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
1045: SELECT pndt.*

Line 1042: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

1038: AND sequence_number = cp_sequence_number
1039: AND admission_appl_number = cp_admission_appl_number;
1040:
1041: CURSOR c_intvw_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1042: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1043: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nomINATED_COURSE_CD%TYPE,
1044: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
1045: SELECT pndt.*
1046: FROM igs_ad_panel_dtls pndt

Line 1043: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nomINATED_COURSE_CD%TYPE,

1039: AND admission_appl_number = cp_admission_appl_number;
1040:
1041: CURSOR c_intvw_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1042: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1043: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nomINATED_COURSE_CD%TYPE,
1044: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
1045: SELECT pndt.*
1046: FROM igs_ad_panel_dtls pndt
1047: WHERE person_id = cp_person_id

Line 1044: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS

1040:
1041: CURSOR c_intvw_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1042: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1043: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nomINATED_COURSE_CD%TYPE,
1044: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE ) IS
1045: SELECT pndt.*
1046: FROM igs_ad_panel_dtls pndt
1047: WHERE person_id = cp_person_id
1048: AND admission_appl_number = cp_admission_appl_number

Line 1440: CURSOR c_appl_inst(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

1436: lv_sql_stmt VARCHAR(32767) ;
1437:
1438:
1439: /* This cursor returns the application to be processed for a given combination of person_id, current calendars and future calendars */
1440: CURSOR c_appl_inst(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1441: cp_fut_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,

Line 1441: cp_fut_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,

1437:
1438:
1439: /* This cursor returns the application to be processed for a given combination of person_id, current calendars and future calendars */
1440: CURSOR c_appl_inst(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1441: cp_fut_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,

Line 1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,

1438:
1439: /* This cursor returns the application to be processed for a given combination of person_id, current calendars and future calendars */
1440: CURSOR c_appl_inst(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1441: cp_fut_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,

Line 1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,

1439: /* This cursor returns the application to be processed for a given combination of person_id, current calendars and future calendars */
1440: CURSOR c_appl_inst(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1441: cp_fut_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,

Line 1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,

1440: CURSOR c_appl_inst(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1441: cp_fut_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,

Line 1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,

1441: cp_fut_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1449: cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,

Line 1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,

1442: cp_fut_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1449: cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
1450: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE

Line 1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,

1443: cp_fut_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1449: cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
1450: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE
1451: ) IS

Line 1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,

1444: cp_fut_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1445: cp_prev_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
1446: cp_prev_acad_cal_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
1447: cp_prev_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
1448: cp_prev_adm_cal_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
1449: cp_admission_cat igs_ad_appl_all.admission_cat%TYPE,
1450: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_type%TYPE
1451: ) IS
1452: SELECT acai.*,

Line 1509: CURSOR c_get_appl_instance (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

1505:
1506:
1507: /* This cursor will return the application instance details for a given combination of
1508: person id, appl number, course cd and sequence number */
1509: CURSOR c_get_appl_instance (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1510: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1511: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1512: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1513: SELECT acai.rowid,acai.*

Line 1510: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

1506:
1507: /* This cursor will return the application instance details for a given combination of
1508: person id, appl number, course cd and sequence number */
1509: CURSOR c_get_appl_instance (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1510: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1511: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1512: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1513: SELECT acai.rowid,acai.*
1514: FROM igs_ad_ps_appl_inst_all acai

Line 1511: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

1507: /* This cursor will return the application instance details for a given combination of
1508: person id, appl number, course cd and sequence number */
1509: CURSOR c_get_appl_instance (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1510: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1511: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1512: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1513: SELECT acai.rowid,acai.*
1514: FROM igs_ad_ps_appl_inst_all acai
1515: WHERE person_id = cp_person_id

Line 1512: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS

1508: person id, appl number, course cd and sequence number */
1509: CURSOR c_get_appl_instance (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1510: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1511: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1512: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1513: SELECT acai.rowid,acai.*
1514: FROM igs_ad_ps_appl_inst_all acai
1515: WHERE person_id = cp_person_id
1516: AND admission_appl_number = cp_admission_appl_number

Line 1514: FROM igs_ad_ps_appl_inst_all acai

1510: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1511: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1512: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1513: SELECT acai.rowid,acai.*
1514: FROM igs_ad_ps_appl_inst_all acai
1515: WHERE person_id = cp_person_id
1516: AND admission_appl_number = cp_admission_appl_number
1517: AND nominated_course_cd = cp_nominated_course_cd
1518: AND sequence_number = cp_sequence_number;

Line 1535: CURSOR c_get_fut_acad_adm_cal_info (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

1531: l_get_acad_cal_info c_get_acad_cal_info%ROWTYPE;
1532:
1533:
1534: /* This cursor will return the future calendars (if any) of an application instance*/
1535: CURSOR c_get_fut_acad_adm_cal_info (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1536: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1537: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1538: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1539: SELECT future_acad_cal_type,future_acad_ci_sequence_number,future_adm_cal_type,future_adm_ci_sequence_number

Line 1536: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

1532:
1533:
1534: /* This cursor will return the future calendars (if any) of an application instance*/
1535: CURSOR c_get_fut_acad_adm_cal_info (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1536: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1537: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1538: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1539: SELECT future_acad_cal_type,future_acad_ci_sequence_number,future_adm_cal_type,future_adm_ci_sequence_number
1540: FROM igs_ad_ps_appl_inst_all

Line 1537: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

1533:
1534: /* This cursor will return the future calendars (if any) of an application instance*/
1535: CURSOR c_get_fut_acad_adm_cal_info (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1536: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1537: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1538: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1539: SELECT future_acad_cal_type,future_acad_ci_sequence_number,future_adm_cal_type,future_adm_ci_sequence_number
1540: FROM igs_ad_ps_appl_inst_all
1541: WHERE person_id = cp_person_id

Line 1538: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS

1534: /* This cursor will return the future calendars (if any) of an application instance*/
1535: CURSOR c_get_fut_acad_adm_cal_info (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1536: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1537: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1538: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1539: SELECT future_acad_cal_type,future_acad_ci_sequence_number,future_adm_cal_type,future_adm_ci_sequence_number
1540: FROM igs_ad_ps_appl_inst_all
1541: WHERE person_id = cp_person_id
1542: AND admission_appl_number = cp_admission_appl_number

Line 1540: FROM igs_ad_ps_appl_inst_all

1536: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1537: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
1538: cp_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE) IS
1539: SELECT future_acad_cal_type,future_acad_ci_sequence_number,future_adm_cal_type,future_adm_ci_sequence_number
1540: FROM igs_ad_ps_appl_inst_all
1541: WHERE person_id = cp_person_id
1542: AND admission_appl_number = cp_admission_appl_number
1543: AND nominated_course_cd = cp_nominated_course_cd
1544: AND sequence_number = cp_sequence_number;

Line 1548: CURSOR c_get_prog_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

1544: AND sequence_number = cp_sequence_number;
1545:
1546: l_get_fut_acad_adm_cal_info c_get_fut_acad_adm_cal_info%ROWTYPE;
1547:
1548: CURSOR c_get_prog_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1549: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1550: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
1551: SELECT aprog.*
1552: FROM igs_ad_ps_appl aprog

Line 1549: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

1545:
1546: l_get_fut_acad_adm_cal_info c_get_fut_acad_adm_cal_info%ROWTYPE;
1547:
1548: CURSOR c_get_prog_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1549: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1550: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
1551: SELECT aprog.*
1552: FROM igs_ad_ps_appl aprog
1553: WHERE aprog.person_id = cp_person_id

Line 1550: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS

1546: l_get_fut_acad_adm_cal_info c_get_fut_acad_adm_cal_info%ROWTYPE;
1547:
1548: CURSOR c_get_prog_dtls (cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
1549: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
1550: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
1551: SELECT aprog.*
1552: FROM igs_ad_ps_appl aprog
1553: WHERE aprog.person_id = cp_person_id
1554: AND aprog.admission_appl_number = cp_admission_appl_number

Line 1568: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;

1564: l_admission_type c_admission_type%ROWTYPE;
1565:
1566: l_new_admission_appl_number NUMBER;
1567:
1568: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
1569: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;
1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;
1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;

Line 1569: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;

1565:
1566: l_new_admission_appl_number NUMBER;
1567:
1568: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
1569: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;
1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;
1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;
1573: l_fut_adm_ci_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE;

Line 1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;

1566: l_new_admission_appl_number NUMBER;
1567:
1568: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
1569: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;
1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;
1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;
1573: l_fut_adm_ci_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE;
1574: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

Line 1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;

1567:
1568: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
1569: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;
1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;
1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;
1573: l_fut_adm_ci_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE;
1574: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1575:

Line 1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;

1568: l_person_id igs_ad_ps_appl_inst_all.person_id%TYPE;
1569: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;
1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;
1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;
1573: l_fut_adm_ci_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE;
1574: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1575:
1576: l_prev_acad_cal_type VARCHAR2(30);

Line 1573: l_fut_adm_ci_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE;

1569: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;
1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;
1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;
1573: l_fut_adm_ci_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE;
1574: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1575:
1576: l_prev_acad_cal_type VARCHAR2(30);
1577: l_prev_acad_cal_seq_no NUMBER;

Line 1574: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

1570: l_future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE;
1571: l_fut_acad_ci_seq_no igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE;
1572: l_future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE;
1573: l_fut_adm_ci_seq_no igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE;
1574: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
1575:
1576: l_prev_acad_cal_type VARCHAR2(30);
1577: l_prev_acad_cal_seq_no NUMBER;
1578: l_prev_adm_cal_type VARCHAR2(30);