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_GEN dependencies on IGF_DB_AWD_DISB_DTL

Line 306: -- ayedubat 11-OCT-2004 Changed the calling of procedure, igf_db_awd_disb_dtl_pkg.insert_row

302:
303: --------------------------------------------------------------------------------------
304: -- sjadhav 05-Nov-2004 FA 134 Build. Update loans table if disb data changes
305: --------------------------------------------------------------------------------------
306: -- ayedubat 11-OCT-2004 Changed the calling of procedure, igf_db_awd_disb_dtl_pkg.insert_row
307: -- to pass NULL values for the columns, DISB_STATUS, DISB_STATUS_DATE,
308: -- DISB_BATCH_ID, DISB_ACK_DATE, BOOKING_BATCH_ID and BOOKED_DATE for Bug, 3416863
309: -- sjadhav 18-Feb-2003 Bug 2758823
310: -- Modified update_disb routine to create adjustment

Line 324: p_award_id igf_db_awd_disb_dtl.award_id%TYPE

320: --
321: -- Cursor to get loan details
322: --
323: CURSOR cur_loans(
324: p_award_id igf_db_awd_disb_dtl.award_id%TYPE
325: )
326: IS
327: SELECT loan.*
328: FROM igf_sl_loans loan

Line 339: p_award_id igf_db_awd_disb_dtl.award_id%TYPE

335: --
336: -- Cursor to get Fed Fund Code
337: --
338: CURSOR cur_get_fed(
339: p_award_id igf_db_awd_disb_dtl.award_id%TYPE
340: )
341: IS
342: SELECT cat.fed_fund_code, awd.award_status award_status
343: FROM igf_aw_award awd, igf_aw_fund_mast fmast, igf_aw_fund_cat cat

Line 351: p_award_id igf_db_awd_disb_dtl.award_id%TYPE,

347:
348: get_fed_rec cur_get_fed%ROWTYPE;
349:
350: CURSOR c_max_seq_num(
351: p_award_id igf_db_awd_disb_dtl.award_id%TYPE,
352: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
353: )
354: IS
355: SELECT MAX(disb_seq_num) max_num

Line 356: FROM igf_db_awd_disb_dtl

352: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
353: )
354: IS
355: SELECT MAX(disb_seq_num) max_num
356: FROM igf_db_awd_disb_dtl
357: WHERE award_id = p_award_id AND disb_num = p_disb_num;
358:
359:
360: CURSOR c_get_net_total(

Line 361: p_award_id igf_db_awd_disb_dtl.award_id%TYPE,

357: WHERE award_id = p_award_id AND disb_num = p_disb_num;
358:
359:
360: CURSOR c_get_net_total(
361: p_award_id igf_db_awd_disb_dtl.award_id%TYPE,
362: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE
363: )
364: IS
365: SELECT

Line 367: FROM igf_db_awd_disb_dtl_all

363: )
364: IS
365: SELECT
366: SUM(DECODE(DISB_ACTIVITY,'D',DISB_NET_AMT,'A',DISB_ADJ_AMT,'Q',0)) net_total
367: FROM igf_db_awd_disb_dtl_all
368: WHERE award_id =p_award_id AND disb_num = p_disb_num AND sf_status in('R','P','E');
369:
370: r_get_net_total c_get_net_total%ROWTYPE;
371:

Line 375: dbdtlrec igf_db_awd_disb_dtl%ROWTYPE;

371:
372:
373: lv_max_seq_num c_max_seq_num%ROWTYPE;
374: lv_rowid VARCHAR2(25);
375: dbdtlrec igf_db_awd_disb_dtl%ROWTYPE;
376: BEGIN
377:
378: --
379: -- check if any of the following fields are changed

Line 445: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);

441: THEN
442: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
443: THEN
444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
445: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
446: END IF;
447:
448: igf_db_awd_disb_dtl_pkg.insert_row(
449: x_rowid => lv_rowid,

Line 448: igf_db_awd_disb_dtl_pkg.insert_row(

444: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
445: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
446: END IF;
447:
448: igf_db_awd_disb_dtl_pkg.insert_row(
449: x_rowid => lv_rowid,
450: x_award_id => dbdtlrec.award_id,
451: x_disb_num => dbdtlrec.disb_num,
452: x_disb_seq_num => dbdtlrec.disb_seq_num,

Line 544: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);

540: THEN
541: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
542: THEN
543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
544: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
545: END IF;
546: --creating an invoice record in disb_dtl table
547: igf_db_awd_disb_dtl_pkg.insert_row(
548: x_rowid => lv_rowid,

Line 547: igf_db_awd_disb_dtl_pkg.insert_row(

543: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
544: 'Inserting igf_db_awd_disb_dtl award_id '|| dbdtlrec.award_id);
545: END IF;
546: --creating an invoice record in disb_dtl table
547: igf_db_awd_disb_dtl_pkg.insert_row(
548: x_rowid => lv_rowid,
549: x_award_id => dbdtlrec.award_id,
550: x_disb_num => dbdtlrec.disb_num,
551: x_disb_seq_num => dbdtlrec.disb_seq_num,

Line 594: igf_db_awd_disb_dtl_pkg.insert_row(

590: dbdtlrec.disb_date := p_disb_old_rec.disb_date;--this should be old disb date only
591:
592: --creating an credit record in disb_dtl table
593:
594: igf_db_awd_disb_dtl_pkg.insert_row(
595: x_rowid => lv_rowid,
596: x_award_id => dbdtlrec.award_id,
597: x_disb_num => dbdtlrec.disb_num,
598: x_disb_seq_num => dbdtlrec.disb_seq_num+1,

Line 684: 'Inserting to igf_db_awd_disb_dtl award_id:'|| dbdtlrec.award_id);

680: THEN
681: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
682: THEN
683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
684: 'Inserting to igf_db_awd_disb_dtl award_id:'|| dbdtlrec.award_id);
685: END IF;
686:
687: igf_db_awd_disb_dtl_pkg.insert_row(
688: x_rowid => lv_rowid,

Line 687: igf_db_awd_disb_dtl_pkg.insert_row(

683: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_gen.update_disb.debug',
684: 'Inserting to igf_db_awd_disb_dtl award_id:'|| dbdtlrec.award_id);
685: END IF;
686:
687: igf_db_awd_disb_dtl_pkg.insert_row(
688: x_rowid => lv_rowid,
689: x_award_id => dbdtlrec.award_id,
690: x_disb_num => dbdtlrec.disb_num,
691: x_disb_seq_num => dbdtlrec.disb_seq_num,