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.

[Home] [Help]

APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 606: PROCEDURE finpl_get_unit_type_level(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

602: END IF;
603:
604: END get_stdnt_unit_set_dtls;
605:
606: PROCEDURE finpl_get_unit_type_level(p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
607: p_n_unit_prg_type_level OUT NOCOPY igs_ps_unit_ver_all.unit_type_id%TYPE,
608: p_v_unit_level OUT NOCOPY igs_ps_unit_ver_all.unit_level%TYPE ) AS
609:
610: /*************************************************************

Line 621: CURSOR cur_unit_type_level (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

617: Change History
618: Who When What
619: ***************************************************************/
620:
621: CURSOR cur_unit_type_level (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
622: SELECT uv.unit_type_id, uv.unit_level
623: FROM igs_ps_unit_ver_all uv,
624: igs_ps_unit_ofr_opt_all uoo
625: WHERE uv.unit_cd = uoo.unit_cd

Line 624: igs_ps_unit_ofr_opt_all uoo

620:
621: CURSOR cur_unit_type_level (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
622: SELECT uv.unit_type_id, uv.unit_level
623: FROM igs_ps_unit_ver_all uv,
624: igs_ps_unit_ofr_opt_all uoo
625: WHERE uv.unit_cd = uoo.unit_cd
626: AND uv.version_number = uoo.version_number
627: AND uoo.uoo_id = cp_n_uoo_id;
628:

Line 687: PROCEDURE finpl_get_unit_class_mode( p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,

683:
684: END finpl_get_uptl;
685:
686:
687: PROCEDURE finpl_get_unit_class_mode( p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
688: p_v_unit_class OUT NOCOPY igs_as_unit_class_all.unit_class%TYPE,
689: p_v_unit_mode OUT NOCOPY igs_as_unit_class_all.unit_mode%TYPE ) AS
690:
691: /*************************************************************

Line 701: CURSOR cur_unit_class_mode (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

697:
698: Change History
699: Who When What
700: ***************************************************************/
701: CURSOR cur_unit_class_mode (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
702: SELECT uc.unit_class, uc.unit_mode
703: FROM igs_as_unit_class_all uc,
704: igs_ps_unit_ofr_opt_all uoo
705: WHERE uc.unit_class = uoo.unit_class

Line 704: igs_ps_unit_ofr_opt_all uoo

700: ***************************************************************/
701: CURSOR cur_unit_class_mode (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
702: SELECT uc.unit_class, uc.unit_mode
703: FROM igs_as_unit_class_all uc,
704: igs_ps_unit_ofr_opt_all uoo
705: WHERE uc.unit_class = uoo.unit_class
706: AND uoo.uoo_id = p_n_uoo_id;
707:
708: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;

Line 884: CURSOR cur_non_std_usec(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

880: AND uoo_id = cp_n_uoo_id
881: ORDER BY discontinued_dt;
882:
883: -- Cursor to determine if a given Unit Section is Non-Standard
884: CURSOR cur_non_std_usec(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
885: SELECT non_std_usec_ind
886: FROM igs_ps_unit_ofr_opt_all
887: WHERE uoo_id = cp_n_uoo_id;
888:

Line 886: FROM igs_ps_unit_ofr_opt_all

882:
883: -- Cursor to determine if a given Unit Section is Non-Standard
884: CURSOR cur_non_std_usec(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
885: SELECT non_std_usec_ind
886: FROM igs_ps_unit_ofr_opt_all
887: WHERE uoo_id = cp_n_uoo_id;
888:
889: l_v_load_incurred VARCHAR2(1) := NULL;
890: l_v_non_std_usec VARCHAR2(1) := NULL;

Line 1671: CURSOR c_org_unit_sec_cd(cp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

1667: WHERE v.course_cd = cp_course_cd
1668: AND v.version_number = cp_version_number;
1669:
1670: -- To find the organization unit code from the Unit Section Level
1671: CURSOR c_org_unit_sec_cd(cp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
1672: SELECT owner_org_unit_cd, location_cd
1673: FROM igs_ps_unit_ofr_opt_all
1674: WHERE uoo_id = cp_uoo_id;
1675:

Line 1673: FROM igs_ps_unit_ofr_opt_all

1669:
1670: -- To find the organization unit code from the Unit Section Level
1671: CURSOR c_org_unit_sec_cd(cp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
1672: SELECT owner_org_unit_cd, location_cd
1673: FROM igs_ps_unit_ofr_opt_all
1674: WHERE uoo_id = cp_uoo_id;
1675:
1676: CURSOR cur_unit_cd (cp_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE) IS
1677: SELECT unit_cd, version_number

Line 1678: FROM igs_ps_unit_ofr_opt_all

1674: WHERE uoo_id = cp_uoo_id;
1675:
1676: CURSOR cur_unit_cd (cp_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE) IS
1677: SELECT unit_cd, version_number
1678: FROM igs_ps_unit_ofr_opt_all
1679: WHERE uoo_id = cp_n_uoo_id;
1680:
1681: FUNCTION finpl_ins_match_chg_rate(
1682: p_rate_location_cd igs_fi_fee_as_rate.location_cd%TYPE,

Line 5093: FROM igs_ps_unit_ofr_opt_all

5089: AND sua.course_cd = cp_v_course_cd;
5090:
5091: CURSOR cur_unit_cd (cp_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE) IS
5092: SELECT unit_cd, version_number
5093: FROM igs_ps_unit_ofr_opt_all
5094: WHERE uoo_id = cp_n_uoo_id;
5095:
5096: l_v_optional_ind igs_fi_fee_type_all.optional_payment_ind%TYPE := NULL;
5097: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;

Line 5105: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;

5101: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
5102: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
5103: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
5104: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
5105: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%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;

Line 5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;

5102: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
5103: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
5104: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
5105: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
5106: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%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;

Line 6311: CURSOR c_org_unit_sec_cd(cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,

6307:
6308: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
6309: -- CREDIT_POINT or PERUNIT)Note : If the above cursor c_org_unit_cd returns no rows,the
6310: -- Organization Unit Code from this cursor is used.
6311: CURSOR c_org_unit_sec_cd(cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
6312: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
6313: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
6314: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,

Line 6312: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE,

6308: -- To find the organization unit code from the Student Attempt Table (For Charge Method of
6309: -- CREDIT_POINT or PERUNIT)Note : If the above cursor c_org_unit_cd returns no rows,the
6310: -- Organization Unit Code from this cursor is used.
6311: CURSOR c_org_unit_sec_cd(cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
6312: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
6313: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
6314: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
6316: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE

Line 6313: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,

6309: -- CREDIT_POINT or PERUNIT)Note : If the above cursor c_org_unit_cd returns no rows,the
6310: -- Organization Unit Code from this cursor is used.
6311: CURSOR c_org_unit_sec_cd(cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
6312: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
6313: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
6314: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
6316: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE
6317: ) IS

Line 6314: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

6310: -- Organization Unit Code from this cursor is used.
6311: CURSOR c_org_unit_sec_cd(cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
6312: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
6313: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
6314: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
6316: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE
6317: ) IS
6318: SELECT owner_org_unit_cd -- this column is added as a part of Unit Section Reference information Build

Line 6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,

6311: CURSOR c_org_unit_sec_cd(cp_unit_cd IN igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
6312: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
6313: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
6314: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
6316: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE
6317: ) IS
6318: SELECT owner_org_unit_cd -- this column is added as a part of Unit Section Reference information Build
6319: FROM igs_ps_unit_ofr_opt_all uoo

Line 6316: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE

6312: cp_version_number IN igs_ps_unit_ofr_opt_all.version_number%TYPE,
6313: cp_cal_type IN igs_ps_unit_ofr_opt_all.cal_type%TYPE,
6314: cp_ci_sequence_number IN igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,
6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
6316: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE
6317: ) IS
6318: SELECT owner_org_unit_cd -- this column is added as a part of Unit Section Reference information Build
6319: FROM igs_ps_unit_ofr_opt_all uoo
6320: WHERE uoo.unit_cd = cp_unit_cd

Line 6319: FROM igs_ps_unit_ofr_opt_all uoo

6315: cp_location_cd IN igs_ps_unit_ofr_opt_all.location_cd%TYPE,
6316: cp_unit_class IN igs_ps_unit_ofr_opt_all.unit_class%TYPE
6317: ) IS
6318: SELECT owner_org_unit_cd -- this column is added as a part of Unit Section Reference information Build
6319: FROM igs_ps_unit_ofr_opt_all uoo
6320: WHERE uoo.unit_cd = cp_unit_cd
6321: AND uoo.version_number = cp_version_number
6322: AND uoo.cal_type = cp_cal_type
6323: AND uoo.ci_sequence_number = cp_ci_sequence_number

Line 6787: igs_ps_unit_ofr_opt_all uoo

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
6790: AND lkp.fee_ass_ind = cp_v_fee_ass_indicator
6791: AND (sua.no_assessment_ind = cp_v_fee_ass_ind OR cp_v_fee_ass_ind IS NULL)

Line 6851: igs_ps_unit_ofr_opt_all uoo

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
6853: sua.person_id = terms.person_id AND
6854: sua.course_cd = terms.program_cd AND
6855: uoo.uoo_id = sua.uoo_id AND

Line 6936: FROM igs_ps_unit_ofr_opt_all

6932: AND fee_ci_sequence_number = cp_n_fee_ci_seq_number;
6933:
6934: CURSOR cur_unit_cd (cp_n_uoo_id igs_fi_fee_as_items.uoo_id%TYPE) IS
6935: SELECT unit_cd, version_number
6936: FROM igs_ps_unit_ofr_opt_all
6937: WHERE uoo_id = cp_n_uoo_id;
6938:
6939: CURSOR cur_get_ret_level (cp_v_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
6940: cp_v_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,

Line 6981: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;

6977: l_v_unit_class igs_as_unit_class_all.unit_class%TYPE;
6978: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
6979: l_n_count NUMBER;
6980: l_b_rule BOOLEAN;
6981: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
6982: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
6983: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
6984: l_v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
6985: l_v_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;

Line 6982: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;

6978: l_v_unit_mode igs_as_unit_class_all.unit_mode%TYPE;
6979: l_n_count NUMBER;
6980: l_b_rule BOOLEAN;
6981: l_v_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE;
6982: l_n_version_num igs_ps_unit_ofr_opt_all.version_number%TYPE;
6983: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
6984: l_v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
6985: l_v_unit_set_cd igs_as_su_setatmpt.unit_set_cd%TYPE;
6986: l_n_us_version_num igs_as_su_setatmpt.us_version_number%TYPE;