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.

[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_1098T_DTLS

Line 70: TYPE r_1098t_drilldown IS RECORD(transaction_id igs_fi_1098t_dtls.transaction_id%TYPE,

66: AND sys_fund_type = cp_v_sys_fund_type;
67:
68: g_rec_1098t_setup cur_1098t_setup%ROWTYPE;
69:
70: TYPE r_1098t_drilldown IS RECORD(transaction_id igs_fi_1098t_dtls.transaction_id%TYPE,
71: transaction_code igs_fi_1098t_dtls.transaction_code%TYPE,
72: box_num igs_fi_1098t_dtls.box_num%TYPE);
73: TYPE t_1098t_drilldown IS TABLE OF r_1098t_drilldown
74: INDEX BY BINARY_INTEGER;

Line 71: transaction_code igs_fi_1098t_dtls.transaction_code%TYPE,

67:
68: g_rec_1098t_setup cur_1098t_setup%ROWTYPE;
69:
70: TYPE r_1098t_drilldown IS RECORD(transaction_id igs_fi_1098t_dtls.transaction_id%TYPE,
71: transaction_code igs_fi_1098t_dtls.transaction_code%TYPE,
72: box_num igs_fi_1098t_dtls.box_num%TYPE);
73: TYPE t_1098t_drilldown IS TABLE OF r_1098t_drilldown
74: INDEX BY BINARY_INTEGER;
75:

Line 72: box_num igs_fi_1098t_dtls.box_num%TYPE);

68: g_rec_1098t_setup cur_1098t_setup%ROWTYPE;
69:
70: TYPE r_1098t_drilldown IS RECORD(transaction_id igs_fi_1098t_dtls.transaction_id%TYPE,
71: transaction_code igs_fi_1098t_dtls.transaction_code%TYPE,
72: box_num igs_fi_1098t_dtls.box_num%TYPE);
73: TYPE t_1098t_drilldown IS TABLE OF r_1098t_drilldown
74: INDEX BY BINARY_INTEGER;
75:
76: l_t_1098t_drilldown t_1098t_drilldown;

Line 2070: FROM igs_fi_1098t_dtls

2066: l_b_rec_exists BOOLEAN;
2067:
2068: CURSOR cur_1098t_dtl(cp_n_stu_1098t_id igs_fi_1098t_data.stu_1098t_id%TYPE) IS
2069: SELECT rowid
2070: FROM igs_fi_1098t_dtls
2071: WHERE stu_1098t_id = cp_n_stu_1098t_id;
2072:
2073: CURSOR cur_1098t_data_lat(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
2074: cp_v_tax_year_name igs_fi_1098t_data.tax_year_name%TYPE) IS

Line 2317: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,

2313: p_v_string => 'Creating '||l_t_1098t_drilldown.COUNT||' detail records for the 1098T record');
2314: FOR l_n_rec_cntr IN l_t_1098t_drilldown.FIRST..l_t_1098t_drilldown.LAST LOOP
2315: IF l_t_1098t_drilldown.EXISTS(l_n_rec_cntr) THEN
2316: l_v_rowid := null;
2317: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,
2318: x_stu_1098t_id => l_n_stu_1098t_id,
2319: x_transaction_id => l_t_1098t_drilldown(l_n_rec_cntr).transaction_id,
2320: x_transaction_code => l_t_1098t_drilldown(l_n_rec_cntr).transaction_code,
2321: x_box_num => l_t_1098t_drilldown(l_n_rec_cntr).box_num);

Line 2469: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,

2465: p_v_string => 'Creating '||l_t_1098t_drilldown.COUNT||' detail records for the 1098T record');
2466: FOR l_n_rec_cntr IN l_t_1098t_drilldown.FIRST..l_t_1098t_drilldown.LAST LOOP
2467: IF l_t_1098t_drilldown.EXISTS(l_n_rec_cntr) THEN
2468: l_v_rowid := null;
2469: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,
2470: x_stu_1098t_id => l_n_stu_1098t_id,
2471: x_transaction_id => l_t_1098t_drilldown(l_n_rec_cntr).transaction_id,
2472: x_transaction_code => l_t_1098t_drilldown(l_n_rec_cntr).transaction_code,
2473: x_box_num => l_t_1098t_drilldown(l_n_rec_cntr).box_num);

Line 2490: igs_fi_1098t_dtls_pkg.delete_row(x_rowid => l_rec_dtl.rowid);

2486: p_v_string => 'Correction flag has not been set. Hence delete all detail records.');
2487:
2488: -- If it is No, then delete all the records in the 1098T details table
2489: FOR l_rec_dtl IN cur_1098t_dtl(l_rec_1098t_data.stu_1098t_id) LOOP
2490: igs_fi_1098t_dtls_pkg.delete_row(x_rowid => l_rec_dtl.rowid);
2491: END LOOP;
2492:
2493: l_b_txn := TRUE;
2494:

Line 2544: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,

2540: p_v_string => 'Creating '||l_t_1098t_drilldown.COUNT||' detail records for the 1098T record');
2541: FOR l_n_rec_cntr IN l_t_1098t_drilldown.FIRST..l_t_1098t_drilldown.LAST LOOP
2542: IF l_t_1098t_drilldown.EXISTS(l_n_rec_cntr) THEN
2543: l_v_rowid := null;
2544: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,
2545: x_stu_1098t_id => l_rec_1098t_data.stu_1098t_id,
2546: x_transaction_id => l_t_1098t_drilldown(l_n_rec_cntr).transaction_id,
2547: x_transaction_code => l_t_1098t_drilldown(l_n_rec_cntr).transaction_code,
2548: x_box_num => l_t_1098t_drilldown(l_n_rec_cntr).box_num);

Line 2686: igs_fi_1098t_dtls_pkg.delete_row(x_rowid => l_rec_dtl.rowid);

2682: p_v_string => 'Correction record needs to be created. Hence delete all detail records');
2683:
2684: -- If there is a change, then delete records from the 1098T detail table
2685: FOR l_rec_dtl IN cur_1098t_dtl(l_rec_1098t_data.stu_1098t_id) LOOP
2686: igs_fi_1098t_dtls_pkg.delete_row(x_rowid => l_rec_dtl.rowid);
2687: END LOOP;
2688:
2689: l_b_txn := TRUE;
2690: log_to_fnd(p_v_module => 'insert_1098t_data',

Line 2739: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,

2735: p_v_string => 'Creating '||l_t_1098t_drilldown.COUNT||' detail records for the 1098T record');
2736: FOR l_n_rec_cntr IN l_t_1098t_drilldown.FIRST..l_t_1098t_drilldown.LAST LOOP
2737: IF l_t_1098t_drilldown.EXISTS(l_n_rec_cntr) THEN
2738: l_v_rowid := null;
2739: igs_fi_1098t_dtls_pkg.insert_row(x_rowid => l_v_rowid,
2740: x_stu_1098t_id => l_rec_1098t_data.stu_1098t_id,
2741: x_transaction_id => l_t_1098t_drilldown(l_n_rec_cntr).transaction_id,
2742: x_transaction_code => l_t_1098t_drilldown(l_n_rec_cntr).transaction_code,
2743: x_box_num => l_t_1098t_drilldown(l_n_rec_cntr).box_num);