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_AW_AWARD_PKG dependencies on IGF_SL_CLCHSN_DTLS

Line 239: FROM igf_sl_clchsn_dtls chdt

235: CURSOR c_sl_clchsn_dtls (
236: cp_n_award_id igf_aw_award_all.award_id%TYPE
237: ) IS
238: SELECT chdt.ROWID row_id,chdt.*
239: FROM igf_sl_clchsn_dtls chdt
240: WHERE chdt.award_id = cp_n_award_id
241: AND chdt.status_code IN ('R','N','D')
242: AND chdt.response_status_code IS NULL
243: AND chdt.cl_version_code = 'RELEASE-4';

Line 293: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);

289: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_record_type_txt : '||rec_c_sl_clchsn_dtls.change_record_type_txt );
290: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.change_code_txt : '||rec_c_sl_clchsn_dtls.change_code_txt );
291: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'rec_c_sl_clchsn_dtls.status_code : '||rec_c_sl_clchsn_dtls.status_code );
292: END IF;
293: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
294: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
295: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Change Send Record deleted successfully ');
296: END IF;
297: END LOOP;

Line 303: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table

299: IF ((new_references.award_status <> old_references.award_status) AND
300: new_references.award_status = 'CANCELLED' AND
301: new_references.accepted_amt = 0)
302: THEN
303: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table
304: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
305: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan Cancellation. ' );
306: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_awd_chg_rec. ' );
307: END IF;

Line 332: -- invoke the procedure to create reinstatement change record in igf_sl_clchsn_dtls table

328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: END IF;
331: END IF;
332: -- invoke the procedure to create reinstatement change record in igf_sl_clchsn_dtls table
333: IF ((old_references.accepted_amt <> new_references.accepted_amt) AND
334: new_references.award_status = 'ACCEPTED') THEN
335: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
336: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.AfterRowInsertUpdateDelete1 ', 'Loan reinstatement/loan increase. ' );