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_SL_REL_DISB dependencies on IGS_CA_INST_ALL

Line 75: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,

71: END get_fund_desc;
72:
73: FUNCTION chk_attendance(
74: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
75: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
76: p_load_seq_number igs_ca_inst_all.sequence_number%TYPE,
77: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,
78: p_result OUT NOCOPY VARCHAR2
79: )

Line 76: p_load_seq_number igs_ca_inst_all.sequence_number%TYPE,

72:
73: FUNCTION chk_attendance(
74: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
75: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
76: p_load_seq_number igs_ca_inst_all.sequence_number%TYPE,
77: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE,
78: p_result OUT NOCOPY VARCHAR2
79: )
80: RETURN BOOLEAN

Line 90: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,

86: --
87: --------------------------------------------------------------------------------------------
88:
89: CURSOR cur_get_range(
90: p_load_cal_type igs_ca_inst_all.cal_type%TYPE,
91: p_min_att_type igs_en_atd_type_all.attendance_type%TYPE
92: )
93: IS
94: SELECT upper_enr_load_range

Line 302: p_cal_type igs_ca_inst_all.cal_type%TYPE,

298:
299: get_pers_num_rec cur_get_pers_num%ROWTYPE;
300:
301: CURSOR cur_get_base(
302: p_cal_type igs_ca_inst_all.cal_type%TYPE,
303: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
304: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
305: )
306: IS

Line 303: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,

299: get_pers_num_rec cur_get_pers_num%ROWTYPE;
300:
301: CURSOR cur_get_base(
302: p_cal_type igs_ca_inst_all.cal_type%TYPE,
303: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
304: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
305: )
306: IS
307: SELECT base_id

Line 515: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

511: igs_ge_msg_stack.ADD;
512: END log_parameters;
513:
514: FUNCTION chk_fund_meth_dl(
515: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
516: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
517: p_award_id igf_aw_award_all.award_id%TYPE,
518: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
519: )

Line 516: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

512: END log_parameters;
513:
514: FUNCTION chk_fund_meth_dl(
515: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
516: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
517: p_award_id igf_aw_award_all.award_id%TYPE,
518: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
519: )
520: RETURN BOOLEAN

Line 534: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

530: --------------------------------------------------------------------------------------------------------*/
531:
532: -- Get the funding method for direct loan
533: CURSOR cur_get_fund_meth(
534: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
535: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE
536: )
537: IS
538: SELECT funding_method

Line 535: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE

531:
532: -- Get the funding method for direct loan
533: CURSOR cur_get_fund_meth(
534: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
535: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE
536: )
537: IS
538: SELECT funding_method
539: FROM igf_sl_dl_setup_all

Line 630: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

