APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_SL_DL_CHG_SEND

Line 128: lv_loan_number igf_sl_dl_chg_send.loan_number%TYPE;

124: lc_chg_flag VARCHAR2(1); -- ## Flag to Indicate if any changes are there between Oldvalues and New values ##
125: lc_disb_chg_flag VARCHAR2(1); -- ## Flag to Indicate if any changes are there between Oldvalues and New ones in Disbursement tables##
126: lc_header_flag VARCHAR2(1) := 'N'; -- ## Flag to indicate if any changes had happened in loans or disbursement so as to set the header record ##
127: l_rowid ROWID;
128: lv_loan_number igf_sl_dl_chg_send.loan_number%TYPE;
129:
130: -- ## REF Cursor Record Types.
131:
132: Header_Rec igf_sl_dl_record.DLHeaderType;

Line 318: l_chg_num igf_sl_dl_chg_send.chg_num%TYPE;

314: AND dl_version =lv_dl_version;
315:
316: lc_chg_code c_chg_code%ROWTYPE;
317: l_rowid ROWID;
318: l_chg_num igf_sl_dl_chg_send.chg_num%TYPE;
319:
320: BEGIN
321: -- ## Comparing the old field value with new field value, if any difference
322: -- ## exists a record is inserted in igf_sl_dl_chg_send table with the status as

Line 322: -- ## exists a record is inserted in igf_sl_dl_chg_send table with the status as

318: l_chg_num igf_sl_dl_chg_send.chg_num%TYPE;
319:
320: BEGIN
321: -- ## Comparing the old field value with new field value, if any difference
322: -- ## exists a record is inserted in igf_sl_dl_chg_send table with the status as
323: -- ## Ready to send.
324:
325: IF (p_field_lor IS NULL AND p_field_lor_loc IS NULL)
326: OR (p_field_lor = p_field_lor_loc) THEN

Line 345: igf_sl_dl_chg_send_pkg.insert_row (

341:
342: -- Directly setting to Send, as the Trans_rec() procedure picks up only the
343: -- picks up record belonging to this dbth_id
344:
345: igf_sl_dl_chg_send_pkg.insert_row (
346: x_mode => 'R',
347: x_rowid => l_rowid,
348: X_chg_num => l_chg_num,
349: X_dbth_id => lv_dbth_id,

Line 1119: l_prev_loan_number igf_sl_dl_chg_send.loan_number%TYPE;

1115: ***************************************************************/
1116:
1117:
1118: l_Trans_Rec VARCHAR2(4000) := NULL;
1119: l_prev_loan_number igf_sl_dl_chg_send.loan_number%TYPE;
1120: l_line_rec_count NUMBER := 0;
1121: l_tot_rec_count NUMBER := 0;
1122:
1123: l_chg_rec_hdr_len NUMBER := 0;

Line 1132: SELECT * from igf_sl_dl_chg_send

1128:
1129: -- ## Cursor to retrieve the changed records for the particular loan_number and batch Id
1130:
1131: CURSOR cur_chg_rec IS
1132: SELECT * from igf_sl_dl_chg_send
1133: WHERE dbth_id = p_dl_dbth_id
1134: ORDER BY loan_number, chg_num;
1135:
1136: lcur_chg_rec cur_chg_rec%ROWTYPE;