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_CL_CREATE_CHG dependencies on IGF_AW_AWD_DISB_ALL

Line 1477: FROM igf_aw_awd_disb_all adisb

1473: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;
1474:
1475: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1476: SELECT adisb.disb_num
1477: FROM igf_aw_awd_disb_all adisb
1478: WHERE adisb.award_id = cp_n_award_id
1479: AND NVL(adisb.fund_status,'N') = 'Y';
1480:
1481: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

Line 1507: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

1503: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
1504: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1507: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1508: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
1509: l_v_response_status_code igf_sl_clchsn_dtls.response_status_code%TYPE;
1510: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;
1511:

Line 2836: PROCEDURE create_disb_chg_rec ( p_new_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,

2832:
2833: END create_awd_chg_rec;
2834:
2835:
2836: PROCEDURE create_disb_chg_rec ( p_new_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,
2837: p_old_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,
2838: p_b_return_status OUT NOCOPY BOOLEAN,
2839: p_v_message_name OUT NOCOPY VARCHAR2
2840: ) AS

Line 2837: p_old_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,

2833: END create_awd_chg_rec;
2834:
2835:
2836: PROCEDURE create_disb_chg_rec ( p_new_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,
2837: p_old_disb_rec IN igf_aw_awd_disb_all%ROWTYPE,
2838: p_b_return_status OUT NOCOPY BOOLEAN,
2839: p_v_message_name OUT NOCOPY VARCHAR2
2840: ) AS
2841: ------------------------------------------------------------------

Line 2873: cp_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE

2869:
2870: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;
2871:
2872: CURSOR c_resp_r1_r8 (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
2873: cp_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2874: ) IS
2875: SELECT resp_r8.disb_date
2876: ,resp_r8.disb_gross_amt
2877: ,resp_r8.disb_hold_rel_ind

Line 2904: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;

2900: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
2901: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
2902: l_n_award_id igf_aw_award_all.award_id%TYPE;
2903: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
2904: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;

Line 2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;

2901: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
2902: l_n_award_id igf_aw_award_all.award_id%TYPE;
2903: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
2904: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;

Line 2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;

2902: l_n_award_id igf_aw_award_all.award_id%TYPE;
2903: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
2904: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;

Line 2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;

2903: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
2904: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;

Line 2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;

2904: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;

Line 2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;

2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;
2913: l_v_change_code_txt igf_sl_clchsn_dtls.change_code_txt%TYPE;

Line 2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;

2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;
2913: l_v_change_code_txt igf_sl_clchsn_dtls.change_code_txt%TYPE;
2914: l_d_disb_cancel_dt igf_aw_awd_disb_all.disb_DATE%TYPE;

Line 2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;

2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;
2913: l_v_change_code_txt igf_sl_clchsn_dtls.change_code_txt%TYPE;
2914: l_d_disb_cancel_dt igf_aw_awd_disb_all.disb_DATE%TYPE;
2915: l_n_disb_cancel_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;

Line 2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;

2908: l_c_resp_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2909: l_n_new_disb_accepted_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;
2913: l_v_change_code_txt igf_sl_clchsn_dtls.change_code_txt%TYPE;
2914: l_d_disb_cancel_dt igf_aw_awd_disb_all.disb_DATE%TYPE;
2915: l_n_disb_cancel_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2916: l_v_fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE;

Line 2914: l_d_disb_cancel_dt igf_aw_awd_disb_all.disb_DATE%TYPE;

2910: l_d_new_disb_date igf_aw_awd_disb_all.disb_date%TYPE;
2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;
2913: l_v_change_code_txt igf_sl_clchsn_dtls.change_code_txt%TYPE;
2914: l_d_disb_cancel_dt igf_aw_awd_disb_all.disb_DATE%TYPE;
2915: l_n_disb_cancel_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2916: l_v_fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE;
2917:
2918: e_valid_edits EXCEPTION;

Line 2915: l_n_disb_cancel_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;

2911: l_c_new_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE;
2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;
2913: l_v_change_code_txt igf_sl_clchsn_dtls.change_code_txt%TYPE;
2914: l_d_disb_cancel_dt igf_aw_awd_disb_all.disb_DATE%TYPE;
2915: l_n_disb_cancel_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2916: l_v_fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE;
2917:
2918: e_valid_edits EXCEPTION;
2919: e_resource_busy EXCEPTION;

Line 2916: l_v_fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE;

2912: l_v_new_change_type_code igf_aw_awd_disb_all.change_type_code%TYPE;
2913: l_v_change_code_txt igf_sl_clchsn_dtls.change_code_txt%TYPE;
2914: l_d_disb_cancel_dt igf_aw_awd_disb_all.disb_DATE%TYPE;
2915: l_n_disb_cancel_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2916: l_v_fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE;
2917:
2918: e_valid_edits EXCEPTION;
2919: e_resource_busy EXCEPTION;
2920: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;