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_DB_DISB dependencies on IGS_CA_INST

Line 280: FUNCTION get_cut_off_dt ( p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE,

276: igs_ge_msg_stack.add;
277:
278: END log_parameters;
279:
280: FUNCTION get_cut_off_dt ( p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE,
281: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE)
282: RETURN DATE
283: IS
284:

Line 294: CURSOR cur_get_eff_date ( p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE )

290: -- to be paased to enrolment api for getting
291: -- poin-in-time credit points
292: --
293:
294: CURSOR cur_get_eff_date ( p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE )
295: IS
296: SELECT
297: start_dt,end_dt
298: FROM

Line 299: igs_ca_inst

295: IS
296: SELECT
297: start_dt,end_dt
298: FROM
299: igs_ca_inst
300: WHERE
301: p_ld_seq_num = sequence_number;
302:
303: get_eff_date_rec cur_get_eff_date%ROWTYPE;

Line 434: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,

430: person_id = p_person_id;
431:
432: get_pers_num_rec cur_get_pers_num%ROWTYPE;
433:
434: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,
435: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
436: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
437: IS
438: SELECT

Line 435: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,

431:
432: get_pers_num_rec cur_get_pers_num%ROWTYPE;
433:
434: CURSOR cur_get_base (p_cal_type igs_ca_inst_all.cal_type%TYPE,
435: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
436: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
437: IS
438: SELECT
439: base_id

Line 1344: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,

1340: END chk_todo_result;
1341:
1342:
1343: PROCEDURE insert_pays_prg_uts(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1344: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1345: p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)
1346: AS
1347: --------------------------------------------------------------------------------------------
1348: --

Line 1345: p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)

1341:
1342:
1343: PROCEDURE insert_pays_prg_uts(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1344: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1345: p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)
1346: AS
1347: --------------------------------------------------------------------------------------------
1348: --
1349: -- Created By : sjadhav

Line 1358: CURSOR cur_get_acad_tp (p_acad_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

1354: --------------------------------------------------------------------------------------------
1355:
1356:
1357: -- Get all the teaching periods for the academic calendar instance
1358: CURSOR cur_get_acad_tp (p_acad_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1359: p_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1360: IS
1361: SELECT
1362: sub_cal_type tp_cal_type,

Line 1359: p_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1355:
1356:
1357: -- Get all the teaching periods for the academic calendar instance
1358: CURSOR cur_get_acad_tp (p_acad_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1359: p_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1360: IS
1361: SELECT
1362: sub_cal_type tp_cal_type,
1363: sub_ci_sequence_number tp_sequence_number

Line 1365: igs_ca_inst_rel cr_1,

1361: SELECT
1362: sub_cal_type tp_cal_type,
1363: sub_ci_sequence_number tp_sequence_number
1364: FROM
1365: igs_ca_inst_rel cr_1,
1366: igs_ca_type ct_1,
1367: igs_ca_type ct_2
1368: WHERE
1369: ct_1.cal_type = cr_1.sup_cal_type AND

Line 1381: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,

1377:
1378: -- Get all the programs,unit attempts in which student has 'enrolled'
1379:
1380: CURSOR cur_get_att(p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1381: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1382: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1384: IS
1385: SELECT

Line 1382: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,

1378: -- Get all the programs,unit attempts in which student has 'enrolled'
1379:
1380: CURSOR cur_get_att(p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1381: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1382: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1384: IS
1385: SELECT
1386: pg.course_cd prg_course_cd,

Line 1383: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1379:
1380: CURSOR cur_get_att(p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1381: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1382: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,
1383: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1384: IS
1385: SELECT
1386: pg.course_cd prg_course_cd,
1387: pg.version_number prg_ver_num,

Line 1404: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

1400: pg.course_cd(+) = su.course_cd;
1401:
1402: get_att_rec cur_get_att%ROWTYPE;
1403:
1404: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1405: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1406: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1407:
1408: dbpays_rec igf_db_pays_prg_t%ROWTYPE;

Line 1405: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

1401:
1402: get_att_rec cur_get_att%ROWTYPE;
1403:
1404: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1405: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1406: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1407:
1408: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1409: lv_rowid ROWID;

Line 1406: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;

1402: get_att_rec cur_get_att%ROWTYPE;
1403:
1404: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1405: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1406: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1407:
1408: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1409: lv_rowid ROWID;
1410:

Line 1722: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

1718: END chk_fed_elig;
1719:
1720: FUNCTION chk_fclass_result(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1721: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1722: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1723: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1724: RETURN BOOLEAN
1725:
1726: AS

Line 1723: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1719:
1720: FUNCTION chk_fclass_result(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1721: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1722: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1723: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1724: RETURN BOOLEAN
1725:
1726: AS
1727: --------------------------------------------------------------------------------------------

Line 1736: p_fee_cal_type igs_ca_inst.cal_type%TYPE;

1732: --
1733: --------------------------------------------------------------------------------------------
1734:
1735:
1736: p_fee_cal_type igs_ca_inst.cal_type%TYPE;
1737: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1738: p_message_name fnd_new_messages.message_name%TYPE;
1739:
1740: --

Line 1737: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

1733: --------------------------------------------------------------------------------------------
1734:
1735:
1736: p_fee_cal_type igs_ca_inst.cal_type%TYPE;
1737: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1738: p_message_name fnd_new_messages.message_name%TYPE;
1739:
1740: --
1741: -- This cursor will retreive records from fund setup for pays only Fee Class

Line 1761: p_fee_cal_type igs_ca_inst.cal_type%TYPE,

1757: -- fund setup and persons charges
1758: --
1759:
1760: CURSOR cur_fee_cls ( p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1761: p_fee_cal_type igs_ca_inst.cal_type%TYPE,
1762: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1763: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
1764: IS
1765: SELECT

Line 1762: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,

1758: --
1759:
1760: CURSOR cur_fee_cls ( p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1761: p_fee_cal_type igs_ca_inst.cal_type%TYPE,
1762: p_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
1763: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
1764: IS
1765: SELECT
1766: fee_class

Line 1842: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

1838:
1839: END chk_fclass_result;
1840:
1841: FUNCTION chk_att_result(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1842: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1843: p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,
1844: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,
1845: p_result OUT NOCOPY VARCHAR2
1846: )

Line 1843: p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,

1839: END chk_fclass_result;
1840:
1841: FUNCTION chk_att_result(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1842: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1843: p_ld_seq_number igs_ca_inst_all.sequence_number%TYPE,
1844: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,
1845: p_result OUT NOCOPY VARCHAR2
1846: )
1847: RETURN BOOLEAN

Line 1857: CURSOR cur_get_rng(p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

1853: -- Purpose : This Process evaluates min attendance for student
1854: --
1855: --------------------------------------------------------------------------------------------
1856:
1857: CURSOR cur_get_rng(p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1858: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE)
1859: IS
1860: SELECT
1861: upper_enr_load_range

Line 1937: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,

1933: PROCEDURE disb_verf_enf(p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1934: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1935: p_key_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1936: p_key_ver_num igs_en_stdnt_ps_att.version_number%TYPE,
1937: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1938: p_acad_seq_num igs_ca_inst_all.sequence_number%TYPE)
1939:
1940: AS
1941: --------------------------------------------------------------------------------------------

Line 1938: p_acad_seq_num igs_ca_inst_all.sequence_number%TYPE)

1934: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1935: p_key_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
1936: p_key_ver_num igs_en_stdnt_ps_att.version_number%TYPE,
1937: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1938: p_acad_seq_num igs_ca_inst_all.sequence_number%TYPE)
1939:
1940: AS
1941: --------------------------------------------------------------------------------------------
1942: --

Line 2011: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

2007:
2008: lv_fund_type VARCHAR2(1);
2009: p_message VARCHAR2(4000);
2010: ln_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
2011: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
2012: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2013: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
2014:
2015:

Line 2012: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

2008: lv_fund_type VARCHAR2(1);
2009: p_message VARCHAR2(4000);
2010: ln_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
2011: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
2012: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2013: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
2014:
2015:
2016: -- following variables are used to make sure that the fund level,award level and term level

Line 2013: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;

2009: p_message VARCHAR2(4000);
2010: ln_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
2011: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
2012: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2013: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
2014:
2015:
2016: -- following variables are used to make sure that the fund level,award level and term level
2017: -- checks are not repeated for each disbursement belonging to the same fund/award/term

Line 2452: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

2448:
2449: term_amounts_rec cur_term_amounts%ROWTYPE;
2450:
2451: ln_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
2452: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
2453: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2454: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
2455:
2456: --Variables to Store the validation results

Line 2453: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

2449: term_amounts_rec cur_term_amounts%ROWTYPE;
2450:
2451: ln_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
2452: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
2453: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2454: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
2455:
2456: --Variables to Store the validation results
2457:

Line 2454: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;

2450:
2451: ln_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
2452: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
2453: ln_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
2454: lv_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
2455:
2456: --Variables to Store the validation results
2457:
2458: lb_todo_result BOOLEAN := TRUE; -- To Do Result

Line 3622: l_ci_cal_type igs_ca_inst.cal_type%TYPE;

3618: --------------------------------------------------------------------------------------------
3619:
3620: PARAM_EXCEPTION EXCEPTION;
3621:
3622: l_ci_cal_type igs_ca_inst.cal_type%TYPE;
3623: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3624: lv_person_number igf_ap_fa_con_v.person_number%TYPE;
3625:
3626:

Line 3623: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

3619:
3620: PARAM_EXCEPTION EXCEPTION;
3621:
3622: l_ci_cal_type igs_ca_inst.cal_type%TYPE;
3623: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3624: lv_person_number igf_ap_fa_con_v.person_number%TYPE;
3625:
3626:
3627:

Line 3632: FROM igs_ca_inst

3628: CURSOR c_award_det(cp_cal_type VARCHAR2,
3629: cp_seq_number NUMBER)
3630: IS
3631: SELECT alternate_code
3632: FROM igs_ca_inst
3633: WHERE cal_type = cp_cal_type
3634: AND sequence_number = cp_seq_number;
3635:
3636: l_award_det c_award_det%ROWTYPE;