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_SL_CLCHSN_DTLS

Line 84: p_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,

80:
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:

Line 86: p_v_send_record_txt IN igf_sl_clchsn_dtls.send_record_txt%TYPE

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 (
90: errbuf OUT NOCOPY VARCHAR2,

Line 999: FROM igf_sl_clchsn_dtls chdt

995: ------------------------------------------------------------------
996: CURSOR c_sl_clchsn_dtls (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
997: SELECT chdt.ROWID row_id
998: ,chdt.*
999: FROM igf_sl_clchsn_dtls chdt
1000: WHERE chdt.loan_number_txt = cp_v_loan_number
1001: AND chdt.status_code ='R';
1002:
1003: CURSOR c_lor_lar (cp_v_cal_type IN igs_ca_inst_all.cal_type%TYPE,

Line 1207: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'

1203: */
1204: l_v_message_text := fnd_message.get;
1205: fnd_file.put_line(fnd_file.log, l_v_message_text);
1206: log_to_fnd(p_v_module => 'identify_clchsn_dtls',
1207: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
1208: );
1209: igf_sl_clchsn_dtls_pkg.update_row
1210: (
1211: x_rowid => rec_c_sl_clchsn_dtls.row_id ,

Line 1209: igf_sl_clchsn_dtls_pkg.update_row

1205: fnd_file.put_line(fnd_file.log, l_v_message_text);
1206: log_to_fnd(p_v_module => 'identify_clchsn_dtls',
1207: p_v_string => ' Invoking igf_sl_clchsn_dtls_pkg.update_row to update the status to Not Ready to Send'
1208: );
1209: igf_sl_clchsn_dtls_pkg.update_row
1210: (
1211: x_rowid => rec_c_sl_clchsn_dtls.row_id ,
1212: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,
1213: x_award_id => rec_c_sl_clchsn_dtls.award_id ,

Line 1592: FROM igf_sl_clchsn_dtls chdt

1588:
1589: CURSOR c_sl_clchsn_dtls (cp_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) IS
1590: SELECT chdt.ROWID row_id
1591: ,chdt.*
1592: FROM igf_sl_clchsn_dtls chdt
1593: WHERE chdt.loan_number_txt = cp_v_loan_number
1594: AND chdt.status_code ='R'
1595: ORDER BY change_record_type_txt,disbursement_number;
1596:

Line 1717: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%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,
1721: revised_disb_amt igf_sl_clchsn_dtls.disbursement_revised_amt%TYPE ,

Line 1718: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,

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,
1721: revised_disb_amt igf_sl_clchsn_dtls.disbursement_revised_amt%TYPE ,
1722: reinstate_ind igf_sl_clchsn_dtls.disbursement_reinst_code%TYPE

Line 1720: revised_disb_date igf_sl_clchsn_dtls.disbursement_revised_date%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: );
1724: l_rec_chsn_09dtl chsn_09dtl_rectyp;

Line 1721: revised_disb_amt igf_sl_clchsn_dtls.disbursement_revised_amt%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: );
1724: l_rec_chsn_09dtl chsn_09dtl_rectyp;
1725:

Line 1722: reinstate_ind igf_sl_clchsn_dtls.disbursement_reinst_code%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: );
1724: l_rec_chsn_09dtl chsn_09dtl_rectyp;
1725:
1726: TYPE tab_rec_09_dtl IS TABLE OF l_rec_chsn_09dtl%TYPE INDEX BY BINARY_INTEGER;

Line 1738: disb_cancel_date igf_sl_clchsn_dtls.disbursement_cancel_date%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 ,
1742: fund_return_mthd_code igf_aw_awd_disb_all.fund_return_mthd_code%TYPE ,

Line 1739: disb_cancel_amt igf_sl_clchsn_dtls.disbursement_cancel_amt%TYPE ,

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

Line 1743: fund_reissue_code igf_sl_clchsn_dtls.disbursement_reissue_code%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
1747: );

Line 1744: revised_disb_date igf_sl_clchsn_dtls.disbursement_revised_date%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
1747: );
1748: l_rec_chsn_10dtl chsn_10dtl_rectyp;

Line 1745: revised_disb_amt igf_sl_clchsn_dtls.disbursement_revised_amt%TYPE ,

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
1747: );
1748: l_rec_chsn_10dtl chsn_10dtl_rectyp;
1749:

Line 1746: reinstate_ind igf_sl_clchsn_dtls.disbursement_reinst_code%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
1747: );
1748: l_rec_chsn_10dtl chsn_10dtl_rectyp;
1749:
1750: TYPE tab_rec_10_dtl IS TABLE OF l_rec_chsn_10dtl%TYPE INDEX BY BINARY_INTEGER;

Line 2307: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2303: log_to_fnd(p_v_module => 'sub_create_file',
2304: p_v_string => ' change send @1-07 record '||l_v_chg_01_7_rec
2305: );
2306: log_to_fnd(p_v_module => 'sub_create_file',
2307: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2308: ' with the send record text and to move status code to Sent for change send @1-07 record'
2309: );
2310: proc_update_clchsn_dtls_rec(
2311: p_v_loan_number => rec_c_recip_dtls.loan_number ,

Line 2317: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2313: p_n_disb_num => NULL ,
2314: p_v_send_record_txt => SUBSTR(l_v_chg_01_7_rec,3,(INSTR(l_v_chg_01_7_rec,'*')-3))
2315: );
2316: log_to_fnd(p_v_module => 'sub_create_file',
2317: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2318: ' for change send @1-07 record '
2319: );
2320: END IF;
2321:

Line 2371: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2367: log_to_fnd(p_v_module => 'sub_create_file',
2368: p_v_string => ' change send @1-08 record '||l_v_chg_01_8_rec
2369: );
2370: log_to_fnd(p_v_module => 'sub_create_file',
2371: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2372: ' with the send record text and to move status code to Sent for change send @1-08 record'
2373: );
2374: proc_update_clchsn_dtls_rec(
2375: p_v_loan_number => rec_c_recip_dtls.loan_number ,

Line 2381: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2377: p_n_disb_num => NULL ,
2378: p_v_send_record_txt => SUBSTR(l_v_chg_01_8_rec,3,(INSTR(l_v_chg_01_8_rec,'*')-3))
2379: );
2380: log_to_fnd(p_v_module => 'sub_create_file',
2381: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2382: ' for change send @1-08 record '
2383: );
2384: END IF;
2385:

Line 2456: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2452: log_to_fnd(p_v_module => 'sub_create_file',
2453: p_v_string => ' change send @1-09 record '||l_v_chg_01_9_rec
2454: );
2455: log_to_fnd(p_v_module => 'sub_create_file',
2456: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2457: ' with the send record text and to move status code to Sent for change send @1-09 record'
2458: );
2459: proc_update_clchsn_dtls_rec(
2460: p_v_loan_number => rec_c_recip_dtls.loan_number ,

Line 2466: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2462: p_n_disb_num => v_tab_rec_09_dtl(l_n_ctr_09).disb_number ,
2463: p_v_send_record_txt => SUBSTR(l_v_chg_01_9_rec,3,(INSTR(l_v_chg_01_9_rec,'*')-3))
2464: );
2465: log_to_fnd(p_v_module => 'sub_create_file',
2466: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2467: ' for change send @1-09 record '
2468: );
2469: END LOOP;
2470: v_tab_rec_09_dtl.DELETE;

Line 2539: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2535: log_to_fnd(p_v_module => 'sub_create_file',
2536: p_v_string => ' change send @1-10 record '||l_v_chg_01_10_rec
2537: );
2538: log_to_fnd(p_v_module => 'sub_create_file',
2539: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2540: ' with the send record text and to move status code to Sent for change send @1-10 record'
2541: );
2542: proc_update_clchsn_dtls_rec(
2543: p_v_loan_number => rec_c_recip_dtls.loan_number ,

Line 2549: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2545: p_n_disb_num => v_tab_rec_10_dtl(l_n_ctr_10).disb_number ,
2546: p_v_send_record_txt => SUBSTR(l_v_chg_01_10_rec,3,(INSTR(l_v_chg_01_10_rec,'*')-3))
2547: );
2548: log_to_fnd(p_v_module => 'sub_create_file',
2549: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2550: ' for change send @1-10 record '
2551: );
2552: END LOOP;
2553: v_tab_rec_10_dtl.DELETE;

Line 2642: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2638: log_to_fnd(p_v_module => 'sub_create_file',
2639: p_v_string => ' change send @1-24 record '||l_v_chg_01_24_rec
2640: );
2641: log_to_fnd(p_v_module => 'sub_create_file',
2642: p_v_string => ' Invoking proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2643: ' with the send record text and to move status code to Sent for change send @1-24 record'
2644: );
2645: proc_update_clchsn_dtls_rec(
2646: p_v_loan_number => rec_c_recip_dtls.loan_number ,

Line 2652: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||

2648: p_n_disb_num => NULL ,
2649: p_v_send_record_txt => SUBSTR(l_v_chg_01_24_rec,3,(INSTR(l_v_chg_01_24_rec,'*')-3))
2650: );
2651: log_to_fnd(p_v_module => 'sub_create_file',
2652: p_v_string => ' Successfully Invoked proc_update_clchsn_dtls_rec to update the igf_sl_clchsn_dtls table ' ||
2653: ' for change send @1-24 record '
2654: );
2655: END IF;
2656:

Line 2934: p_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,

2930: igs_ge_msg_stack.conc_exception_hndl;
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: ------------------------------------------------------------------

Line 2936: p_v_send_record_txt IN igf_sl_clchsn_dtls.send_record_txt%TYPE

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
2940: --Date created: 16 November 2004

Line 2957: cp_v_change_record_typ IN igf_sl_clchsn_dtls.change_record_type_txt%TYPE ,

2953: --Change History:
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.*

Line 2962: FROM igf_sl_clchsn_dtls chdt

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
2963: WHERE chdt.loan_number_txt = cp_v_loan_number
2964: AND chdt.change_record_type_txt = cp_v_change_record_typ
2965: AND ((chdt.disbursement_number = cp_n_disb_num) OR (cp_n_disb_num IS NULL))
2966: AND chdt.status_code ='R'

Line 2972: l_v_change_record_typ igf_sl_clchsn_dtls.change_record_type_txt%TYPE ;

2968:
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',

Line 2974: l_v_send_record_txt igf_sl_clchsn_dtls.send_record_txt%TYPE ;

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 '||
2978: ' p_v_loan_number : ' ||p_v_loan_number ||

Line 2996: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id

2992: cp_n_disb_num => l_n_disb_num
2993: )
2994: LOOP
2995: log_to_fnd(p_v_module => 'proc_update_clchsn_dtls_rec',
2996: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id
2997: );
2998:
2999: igf_sl_clchsn_dtls_pkg.update_row (
3000: x_rowid => rec_c_sl_clchsn_dtls.row_id ,

Line 2999: igf_sl_clchsn_dtls_pkg.update_row (

2995: log_to_fnd(p_v_module => 'proc_update_clchsn_dtls_rec',
2996: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id
2997: );
2998:
2999: igf_sl_clchsn_dtls_pkg.update_row (
3000: x_rowid => rec_c_sl_clchsn_dtls.row_id ,
3001: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,
3002: x_award_id => rec_c_sl_clchsn_dtls.award_id ,
3003: x_loan_number_txt => rec_c_sl_clchsn_dtls.loan_number_txt ,

Line 3042: p_v_string => 'Call out to igf_sl_clchsn_dtls_pkg.update_row successful for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id

3038: x_send_record_txt => l_v_send_record_txt ,
3039: x_mode => 'R'
3040: );
3041: log_to_fnd(p_v_module => 'proc_update_clchsn_dtls_rec',
3042: p_v_string => 'Call out to igf_sl_clchsn_dtls_pkg.update_row successful for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id
3043: );
3044:
3045: END LOOP;
3046: