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_SL_DL_PRINT_PNOTE dependencies on IGF_SL_DL_PNOTE_P_P

Line 186: l_person_phone igf_sl_dl_pnote_p_p.s_phone%TYPE;

182: l_ci_sequence_number igf_sl_dl_setup_v.ci_sequence_number%TYPE;
183: l_alternate_code igs_ca_inst.alternate_code%TYPE;
184: l_batch_seq_num NUMBER(15);
185: l_no_of_pnotes NUMBER;
186: l_person_phone igf_sl_dl_pnote_p_p.s_phone%TYPE;
187: l_parent_phone igf_sl_dl_pnote_p_p.p_phone%TYPE;
188: l_rowid VARCHAR2(30);
189: l_log_mesg VARCHAR2(2000);
190: l_pnsp_id igf_sl_dl_pnote_s_p.pnsp_id%TYPE;

Line 187: l_parent_phone igf_sl_dl_pnote_p_p.p_phone%TYPE;

183: l_alternate_code igs_ca_inst.alternate_code%TYPE;
184: l_batch_seq_num NUMBER(15);
185: l_no_of_pnotes NUMBER;
186: l_person_phone igf_sl_dl_pnote_p_p.s_phone%TYPE;
187: l_parent_phone igf_sl_dl_pnote_p_p.p_phone%TYPE;
188: l_rowid VARCHAR2(30);
189: l_log_mesg VARCHAR2(2000);
190: l_pnsp_id igf_sl_dl_pnote_s_p.pnsp_id%TYPE;
191: l_pnpp_id igf_sl_dl_pnote_p_p.pnpp_id%TYPE;

Line 191: l_pnpp_id igf_sl_dl_pnote_p_p.pnpp_id%TYPE;

187: l_parent_phone igf_sl_dl_pnote_p_p.p_phone%TYPE;
188: l_rowid VARCHAR2(30);
189: l_log_mesg VARCHAR2(2000);
190: l_pnsp_id igf_sl_dl_pnote_s_p.pnsp_id%TYPE;
191: l_pnpp_id igf_sl_dl_pnote_p_p.pnpp_id%TYPE;
192: l_person_num igf_aw_award_v.person_number%TYPE;
193: l_heading VARCHAR2(100);
194: l_stud_number igf_aw_award_v.person_number%TYPE;
195: l_parent_number igf_aw_award_v.person_number%TYPE;

Line 590: /* Insert into IGF_SL_DL_PNOTE_P_P */

586: END IF;
587:
588: ELSIF ( p_loan_catg = 'DL_PLUS' ) THEN
589:
590: /* Insert into IGF_SL_DL_PNOTE_P_P */
591: /* Get person details for this loan id */
592: OPEN c_plus_det( r_dl_orig_rec.loan_id );
593: FETCH c_plus_det INTO r_plus_det;
594:

Line 648: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_p_p';

644:
645: --Transaction to be rolled back whenever Lock Error
646: SAVEPOINT sp_prom_note;
647: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
648: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_p_p';
649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
650: l_debug_str := NULL;
651: END IF;
652:

Line 653: --insert into igf_sl_dl_pnote_p_p table

649: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
650: l_debug_str := NULL;
651: END IF;
652:
653: --insert into igf_sl_dl_pnote_p_p table
654: igf_sl_dl_pnote_p_p_pkg.insert_row(
655: x_mode => 'R',
656: x_rowid => l_rowid,
657: x_pnpp_id => l_pnpp_id,

Line 654: igf_sl_dl_pnote_p_p_pkg.insert_row(

650: l_debug_str := NULL;
651: END IF;
652:
653: --insert into igf_sl_dl_pnote_p_p table
654: igf_sl_dl_pnote_p_p_pkg.insert_row(
655: x_mode => 'R',
656: x_rowid => l_rowid,
657: x_pnpp_id => l_pnpp_id,
658: x_batch_seq_num => l_batch_seq_num,