APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_AD_APPL_ALL

Line 4: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_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,

Line 1449: cp_admission_cat igs_ad_appl_all.admission_cat%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.*,
1453: aa.appl_dt,

Line 1450: cp_s_adm_process_type igs_ad_appl_all.s_admission_process_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.*,
1453: aa.appl_dt,
1454: aa.admission_cat,

Line 1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,

1520: l_get_appl_instance c_get_appl_instance%ROWTYPE;
1521:
1522:
1523: /* This cursor will return the calenar information for a given application */
1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1526: SELECT acad_cal_type,acad_ci_sequence_number
1527: FROM igs_ad_appl_all
1528: WHERE person_id = cp_person_id

Line 1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

1521:
1522:
1523: /* This cursor will return the calenar information for a given application */
1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1526: SELECT acad_cal_type,acad_ci_sequence_number
1527: FROM igs_ad_appl_all
1528: WHERE person_id = cp_person_id
1529: AND admission_appl_number = cp_admission_appl_number;

Line 1527: FROM igs_ad_appl_all

1523: /* This cursor will return the calenar information for a given application */
1524: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
1525: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
1526: SELECT acad_cal_type,acad_ci_sequence_number
1527: FROM igs_ad_appl_all
1528: WHERE person_id = cp_person_id
1529: AND admission_appl_number = cp_admission_appl_number;
1530:
1531: l_get_acad_cal_info c_get_acad_cal_info%ROWTYPE;

Line 1587: l_application_type igs_ad_appl_all.application_type%TYPE;

1583: l_fut_adm_cal_type VARCHAR2(30);
1584: l_fut_adm_cal_seq_no NUMBER;
1585:
1586: l_message_name VARCHAR2(30);
1587: l_application_type igs_ad_appl_all.application_type%TYPE;
1588:
1589: l_sequence_number NUMBER;
1590:
1591: l_return_type VARCHAR2(100);