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

Line 358: FUNCTION chk_prior_lps(p_v_load_cal_type igs_ca_inst.cal_type%TYPE,

354: x_waiver_name => l_rec_chg.waiver_name);
355: END LOOP;
356: END update_charges;
357:
358: FUNCTION chk_prior_lps(p_v_load_cal_type igs_ca_inst.cal_type%TYPE,
359: p_n_load_ci_seq igs_ca_inst.sequence_number%TYPE,
360: p_d_txn_date DATE) RETURN BOOLEAN AS
361:
362: /******************************************************************

Line 359: p_n_load_ci_seq igs_ca_inst.sequence_number%TYPE,

355: END LOOP;
356: END update_charges;
357:
358: FUNCTION chk_prior_lps(p_v_load_cal_type igs_ca_inst.cal_type%TYPE,
359: p_n_load_ci_seq igs_ca_inst.sequence_number%TYPE,
360: p_d_txn_date DATE) RETURN BOOLEAN AS
361:
362: /******************************************************************
363: Created By : Amit Gairola

Line 372: CURSOR cur_prior_lps(cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,

368: Change History
369: Who When What
370: ***************************************************************** */
371:
372: CURSOR cur_prior_lps(cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,
373: cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,
374: cp_d_end_date igs_fi_1098t_setup.end_date%TYPE) IS
375: SELECT stp.tax_year_name
376: FROM igs_fi_1098t_lps lps,

Line 373: cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,

369: Who When What
370: ***************************************************************** */
371:
372: CURSOR cur_prior_lps(cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,
373: cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,
374: cp_d_end_date igs_fi_1098t_setup.end_date%TYPE) IS
375: SELECT stp.tax_year_name
376: FROM igs_fi_1098t_lps lps,
377: igs_fi_1098t_setup stp

Line 509: p_v_load_cal_type igs_ca_inst.cal_type%TYPE,

