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.IGF_GR_PELL_CALC dependencies on IGS_CA_INST_ALL

Line 52: PROCEDURE get_pm_3_acad_term_wks(p_cal_type igs_ca_inst_all.cal_type%TYPE,

48: *===================================================================================================================*/
49:
50: NO_SETUP EXCEPTION;
51:
52: PROCEDURE get_pm_3_acad_term_wks(p_cal_type igs_ca_inst_all.cal_type%TYPE,
53: p_seq_number igs_ca_inst_all.sequence_number%TYPE,
54: p_course_cd igs_en_psv_term_it.course_cd%TYPE,
55: p_version_number igs_en_psv_term_it.version_number%TYPE,
56: p_term_weeks OUT NOCOPY NUMBER,

Line 53: p_seq_number igs_ca_inst_all.sequence_number%TYPE,

49:
50: NO_SETUP EXCEPTION;
51:
52: PROCEDURE get_pm_3_acad_term_wks(p_cal_type igs_ca_inst_all.cal_type%TYPE,
53: p_seq_number igs_ca_inst_all.sequence_number%TYPE,
54: p_course_cd igs_en_psv_term_it.course_cd%TYPE,
55: p_version_number igs_en_psv_term_it.version_number%TYPE,
56: p_term_weeks OUT NOCOPY NUMBER,
57: p_acad_weeks OUT NOCOPY NUMBER,

Line 88: igs_ca_inst_all

84: IS
85: SELECT
86: term_instruction_time
87: FROM
88: igs_ca_inst_all
89: WHERE
90: cal_type = p_cal_type AND
91: sequence_number = p_seq_number;
92:

Line 909: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

905: l_chk_enr_rec c_chk_enr%ROWTYPE;
906:
907: CURSOR c_get_ant_atype(
908: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
909: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
910: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
911: ) IS
912: SELECT pell.pell_att_code attendance_type
913: FROM igf_ap_fa_ant_data ant,

Line 910: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE

906:
907: CURSOR c_get_ant_atype(
908: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
909: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
910: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
911: ) IS
912: SELECT pell.pell_att_code attendance_type
913: FROM igf_ap_fa_ant_data ant,
914: igf_ap_attend_map pell,

Line 1367: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

1363: END get_pell_matrix_amt ;
1364:
1365: FUNCTION num_disb(
1366: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1367: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1368: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1369: ) RETURN NUMBER AS
1370: ------------------------------------------------------------------
1371: --Created by : veramach, Oracle India

Line 1368: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE

1364:
1365: FUNCTION num_disb(
1366: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1367: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1368: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1369: ) RETURN NUMBER AS
1370: ------------------------------------------------------------------
1371: --Created by : veramach, Oracle India
1372: --Date created: 24/August/2005

Line 1386: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

1382:
1383: -- Get number of disbursements
1384: CURSOR c_num_disb(
1385: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1386: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1387: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1388: ) IS
1389: SELECT COUNT (*) num_disb
1390: FROM igf_aw_dp_terms terms,

Line 1387: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE

1383: -- Get number of disbursements
1384: CURSOR c_num_disb(
1385: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1386: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1387: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1388: ) IS
1389: SELECT COUNT (*) num_disb
1390: FROM igf_aw_dp_terms terms,
1391: igf_aw_dp_teach_prds teach_periods

Line 1410: p_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1406: PROCEDURE round_term_disbursements (
1407: p_pell_tab IN OUT NOCOPY pell_tab,
1408: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1409: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1410: p_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1411: p_ld_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1412: p_term_amt IN NUMBER,
1413: p_tp_count IN NUMBER,
1414: p_pkg_awd_status IN igf_aw_fund_mast_all.pckg_awd_stat%TYPE,

Line 1411: p_ld_seq_num IN igs_ca_inst_all.sequence_number%TYPE,

1407: p_pell_tab IN OUT NOCOPY pell_tab,
1408: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1409: p_dist_plan_code IN igf_aw_awd_dist_plans.dist_plan_method_code%TYPE,
1410: p_ld_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1411: p_ld_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
1412: p_term_amt IN NUMBER,
1413: p_tp_count IN NUMBER,
1414: p_pkg_awd_status IN igf_aw_fund_mast_all.pckg_awd_stat%TYPE,
1415: p_return_status OUT NOCOPY VARCHAR2