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_LI_IMPORT dependencies on IGF_AW_LI_DACT_INTS

Line 153: g_disb_net_amount igf_aw_li_dact_ints.disb_net_amt%TYPE;

149: g_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
150: g_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
151: g_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
152: g_award_id igf_aw_award_all.award_id%TYPE;
153: g_disb_net_amount igf_aw_li_dact_ints.disb_net_amt%TYPE;
154: g_person_id hz_parties.party_id%TYPE;
155: g_processing_string VARCHAR2(1000);
156: g_debug_string fnd_log_messages.message_text%TYPE;
157: g_debug_runtime_level NUMBER;

Line 1731: FROM igf_aw_li_dact_ints

1727: c_get_sp_fee_class_rec c_get_sp_fee_class%ROWTYPE;
1728:
1729: CURSOR c_get_dact_fws(p_disbursement_num igf_aw_li_disb_ints.disbursement_num%TYPE) IS
1730: SELECT disb_activity_num
1731: FROM igf_aw_li_dact_ints
1732: WHERE ci_alternate_code = li_awd_rec.ci_alternate_code
1733: AND person_number = li_awd_rec.person_number
1734: AND award_number_txt = li_awd_rec.award_number_txt
1735: AND disbursement_num = p_disbursement_num;

Line 2504: pssahni 10/20/2004 The newly added fields in the table IGF_AW_LI_DACT_INTS and table IGF_DB_AWD_DISB_DTL.

2500: Purpose : Validates disbursements activity interface record.
2501: Known Limitations,Enhancements or Remarks
2502: Change History :
2503: Who When What
2504: pssahni 10/20/2004 The newly added fields in the table IGF_AW_LI_DACT_INTS and table IGF_DB_AWD_DISB_DTL.
2505: (ORIG_FEE_AMT, GUARNT_FEE_AMT, ORIG_FEE_PAID_AMT, GUARNT_FEE_PAID_AMT, INT_REBATE_AMT)
2506: are taken into account and data is inseted into IGF_AW_DB_CHG_DTLS table also
2507: Validation is done to check that the last activity always reflect the current disbursement information.
2508:

Line 2539: FROM igf_aw_li_dact_ints disbact

2535: trim(disbact.origination_fee_paid_amt ) origination_fee_paid_amt ,
2536: trim(disbact.guarntee_fee_paid_amt ) guarntee_fee_paid_amt ,
2537: trim(disbact.interest_rebate_amt ) interest_rebate_amt ,
2538: trim(disbact.disbursement_accepted_amt ) disbursement_accepted_amt
2539: FROM igf_aw_li_dact_ints disbact
2540: WHERE ci_alternate_code = li_awd_disb_rec.ci_alternate_code
2541: AND person_number = li_awd_disb_rec.person_number
2542: AND award_number_txt = li_awd_disb_rec.award_number_txt
2543: AND disbursement_num = li_awd_disb_rec.disbursement_num

Line 2549: FROM igf_aw_li_dact_ints

2545:
2546: -- Get the last activity sequence number
2547: CURSOR cur_get_max_disb IS
2548: SELECT MAX(disb_activity_num) last_activity
2549: FROM igf_aw_li_dact_ints
2550: WHERE ci_alternate_code = li_awd_disb_rec.ci_alternate_code
2551: AND person_number = li_awd_disb_rec.person_number
2552: AND award_number_txt = li_awd_disb_rec.award_number_txt
2553: AND disbursement_num = li_awd_disb_rec.disbursement_num;

Line 2557: CURSOR cur_sf_credit_num (p_credit_num igf_aw_li_dact_ints.sf_credit_num_txt%TYPE) IS

2553: AND disbursement_num = li_awd_disb_rec.disbursement_num;
2554:
2555: max_disb_num cur_get_max_disb%ROWTYPE;
2556:
2557: CURSOR cur_sf_credit_num (p_credit_num igf_aw_li_dact_ints.sf_credit_num_txt%TYPE) IS
2558: SELECT credit_number, amount, credit_id
2559: FROM igs_fi_credits
2560: WHERE party_id = g_person_id
2561: AND credit_number = p_credit_num;

Line 2574: CURSOR cur_sf_invoice_num(p_invoice_num igf_aw_li_dact_ints.sf_invoice_num_txt%TYPE) IS

2570:
2571: r_get_cal_typ_seq_num c_get_cal_typ_seq_num%ROWTYPE;
2572:
2573:
2574: CURSOR cur_sf_invoice_num(p_invoice_num igf_aw_li_dact_ints.sf_invoice_num_txt%TYPE) IS
2575: SELECT invoice_number, invoice_amount, invoice_id
2576: FROM igs_fi_inv_int
2577: WHERE person_id = g_person_id
2578: AND invoice_number = p_invoice_num;

Line 2583: --l_disbact_rec igf_aw_li_dact_ints%ROWTYPE;

2579: cur_sf_invoice_num_rec cur_sf_invoice_num%ROWTYPE;
2580: l_trans_invoice_id igs_fi_inv_int_all.invoice_id%TYPE;
2581: l_trans_spnsr_charge_id igs_fi_inv_int_all.invoice_id%TYPE;
2582:
2583: --l_disbact_rec igf_aw_li_dact_ints%ROWTYPE;
2584: l_disbact_rec cur_li_disb_act_int%ROWTYPE;
2585: l_ctr PLS_INTEGER;
2586: l_adjust_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;
2587: l_last_disb_net_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;

Line 2586: l_adjust_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;

2582:
2583: --l_disbact_rec igf_aw_li_dact_ints%ROWTYPE;
2584: l_disbact_rec cur_li_disb_act_int%ROWTYPE;
2585: l_ctr PLS_INTEGER;
2586: l_adjust_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;
2587: l_last_disb_net_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;
2588: l_return_status_da VARCHAR2(1);
2589:
2590: TYPE disb_net_amt_tab IS TABLE OF igf_aw_li_dact_ints.disb_net_amt%TYPE;

Line 2587: l_last_disb_net_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;

2583: --l_disbact_rec igf_aw_li_dact_ints%ROWTYPE;
2584: l_disbact_rec cur_li_disb_act_int%ROWTYPE;
2585: l_ctr PLS_INTEGER;
2586: l_adjust_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;
2587: l_last_disb_net_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;
2588: l_return_status_da VARCHAR2(1);
2589:
2590: TYPE disb_net_amt_tab IS TABLE OF igf_aw_li_dact_ints.disb_net_amt%TYPE;
2591: disb_net_amt_table disb_net_amt_tab;

Line 2590: TYPE disb_net_amt_tab IS TABLE OF igf_aw_li_dact_ints.disb_net_amt%TYPE;

2586: l_adjust_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;
2587: l_last_disb_net_amt igf_aw_li_dact_ints.disb_net_amt%TYPE;
2588: l_return_status_da VARCHAR2(1);
2589:
2590: TYPE disb_net_amt_tab IS TABLE OF igf_aw_li_dact_ints.disb_net_amt%TYPE;
2591: disb_net_amt_table disb_net_amt_tab;
2592:
2593: TYPE disb_date_tab IS TABLE OF igf_aw_li_dact_ints.disb_date%TYPE;
2594: disb_date_table disb_date_tab;

Line 2593: TYPE disb_date_tab IS TABLE OF igf_aw_li_dact_ints.disb_date%TYPE;

2589:
2590: TYPE disb_net_amt_tab IS TABLE OF igf_aw_li_dact_ints.disb_net_amt%TYPE;
2591: disb_net_amt_table disb_net_amt_tab;
2592:
2593: TYPE disb_date_tab IS TABLE OF igf_aw_li_dact_ints.disb_date%TYPE;
2594: disb_date_table disb_date_tab;
2595:
2596: CURSOR c_get_all_disb_amt IS
2597: SELECT disbact.disb_net_amt, disbact.disb_date

Line 2598: FROM igf_aw_li_dact_ints disbact

2594: disb_date_table disb_date_tab;
2595:
2596: CURSOR c_get_all_disb_amt IS
2597: SELECT disbact.disb_net_amt, disbact.disb_date
2598: FROM igf_aw_li_dact_ints disbact
2599: WHERE ci_alternate_code = li_awd_disb_rec.ci_alternate_code
2600: AND person_number = li_awd_disb_rec.person_number
2601: AND award_number_txt = li_awd_disb_rec.award_number_txt
2602: AND disbursement_num = li_awd_disb_rec.disbursement_num

Line 2610: FROM igf_aw_li_dact_ints

2606: -- Get the last disbursment sequence number activity
2607: CURSOR c_get_last_activity (p_disb_seq_num NUMBER)
2608: IS
2609: SELECT *
2610: FROM igf_aw_li_dact_ints
2611: WHERE ci_alternate_code = li_awd_disb_rec.ci_alternate_code
2612: AND person_number = li_awd_disb_rec.person_number
2613: AND award_number_txt = li_awd_disb_rec.award_number_txt
2614: AND disbursement_num = li_awd_disb_rec.disbursement_num

Line 3301: DELETE FROM igf_aw_li_dact_ints

3297: AND person_number = ctx_li_awd_rec.person_number
3298: AND award_number_txt = ctx_li_awd_rec.award_number_txt
3299: AND import_status_type = ctx_li_awd_rec.import_status_type;
3300: ELSIF(p_operation = 'D') THEN
3301: DELETE FROM igf_aw_li_dact_ints
3302: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3303: AND person_number = ctx_li_awd_rec.person_number
3304: AND award_number_txt = ctx_li_awd_rec.award_number_txt;
3305: