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_STDNT_PS_ATT

Line 237: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

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,
237: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
238: p_career igs_ps_ver_all.course_type%TYPE);
239:
240: TYPE wav_fcfl_tbl_type IS TABLE OF wav_fcfl_rec_type INDEX BY BINARY_INTEGER;
241: tbl_wav_fcfl wav_fcfl_tbl_type;

Line 380: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,

376:
377: FUNCTION finp_clc_ass_amnt(
378: p_effective_dt IN DATE ,
379: p_person_id IN hz_parties.party_id%TYPE ,
380: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
381: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
382: p_course_attempt_status IN VARCHAR2 ,
383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
384: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,

Line 381: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,

377: FUNCTION finp_clc_ass_amnt(
378: p_effective_dt IN DATE ,
379: p_person_id IN hz_parties.party_id%TYPE ,
380: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
381: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
382: p_course_attempt_status IN VARCHAR2 ,
383: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
384: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
385: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,

Line 407: FUNCTION get_stdnt_res_status_cd ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE) RETURN VARCHAR2 AS

403:
404:
405: FUNCTION finpl_get_org_unit_cd(p_n_party_id IN hz_parties.party_id%TYPE) RETURN VARCHAR2;
406:
407: FUNCTION get_stdnt_res_status_cd ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE) RETURN VARCHAR2 AS
408: /*************************************************************
409: Created By : Shirish Tatikonda
410: Date Created By : 30-DEC-2003
411: Purpose : To derive Residency Status Code.

Line 455: FUNCTION get_stdnt_class_standing ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,

451: RETURN l_v_res_status;
452:
453: END get_stdnt_res_status_cd;
454:
455: FUNCTION get_stdnt_class_standing ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,
456: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
457: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE ) RETURN VARCHAR2 AS
458: /*************************************************************
459: Created By : Shirish Tatikonda

Line 529: PROCEDURE get_stdnt_unit_set_dtls ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,

525: RETURN l_v_derived_class_standing;
526:
527: END get_stdnt_class_standing;
528:
529: PROCEDURE get_stdnt_unit_set_dtls ( p_n_person_id IN igs_en_stdnt_ps_att_all.person_id%TYPE,
530: p_v_course_cd IN igs_ps_ver_all.course_cd%TYPE,
531: p_v_s_fee_trigger_cat IN igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
532: p_v_unit_set_cd OUT NOCOPY igs_as_su_setatmpt.unit_set_cd%TYPE,
533: p_n_unit_set_ver_num OUT NOCOPY igs_as_su_setatmpt.us_version_number%TYPE ) AS

Line 1137: igs_en_stdnt_ps_att_all sca,

1133: spat.attendance_mode,
1134: spat.attendance_type,
1135: ps.course_type
1136: FROM igs_en_spa_terms spat,
1137: igs_en_stdnt_ps_att_all sca,
1138: igs_ps_ver_all ps,
1139: igs_lookups_view lkps
1140: WHERE spat.person_id = p_person_id
1141: AND spat.person_id = sca.person_id

Line 1448: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,

1444: -----------------------------------------------------------------------------------
1445:
1446: FUNCTION finp_clc_ass_amnt( p_effective_dt IN DATE ,
1447: p_person_id IN hz_parties.party_id%TYPE ,
1448: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
1449: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
1450: p_course_attempt_status IN VARCHAR2 ,
1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
1452: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,

Line 1449: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,

1445:
1446: FUNCTION finp_clc_ass_amnt( p_effective_dt IN DATE ,
1447: p_person_id IN hz_parties.party_id%TYPE ,
1448: p_course_cd IN igs_en_stdnt_ps_att_all.course_cd%TYPE ,
1449: p_course_version_number IN igs_en_stdnt_ps_att_all.version_number%TYPE ,
1450: p_course_attempt_status IN VARCHAR2 ,
1451: p_fee_type IN igs_fi_f_cat_fee_lbl_all.fee_type%TYPE ,
1452: p_fee_cal_type IN igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE ,
1453: p_fee_ci_sequence_number IN igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE ,

Line 1546: v_derived_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

1542:
1543: /**to check whether override charge method is actioned**/
1544: lv_charge_override BOOLEAN := FALSE;
1545: lv_fee_assessment IGS_FI_FEE_AS_ITEMS.amount%TYPE;
1546: v_derived_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
1547: l_overide_chg_method igs_fi_f_typ_ca_inst_all.s_chg_method_type%TYPE;
1548: l_fee_category IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE;
1549:
1550: l_ch_ovr_exist BOOLEAN := FALSE;

