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

Line 85: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE ,

81: PROCEDURE proc_update_loan_rec(p_loan_rec igf_sl_loans%ROWTYPE);
82:
83: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,
84: p_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,
85: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE ,
86: p_v_send_record_txt IN igf_sl_clchsn_dtls.send_record_txt%TYPE
87: );
88:
89: PROCEDURE create_file (

Line 834: FROM igf_aw_awd_disb_all awd

830: --Who When What
831: ------------------------------------------------------------------
832: CURSOR c_nof_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
833: SELECT COUNT(awd.disb_num) tot_disb
834: FROM igf_aw_awd_disb_all awd
835: WHERE awd.award_id = cp_n_award_id
836: GROUP BY awd.award_id
837: HAVING COUNT(awd.disb_num) > 4;
838:

Line 1602: FROM igf_aw_awd_disb_all adisb

1598: SELECT adisb.disb_date
1599: ,NVL(adisb.disb_accepted_amt,0) disb_accepted_amt
1600: ,adisb.hold_rel_ind
1601: ,adisb.disb_num
1602: FROM igf_aw_awd_disb_all adisb
1603: WHERE adisb.award_id = cp_n_award_id
1604: ORDER BY adisb.disb_num;
1605:
1606: CURSOR c_aw_awd_disb2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,

Line 1607: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE

1603: WHERE adisb.award_id = cp_n_award_id
1604: ORDER BY adisb.disb_num;
1605:
1606: CURSOR c_aw_awd_disb2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,
1607: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
1608: ) IS
1609: SELECT adisb.disb_date
1610: ,NVL(adisb.disb_accepted_amt,0) disb_accepted_amt
1611: ,adisb.hold_rel_ind

Line 1617: FROM igf_aw_awd_disb_all adisb

1613: ,adisb.fee_1
1614: ,adisb.fee_2
1615: ,adisb.fee_paid_1
1616: ,adisb.fee_paid_2
1617: FROM igf_aw_awd_disb_all adisb
1618: WHERE adisb.award_id = cp_n_award_id
1619: AND adisb.disb_num = cp_n_disb_num
1620: ORDER BY adisb.disb_num;
1621:

Line 1712: l_n_disb_number igf_aw_awd_disb_all.disb_num%TYPE;

1708:
1709: -- variables for (@1-09)
1710: l_v_chg_01_9_rec VARCHAR2(4000);
1711: l_c_01_09_flg VARCHAR2(1);
1712: l_n_disb_number igf_aw_awd_disb_all.disb_num%TYPE;
1713:
1714: TYPE chsn_09dtl_rectyp IS RECORD (
1715: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,
1716: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,

Line 1715: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,

1711: l_c_01_09_flg VARCHAR2(1);
1712: l_n_disb_number igf_aw_awd_disb_all.disb_num%TYPE;
1713:
1714: TYPE chsn_09dtl_rectyp IS RECORD (
1715: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,
1716: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,
1717: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%TYPE ,
1718: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,
1719: disb_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE ,

Line 1716: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,

1712: l_n_disb_number igf_aw_awd_disb_all.disb_num%TYPE;
1713:
1714: TYPE chsn_09dtl_rectyp IS RECORD (
1715: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,
1716: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,
1717: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%TYPE ,
1718: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,
1719: disb_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE ,
1720: revised_disb_date igf_sl_clchsn_dtls.disbursement_revised_date%TYPE,

Line 1719: disb_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE ,

1715: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,
1716: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,
1717: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%TYPE ,
1718: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,
1719: disb_hold_rel_ind igf_aw_awd_disb_all.hold_rel_ind%TYPE ,
1720: revised_disb_date igf_sl_clchsn_dtls.disbursement_revised_date%TYPE,
1721: revised_disb_amt igf_sl_clchsn_dtls.disbursement_revised_amt%TYPE ,
1722: reinstate_ind igf_sl_clchsn_dtls.disbursement_reinst_code%TYPE
1723: );

Line 1733: l_n_post_disb_number igf_aw_awd_disb_all.disb_num%TYPE;

1729:
1730: -- variables for (@1-10)
1731: l_v_chg_01_10_rec VARCHAR2(4000);
1732: l_c_01_10_flg VARCHAR2(1);
1733: l_n_post_disb_number igf_aw_awd_disb_all.disb_num%TYPE;
1734:
1735: TYPE chsn_10dtl_rectyp IS RECORD (
1736: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,
1737: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,

Line 1736: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,

1732: l_c_01_10_flg VARCHAR2(1);
1733: l_n_post_disb_number igf_aw_awd_disb_all.disb_num%TYPE;
1734:
1735: TYPE chsn_10dtl_rectyp IS RECORD (
1736: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,
1737: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,
1738: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%TYPE ,
1739: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,
1740: disb_consummation_ind VARCHAR2(30) ,

Line 1737: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,

1733: l_n_post_disb_number igf_aw_awd_disb_all.disb_num%TYPE;
1734:
1735: TYPE chsn_10dtl_rectyp IS RECORD (
1736: disb_number igf_aw_awd_disb_all.disb_num%TYPE ,
1737: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,
1738: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%TYPE ,
1739: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,
1740: disb_consummation_ind VARCHAR2(30) ,
1741: actual_return_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE ,

Line 1741: actual_return_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE ,

1737: disb_date igf_aw_awd_disb_all.disb_date%TYPE ,
1738: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%TYPE ,
1739: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,
1740: disb_consummation_ind VARCHAR2(30) ,
1741: actual_return_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE ,
1742: fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE ,
1743: fund_reissue_code igf_sl_clchsn_dtls.disbursement_reissue_code%TYPE,
1744: revised_disb_date igf_sl_clchsn_dtls.disbursement_revised_date%TYPE,
1745: revised_disb_amt igf_sl_clchsn_dtls.disbursement_revised_amt%TYPE ,

Line 1742: fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE ,

1738: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%TYPE ,
1739: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,
1740: disb_consummation_ind VARCHAR2(30) ,
1741: actual_return_amt igf_aw_awd_disb_all.disb_accepted_amt%TYPE ,
1742: fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE ,
1743: fund_reissue_code igf_sl_clchsn_dtls.disbursement_reissue_code%TYPE,
1744: revised_disb_date igf_sl_clchsn_dtls.disbursement_revised_date%TYPE,
1745: revised_disb_amt igf_sl_clchsn_dtls.disbursement_revised_amt%TYPE ,
1746: reinstate_ind igf_sl_clchsn_dtls.disbursement_reinst_code%TYPE

Line 1759: l_n_loan_amt_increase igf_aw_awd_disb_all.disb_accepted_amt%TYPE;

1755: -- variables for (@1-24)
1756: l_v_chg_01_24_rec VARCHAR2(4000);
1757: l_v_disb_rec VARCHAR2(1000);
1758: l_c_01_24_flg VARCHAR2(1);
1759: l_n_loan_amt_increase igf_aw_awd_disb_all.disb_accepted_amt%TYPE;
1760: l_n_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1761: l_n_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1762: l_n_est_fin igf_aw_award_all.accepted_amt%TYPE;
1763: l_n_pell_efc NUMBER;

Line 2935: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE ,

2931: END sub_create_file;
2932:
2933: PROCEDURE proc_update_clchsn_dtls_rec(p_v_loan_number IN igf_sl_loans.loan_number%TYPE ,
2934: p_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,
2935: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE ,
2936: p_v_send_record_txt IN igf_sl_clchsn_dtls.send_record_txt%TYPE
2937: ) AS
2938: ------------------------------------------------------------------
2939: --Created by : Sanil Madathil, Oracle IDC

Line 2958: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE

2954: --Who When What
2955: ------------------------------------------------------------------
2956: CURSOR c_sl_clchsn_dtls (cp_v_loan_number IN igf_sl_loans_all.loan_number%TYPE ,
2957: cp_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,
2958: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
2959: ) IS
2960: SELECT chdt.ROWID row_id
2961: ,chdt.*
2962: FROM igf_sl_clchsn_dtls chdt

Line 2973: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE ;

2969: rec_c_sl_clchsn_dtls c_sl_clchsn_dtls%ROWTYPE;
2970:
2971: l_v_loan_number igf_sl_loans.loan_number%TYPE ;
2972: l_v_change_record_typ igf_sl_clchsn_dtls.change_record_type_txt%TYPE ;
2973: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE ;
2974: l_v_send_record_txt igf_sl_clchsn_dtls.send_record_txt%TYPE ;
2975: BEGIN
2976: log_to_fnd(p_v_module => 'proc_update_clchsn_dtls_rec',
2977: p_v_string => ' Entered Procedure proc_update_clchsn_dtls_rec: The input parameters are '||