505: END log_line;
506:
507: FUNCTION chk_non_credit_course(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
508: p_v_override_excl VARCHAR2,
509: p_v_load_cal_type igs_ca_inst.cal_type%TYPE,
510: p_n_load_ci_seq igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN AS
511: /******************************************************************
512: Created By : Amit Gairola
513: Date Created By : 06-May-2005

Line 510: p_n_load_ci_seq igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN AS

506:
507: FUNCTION chk_non_credit_course(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
508: p_v_override_excl VARCHAR2,
509: p_v_load_cal_type igs_ca_inst.cal_type%TYPE,
510: p_n_load_ci_seq igs_ca_inst.sequence_number%TYPE) RETURN BOOLEAN AS
511: /******************************************************************
512: Created By : Amit Gairola
513: Date Created By : 06-May-2005
514: Purpose : Function for checking Non Credit Courses

Line 922: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;

918: agairola 05-Aug-2005 Changes as per Waiver build: 3392095
919: ***************************************************************** */
920: l_n_orig_credit NUMBER;
921: l_n_adj_credit NUMBER;
922: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
923: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
924:
925: -- Cursor for selecting the Negative Charge Adjustment credits, where the fee type is associated
926: -- to the current tax year being processed

Line 923: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;

919: ***************************************************************** */
920: l_n_orig_credit NUMBER;
921: l_n_adj_credit NUMBER;
922: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
923: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
924:
925: -- Cursor for selecting the Negative Charge Adjustment credits, where the fee type is associated
926: -- to the current tax year being processed
927: CURSOR cur_qtre_crd(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

Line 952: CURSOR cur_chk_inv(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

948: ORDER BY crd.fee_ci_sequence_number;
949:
950: -- Cursor for checking if any charge for the same person and having the same FTCI was
951: -- reported in a prior year
952: CURSOR cur_chk_inv(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
953: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
954: cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
955: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
956: cp_d_start_date DATE) IS

Line 953: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

949:
950: -- Cursor for checking if any charge for the same person and having the same FTCI was
951: -- reported in a prior year
952: CURSOR cur_chk_inv(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
953: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
954: cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
955: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
956: cp_d_start_date DATE) IS
957: SELECT 'x'

Line 976: l_n_prev_fee_ci_seq igs_ca_inst.sequence_number%TYPE;

972: l_b_bool BOOLEAN;
973: l_var VARCHAR2(1);
974: l_n_box_num NUMBER(5);
975:
976: l_n_prev_fee_ci_seq igs_ca_inst.sequence_number%TYPE;
977:
978: BEGIN
979: l_n_orig_credit := 0;
980: l_n_adj_credit := 0;

Line 1180: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;

1176: agairola 05-Aug-2005 Changes as per Waiver build: 3392095
1177: ***************************************************************** */
1178: l_n_orig_chg NUMBER;
1179: l_n_adj_chg NUMBER;
1180: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1181: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
1182:
1183: CURSOR cur_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1184: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

Line 1181: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;

1177: ***************************************************************** */
1178: l_n_orig_chg NUMBER;
1179: l_n_adj_chg NUMBER;
1180: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1181: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
1182:
1183: CURSOR cur_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1184: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1185: cp_d_end_date DATE) IS

Line 1197: cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,

1193: AND inv.tax_year_code IS NULL
1194: ORDER BY inv.fee_ci_sequence_number;
1195:
1196: CURSOR cur_next_acad_flag(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1197: cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,
1198: cp_n_load_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1199: SELECT 'x'
1200: FROM igs_fi_1098t_lps
1201: WHERE tax_year_name = cp_v_tax_year_name

Line 1198: cp_n_load_ci_seq igs_ca_inst.sequence_number%TYPE) IS

1194: ORDER BY inv.fee_ci_sequence_number;
1195:
1196: CURSOR cur_next_acad_flag(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1197: cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,
1198: cp_n_load_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1199: SELECT 'x'
1200: FROM igs_fi_1098t_lps
1201: WHERE tax_year_name = cp_v_tax_year_name
1202: AND cal_type = cp_v_load_cal_type

Line 1208: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

1204: AND next_acad_flag = 'Y';
1205:
1206: CURSOR cur_chk_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1207: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
1208: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1209: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1210: cp_d_start_date DATE) IS
1211: SELECT 'x'
1212: FROM igs_fi_inv_int_all inv,

Line 1209: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

1205:
1206: CURSOR cur_chk_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1207: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
1208: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1209: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1210: cp_d_start_date DATE) IS
1211: SELECT 'x'
1212: FROM igs_fi_inv_int_all inv,
1213: igs_fi_1098t_setup stp

Line 1230: l_n_prev_fee_ci_seq igs_ca_inst.sequence_number%TYPE;

1226: l_v_message_name VARCHAR2(2000);
1227: l_var VARCHAR2(1);
1228: l_b_bool BOOLEAN;
1229: l_n_box_num NUMBER(5);
1230: l_n_prev_fee_ci_seq igs_ca_inst.sequence_number%TYPE;
1231: BEGIN
1232: l_v_next_acad_flag := 'N';
1233: l_b_non_zero_credits_flag := FALSE;
1234: l_n_orig_chg := 0;

Line 1401: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;

1397: l_n_aid_orig_credit NUMBER;
1398: l_n_aid_adj_credit NUMBER;
1399: l_b_party_sponsor BOOLEAN;
1400: l_b_process_credit BOOLEAN;
1401: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1402: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
1403:
1404: l_v_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1405: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;

Line 1402: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;

1398: l_n_aid_adj_credit NUMBER;
1399: l_b_party_sponsor BOOLEAN;
1400: l_b_process_credit BOOLEAN;
1401: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1402: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
1403:
1404: l_v_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1405: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1406: l_v_message_name VARCHAR2(2000);

Line 1440: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

1436: FROM igf_db_awd_disb_dtl_all
1437: WHERE spnsr_credit_id = cp_n_credit_id;
1438:
1439: CURSOR cur_chk_orig_credit(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1440: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1441: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1442: cp_d_start_date DATE) IS
1443: SELECT crd.credit_id,
1444: crd.waiver_name

Line 1441: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

1437: WHERE spnsr_credit_id = cp_n_credit_id;
1438:
1439: CURSOR cur_chk_orig_credit(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1440: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1441: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1442: cp_d_start_date DATE) IS
1443: SELECT crd.credit_id,
1444: crd.waiver_name
1445: FROM igs_fi_credits_all crd,

Line 1678: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,

1674: AND TRUNC(inv.invoice_creation_date) BETWEEN TRUNC(cp_d_start_date) AND TRUNC(cp_d_end_date)
1675: AND ft.s_fee_type IN ('AID_ADJ','WAIVER_ADJ');
1676:
1677: CURSOR cur_chk_orig_credit(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1678: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1679: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1680: cp_d_start_date DATE) IS
1681: SELECT crd.credit_id,
1682: crd.waiver_name

Line 1679: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,

1675: AND ft.s_fee_type IN ('AID_ADJ','WAIVER_ADJ');
1676:
1677: CURSOR cur_chk_orig_credit(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1678: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1679: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1680: cp_d_start_date DATE) IS
1681: SELECT crd.credit_id,
1682: crd.waiver_name
1683: FROM igs_fi_credits_all crd,

Line 1916: CURSOR cur_load_teach(cp_v_cal_type igs_ca_inst.cal_type%TYPE,

1912: FROM igs_fi_1098t_lps
1913: WHERE tax_year_name = cp_v_tax_year_name
1914: AND grad_flag = 'Y';
1915:
1916: CURSOR cur_load_teach(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1917: cp_n_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1918: SELECT teach_cal_type,
1919: teach_ci_sequence_number
1920: FROM igs_ca_load_to_teach_v

Line 1917: cp_n_ci_seq igs_ca_inst.sequence_number%TYPE) IS

1913: WHERE tax_year_name = cp_v_tax_year_name
1914: AND grad_flag = 'Y';
1915:
1916: CURSOR cur_load_teach(cp_v_cal_type igs_ca_inst.cal_type%TYPE,
1917: cp_n_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1918: SELECT teach_cal_type,
1919: teach_ci_sequence_number
1920: FROM igs_ca_load_to_teach_v
1921: WHERE load_cal_type = cp_v_cal_type

Line 1926: cp_v_teach_cal_type igs_ca_inst.cal_type%TYPE,

1922: AND load_ci_sequence_number = cp_n_ci_seq;
1923:
1924: CURSOR cur_en_su_att(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1925: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1926: cp_v_teach_cal_type igs_ca_inst.cal_type%TYPE,
1927: cp_n_teach_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1928: SELECT 'x'
1929: FROM igs_en_su_attempt_all sua,
1930: igs_ps_ver ps,

Line 1927: cp_n_teach_ci_seq igs_ca_inst.sequence_number%TYPE) IS

1923:
1924: CURSOR cur_en_su_att(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1925: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1926: cp_v_teach_cal_type igs_ca_inst.cal_type%TYPE,
1927: cp_n_teach_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1928: SELECT 'x'
1929: FROM igs_en_su_attempt_all sua,
1930: igs_ps_ver ps,
1931: igs_fi_1098t_pts pts