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_FI_PRC_FEE_ASS dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 232: TYPE t_date IS TABLE OF igs_en_su_attempt_all.enrolled_dt%TYPE INDEX BY BINARY_INTEGER;

228: tbl_fee_as_items_diff t_fee_as_items_typ; -- Holds the records which are the diff between previous assessment and current assessment while processing retention
229: tbl_fee_as_items_dummy t_fee_as_items_typ; -- This is the dummy table used in retention calculation
230:
231: TYPE t_unit_status IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
232: TYPE t_date IS TABLE OF igs_en_su_attempt_all.enrolled_dt%TYPE INDEX BY BINARY_INTEGER;
233:
234: TYPE wav_fcfl_rec_type IS RECORD (
235: p_fee_category igs_fi_f_cat_fee_lbl_all.fee_cat%TYPE,
236: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

Line 873: CURSOR cur_usec_dtls(cp_n_person_id igs_en_su_attempt_all.person_id%TYPE,

869: Who When What
870: ***************************************************************/
871: -- Cursor to obtain the Unit Section details
872: -- Retention not applicable for Unit Sections with status Invalid or Duplicate
873: CURSOR cur_usec_dtls(cp_n_person_id igs_en_su_attempt_all.person_id%TYPE,
874: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
875: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
876: SELECT *
877: FROM igs_en_su_attempt_all

Line 874: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,

870: ***************************************************************/
871: -- Cursor to obtain the Unit Section details
872: -- Retention not applicable for Unit Sections with status Invalid or Duplicate
873: CURSOR cur_usec_dtls(cp_n_person_id igs_en_su_attempt_all.person_id%TYPE,
874: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
875: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
876: SELECT *
877: FROM igs_en_su_attempt_all
878: WHERE person_id = cp_n_person_id

Line 875: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

871: -- Cursor to obtain the Unit Section details
872: -- Retention not applicable for Unit Sections with status Invalid or Duplicate
873: CURSOR cur_usec_dtls(cp_n_person_id igs_en_su_attempt_all.person_id%TYPE,
874: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
875: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
876: SELECT *
877: FROM igs_en_su_attempt_all
878: WHERE person_id = cp_n_person_id
879: AND course_cd = cp_v_course_cd

Line 877: FROM igs_en_su_attempt_all

873: CURSOR cur_usec_dtls(cp_n_person_id igs_en_su_attempt_all.person_id%TYPE,
874: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
875: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
876: SELECT *
877: FROM igs_en_su_attempt_all
878: WHERE person_id = cp_n_person_id
879: AND course_cd = cp_v_course_cd
880: AND uoo_id = cp_n_uoo_id
881: ORDER BY discontinued_dt;

Line 1017: FUNCTION finpl_clc_sua_cp( p_v_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,

1013: igs_ge_msg_stack.add;
1014: app_exception.raise_exception;
1015: END finpl_prc_teach_prd_retn_levl;
1016:
1017: FUNCTION finpl_clc_sua_cp( p_v_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,
1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,

Line 1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,

1014: app_exception.raise_exception;
1015: END finpl_prc_teach_prd_retn_levl;
1016:
1017: FUNCTION finpl_clc_sua_cp( p_v_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,
1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,

Line 1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,

1015: END finpl_prc_teach_prd_retn_levl;
1016:
1017: FUNCTION finpl_clc_sua_cp( p_v_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,
1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,

Line 1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,

1016:
1017: FUNCTION finpl_clc_sua_cp( p_v_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,
1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,
1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,

Line 1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,

1017: FUNCTION finpl_clc_sua_cp( p_v_unit_cd IN igs_en_su_attempt_all.unit_cd%TYPE,
1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,
1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,
1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,
1025: p_n_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,

Line 1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,

1018: p_n_version_number IN igs_en_su_attempt_all.version_number%TYPE,
1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,
1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,
1025: p_n_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
1026: p_v_include_audit IN igs_en_su_attempt_all.no_assessment_ind%TYPE ) RETURN NUMBER AS

Line 1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,

1019: p_v_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,
1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,
1025: p_n_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
1026: p_v_include_audit IN igs_en_su_attempt_all.no_assessment_ind%TYPE ) RETURN NUMBER AS
1027: /*************************************************************

Line 1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,

1020: p_n_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,
1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,
1025: p_n_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
1026: p_v_include_audit IN igs_en_su_attempt_all.no_assessment_ind%TYPE ) RETURN NUMBER AS
1027: /*************************************************************
1028: Created By : Shirish Tatikonda

Line 1025: p_n_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,

1021: p_v_load_cal_type IN igs_en_su_attempt_all.cal_type%TYPE,
1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,
1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,
1025: p_n_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
1026: p_v_include_audit IN igs_en_su_attempt_all.no_assessment_ind%TYPE ) RETURN NUMBER AS
1027: /*************************************************************
1028: Created By : Shirish Tatikonda
1029: Date Created By : 21-JUL-2004

Line 1026: p_v_include_audit IN igs_en_su_attempt_all.no_assessment_ind%TYPE ) RETURN NUMBER AS

1022: p_n_load_ci_sequence_number IN igs_en_su_attempt_all.ci_sequence_number%TYPE,
1023: p_n_override_enrolled_cp IN igs_en_su_attempt_all.override_enrolled_cp%TYPE,
1024: p_n_override_eftsu IN igs_en_su_attempt_all.override_eftsu%TYPE,
1025: p_n_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE,
1026: p_v_include_audit IN igs_en_su_attempt_all.no_assessment_ind%TYPE ) RETURN NUMBER AS
1027: /*************************************************************
1028: Created By : Shirish Tatikonda
1029: Date Created By : 21-JUL-2004
1030: Purpose : This function returns Enrolled/Audit/Billable Credit points.

Line 1118: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;

1114: TYPE l_der_nom_ref IS REF CURSOR RETURN l_der_nom_rec;
1115: l_v_prg_liabale VARCHAR2(10);
1116: c_att_md_ty l_der_nom_ref;
1117: l_c_att_md_ty c_att_md_ty%ROWTYPE;
1118: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;
1119: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;
1120: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
1121: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
1122: SELECT spat.person_id,

Line 1119: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;

1115: l_v_prg_liabale VARCHAR2(10);
1116: c_att_md_ty l_der_nom_ref;
1117: l_c_att_md_ty c_att_md_ty%ROWTYPE;
1118: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;
1119: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;
1120: CURSOR c_sca_psv ( cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
1121: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE ) IS
1122: SELECT spat.person_id,
1123: spat.program_cd,

Line 1989: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;

1985: FROM igs_fi_fee_type_all
1986: WHERE fee_type = cp_v_fee_type;
1987:
1988: l_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE := NULL;
1989: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;
1990: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;
1991:
1992: BEGIN
1993: log_to_fnd( p_v_module => 'finpl_get_derived_values',

Line 1990: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;

1986: WHERE fee_type = cp_v_fee_type;
1987:
1988: l_v_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE := NULL;
1989: l_n_cr_points igs_en_su_attempt_all.override_achievable_cp%TYPE;
1990: l_n_fte igs_en_su_attempt_all.override_achievable_cp%TYPE;
1991:
1992: BEGIN
1993: log_to_fnd( p_v_module => 'finpl_get_derived_values',
1994: p_v_string => 'Entered finpl_get_derived_values. Parameters are: ' ||

Line 4644: igs_en_su_attempt_all sua

4640: cp_v_secondary VARCHAR2,
4641: cp_v_enrolled VARCHAR2) IS
4642: SELECT 'X'
4643: FROM igs_en_stdnt_ps_att_all sca,
4644: igs_en_su_attempt_all sua
4645: WHERE sca.person_id = cp_n_person_id
4646: AND sca.person_id = sua.person_id
4647: AND sca.course_cd = sua.course_cd
4648: AND NVL(sca.primary_program_type, cp_v_secondary) = cp_v_secondary

Line 5047: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

5043: FROM igs_fi_fai_dtls fai
5044: WHERE fee_ass_item_id = cp_n_fee_ass_item_id;
5045:
5046: CURSOR cur_dropped_unit (cp_person_id hz_parties.party_id%TYPE,
5047: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5048: cp_v_fee_ass_ind VARCHAR2,
5049: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
5050: cp_v_enrp_get_load_apply VARCHAR2,
5051: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

Line 5051: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

5047: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5048: cp_v_fee_ass_ind VARCHAR2,
5049: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
5050: cp_v_enrp_get_load_apply VARCHAR2,
5051: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5052: SELECT discontinued_dt
5053: FROM igs_en_su_attempt_all sua,
5054: igs_lookups_view lkp
5055: WHERE lkp.lookup_code = sua.unit_attempt_status

Line 5053: FROM igs_en_su_attempt_all sua,

5049: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
5050: cp_v_enrp_get_load_apply VARCHAR2,
5051: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5052: SELECT discontinued_dt
5053: FROM igs_en_su_attempt_all sua,
5054: igs_lookups_view lkp
5055: WHERE lkp.lookup_code = sua.unit_attempt_status
5056: AND lkp.lookup_type = cp_v_lookup_type
5057: AND (sua.no_assessment_ind = cp_v_fee_ass_ind OR cp_v_fee_ass_ind IS NULL)

Line 5074: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

5070: AND (igs_fi_gen_008.chk_unit_prg_transfer(sua.dcnt_reason_cd) = 'N')
5071: ORDER BY sua.discontinued_dt;
5072:
5073: CURSOR cur_enr_date (cp_person_id hz_parties.party_id%TYPE,
5074: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5075: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5076: SELECT sua.enrolled_dt
5077: FROM igs_en_su_attempt_all sua
5078: WHERE sua.uoo_id = cp_n_uoo_id

Line 5075: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

5071: ORDER BY sua.discontinued_dt;
5072:
5073: CURSOR cur_enr_date (cp_person_id hz_parties.party_id%TYPE,
5074: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5075: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5076: SELECT sua.enrolled_dt
5077: FROM igs_en_su_attempt_all sua
5078: WHERE sua.uoo_id = cp_n_uoo_id
5079: AND sua.person_id = cp_person_id

Line 5077: FROM igs_en_su_attempt_all sua

5073: CURSOR cur_enr_date (cp_person_id hz_parties.party_id%TYPE,
5074: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5075: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5076: SELECT sua.enrolled_dt
5077: FROM igs_en_su_attempt_all sua
5078: WHERE sua.uoo_id = cp_n_uoo_id
5079: AND sua.person_id = cp_person_id
5080: AND sua.course_cd = cp_course_cd;
5081:

Line 5083: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,

5079: AND sua.person_id = cp_person_id
5080: AND sua.course_cd = cp_course_cd;
5081:
5082: CURSOR cur_disc_dt (cp_n_person_id hz_parties.party_id%TYPE,
5083: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5084: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5085: SELECT sua.dcnt_reason_cd
5086: FROM igs_en_su_attempt_all sua
5087: WHERE sua.uoo_id = cp_n_uoo_id

Line 5084: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS

5080: AND sua.course_cd = cp_course_cd;
5081:
5082: CURSOR cur_disc_dt (cp_n_person_id hz_parties.party_id%TYPE,
5083: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5084: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5085: SELECT sua.dcnt_reason_cd
5086: FROM igs_en_su_attempt_all sua
5087: WHERE sua.uoo_id = cp_n_uoo_id
5088: AND sua.person_id = cp_n_person_id

Line 5086: FROM igs_en_su_attempt_all sua

5082: CURSOR cur_disc_dt (cp_n_person_id hz_parties.party_id%TYPE,
5083: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE,
5084: cp_n_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
5085: SELECT sua.dcnt_reason_cd
5086: FROM igs_en_su_attempt_all sua
5087: WHERE sua.uoo_id = cp_n_uoo_id
5088: AND sua.person_id = cp_n_person_id
5089: AND sua.course_cd = cp_v_course_cd;
5090:

Line 5111: l_d_disc_dt igs_en_su_attempt_all.enrolled_dt%TYPE;

5107: l_n_amount igs_fi_fee_as_items.amount%TYPE;
5108: l_v_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE;
5109: l_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE;
5110: l_n_old_amount igs_fi_fee_as_items.amount%TYPE;
5111: l_d_disc_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5112: l_d_enr_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5113: l_b_rec_found BOOLEAN;
5114: l_n_disc_units NUMBER;
5115: l_b_flag BOOLEAN;

Line 5112: l_d_enr_dt igs_en_su_attempt_all.enrolled_dt%TYPE;

5108: l_v_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE;
5109: l_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE;
5110: l_n_old_amount igs_fi_fee_as_items.amount%TYPE;
5111: l_d_disc_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5112: l_d_enr_dt igs_en_su_attempt_all.enrolled_dt%TYPE;
5113: l_b_rec_found BOOLEAN;
5114: l_n_disc_units NUMBER;
5115: l_b_flag BOOLEAN;
5116:

Line 5117: l_v_dcnt_reason_cd igs_en_su_attempt_all.dcnt_reason_cd%TYPE;

5113: l_b_rec_found BOOLEAN;
5114: l_n_disc_units NUMBER;
5115: l_b_flag BOOLEAN;
5116:
5117: l_v_dcnt_reason_cd igs_en_su_attempt_all.dcnt_reason_cd%TYPE;
5118:
5119: BEGIN
5120:
5121: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',

Line 6279: l_v_no_assessment_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;

6275: DECLARE
6276: v_message_name VARCHAR2(30);
6277: v_derived_org_unit_cd IGS_FI_FEE_AS_ITEMS.org_unit_cd%TYPE;
6278:
6279: l_v_no_assessment_ind igs_en_su_attempt_all.no_assessment_ind%TYPE;
6280: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
6281: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6282:
6283:

Line 6284: CURSOR c_unit_class_att (cp_person_id igs_en_su_attempt_all.person_id%TYPE,

6280: l_n_eftsu igs_fi_fee_as_items.eftsu%TYPE;
6281: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6282:
6283:
6284: CURSOR c_unit_class_att (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
6285: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6286: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE ) IS
6287: SELECT unit_class, no_assessment_ind
6288: FROM igs_en_su_attempt_all

Line 6285: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

6281: l_n_credit_points igs_fi_fee_as_items.credit_points%TYPE;
6282:
6283:
6284: CURSOR c_unit_class_att (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
6285: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6286: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE ) IS
6287: SELECT unit_class, no_assessment_ind
6288: FROM igs_en_su_attempt_all
6289: WHERE person_id = cp_person_id

Line 6286: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE ) IS

6282:
6283:
6284: CURSOR c_unit_class_att (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
6285: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6286: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE ) IS
6287: SELECT unit_class, no_assessment_ind
6288: FROM igs_en_su_attempt_all
6289: WHERE person_id = cp_person_id
6290: AND course_cd = cp_course_cd

Line 6288: FROM igs_en_su_attempt_all

6284: CURSOR c_unit_class_att (cp_person_id igs_en_su_attempt_all.person_id%TYPE,
6285: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6286: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE ) IS
6287: SELECT unit_class, no_assessment_ind
6288: FROM igs_en_su_attempt_all
6289: WHERE person_id = cp_person_id
6290: AND course_cd = cp_course_cd
6291: AND uoo_id = cp_uoo_id;
6292:

Line 6293: lv_unit_class_att igs_en_su_attempt_all.unit_class%TYPE;

6289: WHERE person_id = cp_person_id
6290: AND course_cd = cp_course_cd
6291: AND uoo_id = cp_uoo_id;
6292:
6293: lv_unit_class_att igs_en_su_attempt_all.unit_class%TYPE;
6294:
6295: -- Added by schodava as a part of the CCR for the Fee Calc (Enh # 1851586) DLD
6296: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
6297: -- CREDIT_POINT or PERUNIT)

Line 6298: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,

6294:
6295: -- Added by schodava as a part of the CCR for the Fee Calc (Enh # 1851586) DLD
6296: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
6297: -- CREDIT_POINT or PERUNIT)
6298: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
6299: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
6300: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
6301: ) IS
6302: SELECT org_unit_cd -- this column needs to be added as yet to the table as a part of Nov 2001 Build

Line 6299: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,

6295: -- Added by schodava as a part of the CCR for the Fee Calc (Enh # 1851586) DLD
6296: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
6297: -- CREDIT_POINT or PERUNIT)
6298: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
6299: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
6300: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
6301: ) IS
6302: SELECT org_unit_cd -- this column needs to be added as yet to the table as a part of Nov 2001 Build
6303: FROM igs_en_su_attempt_all su

Line 6300: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE

6296: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
6297: -- CREDIT_POINT or PERUNIT)
6298: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
6299: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
6300: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
6301: ) IS
6302: SELECT org_unit_cd -- this column needs to be added as yet to the table as a part of Nov 2001 Build
6303: FROM igs_en_su_attempt_all su
6304: WHERE su.person_id = cp_person_id

Line 6303: FROM igs_en_su_attempt_all su

6299: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
6300: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
6301: ) IS
6302: SELECT org_unit_cd -- this column needs to be added as yet to the table as a part of Nov 2001 Build
6303: FROM igs_en_su_attempt_all su
6304: WHERE su.person_id = cp_person_id
6305: AND su.course_cd = cp_course_cd
6306: AND su.uoo_id = cp_uoo_id;
6307:

Line 6767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

6763: -- Enh#2162747, Modified the cursor, removed the eftsu and credit point calculation, same function is invoked to calculate EFTSU, CREDIT POINTS
6764: -- when the the charge method is either EFTSU or CREDIT POINTS
6765: -- Enh# 3167098, modified following cursor
6766: CURSOR c_sualv_scafv (cp_person_id hz_parties.party_id%TYPE,
6767: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,
6768: cp_v_fee_ass_ind VARCHAR2,
6769: cp_v_lookup_type igs_lookups_view.lookup_type%TYPE,
6770: cp_v_fee_ass_indicator igs_lookups_view.fee_ass_ind%TYPE) IS
6771: SELECT sua.cal_type,

Line 6785: FROM igs_en_su_attempt_all sua,

6781: sua.no_assessment_ind,
6782: sua.location_cd,
6783: sua.org_unit_cd,
6784: uoo.owner_org_unit_cd
6785: FROM igs_en_su_attempt_all sua,
6786: igs_lookups_view lkp,
6787: igs_ps_unit_ofr_opt_all uoo
6788: WHERE lkp.lookup_code = sua.unit_attempt_status
6789: AND lkp.lookup_type = cp_v_lookup_type

Line 6848: FROM igs_en_su_attempt_all sua,

6844: sua.uoo_id uoo_id,
6845: sua.no_assessment_ind,
6846: sua.org_unit_cd,
6847: uoo.owner_org_unit_cd
6848: FROM igs_en_su_attempt_all sua,
6849: igs_lookups_view suas,
6850: igs_en_spa_terms terms,
6851: igs_ps_unit_ofr_opt_all uoo
6852: WHERE sua.person_id = p_person_id AND