APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_SL_CL_BATCH

Line 1674: l_v_batch_id igf_sl_cl_batch.batch_id%TYPE;

1670: l_n_lender_id igf_sl_lender.lender_id%TYPE;
1671: l_n_guarantor_id igf_sl_guarantor.guarantor_id%TYPE;
1672: l_n_servicer_id igf_sl_servicer.servicer_id%TYPE;
1673: l_v_filler_2_char VARCHAR2(2);
1674: l_v_batch_id igf_sl_cl_batch.batch_id%TYPE;
1675: l_v_rowid ROWID;
1676: l_n_cbth_id igf_sl_cl_batch.cbth_id%TYPE;
1677:
1678: -- variables for trailer

Line 1676: l_n_cbth_id igf_sl_cl_batch.cbth_id%TYPE;

1672: l_n_servicer_id igf_sl_servicer.servicer_id%TYPE;
1673: l_v_filler_2_char VARCHAR2(2);
1674: l_v_batch_id igf_sl_cl_batch.batch_id%TYPE;
1675: l_v_rowid ROWID;
1676: l_n_cbth_id igf_sl_cl_batch.cbth_id%TYPE;
1677:
1678: -- variables for trailer
1679: l_v_chg_trailer_rec VARCHAR2(1000);
1680: l_n_1cntr NUMBER;

Line 1867: p_v_string => ' Inserting into igf_sl_cl_batch table '

1863: p_v_string => ' Derived Unique Batchid : ' ||l_v_batch_id
1864: );
1865: -- insert into cl batch table
1866: log_to_fnd(p_v_module => 'sub_create_file',
1867: p_v_string => ' Inserting into igf_sl_cl_batch table '
1868: );
1869: l_v_rowid := NULL;
1870: igf_sl_cl_batch_pkg.insert_row (
1871: x_mode => 'R' ,

Line 1870: igf_sl_cl_batch_pkg.insert_row (

1866: log_to_fnd(p_v_module => 'sub_create_file',
1867: p_v_string => ' Inserting into igf_sl_cl_batch table '
1868: );
1869: l_v_rowid := NULL;
1870: igf_sl_cl_batch_pkg.insert_row (
1871: x_mode => 'R' ,
1872: x_rowid => l_v_rowid ,
1873: x_cbth_id => l_n_cbth_id ,
1874: x_batch_id => l_v_batch_id ,

Line 1894: p_v_string => ' Inserted successfully into igf_sl_cl_batch table '

1890: x_total_net_cancel_amt => NULL ,
1891: x_total_net_out_cancel_amt => NULL
1892: );
1893: log_to_fnd(p_v_module => 'sub_create_file',
1894: p_v_string => ' Inserted successfully into igf_sl_cl_batch table '
1895: );
1896:
1897: -- defining values for filler characters variables
1898: l_v_filler_2_char := RPAD(' ',2,' ');