Line 2374: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

2370:
2371: -------------------------------------------------------------------------------
2372: PROCEDURE finpl_find_far(
2373: p_person_id hz_parties.party_id%TYPE,
2374: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2378: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,

Line 2379: p_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,

2375: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
2376: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
2377: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
2378: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
2379: p_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
2380: p_effective_dt DATE,
2381: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
2382: p_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
2383: p_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,

Line 4512: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,

4508:
4509: --
4510: -- Calculate and insert fee assessments as required
4511: FUNCTION finp_ins_enr_fee_ass(p_effective_dt IN DATE ,
4512: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
4513: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
4514: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
4515: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
4516: p_fee_ci_sequence_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,

Line 4513: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,

4509: --
4510: -- Calculate and insert fee assessments as required
4511: FUNCTION finp_ins_enr_fee_ass(p_effective_dt IN DATE ,
4512: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
4513: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
4514: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
4515: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
4516: p_fee_ci_sequence_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
4517: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,

Line 4514: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,

4510: -- Calculate and insert fee assessments as required
4511: FUNCTION finp_ins_enr_fee_ass(p_effective_dt IN DATE ,
4512: p_person_id IN IGS_EN_STDNT_PS_ATT_ALL.person_id%TYPE ,
4513: p_course_cd IN IGS_EN_STDNT_PS_ATT_ALL.course_cd%TYPE ,
4514: p_fee_category IN IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT%TYPE ,
4515: p_fee_cal_type IN IGS_CA_INST_ALL.CAL_TYPE%TYPE ,
4516: p_fee_ci_sequence_num IN IGS_CA_INST_ALL.sequence_number%TYPE ,
4517: p_fee_type IN IGS_FI_FEE_TYPE_ALL.FEE_TYPE%TYPE ,
4518: p_trace_on IN VARCHAR2 ,

Line 4634: FROM igs_en_stdnt_ps_att_all sca

4630:
4631: -- Get the Program Attempt Status for the program that is passed as input to the process
4632: CURSOR cur_sca IS
4633: SELECT sca.course_attempt_status
4634: FROM igs_en_stdnt_ps_att_all sca
4635: WHERE sca.person_id = p_person_id
4636: AND sca.course_cd = p_course_cd;
4637:
4638: -- Cursor to check if there are any Incomplete Program Transfers.

Line 4643: FROM igs_en_stdnt_ps_att_all sca,

4639: CURSOR c_sua_for_sec (cp_n_person_id PLS_INTEGER,
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

Line 4690: igs_en_stdnt_ps_att_all sca,

4686: psv.short_title,
4687: esptv.key_program_flag
4688: FROM igs_en_spa_terms esptv,
4689: igs_ps_ver_all psv,
4690: igs_en_stdnt_ps_att_all sca,
4691: igs_lookups_view scas
4692: WHERE esptv.program_cd = psv.course_cd
4693: AND esptv.program_version = psv.version_number
4694: AND esptv.program_cd = sca.course_cd

Line 4745: igs_en_stdnt_ps_att_all sca,

4741: psv.short_title,
4742: esptv.key_program_flag
4743: FROM igs_en_spa_terms esptv,
4744: igs_ps_ver_all psv,
4745: igs_en_stdnt_ps_att_all sca,
4746: igs_lookups_view scas
4747: WHERE esptv.program_cd = psv.course_cd
4748: AND esptv.program_version = psv.version_number
4749: AND esptv.program_cd = sca.course_cd

Line 4774: CURSOR cur_fee_cat(cp_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

4770: l_v_return_status VARCHAR2(10);
4771: l_n_msg_count NUMBER;
4772: l_v_msg_data VARCHAR2(2000);
4773:
4774: CURSOR cur_fee_cat(cp_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
4775: cp_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE) IS
4776: SELECT fee_cat
4777: FROM igs_en_stdnt_ps_att
4778: WHERE person_id = cp_n_person_id

Line 4775: cp_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE) IS

4771: l_n_msg_count NUMBER;
4772: l_v_msg_data VARCHAR2(2000);
4773:
4774: CURSOR cur_fee_cat(cp_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
4775: cp_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE) IS
4776: SELECT fee_cat
4777: FROM igs_en_stdnt_ps_att
4778: WHERE person_id = cp_n_person_id
4779: AND course_cd = cp_v_course_cd;

Line 4777: FROM igs_en_stdnt_ps_att

4773:
4774: CURSOR cur_fee_cat(cp_n_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
4775: cp_v_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE) IS
4776: SELECT fee_cat
4777: FROM igs_en_stdnt_ps_att
4778: WHERE person_id = cp_n_person_id
4779: AND course_cd = cp_v_course_cd;
4780:
4781: l_v_fee_cat igs_en_stdnt_ps_att.fee_cat%TYPE;

Line 4781: l_v_fee_cat igs_en_stdnt_ps_att.fee_cat%TYPE;

4777: FROM igs_en_stdnt_ps_att
4778: WHERE person_id = cp_n_person_id
4779: AND course_cd = cp_v_course_cd;
4780:
4781: l_v_fee_cat igs_en_stdnt_ps_att.fee_cat%TYPE;
4782:
4783: FUNCTION finpl_sum_fee_ass_item (
4784: p_person_id IGS_FI_FEE_AS_ITEMS.person_id%TYPE,
4785: p_status IGS_FI_FEE_AS_ITEMS.status%TYPE,

Line 5646: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

5642: END finpl_chk_debt_ret_sched;
5643:
5644: PROCEDURE finpl_ins_fee_ass(
5645: p_person_id hz_parties.party_id%TYPE,
5646: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
5647: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
5650: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,

Line 5651: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%TYPE,

5647: p_fee_type igs_fi_f_cat_fee_lbl_all.fee_type%TYPE,
5648: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
5649: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,
5650: p_s_fee_trigger_cat igs_fi_fee_type_all.s_fee_trigger_cat%TYPE,
5651: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%TYPE,
5652: p_currency igs_fi_control_all.currency_cd%TYPE,
5653: p_charge_rate igs_fi_fee_as_rate.chg_rate%TYPE,
5654: p_s_fee_type igs_fi_fee_type_all.s_fee_type%TYPE,
5655: p_effective_dt DATE,

Line 5720: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

5716:
5717: cst_assessment CONSTANT igs_fi_fee_as_all.s_transaction_type%TYPE := 'ASSESSMENT';
5718: v_chg_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE;
5719: v_chg_elements NUMBER;
5720: v_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
5721: v_message_name VARCHAR2(30);
5722:
5723: l_source_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
5724: l_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;

Line 6243: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

6239: FUNCTION finpl_prc_sua_load (
6240: p_effective_dt DATE,
6241: p_trace_on VARCHAR2,
6242: p_person_id hz_parties.party_id%TYPE,
6243: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6244: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6245: p_unit_cd igs_en_su_attempt_h_all.unit_cd%TYPE,
6246: p_unit_version_number igs_en_su_attempt_h_all.version_number%TYPE,
6247: p_cal_type igs_en_su_attempt_h_all.CAL_TYPE%TYPE,

Line 6244: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,

6240: p_effective_dt DATE,
6241: p_trace_on VARCHAR2,
6242: p_person_id hz_parties.party_id%TYPE,
6243: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6244: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6245: p_unit_cd igs_en_su_attempt_h_all.unit_cd%TYPE,
6246: p_unit_version_number igs_en_su_attempt_h_all.version_number%TYPE,
6247: p_cal_type igs_en_su_attempt_h_all.CAL_TYPE%TYPE,
6248: p_effective_start_dt igs_en_su_attempt_h_all.hist_start_dt%TYPE,

Line 6694: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

6690: ------------------------------------------------------------------------------
6691: FUNCTION finpl_clc_chg_mthd_elements(
6692: p_effective_dt DATE,
6693: p_trace_on VARCHAR2,
6694: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
6695: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

Line 6695: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

6691: FUNCTION finpl_clc_chg_mthd_elements(
6692: p_effective_dt DATE,
6693: p_trace_on VARCHAR2,
6694: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
6695: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,

Line 6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,

6692: p_effective_dt DATE,
6693: p_trace_on VARCHAR2,
6694: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
6695: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,

Line 6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,

6693: p_trace_on VARCHAR2,
6694: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
6695: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,

Line 6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

6694: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
6695: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
6696: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
6697: p_attendance_type igs_en_stdnt_ps_att_all.ATTENDANCE_TYPE%TYPE,
6698: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
6699: p_charge_method igs_fi_f_cat_fee_lbl_all.s_chg_method_type%TYPE,
6700: p_fee_cat IGS_FI_F_CAT_CA_INST.FEE_CAT%TYPE,
6701: p_fee_cal_type igs_fi_f_cat_fee_lbl_all.fee_cal_type%TYPE,
6702: p_fee_ci_sequence_number igs_fi_f_cat_fee_lbl_all.fee_ci_sequence_number%TYPE,

Line 6734: v_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;

6730: ***************************************************************/
6731: lv_param_values VARCHAR2(1080);
6732: BEGIN
6733: DECLARE
6734: v_version_number igs_en_stdnt_ps_att_all.version_number%TYPE;
6735: v_eftsu igs_fi_fee_as_all.chg_elements%TYPE;
6736: v_credit_points igs_fi_fee_as_all.chg_elements%TYPE;
6737: v_ret_true_flag BOOLEAN;
6738: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;

Line 6908: igs_en_stdnt_ps_att_all sca,

6904: spat.attendance_mode,
6905: spat.attendance_type,
6906: ps.course_type
6907: FROM igs_en_spa_terms spat,
6908: igs_en_stdnt_ps_att_all sca,
6909: igs_ps_ver_all ps,
6910: igs_lookups_view lkps
6911: WHERE spat.person_id = p_person_id
6912: AND spat.person_id = sca.person_id

Line 7722: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%tYPE,

7718: p_trace_on VARCHAR2,
7719: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
7720: p_fee_ci_sequence_num igs_ca_inst_all.sequence_number%TYPE,
7721: p_local_currency igs_fi_control_all.currency_cd%TYPE,
7722: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%tYPE,
7723: p_person_id hz_parties.party_id%TYPE,
7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,

Line 7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

7720: p_fee_ci_sequence_num igs_ca_inst_all.sequence_number%TYPE,
7721: p_local_currency igs_fi_control_all.currency_cd%TYPE,
7722: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%tYPE,
7723: p_person_id hz_parties.party_id%TYPE,
7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,

Line 7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,

7721: p_local_currency igs_fi_control_all.currency_cd%TYPE,
7722: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%tYPE,
7723: p_person_id hz_parties.party_id%TYPE,
7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,

Line 7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,

7722: p_fee_cat igs_en_stdnt_ps_att_all.fee_cat%tYPE,
7723: p_person_id hz_parties.party_id%TYPE,
7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,

Line 7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,

7723: p_person_id hz_parties.party_id%TYPE,
7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
7731: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

Line 7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,

7724: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
7731: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
7732: p_message_name OUT NOCOPY VARCHAR2,

Line 7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,

7725: p_course_version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
7731: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
7732: p_message_name OUT NOCOPY VARCHAR2,
7733: p_process_mode IN VARCHAR2 ,

Line 7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,

7726: p_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
7731: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
7732: p_message_name OUT NOCOPY VARCHAR2,
7733: p_process_mode IN VARCHAR2 ,
7734: p_c_career IN igs_ps_ver_all.course_type%TYPE,

Line 7731: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

7727: p_scahv_location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
7728: p_scahv_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
7729: p_scahv_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
7730: p_discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
7731: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
7732: p_message_name OUT NOCOPY VARCHAR2,
7733: p_process_mode IN VARCHAR2 ,
7734: p_c_career IN igs_ps_ver_all.course_type%TYPE,
7735: p_waiver_call_ind IN VARCHAR2,

Line 7761: cst_completed CONSTANT igs_en_stdnt_ps_att_all.course_attempt_status%TYPE := 'COMPLETED';

7757: PRAGMA EXCEPTION_INIT(e_lock_exception, -54);
7758:
7759: BEGIN
7760: DECLARE
7761: cst_completed CONSTANT igs_en_stdnt_ps_att_all.course_attempt_status%TYPE := 'COMPLETED';
7762: v_next_fcfl_flag BOOLEAN;
7763: v_charge_rate IGS_FI_FEE_AS_RATE.chg_rate%TYPE;
7764: v_charge_elements igs_fi_fee_as_all.chg_elements%TYPE;
7765: v_fee_assessment NUMBER;

Line 7777: l_v_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;

7773: v_fcfl_found BOOLEAN;
7774: v_message_name VARCHAR2(30);
7775: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
7776: l_n_rec_count NUMBER;
7777: l_v_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
7778: l_v_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE;
7779:
7780: inst_liable_prog_dummy_tbl inst_prog_det_tbl_typ;
7781:

Line 7778: l_v_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE;

7774: v_message_name VARCHAR2(30);
7775: v_trigger_fired fnd_lookup_values.lookup_code%TYPE;
7776: l_n_rec_count NUMBER;
7777: l_v_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
7778: l_v_attendance_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE;
7779:
7780: inst_liable_prog_dummy_tbl inst_prog_det_tbl_typ;
7781:
7782: CURSOR c_fcci_fss (

Line 7970: igs_en_stdnt_ps_att_all spa,

7966: spt.location_cd,
7967: spt.attendance_mode,
7968: spt.attendance_type
7969: FROM igs_en_spa_terms spt,
7970: igs_en_stdnt_ps_att_all spa,
7971: igs_ps_ver_all ps,
7972: igs_lookups_view lkps
7973: WHERE spt.person_id = spa.person_id
7974: AND spt.program_cd = spa.course_cd

Line 9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,

9172: program_cd igs_ps_ver_all.course_cd%TYPE,
9173: program_version igs_ps_ver_all.version_number%TYPE,
9174: career igs_ps_ver_all.course_type%TYPE,
9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,

Line 9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,

9173: program_version igs_ps_ver_all.version_number%TYPE,
9174: career igs_ps_ver_all.course_type%TYPE,
9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

Line 9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,

9174: career igs_ps_ver_all.course_type%TYPE,
9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,

Line 9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,

9175: fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,

Line 9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,

9176: crs_cal_type igs_en_stdnt_ps_att_all.cal_type%TYPE,
9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,

Line 9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9177: location_cd igs_en_stdnt_ps_att_all.location_cd%TYPE,
9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9185: adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,

Line 9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,

9178: att_mode igs_en_stdnt_ps_att_all.attendance_mode%TYPE,
9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9185: adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9186: adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE,

Line 9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,

9179: att_type igs_en_stdnt_ps_att_all.attendance_type%TYPE,
9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9185: adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9186: adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE,
9187: source VARCHAR2 (1)

Line 9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,

9180: key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9185: adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9186: adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE,
9187: source VARCHAR2 (1)
9188: );

Line 9185: adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,

9181: crs_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9185: adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9186: adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE,
9187: source VARCHAR2 (1)
9188: );
9189:

Line 9186: adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE,

9182: crs_commence_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
9183: disc_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
9184: adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9185: adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9186: adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE,
9187: source VARCHAR2 (1)
9188: );
9189:
9190: -- This table type will hold the assessable program details Under Predictive Mode of Processing.

Line 9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9203: cp_v_fee_category igs_fi_fee_cat_all.fee_cat%TYPE,
9204: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9205: cp_v_career igs_ps_ver_all.course_type%TYPE,
9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9210: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9211: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE

Line 9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9204: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9205: cp_v_career igs_ps_ver_all.course_type%TYPE,
9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9210: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9211: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE
9212: ) IS

Line 9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9205: cp_v_career igs_ps_ver_all.course_type%TYPE,
9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9210: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9211: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE
9212: ) IS
9213: SELECT spat.person_id,

Line 9210: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9206: cp_v_key_program_flag igs_en_spa_terms.key_program_flag%TYPE,
9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9210: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9211: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE
9212: ) IS
9213: SELECT spat.person_id,
9214: spat.program_cd,

Line 9211: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE

9207: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9208: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9209: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9210: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9211: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE
9212: ) IS
9213: SELECT spat.person_id,
9214: spat.program_cd,
9215: spat.program_version,

Line 9227: igs_en_stdnt_ps_att_all sca,

9223: sca.course_attempt_status,
9224: sca.commencement_dt,
9225: sca.discontinued_dt
9226: FROM igs_en_spa_terms spat,
9227: igs_en_stdnt_ps_att_all sca,
9228: igs_ps_ver_all psv
9229: WHERE spat.program_cd = psv.course_cd
9230: AND spat.program_version = psv.version_number
9231: AND spat.person_id = cp_n_person_id

Line 9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,

9265: CURSOR c_get_scas_recs(cp_n_person_id igs_fi_fee_as_items.person_id%TYPE,
9266: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9267: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9268: cp_v_career igs_ps_ver_all.course_type%TYPE,
9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

Line 9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,

9266: cp_v_fee_cat igs_fi_fee_cat_all.fee_cat%TYPE,
9267: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9268: cp_v_career igs_ps_ver_all.course_type%TYPE,
9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9274: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

Line 9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9267: cp_v_course_cd igs_ps_ver_all.course_cd%TYPE,
9268: cp_v_career igs_ps_ver_all.course_type%TYPE,
9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9274: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9275: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE ) IS

Line 9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9268: cp_v_career igs_ps_ver_all.course_type%TYPE,
9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9274: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9275: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE ) IS
9276: SELECT sca.person_id,

Line 9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9269: cp_v_primary_program_type igs_en_stdnt_ps_att_all.primary_program_type%TYPE,
9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9274: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9275: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE ) IS
9276: SELECT sca.person_id,
9277: sca.course_cd,

Line 9274: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

9270: cp_v_key_program igs_en_stdnt_ps_att_all.key_program%TYPE,
9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9274: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9275: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE ) IS
9276: SELECT sca.person_id,
9277: sca.course_cd,
9278: sca.version_number,

Line 9275: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE ) IS

9271: cp_v_course_attempt_status1 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9272: cp_v_course_attempt_status2 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9273: cp_v_course_attempt_status3 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9274: cp_v_course_attempt_status4 igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
9275: cp_v_future_dated_trans_flag igs_en_stdnt_ps_att_all.future_dated_trans_flag%TYPE ) IS
9276: SELECT sca.person_id,
9277: sca.course_cd,
9278: sca.version_number,
9279: psv.course_type,

Line 9292: FROM igs_en_stdnt_ps_att_all sca,

9288: sca.discontinued_dt,
9289: sca.adm_admission_appl_number,
9290: sca.adm_nominated_course_cd,
9291: sca.adm_sequence_number
9292: FROM igs_en_stdnt_ps_att_all sca,
9293: igs_ps_ver_all psv
9294: WHERE sca.course_cd = psv.course_cd
9295: AND sca. version_number = psv.version_number
9296: AND sca.person_id = cp_n_person_id

Line 9402: cp_n_adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,

9398: l_d_int_end_dt igs_en_stdnt_ps_intm.end_dt%TYPE;
9399:
9400: -- Cursor to get the admission offer response status and admission calendar instance details
9401: CURSOR c_adm_details ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9402: cp_n_adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9403: cp_v_adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9404: cp_n_adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE ) IS
9405: SELECT off.s_adm_offer_resp_status,
9406: app.adm_cal_type,

Line 9403: cp_v_adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,

9399:
9400: -- Cursor to get the admission offer response status and admission calendar instance details
9401: CURSOR c_adm_details ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9402: cp_n_adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9403: cp_v_adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9404: cp_n_adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE ) IS
9405: SELECT off.s_adm_offer_resp_status,
9406: app.adm_cal_type,
9407: app.adm_ci_sequence_number

Line 9404: cp_n_adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE ) IS

9400: -- Cursor to get the admission offer response status and admission calendar instance details
9401: CURSOR c_adm_details ( cp_n_person_id igs_en_stdnt_ps_intm.person_id%TYPE,
9402: cp_n_adm_admission_appl_number igs_en_stdnt_ps_att_all.adm_admission_appl_number%TYPE,
9403: cp_v_adm_nominated_course_cd igs_en_stdnt_ps_att_all.adm_nominated_course_cd%TYPE,
9404: cp_n_adm_sequence_number igs_en_stdnt_ps_att_all.adm_sequence_number%TYPE ) IS
9405: SELECT off.s_adm_offer_resp_status,
9406: app.adm_cal_type,
9407: app.adm_ci_sequence_number
9408: FROM igs_ad_ps_appl_inst_all apl_in,