APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_CA_INST

Line 473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

469: WHERE ps.person_id = p_person_id
470: AND ps.course_cd = p_course_cd;
471:
472: -- Bug 5123583, Created the Cursor to fetch Teaching calendar description
473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
475: ) IS
476: SELECT description
477: FROM igs_ca_inst_all ca

Line 474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE

470: AND ps.course_cd = p_course_cd;
471:
472: -- Bug 5123583, Created the Cursor to fetch Teaching calendar description
473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
475: ) IS
476: SELECT description
477: FROM igs_ca_inst_all ca
478: WHERE ca.cal_type = p_v_cal_type

Line 477: FROM igs_ca_inst_all ca

473: CURSOR cur_get_cal_inst_desc(p_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,
474: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE
475: ) IS
476: SELECT description
477: FROM igs_ca_inst_all ca
478: WHERE ca.cal_type = p_v_cal_type
479: AND ca.sequence_number = p_n_sequence_number;
480:
481: -- Declaration of local variables

Line 491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;

487: l_str VARCHAR2(4000);
488: l_message VARCHAR2(2000);
489: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
490: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;

Line 492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;

488: l_message VARCHAR2(2000);
489: l_fee_cal_type igs_fi_inv_int.fee_cal_type%TYPE;
490: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;
496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;

Line 516: l_v_cal_inst_desc igs_ca_inst_all.description%TYPE := NULL;

512:
513: l_v_dcnt_reason_cd_desc igs_en_dcnt_reasoncd_v.description%TYPE;
514:
515: --Bug 5123583, variable declared to fetch calendar description from cur_get_cal_inst_desc.
516: l_v_cal_inst_desc igs_ca_inst_all.description%TYPE := NULL;
517:
518:
519: TYPE tab_chrgs_rec IS TABLE OF cur_person_chrgs%ROWTYPE INDEX BY BINARY_INTEGER;
520: v_tab_chrgs_rec tab_chrgs_rec;