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

Line 913: FROM igf_sl_clchsn_dtls chdt

909: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
910: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE
911: ) IS
912: SELECT chdt.ROWID row_id,chdt.*
913: FROM igf_sl_clchsn_dtls chdt
914: WHERE chdt.loan_number_txt = cp_v_loan_number
915: AND chdt.disbursement_number = cp_new_disb_num
916: AND chdt.status_code IN ('R','N','D')
917: AND chdt.change_field_code = 'DISB_NUM'

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

994: IF c_sl_clchsn_dtls%FOUND THEN
995: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
996: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record to be deleted ');
997: END IF;
998: igf_sl_clchsn_dtls_pkg.delete_row(x_rowid => rec_c_sl_clchsn_dtls.row_id);
999: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1000: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.BeforeRowInsertUpdateDelete1 ', ' Change record deleted successfully ');
1001: END IF;
1002: END IF;

Line 1037: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;

1033:
1034: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
1035: l_v_message_name fnd_new_messages.message_name%TYPE;
1036: l_b_return_status BOOLEAN;
1037: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
1038: l_v_rowid ROWID;
1039: l_n_award_id igf_aw_award_all.award_id%TYPE;
1040: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1041: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

Line 1051: FROM igf_sl_clchsn_dtls chdt

1047: cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
1048: cp_new_disb_num igf_aw_awd_disb_all.disb_num%TYPE
1049: ) IS
1050: SELECT chdt.ROWID row_id,chdt.*
1051: FROM igf_sl_clchsn_dtls chdt
1052: WHERE chdt.loan_number_txt = cp_v_loan_number
1053: AND chdt.disbursement_number = cp_new_disb_num
1054: AND chdt.status_code IN ('R','N','D')
1055: AND chdt.change_field_code = 'DISB_NUM'

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

1090: ) THEN
1091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1092: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_cl_create_chg.create_disb_chg_rec. ' );
1093: END IF;
1094: -- invoke the procedure to create loan cancellation change record in igf_sl_clchsn_dtls table
1095: igf_sl_cl_create_chg.create_disb_chg_rec(
1096: p_new_disb_rec => new_references,
1097: p_old_disb_rec => old_references,
1098: p_b_return_status => l_b_return_status,

Line 1157: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.update_row to update @9 record of change_code_txt = D ');

1153: );
1154: FETCH c_sl_clchsn_dtls INTO rec_c_sl_clchsn_dtls;
1155: IF c_sl_clchsn_dtls%FOUND THEN
1156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1157: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.update_row to update @9 record of change_code_txt = D ');
1158: END IF;
1159: igf_sl_clchsn_dtls_pkg.update_row (
1160: x_rowid => rec_c_sl_clchsn_dtls.row_id,
1161: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,

Line 1159: igf_sl_clchsn_dtls_pkg.update_row (

1155: IF c_sl_clchsn_dtls%FOUND THEN
1156: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1157: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.update_row to update @9 record of change_code_txt = D ');
1158: END IF;
1159: igf_sl_clchsn_dtls_pkg.update_row (
1160: x_rowid => rec_c_sl_clchsn_dtls.row_id,
1161: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,
1162: x_award_id => rec_c_sl_clchsn_dtls.award_id ,
1163: x_loan_number_txt => rec_c_sl_clchsn_dtls.loan_number_txt ,

Line 1226: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send ');

1222: fnd_message.set_token(l_d_message_tokens(token_counter).token_name, l_d_message_tokens(token_counter).token_value);
1223: END LOOP;
1224: */
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1226: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send ');
1227: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1228: END IF;
1229: igf_sl_clchsn_dtls_pkg.update_row (
1230: x_rowid => rec_c_sl_clchsn_dtls.row_id,

Line 1229: igf_sl_clchsn_dtls_pkg.update_row (

1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1226: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send ');
1227: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', ' Change send id: ' ||rec_c_sl_clchsn_dtls.clchgsnd_id);
1228: END IF;
1229: igf_sl_clchsn_dtls_pkg.update_row (
1230: x_rowid => rec_c_sl_clchsn_dtls.row_id,
1231: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,
1232: x_award_id => rec_c_sl_clchsn_dtls.award_id ,
1233: x_loan_number_txt => rec_c_sl_clchsn_dtls.loan_number_txt ,

Line 1302: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.insert_row to insert @9 record of change_code_txt = D ');

1298: l_c_cl_rec_status IN ('B','G')) THEN
1299: l_v_rowid := NULL;
1300: l_n_clchgsnd_id := NULL;
1301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1302: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.insert_row to insert @9 record of change_code_txt = D ');
1303: END IF;
1304: igf_sl_clchsn_dtls_pkg.insert_row (
1305: x_rowid => l_v_rowid ,
1306: x_clchgsnd_id => l_n_clchgsnd_id ,

Line 1304: igf_sl_clchsn_dtls_pkg.insert_row (

1300: l_n_clchgsnd_id := NULL;
1301: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1302: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_awd_disb_pkg.AfterRowInsertUpdateDelete1 ', 'invoking igf_sl_clchsn_dtls_pkg.insert_row to insert @9 record of change_code_txt = D ');
1303: END IF;
1304: igf_sl_clchsn_dtls_pkg.insert_row (
1305: x_rowid => l_v_rowid ,
1306: x_clchgsnd_id => l_n_clchgsnd_id ,
1307: x_award_id => l_n_award_id ,
1308: x_loan_number_txt => l_v_loan_number ,