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

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 272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,

268:
269: PROCEDURE get_pell_setup ( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,
275: cp_message OUT NOCOPY VARCHAR2,
276: cp_return_status OUT NOCOPY VARCHAR2

Line 273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,

269: PROCEDURE get_pell_setup ( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,
275: cp_message OUT NOCOPY VARCHAR2,
276: cp_return_status OUT NOCOPY VARCHAR2
277: )

Line 301: l_cal_type igs_ca_inst.cal_type%TYPE,

297: || CDCRUZ 19-NOV-2003 BUG# 3252832 FA-131 Cod updates
298: */
299:
300: CURSOR c_get_rep_pell_id(
301: l_cal_type igs_ca_inst.cal_type%TYPE,
302: l_seq_num igs_ca_inst.sequence_number%TYPE,
303: l_att_pell_id igf_gr_pell_setup_all.rep_pell_id%TYPE
304: )
305: IS

Line 302: l_seq_num igs_ca_inst.sequence_number%TYPE,

298: */
299:
300: CURSOR c_get_rep_pell_id(
301: l_cal_type igs_ca_inst.cal_type%TYPE,
302: l_seq_num igs_ca_inst.sequence_number%TYPE,
303: l_att_pell_id igf_gr_pell_setup_all.rep_pell_id%TYPE
304: )
305: IS
306: SELECT rep.reporting_pell_cd

Line 353: l_cal_type igs_ca_inst.cal_type%TYPE,

349:
350:
351: -- Entity ID declarations
352: CURSOR c_get_rep_entity_id_txt(
353: l_cal_type igs_ca_inst.cal_type%TYPE,
354: l_seq_num igs_ca_inst.sequence_number%TYPE,
355: l_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
356: )
357: IS

Line 354: l_seq_num igs_ca_inst.sequence_number%TYPE,

350:
351: -- Entity ID declarations
352: CURSOR c_get_rep_entity_id_txt(
353: l_cal_type igs_ca_inst.cal_type%TYPE,
354: l_seq_num igs_ca_inst.sequence_number%TYPE,
355: l_atd_entity_id igf_gr_attend_pell.atd_entity_id_txt%TYPE
356: )
357: IS
358: SELECT rep.rep_entity_id_txt

Line 804: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

800: END get_pell_coa_efc;
801:
802: PROCEDURE get_pell_attendance_type (
803: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
804: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
805: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
806: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
807: cp_attendance_type IN OUT NOCOPY igf_ap_attend_map.attendance_type%TYPE,
808: cp_message OUT NOCOPY VARCHAR2,

Line 805: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

801:
802: PROCEDURE get_pell_attendance_type (
803: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
804: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
805: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
806: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
807: cp_attendance_type IN OUT NOCOPY igf_ap_attend_map.attendance_type%TYPE,
808: cp_message OUT NOCOPY VARCHAR2,
809: cp_return_status OUT NOCOPY VARCHAR2

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 1194: cp_cal_type IN igs_ca_inst.cal_type%TYPE,

1190:
1191: END get_pell_attendance_type;
1192:
1193: PROCEDURE get_pell_matrix_amt(
1194: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
1195: cp_sequence_num IN igs_ca_inst.sequence_number%TYPE,
1196: cp_efc IN NUMBER,
1197: cp_pell_schd IN VARCHAR2,
1198: cp_enrl_stat IN VARCHAR2,

Line 1195: cp_sequence_num IN igs_ca_inst.sequence_number%TYPE,

1191: END get_pell_attendance_type;
1192:
1193: PROCEDURE get_pell_matrix_amt(
1194: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
1195: cp_sequence_num IN igs_ca_inst.sequence_number%TYPE,
1196: cp_efc IN NUMBER,
1197: cp_pell_schd IN VARCHAR2,
1198: cp_enrl_stat IN VARCHAR2,
1199: cp_pell_coa IN NUMBER,

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

Line 2062: cp_tp_Cal_type igs_ca_inst.cal_type%TYPE,

2058:
2059: l_fund_rec c_fund%ROWTYPE;
2060:
2061: CURSOR c_get_ofst( cp_ofst_da igs_ca_da.dt_alias%TYPE,
2062: cp_tp_Cal_type igs_ca_inst.cal_type%TYPE,
2063: cp_ci_sequence igs_ca_inst.sequence_number%TYPE,
2064: cp_cur_da igs_ca_da.dt_alias%TYPE) IS
2065: SELECT dai.absolute_val ofst_absolute_val,
2066: dai.derived_val ofst_derived_val

Line 2063: cp_ci_sequence igs_ca_inst.sequence_number%TYPE,

2059: l_fund_rec c_fund%ROWTYPE;
2060:
2061: CURSOR c_get_ofst( cp_ofst_da igs_ca_da.dt_alias%TYPE,
2062: cp_tp_Cal_type igs_ca_inst.cal_type%TYPE,
2063: cp_ci_sequence igs_ca_inst.sequence_number%TYPE,
2064: cp_cur_da igs_ca_da.dt_alias%TYPE) IS
2065: SELECT dai.absolute_val ofst_absolute_val,
2066: dai.derived_val ofst_derived_val
2067: FROM igs_ca_da_inst_ofst ofst,

Line 2190: term_ld_cal_type igs_ca_inst.cal_type%TYPE,

2186: l_get_ant_key_prog_ver_rec cur_get_ant_key_prog_ver%ROWTYPE;
2187:
2188: -- museshad (Build# FA 157 Pell disbursement rounding)
2189: TYPE pell_term_rec IS RECORD(
2190: term_ld_cal_type igs_ca_inst.cal_type%TYPE,
2191: term_ld_seq_num igs_ca_inst.sequence_number%TYPE,
2192: term_amt NUMBER,
2193: tp_count NUMBER
2194: );

Line 2191: term_ld_seq_num igs_ca_inst.sequence_number%TYPE,

2187:
2188: -- museshad (Build# FA 157 Pell disbursement rounding)
2189: TYPE pell_term_rec IS RECORD(
2190: term_ld_cal_type igs_ca_inst.cal_type%TYPE,
2191: term_ld_seq_num igs_ca_inst.sequence_number%TYPE,
2192: term_amt NUMBER,
2193: tp_count NUMBER
2194: );
2195: TYPE pell_term_tab IS TABLE OF pell_term_rec;

Line 3176: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,

3172:
3173: PROCEDURE calc_term_pell(
3174: cp_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
3175: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,
3176: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
3177: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
3178: cp_term_aid IN OUT NOCOPY NUMBER,
3179: cp_return_status IN OUT NOCOPY VARCHAR2,
3180: cp_message IN OUT NOCOPY VARCHAR2,

Line 3177: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,

3173: PROCEDURE calc_term_pell(
3174: cp_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
3175: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,
3176: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
3177: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
3178: cp_term_aid IN OUT NOCOPY NUMBER,
3179: cp_return_status IN OUT NOCOPY VARCHAR2,
3180: cp_message IN OUT NOCOPY VARCHAR2,
3181: cp_called_from IN VARCHAR2,

Line 3218: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,

3214:
3215: -- Gets FA Anticipated key program details
3216: CURSOR cur_get_ant_key_prog_ver(
3217: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
3218: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
3219: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
3220: )
3221: IS
3222: SELECT

Line 3219: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE

3215: -- Gets FA Anticipated key program details
3216: CURSOR cur_get_ant_key_prog_ver(
3217: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
3218: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
3219: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
3220: )
3221: IS
3222: SELECT
3223: ant_data.program_cd key_prog,