APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_SL_DL_PNOTE_S_P

Line 190: l_pnsp_id igf_sl_dl_pnote_s_p.pnsp_id%TYPE;

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;
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;

Line 541: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_s_p';

537:
538: --Inorder to rollback this Transaction whenever Lock Error happens
539: SAVEPOINT sp_prom_note;
540: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
541: l_debug_str := l_debug_str || 'Before inserting into igf_sl_dl_pnote_s_p';
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
543: l_debug_str := NULL;
544: END IF;
545:

Line 546: /* Insert into IGF_SL_DL_PNOTE_S_P */

542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
543: l_debug_str := NULL;
544: END IF;
545:
546: /* Insert into IGF_SL_DL_PNOTE_S_P */
547: igf_sl_dl_pnote_s_p_pkg.insert_row(
548: x_mode => 'R',
549: x_rowid => l_rowid,
550: x_pnsp_id => l_pnsp_id,

Line 547: igf_sl_dl_pnote_s_p_pkg.insert_row(

543: l_debug_str := NULL;
544: END IF;
545:
546: /* Insert into IGF_SL_DL_PNOTE_S_P */
547: igf_sl_dl_pnote_s_p_pkg.insert_row(
548: x_mode => 'R',
549: x_rowid => l_rowid,
550: x_pnsp_id => l_pnsp_id,
551: x_batch_seq_num => l_batch_seq_num,

Line 572: l_debug_str := l_debug_str || 'Inserted into igf_sl_dl_pnote_s_p';

568: x_s_phone => l_person_phone,
569: x_status => 'N' /* not printed */
570: );
571: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
572: l_debug_str := l_debug_str || 'Inserted into igf_sl_dl_pnote_s_p';
573: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_print_pnote.process_pnote.debug', l_debug_str);
574: l_debug_str := NULL;
575: END IF;
576: