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_PS_UNIT_VER_ALL

Line 607: p_n_unit_prg_type_level OUT NOCOPY igs_ps_unit_ver_all.unit_type_id%TYPE,

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: /*************************************************************
611: Created By : Bhaskar Annamalai

Line 608: p_v_unit_level OUT NOCOPY igs_ps_unit_ver_all.unit_level%TYPE ) AS

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: /*************************************************************
611: Created By : Bhaskar Annamalai
612: Date Created By : 03-JUN-2005

Line 623: FROM igs_ps_unit_ver_all uv,

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
626: AND uv.version_number = uoo.version_number
627: AND uoo.uoo_id = cp_n_uoo_id;

Line 629: l_n_unit_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;

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:
629: l_n_unit_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
630: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
631:
632: BEGIN
633: p_n_unit_prg_type_level := NULL;

Line 630: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;

626: AND uv.version_number = uoo.version_number
627: AND uoo.uoo_id = cp_n_uoo_id;
628:
629: l_n_unit_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
630: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;
631:
632: BEGIN
633: p_n_unit_prg_type_level := NULL;
634: p_v_unit_level := NULL;

Line 1688: p_rate_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,

1684: p_rate_attendance_mode igs_fi_fee_as_rate.attendance_mode%TYPE,
1685: p_rate_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1686: p_rate_course_cd igs_ps_ver_all.course_cd%TYPE,
1687: p_rate_version_number igs_ps_ver_all.version_number%TYPE,
1688: p_rate_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1689: p_rate_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1690: p_derived_location_cd igs_fi_fee_as_rate.location_cd%TYPE,
1691: p_derived_attendance_type igs_fi_fee_as_rate.attendance_type%TYPE,
1692: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,

Line 1697: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,

1693: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,
1694: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
1695: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
1696: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
1697: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
1698: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
1699: p_rate_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,
1700: p_rate_us_version_num igs_fi_fee_as_rate.us_version_number%TYPE,
1701: p_derived_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE,

Line 2388: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,

2384: p_derived_govt_att_mode igs_en_atd_mode_all.govt_attendance_mode%TYPE,
2385: p_derived_prog_att_mode igs_en_atd_mode_all.attendance_mode%TYPE,
2386: p_trace_on VARCHAR2,
2387: p_derived_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE,
2388: p_derived_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE,
2389: p_derived_course_cd igs_ps_ver_all.course_cd%TYPE,
2390: p_derived_version_number igs_ps_ver_all.version_number%TYPE,
2391: p_derived_class_standing IGS_PR_CLASS_STD.CLASS_STANDING%TYPE,
2392: p_charge_rate OUT NOCOPY IGS_FI_FEE_AS_RATE.chg_rate%TYPE,

Line 2431: v_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;

2427: v_rate_number igs_fi_fee_as_rate.rate_number%TYPE;
2428: v_fee_ass_rate_match BOOLEAN;
2429: l_b_fee_ass_rate_found BOOLEAN;
2430: v_residency_status_cd igs_pe_res_dtls_all.residency_status_cd%TYPE;
2431: v_org_unit_cd igs_ps_unit_ver_all.owner_org_unit_cd%TYPE;
2432: v_course_cd igs_fi_fee_as_rate.course_cd%TYPE;
2433: v_version_number igs_fi_fee_as_rate.version_number%TYPE;
2434: v_class_standing igs_fi_fee_as_rate.class_standing%TYPE;
2435: v_unit_set_cd igs_fi_fee_as_rate.unit_set_cd%TYPE := NULL;

Line 5101: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;

5097: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;
5098: l_v_fee_ass_ind VARCHAR2(1);
5099: l_n_chg_elements igs_fi_fee_as_items.chg_elements%TYPE;
5100: l_n_count NUMBER;
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;

Line 5102: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;

5098: l_v_fee_ass_ind VARCHAR2(1);
5099: l_n_chg_elements igs_fi_fee_as_items.chg_elements%TYPE;
5100: l_n_count NUMBER;
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;

Line 6975: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;

6971: l_v_org_unit_cd VARCHAR2(30);
6972: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;
6973: l_n_crs_version_number igs_fi_Fee_as_items.crs_version_number%TYPE;
6974:
6975: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
6976: l_v_unit_level igs_ps_unit_ver_all.unit_level%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;

Line 6976: l_v_unit_level igs_ps_unit_ver_all.unit_level%TYPE;

6972: l_v_nz_bill_cp_flag igs_fi_f_typ_ca_inst_all.nonzero_billable_cp_flag%TYPE;
6973: l_n_crs_version_number igs_fi_Fee_as_items.crs_version_number%TYPE;
6974:
6975: l_n_prg_type_level igs_ps_unit_ver_all.unit_type_id%TYPE;
6976: l_v_unit_level igs_ps_unit_ver_all.unit_level%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;