APPS.IGS_AD_SS_APPL_FEE_PKG dependencies on IGS_AD_APPL

Line 35: FROM igs_ad_appl

31: Who When What
32: ***************************************************************/
33: CURSOR c_appl(cp_person_id NUMBER,cp_admission_appl_number NUMBER) IS
34: SELECT *
35: FROM igs_ad_appl
36: WHERE person_id = cp_person_id
37: AND admission_appl_number = cp_admission_appl_number;
38:
39: CURSOR c_appl_inst(cp_person_id NUMBER,cp_admission_appl_number NUMBER,cp_nominated_cd VARCHAR,cp_seq_number NUMBER) IS

Line 243: FROM igs_ad_appl

239: ***************************************************************/
240:
241: CURSOR c_appl(cp_person_id NUMBER,cp_admission_appl_number NUMBER) IS
242: SELECT *
243: FROM igs_ad_appl
244: WHERE person_id = cp_person_id
245: AND admission_appl_number = cp_admission_appl_number;
246:
247: CURSOR c_appl_inst(cp_person_id NUMBER,cp_admission_appl_number NUMBER,cp_nominated_cd VARCHAR,cp_seq_number NUMBER) IS

Line 455: FROM igs_ad_appl

451: ***************************************************************/
452: --Cursor which retrieves the system admission process type associated with the application.
453: CURSOR c_appl_cur IS
454: SELECT s_admission_process_type, admission_cat
455: FROM igs_ad_appl
456: WHERE person_id = p_person_id AND
457: admission_appl_number = p_admission_application_number;
458:
459: CURSOR c_trk_exists(p_adm_cat VARCHAR2, p_adm_prc_typ VARCHAR2) IS

Line 471: l_adm_cat igs_ad_appl.ADMISSION_CAT%TYPE;

467:
468: c_appl_rec c_appl_cur%ROWTYPE;
469:
470: l_trk_exists number;
471: l_adm_cat igs_ad_appl.ADMISSION_CAT%TYPE;
472: l_adm_proc_type igs_ad_appl.S_ADMISSION_PROCESS_TYPE%TYPE;
473: lvc_user_application_status VARCHAR2(30);
474: lvc_user_entry_qual_status VARCHAR2(30);
475: lvc_user_outcome_status VARCHAR2(30);

Line 472: l_adm_proc_type igs_ad_appl.S_ADMISSION_PROCESS_TYPE%TYPE;

468: c_appl_rec c_appl_cur%ROWTYPE;
469:
470: l_trk_exists number;
471: l_adm_cat igs_ad_appl.ADMISSION_CAT%TYPE;
472: l_adm_proc_type igs_ad_appl.S_ADMISSION_PROCESS_TYPE%TYPE;
473: lvc_user_application_status VARCHAR2(30);
474: lvc_user_entry_qual_status VARCHAR2(30);
475: lvc_user_outcome_status VARCHAR2(30);
476: lvc_user_conditional_status VARCHAR2(30);

Line 593: modified to derive fee amount from igs_ad_appl_all - igsm - arvsrini

589: x_msg_data OUT NOCOPY VARCHAR2)
590: AS
591: /**************************************************************
592: Created By :rboddu
593: modified to derive fee amount from igs_ad_appl_all - igsm - arvsrini
594: Date Created By : 31-DEC-2001
595: Purpose : 2158524
596: Know limitations, enhancements or remarks
597: Change History

Line 606: FROM igs_ad_appl

602:
603: --Cursor which returns the admission_application_type associated with the passed admission_application_number
604: CURSOR get_appl_type_cur IS
605: SELECT application_type
606: FROM igs_ad_appl
607: WHERE person_id = p_person_id AND
608: admission_appl_number = p_admission_appl_number;
609:
610: --Cursor to fetch the account details associated with the application_type into the OUT NOCOPY parameters

Line 625: IGS_AD_APPL_ALL apl,

621: CURSOR c_appl_fee_amt IS
622: SELECT
623: (NVL(apl.appl_fee_amt,0)-sum(req.FEE_AMOUNT)) OutstandingBal
624: FROM
625: IGS_AD_APPL_ALL apl,
626: igs_ad_app_req req
627: WHERE
628: apl.person_id= p_person_id AND
629: apl.admission_appl_number = p_admission_appl_number AND

Line 643: FROM IGS_AD_APPL_ALL apl

639: --cursor to fetch the initial application fee amount
640: CURSOR c_appl_fee_appl IS
641: SELECT
642: NVL(apl.appl_fee_amt,0) appfee
643: FROM IGS_AD_APPL_ALL apl
644: WHERE
645: apl.person_id= p_person_id AND
646: apl.admission_appl_number = p_admission_appl_number;
647:

Line 747: FROM igs_ad_appl apai

743:
744: --CURSOR which checks whether the application is a valid one
745: CURSOR is_valid_appl_cur(l_person_id IN NUMBER, l_admission_appl_number IN NUMBER) IS
746: SELECT person_id
747: FROM igs_ad_appl apai
748: WHERE apai.person_id = l_person_id AND
749: apai.admission_appl_number = l_admission_appl_number;
750:
751: --CURSOR which retrieves the default System Status for the given System Fee Method

Line 781: lv_person_id igs_ad_appl.person_id%TYPE;

777: l_default_fee_status igs_ad_code_classes.code_id%TYPE;
778: l_default_fee_type igs_ad_code_classes.code_id%TYPE;
779: l_rowid VARCHAR2(100);
780: l_app_req_id NUMBER(15);
781: lv_person_id igs_ad_appl.person_id%TYPE;
782: lv_dup_person VARCHAR2(10);
783: l_message VARCHAR2(100);
784: invalidamount EXCEPTION;
785: invalidappl EXCEPTION;