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_CL_ORIG_ACK dependencies on IGF_SL_CL_BATCH

Line 150: g_loaded_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;

146: --
147:
148: gv_debug_str VARCHAR2(4000);
149:
150: g_loaded_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
151: g_loaded_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
152: g_loaded_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
153: g_file_source_id igf_sl_cl_batch_all.source_id%TYPE;
154: g_file_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;

Line 151: g_loaded_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;

147:
148: gv_debug_str VARCHAR2(4000);
149:
150: g_loaded_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
151: g_loaded_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
152: g_loaded_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
153: g_file_source_id igf_sl_cl_batch_all.source_id%TYPE;
154: g_file_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
155: g_loaded_batch_id igf_sl_cl_batch_all.batch_id%TYPE;

Line 152: g_loaded_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;

148: gv_debug_str VARCHAR2(4000);
149:
150: g_loaded_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
151: g_loaded_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
152: g_loaded_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
153: g_file_source_id igf_sl_cl_batch_all.source_id%TYPE;
154: g_file_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
155: g_loaded_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
156: g_c_update_disb_dtls varchar2(10);

Line 153: g_file_source_id igf_sl_cl_batch_all.source_id%TYPE;

149:
150: g_loaded_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
151: g_loaded_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
152: g_loaded_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
153: g_file_source_id igf_sl_cl_batch_all.source_id%TYPE;
154: g_file_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
155: g_loaded_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
156: g_c_update_disb_dtls varchar2(10);
157: --

Line 154: g_file_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;

150: g_loaded_file_ident_code igf_sl_cl_batch_all.file_ident_code%TYPE;
151: g_loaded_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
152: g_loaded_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
153: g_file_source_id igf_sl_cl_batch_all.source_id%TYPE;
154: g_file_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
155: g_loaded_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
156: g_c_update_disb_dtls varchar2(10);
157: --
158: -- Added exceptions so that unhandled exception is not raised

Line 155: g_loaded_batch_id igf_sl_cl_batch_all.batch_id%TYPE;

151: g_loaded_recipient_id igf_sl_cl_batch_all.recipient_id%TYPE;
152: g_loaded_recip_non_ed_brc_id igf_sl_cl_batch_all.recip_non_ed_brc_id%TYPE;
153: g_file_source_id igf_sl_cl_batch_all.source_id%TYPE;
154: g_file_source_non_ed_brc_id igf_sl_cl_batch_all.source_non_ed_brc_id%TYPE;
155: g_loaded_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
156: g_c_update_disb_dtls varchar2(10);
157: --
158: -- Added exceptions so that unhandled exception is not raised
159: -- for user defined exception

Line 180: g_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;

176:
177: Format_1_rec igf_sl_load_file_t%ROWTYPE;
178: Format_1_rec_temp igf_sl_load_file_t%ROWTYPE;
179: loaded_1rec cur_resp1_records%ROWTYPE;
180: g_cbth_id igf_sl_cl_batch_all.cbth_id%TYPE;
181: l_loan_number igf_sl_loans_all.loan_number%TYPE;
182: p_disb_title VARCHAR2(1000);
183: p_disb_under_line VARCHAR2(1000);
184:

Line 323: l_batch_id igf_sl_cl_batch_all.batch_id%TYPE;

319: l_trailer VARCHAR2(2);
320: l_log_msg VARCHAR2(100);
321: l_file_creation_date DATE;
322: l_file_trans_date DATE;
323: l_batch_id igf_sl_cl_batch_all.batch_id%TYPE;
324: l_n_cbth_id NUMBER;
325:
326: -- To Fetch the Current School Id from Setup table
327:

Line 356: CURSOR cur_batch( p_send_resp igf_sl_cl_batch.send_resp%TYPE )IS

352:
353:
354: -- To Fetch the Batch Id Info from CL Batch Table
355:
356: CURSOR cur_batch( p_send_resp igf_sl_cl_batch.send_resp%TYPE )IS
357: SELECT clbatch.*, clbatch.ROWID row_id
358: FROM igf_sl_cl_batch_all clbatch
359: WHERE RTRIM(batch_id) = g_loaded_batch_id
360: AND file_creation_date = l_file_creation_date

Line 358: FROM igf_sl_cl_batch_all clbatch

354: -- To Fetch the Batch Id Info from CL Batch Table
355:
356: CURSOR cur_batch( p_send_resp igf_sl_cl_batch.send_resp%TYPE )IS
357: SELECT clbatch.*, clbatch.ROWID row_id
358: FROM igf_sl_cl_batch_all clbatch
359: WHERE RTRIM(batch_id) = g_loaded_batch_id
360: AND file_creation_date = l_file_creation_date
361: AND file_ident_code = g_loaded_file_ident_code
362: AND recipient_id = g_loaded_recipient_id

Line 456: igf_sl_cl_batch_pkg.insert_row (

452: FETCH cur_batch INTO rec_cur_batch;
453: IF cur_batch%NOTFOUND THEN
454: gv_debug_str := gv_debug_str || 'CL_LOAD_FILE - 9' ||' ';
455: l_row_id := NULL;
456: igf_sl_cl_batch_pkg.insert_row (
457: x_mode => 'R',
458: x_rowid => l_row_id,
459: x_cbth_id => g_cbth_id, -- generated by sequence
460: x_batch_id => g_loaded_batch_id,

Line 489: igf_sl_cl_batch_pkg.update_row (

485: l_n_cbth_id := rec_cur_batch.cbth_id;
486: l_row_id := rec_cur_batch.row_id ;
487: l_batch_id := rec_cur_batch.batch_id;
488: g_cbth_id := l_n_cbth_id;
489: igf_sl_cl_batch_pkg.update_row (
490: x_mode => 'R',
491: x_rowid => l_row_id,
492: x_cbth_id => l_n_cbth_id,
493: x_batch_id => g_loaded_batch_id,