626: END chk_fund_meth_dl;
627:
628: FUNCTION chk_fund_meth_pell(
629: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
630: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
631: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
632: p_award_id igf_aw_award_all.award_id%TYPE,
633: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
634: cp_return_status IN OUT NOCOPY VARCHAR2,

Line 631: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

627:
628: FUNCTION chk_fund_meth_pell(
629: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
630: p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
631: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
632: p_award_id igf_aw_award_all.award_id%TYPE,
633: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE,
634: cp_return_status IN OUT NOCOPY VARCHAR2,
635: cp_message IN OUT NOCOPY VARCHAR2

Line 1004: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,

1000: END chk_todo_result;
1001:
1002: PROCEDURE insert_pays_prg_uts(
1003: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1004: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1005: p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE
1006: )
1007: AS
1008:

Line 1005: p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE

1001:
1002: PROCEDURE insert_pays_prg_uts(
1003: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1004: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1005: p_acad_ci_seq_num igs_ca_inst_all.sequence_number%TYPE
1006: )
1007: AS
1008:
1009: --------------------------------------------------------------------------------------------

Line 1020: p_acad_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

1016: --------------------------------------------------------------------------------------------
1017:
1018: -- Get all the teaching periods for the academic calendar instance
1019: CURSOR cur_get_acad_tp(
1020: p_acad_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1021: p_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE
1022: )
1023: IS
1024: SELECT sub_cal_type tp_cal_type,

Line 1021: p_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE

1017:
1018: -- Get all the teaching periods for the academic calendar instance
1019: CURSOR cur_get_acad_tp(
1020: p_acad_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
1021: p_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE
1022: )
1023: IS
1024: SELECT sub_cal_type tp_cal_type,
1025: sub_ci_sequence_number tp_sequence_number

Line 1041: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,

1037: -- Get all the programs,unit attempts in which student has 'enrolled'
1038:
1039: CURSOR cur_get_att(
1040: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1041: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1042: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,
1043: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE
1044: )
1045: IS

Line 1042: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,

1038:
1039: CURSOR cur_get_att(
1040: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1041: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1042: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,
1043: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE
1044: )
1045: IS
1046: SELECT pg.course_cd prg_course_cd, pg.version_number prg_ver_num,

Line 1043: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE

1039: CURSOR cur_get_att(
1040: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1041: p_acad_cal_type igs_ca_inst_all.cal_type%TYPE,
1042: p_tp_cal_type igs_ca_inst_all.cal_type%TYPE,
1043: p_tp_sequence_number igs_ca_inst_all.sequence_number%TYPE
1044: )
1045: IS
1046: SELECT pg.course_cd prg_course_cd, pg.version_number prg_ver_num,
1047: su.unit_cd unit_course_cd, su.version_number unit_ver_num

Line 1058: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

1054: AND pg.cal_type = p_acad_cal_type
1055: AND pg.course_cd(+) = su.course_cd;
1056:
1057: get_att_rec cur_get_att%ROWTYPE;
1058: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1059: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1060: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1061: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1062: l_rowid ROWID;

Line 1059: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

1055: AND pg.course_cd(+) = su.course_cd;
1056:
1057: get_att_rec cur_get_att%ROWTYPE;
1058: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1059: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1060: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1061: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1062: l_rowid ROWID;
1063: BEGIN

Line 1060: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;

1056:
1057: get_att_rec cur_get_att%ROWTYPE;
1058: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1059: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1060: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1061: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1062: l_rowid ROWID;
1063: BEGIN
1064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 1297: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

1293:
1294: FUNCTION chk_fclass_result(
1295: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1296: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1297: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1298: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1299: )
1300: RETURN BOOLEAN
1301: AS

Line 1298: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE

1294: FUNCTION chk_fclass_result(
1295: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1296: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1297: p_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
1298: p_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
1299: )
1300: RETURN BOOLEAN
1301: AS
1302:

Line 1312: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE;

1308: --
1309: --------------------------------------------------------------------------------------------
1310:
1311:
1312: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
1313: p_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1314: p_message_name fnd_new_messages.message_name%TYPE;
1315:
1316:

Line 1313: p_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

1309: --------------------------------------------------------------------------------------------
1310:
1311:
1312: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE;
1313: p_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
1314: p_message_name fnd_new_messages.message_name%TYPE;
1315:
1316:
1317: --

Line 1337: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,

1333: --
1334:
1335: CURSOR cur_fee_cls(
1336: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1337: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1338: p_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1339: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1340: )
1341: IS

Line 1338: p_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

1334:
1335: CURSOR cur_fee_cls(
1336: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
1337: p_fee_cal_type igs_ca_inst_all.cal_type%TYPE,
1338: p_fee_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1339: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE
1340: )
1341: IS
1342: SELECT fee_class

Line 1497: p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE,

1493: app_exception.raise_exception;
1494: END get_loan_num;
1495:
1496: FUNCTION get_cut_off_dt(
1497: p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE,
1498: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE
1499: )
1500: RETURN DATE
1501: IS

Line 1513: p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE

1509: -- poin-in-time credit points
1510: -----------------------------------------------------------------------------------------
1511:
1512: CURSOR cur_get_eff_date(
1513: p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE
1514: )
1515: IS
1516: SELECT start_dt, end_dt
1517: FROM igs_ca_inst_all

Line 1517: FROM igs_ca_inst_all

1513: p_ld_seq_num igs_ca_inst_all.sequence_number%TYPE
1514: )
1515: IS
1516: SELECT start_dt, end_dt
1517: FROM igs_ca_inst_all
1518: WHERE p_ld_seq_num = sequence_number;
1519:
1520: get_eff_date_rec cur_get_eff_date%ROWTYPE;
1521: ld_cut_off_dt igf_aw_awd_disb_all.disb_date%TYPE;

Line 1875: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;

1871: FROM igf_aw_fund_cat_all cat, igf_aw_fund_mast_all fmast
1872: WHERE fmast.fund_code = cat.fund_code AND fmast.fund_id = p_fund_id;
1873:
1874: get_fed_fund_code_rec cur_get_fed_fund_code%ROWTYPE;
1875: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1876: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1877: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1878: l_message_name fnd_new_messages.message_text%TYPE;
1879: l_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;

Line 1876: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

1872: WHERE fmast.fund_code = cat.fund_code AND fmast.fund_id = p_fund_id;
1873:
1874: get_fed_fund_code_rec cur_get_fed_fund_code%ROWTYPE;
1875: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1876: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1877: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1878: l_message_name fnd_new_messages.message_text%TYPE;
1879: l_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
1880:

Line 1877: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;

1873:
1874: get_fed_fund_code_rec cur_get_fed_fund_code%ROWTYPE;
1875: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
1876: l_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
1877: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1878: l_message_name fnd_new_messages.message_text%TYPE;
1879: l_credit_pts igf_aw_awd_disb_all.min_credit_pts%TYPE;
1880:
1881: --Variables to Store the validation results

Line 3325: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

3321: p_trans_type IN VARCHAR2, p_per_grp_id IN NUMBER
3322: )
3323: IS
3324: param_exception EXCEPTION;
3325: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
3326: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3327: l_list VARCHAR2(32767);
3328: l_status VARCHAR2(1);
3329: l_base_id NUMBER;

Line 3326: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

3322: )
3323: IS
3324: param_exception EXCEPTION;
3325: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
3326: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
3327: l_list VARCHAR2(32767);
3328: l_status VARCHAR2(1);
3329: l_base_id NUMBER;
3330: l_person_number VARCHAR2(30);

Line 3343: FROM igs_ca_inst_all

3339: -- Cursor to get alternate code for the calendar instance
3340: CURSOR cur_awdyear(cp_cal_type VARCHAR2, cp_seq_number NUMBER)
3341: IS
3342: SELECT alternate_code
3343: FROM igs_ca_inst_all
3344: WHERE cal_type = cp_cal_type AND sequence_number = cp_seq_number;
3345:
3346: awdyear_rec cur_awdyear%ROWTYPE;
3347: