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_FI_1098T_SETUP

Line 56: CURSOR cur_1098t_setup(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS

52: e_resource_busy EXCEPTION;
53:
54: PRAGMA EXCEPTION_INIT(e_resource_busy, -0054);
55:
56: CURSOR cur_1098t_setup(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
57: SELECT *
58: FROM igs_fi_1098t_setup
59: WHERE tax_year_name = cp_v_tax_year_name;
60:

Line 58: FROM igs_fi_1098t_setup

54: PRAGMA EXCEPTION_INIT(e_resource_busy, -0054);
55:
56: CURSOR cur_1098t_setup(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
57: SELECT *
58: FROM igs_fi_1098t_setup
59: WHERE tax_year_name = cp_v_tax_year_name;
60:
61: CURSOR cur_chk_1098t_sfts(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
62: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS

Line 61: CURSOR cur_chk_1098t_sfts(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

57: SELECT *
58: FROM igs_fi_1098t_setup
59: WHERE tax_year_name = cp_v_tax_year_name;
60:
61: CURSOR cur_chk_1098t_sfts(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
62: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS
63: SELECT 'x'
64: FROM igs_fi_1098t_sfts
65: WHERE tax_year_name = cp_v_tax_year_name

Line 186: p_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) AS

182: RETURN l_b_bool;
183: END validate_tin;
184:
185: PROCEDURE update_credits(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
186: p_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) AS
187:
188: /******************************************************************
189: Created By : Amit Gairola
190: Date Created By : 06-May-2005

Line 202: cp_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) IS

198:
199: -- Cursor for selecting all the records from the credits table for the person id
200: -- having the tax_year_name as the current tax year
201: CURSOR cur_crd(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
202: cp_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) IS
203: SELECT crd.rowid row_id,
204: crd.*
205: FROM igs_fi_credits_all crd
206: WHERE party_id = cp_n_person_id

Line 285: p_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) AS

281: END LOOP;
282: END update_credits;
283:
284: PROCEDURE update_charges(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
285: p_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) AS
286:
287: /******************************************************************
288: Created By : Amit Gairola
289: Date Created By : 06-May-2005

Line 301: cp_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) IS

297: ***************************************************************** */
298:
299: -- Cursor for selecting all the Charge records for the person and tax year.
300: CURSOR cur_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
301: cp_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) IS
302: SELECT inv.rowid row_id, inv.*
303: FROM igs_fi_inv_int_all inv
304: WHERE person_id = cp_n_person_id
305: AND tax_year_code = cp_v_tax_year

Line 374: cp_d_end_date igs_fi_1098t_setup.end_date%TYPE) IS

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
378: WHERE lps.cal_type = cp_v_load_cal_type

Line 377: igs_fi_1098t_setup stp

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
378: WHERE lps.cal_type = cp_v_load_cal_type
379: AND lps.sequence_number = cp_n_load_ci_seq_num
380: AND lps.tax_year_name = stp.tax_year_name
381: AND TRUNC(stp.end_date) <= TRUNC(cp_d_end_date)

Line 547: PROCEDURE log_params(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

543:
544: RETURN TRUE;
545: END chk_non_credit_course;
546:
547: PROCEDURE log_params(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
548: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
549: p_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE,
550: p_v_override_excl VARCHAR2,
551: p_v_file_addr_correction VARCHAR2,

Line 604: FUNCTION validate_params(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

600: fnd_file.put_line(fnd_file.log,
601: g_v_line_sep);
602: END log_params;
603:
604: FUNCTION validate_params(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
605: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
606: p_n_person_grp_id igs_pe_persid_group_all.group_id%TYPE,
607: p_v_override_excl VARCHAR2,
608: p_v_file_addr_correction VARCHAR2,

Line 634: CURSOR cur_val_one_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS

630: FROM igs_pe_persid_group_all
631: WHERE group_id = cp_n_pers_grp_id
632: AND closed_ind = cp_v_closed_ind;
633:
634: CURSOR cur_val_one_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
635: SELECT 'x'
636: FROM igs_fi_1098t_lps
637: WHERE tax_year_name = cp_v_tax_year_name;
638:

Line 639: CURSOR cur_val_one_ft(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS

635: SELECT 'x'
636: FROM igs_fi_1098t_lps
637: WHERE tax_year_name = cp_v_tax_year_name;
638:
639: CURSOR cur_val_one_ft(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
640: SELECT 'x'
641: FROM igs_fi_1098t_fts
642: WHERE tax_year_name = cp_v_tax_year_name;
643:

Line 904: PROCEDURE box236_credits(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

900: p_v_api_pers_id_uf := l_v_api_person_id_uf;
901:
902: END get_alt_person_id;
903:
904: PROCEDURE box236_credits(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
905: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
906: p_v_override_excl VARCHAR2,
907: p_n_orig_credit OUT NOCOPY NUMBER,
908: p_n_adj_credit OUT NOCOPY NUMBER) AS

Line 927: CURSOR cur_qtre_crd(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%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,
928: cp_d_end_date DATE,
929: cp_n_person_id igs_pe_person_base_v.person_id%TYPE) IS
930: SELECT crd.*,
931: crd.rowid row_id,

Line 959: igs_fi_1098t_setup stp

955: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
956: cp_d_start_date DATE) IS
957: SELECT 'x'
958: FROM igs_fi_inv_int_all inv,
959: igs_fi_1098t_setup stp
960: WHERE inv.person_id = cp_n_person_id
961: AND inv.fee_type = cp_v_fee_type
962: AND inv.fee_cal_type = cp_v_fee_cal_type
963: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq

Line 1160: PROCEDURE box236_charges(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

1156: p_n_adj_credit := l_n_adj_credit;
1157:
1158: END box236_credits;
1159:
1160: PROCEDURE box236_charges(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1161: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
1162: p_v_override_excl VARCHAR2,
1163: p_n_orig_charge OUT NOCOPY NUMBER,
1164: p_n_adj_charge OUT NOCOPY NUMBER,

Line 1184: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

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
1186: SELECT inv.*, inv.rowid row_id
1187: FROM igs_fi_inv_int_all inv,
1188: igs_fi_1098t_fts fts

Line 1196: CURSOR cur_next_acad_flag(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

1192: AND TRUNC(inv.invoice_creation_date) <= TRUNC(cp_d_end_date)
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

Line 1213: igs_fi_1098t_setup stp

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
1214: WHERE inv.person_id = cp_n_person_id
1215: AND inv.fee_type = cp_v_fee_type
1216: AND inv.fee_cal_type = cp_v_fee_cal_type
1217: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq

Line 1380: PROCEDURE box45_credits(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

1376: p_n_adj_charge := l_n_adj_chg;
1377: p_v_next_acad_flag := l_v_next_acad_flag;
1378: END box236_charges;
1379:
1380: PROCEDURE box45_credits(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1381: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
1382: p_n_orig_credit OUT NOCOPY NUMBER,
1383: p_n_adj_credit OUT NOCOPY NUMBER) AS
1384:

Line 1446: igs_fi_1098t_setup stp

1442: cp_d_start_date DATE) IS
1443: SELECT crd.credit_id,
1444: crd.waiver_name
1445: FROM igs_fi_credits_all crd,
1446: igs_fi_1098t_setup stp
1447: WHERE party_id = cp_n_person_id
1448: AND fee_cal_type = cp_v_fee_cal_type
1449: AND fee_ci_sequence_number = cp_n_fee_ci_seq
1450: AND TRUNC(transaction_date) < TRUNC(cp_d_start_date)

Line 1642: PROCEDURE box45_charges(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

1638: p_n_orig_credit := l_n_aid_orig_credit;
1639: p_n_adj_credit := l_n_aid_adj_credit;
1640: END box45_credits;
1641:
1642: PROCEDURE box45_charges(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1643: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
1644: p_n_orig_charge OUT NOCOPY NUMBER,
1645: p_n_adj_charge OUT NOCOPY NUMBER) AS
1646:

Line 1684: igs_fi_1098t_setup stp

1680: cp_d_start_date DATE) IS
1681: SELECT crd.credit_id,
1682: crd.waiver_name
1683: FROM igs_fi_credits_all crd,
1684: igs_fi_1098t_setup stp
1685: WHERE crd.party_id = cp_n_person_id
1686: AND crd.fee_cal_type = cp_v_fee_cal_type
1687: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq
1688: AND TRUNC(transaction_date) < TRUNC(cp_d_start_date)

Line 1830: p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) RETURN VARCHAR2 AS

1826:
1827: END box45_charges;
1828:
1829: FUNCTION compute_box8(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
1830: p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) RETURN VARCHAR2 AS
1831:
1832: /******************************************************************
1833: Created By : Amit Gairola
1834: Date Created By : 06-May-2005

Line 1841: CURSOR cur_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS

1837: Known limitations,enhancements,remarks:
1838: Change History
1839: Who When What
1840: ***************************************************************** */
1841: CURSOR cur_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
1842: SELECT cal_type,
1843: sequence_number
1844: FROM igs_fi_1098t_lps
1845: WHERE tax_year_name = cp_v_tax_year_name

Line 1848: CURSOR cur_ats(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

1844: FROM igs_fi_1098t_lps
1845: WHERE tax_year_name = cp_v_tax_year_name
1846: AND half_time_flag = 'Y';
1847:
1848: CURSOR cur_ats(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1849: cp_v_att_type igs_en_atd_type.attendance_type%TYPE) IS
1850: SELECT 'x'
1851: FROM igs_fi_1098t_ats
1852: WHERE tax_year_name = cp_v_tax_year_name

Line 1897: p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) RETURN VARCHAR2 AS

1893: RETURN l_v_half_time_flag;
1894: END compute_box8;
1895:
1896: FUNCTION compute_box9(p_n_person_id igs_pe_person_base_v.person_id%TYPE,
1897: p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) RETURN VARCHAR2 AS
1898:
1899: /******************************************************************
1900: Created By : Amit Gairola
1901: Date Created By : 06-May-2005

Line 1909: CURSOR cur_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS

1905: Change History
1906: Who When What
1907: ***************************************************************** */
1908:
1909: CURSOR cur_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
1910: SELECT cal_type,
1911: sequence_number
1912: FROM igs_fi_1098t_lps
1913: WHERE tax_year_name = cp_v_tax_year_name

Line 1925: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

1921: WHERE load_cal_type = cp_v_cal_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,

Line 1984: PROCEDURE insert_1098t_data(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

1980:
1981: RETURN l_v_grad_flag;
1982: END compute_box9;
1983:
1984: PROCEDURE insert_1098t_data(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1985: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
1986: p_v_full_name igs_pe_person_base_v.full_name%TYPE,
1987: p_n_box2 igs_fi_1098t_data.billed_amt%TYPE,
1988: p_n_box3 igs_fi_1098t_data.adj_amt%TYPE,

Line 2010: CURSOR cur_data_exists(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

2006: abshriva 26/10/05 Bug:4697644-Modification in where clause for cursor 'cur_party_sites'
2007:
2008: ***************************************************************** */
2009:
2010: CURSOR cur_data_exists(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
2011: cp_n_person_id igs_pe_person_base_v.person_id%TYPE) IS
2012: SELECT tdata.rowid row_id, tdata.*
2013: FROM igs_fi_1098t_data tdata
2014: WHERE tdata.party_id = cp_n_person_id

Line 2028: cp_v_party_site_use_code igs_fi_1098t_setup.perm_party_site_use_code%TYPE) IS

2024:
2025: l_v_rowid VARCHAR2(2000);
2026:
2027: CURSOR cur_party_sites(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
2028: cp_v_party_site_use_code igs_fi_1098t_setup.perm_party_site_use_code%TYPE) IS
2029: SELECT ps.location_id,
2030: ps.identifying_address_flag,
2031: ps.status
2032: FROM hz_party_site_uses hps,

Line 2793: PROCEDURE extract_data_main(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

2789: END IF;
2790: END IF;
2791: END insert_1098t_data;
2792:
2793: PROCEDURE extract_data_main(p_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
2794: p_n_person_id igs_pe_person_base_v.person_id%TYPE,
2795: p_v_override_excl VARCHAR2,
2796: p_v_file_addr_correction VARCHAR2) AS
2797: /******************************************************************

Line 2818: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

2814:
2815: l_rec_pers_dtl cur_pers_dtl%ROWTYPE;
2816:
2817: CURSOR cur_chk_rec_exists(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
2818: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
2819: cp_v_status igs_fi_1098t_data.status_code%TYPE) IS
2820: SELECT dat.override_flag, dat.irs_filed_flag
2821: FROM igs_fi_1098t_data dat
2822: WHERE dat.party_id = cp_n_person_id