APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_1098T_DTLS_PKG

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);