APPS.IGF_SL_CL_ORIG_ACK dependencies on IGF_SL_EDIT

Line 1910: CURSOR c_reject (p_chg_code igf_sl_edit_report_v.orig_chg_code%TYPE)

1906:
1907: err_mesg_array t_message;
1908:
1909: --Select the Error Messages from Edit Report
1910: CURSOR c_reject (p_chg_code igf_sl_edit_report_v.orig_chg_code%TYPE)
1911: IS
1912: SELECT rpad(field_desc,50)||sl_error_desc reject_desc FROM igf_sl_edit_report_v
1913: WHERE loan_number = loaded_1rec.loan_number
1914: AND orig_chg_code = p_chg_code

Line 1912: SELECT rpad(field_desc,50)||sl_error_desc reject_desc FROM igf_sl_edit_report_v

1908:
1909: --Select the Error Messages from Edit Report
1910: CURSOR c_reject (p_chg_code igf_sl_edit_report_v.orig_chg_code%TYPE)
1911: IS
1912: SELECT rpad(field_desc,50)||sl_error_desc reject_desc FROM igf_sl_edit_report_v
1913: WHERE loan_number = loaded_1rec.loan_number
1914: AND orig_chg_code = p_chg_code
1915: ORDER BY edtr_id;
1916:

Line 1982: igf_sl_edit.delete_edit(l_loan_number, 'R');

1978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1979: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig_ack.process_ack.debug',gv_debug_str);
1980: END IF;
1981:
1982: igf_sl_edit.delete_edit(l_loan_number, 'R');
1983: gv_debug_str := '';
1984:
1985:
1986: -- Need to insert all the Error Messages in the current @1 record into Edit Table

Line 2025: igf_sl_edit.insert_edit(loaded_1rec.loan_number,

2021: --
2022: -- Insert Message
2023: --
2024: gv_debug_str := gv_debug_str || 'MAIN - 8' || ' ';
2025: igf_sl_edit.insert_edit(loaded_1rec.loan_number,
2026: 'R',
2027: 'IGF_SL_CL_ERROR',
2028: err_mesg_array(l_index),'','');
2029: gv_debug_str := '';