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.

[Home] [Help]

APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_SL_GEN

Line 1686: c_borrower_dtls igf_sl_gen.person_dtl_cur;

1682:
1683: -- variables for (@1-02)
1684: l_n_borrower_id igf_ap_fa_base_rec_all.person_id%TYPE;
1685: l_v_chg_01_2_rec VARCHAR2(2000);
1686: c_borrower_dtls igf_sl_gen.person_dtl_cur;
1687: rec_borrower_dtls igf_sl_gen.person_dtl_rec;
1688: l_v_filler_3_char VARCHAR2(3);
1689:
1690: -- variables for (@1-07)

Line 1687: rec_borrower_dtls igf_sl_gen.person_dtl_rec;

1683: -- variables for (@1-02)
1684: l_n_borrower_id igf_ap_fa_base_rec_all.person_id%TYPE;
1685: l_v_chg_01_2_rec VARCHAR2(2000);
1686: c_borrower_dtls igf_sl_gen.person_dtl_cur;
1687: rec_borrower_dtls igf_sl_gen.person_dtl_rec;
1688: l_v_filler_3_char VARCHAR2(3);
1689:
1690: -- variables for (@1-07)
1691: l_v_chg_01_7_rec VARCHAR2(4000);

Line 1695: c_student_dtls igf_sl_gen.person_dtl_cur;

1691: l_v_chg_01_7_rec VARCHAR2(4000);
1692: l_c_01_07_flg VARCHAR2(1);
1693: l_v_loan_type igf_aw_fund_cat_all.fed_fund_code%TYPE;
1694: l_v_alt_prog_type_code igf_sl_lor_all.alt_prog_type_code%TYPE;
1695: c_student_dtls igf_sl_gen.person_dtl_cur;
1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1699: l_d_old_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;

Line 1696: rec_student_dtls igf_sl_gen.person_dtl_rec;

1692: l_c_01_07_flg VARCHAR2(1);
1693: l_v_loan_type igf_aw_fund_cat_all.fed_fund_code%TYPE;
1694: l_v_alt_prog_type_code igf_sl_lor_all.alt_prog_type_code%TYPE;
1695: c_student_dtls igf_sl_gen.person_dtl_cur;
1696: rec_student_dtls igf_sl_gen.person_dtl_rec;
1697: l_d_revised_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1698: l_d_revised_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;
1699: l_d_old_per_begin_dt igf_sl_loans_all.loan_per_begin_date%TYPE;
1700: l_d_old_per_end_dt igf_sl_loans_all.loan_per_end_date%TYPE;

Line 1802: l_v_cl_version := igf_sl_gen.get_cl_version(

1798: l_v_file_crea_time := TO_CHAR(SYSDATE,'HH24MISS');
1799: -- obtain the common line release version based on the award year and relationship code passed as parameter
1800: -- museshad(Bug# 4346258) - Added the parameter p_base_id due to change in the
1801: -- signature of the function 'get_cl_version()'
1802: l_v_cl_version := igf_sl_gen.get_cl_version(
1803: p_ci_cal_type => l_v_cal_type ,
1804: p_ci_seq_num => l_n_sequence_number ,
1805: p_relationship_cd => l_v_relationship_cd ,
1806: p_base_id => l_n_base_id

Line 1808: l_v_file_ident_code := igf_sl_gen.get_cl_file_type(l_v_cl_version, 'CL_CHANGE_TRANS', 'FILE-IDENT-CODE');

1804: p_ci_seq_num => l_n_sequence_number ,
1805: p_relationship_cd => l_v_relationship_cd ,
1806: p_base_id => l_n_base_id
1807: );
1808: l_v_file_ident_code := igf_sl_gen.get_cl_file_type(l_v_cl_version, 'CL_CHANGE_TRANS', 'FILE-IDENT-CODE');
1809: l_v_file_ident_name := igf_sl_gen.get_cl_file_type(l_v_cl_version, 'CL_CHANGE_TRANS', 'FILE-IDENT-NAME');
1810: -- get the source name
1811: OPEN c_school_opeid(cp_v_school_id => l_v_school_id);
1812: FETCH c_school_opeid INTO l_v_source_name;

Line 1809: l_v_file_ident_name := igf_sl_gen.get_cl_file_type(l_v_cl_version, 'CL_CHANGE_TRANS', 'FILE-IDENT-NAME');

1805: p_relationship_cd => l_v_relationship_cd ,
1806: p_base_id => l_n_base_id
1807: );
1808: l_v_file_ident_code := igf_sl_gen.get_cl_file_type(l_v_cl_version, 'CL_CHANGE_TRANS', 'FILE-IDENT-CODE');
1809: l_v_file_ident_name := igf_sl_gen.get_cl_file_type(l_v_cl_version, 'CL_CHANGE_TRANS', 'FILE-IDENT-NAME');
1810: -- get the source name
1811: OPEN c_school_opeid(cp_v_school_id => l_v_school_id);
1812: FETCH c_school_opeid INTO l_v_source_name;
1813: CLOSE c_school_opeid ;

Line 1960: igf_sl_gen.get_person_details(rec_c_recip_dtls.borrower_id,c_borrower_dtls);

1956: IF (l_n_borrower_id <> rec_c_recip_dtls.borrower_id) THEN
1957: l_v_chg_01_2_rec := NULL;
1958: l_n_borrower_id := rec_c_recip_dtls.borrower_id;
1959: -- get the borrower details
1960: igf_sl_gen.get_person_details(rec_c_recip_dtls.borrower_id,c_borrower_dtls);
1961: FETCH c_borrower_dtls INTO rec_borrower_dtls;
1962: CLOSE c_borrower_dtls;
1963: -- constructing change send @1-02 record
1964: log_to_fnd(p_v_module => 'sub_create_file',

Line 2001: igf_sl_gen.get_person_details(rec_c_recip_dtls.student_id,c_student_dtls);

1997: );
1998: END IF;
1999:
2000: -- get the student details
2001: igf_sl_gen.get_person_details(rec_c_recip_dtls.student_id,c_student_dtls);
2002: FETCH c_student_dtls INTO rec_student_dtls;
2003: CLOSE c_student_dtls;
2004:
2005: -- derivation of loan type code

Line 2657: -- invoke the igf_sl_gen.update_cl_chg_status to update the change status of loan table

2653: ' for change send @1-24 record '
2654: );
2655: END IF;
2656:
2657: -- invoke the igf_sl_gen.update_cl_chg_status to update the change status of loan table
2658: log_to_fnd(p_v_module => 'sub_create_file',
2659: p_v_string => 'invoking igf_sl_gen.update_cl_chg_status for loan number ='||rec_c_recip_dtls.loan_number
2660: );
2661: igf_sl_gen.update_cl_chg_status(p_v_loan_number => rec_c_recip_dtls.loan_number);

Line 2659: p_v_string => 'invoking igf_sl_gen.update_cl_chg_status for loan number ='||rec_c_recip_dtls.loan_number

2655: END IF;
2656:
2657: -- invoke the igf_sl_gen.update_cl_chg_status to update the change status of loan table
2658: log_to_fnd(p_v_module => 'sub_create_file',
2659: p_v_string => 'invoking igf_sl_gen.update_cl_chg_status for loan number ='||rec_c_recip_dtls.loan_number
2660: );
2661: igf_sl_gen.update_cl_chg_status(p_v_loan_number => rec_c_recip_dtls.loan_number);
2662: log_to_fnd(p_v_module => 'sub_create_file',
2663: p_v_string => ' Call out to igf_sl_gen.update_cl_chg_status successful for loan number ='||rec_c_recip_dtls.loan_number

Line 2661: igf_sl_gen.update_cl_chg_status(p_v_loan_number => rec_c_recip_dtls.loan_number);

2657: -- invoke the igf_sl_gen.update_cl_chg_status to update the change status of loan table
2658: log_to_fnd(p_v_module => 'sub_create_file',
2659: p_v_string => 'invoking igf_sl_gen.update_cl_chg_status for loan number ='||rec_c_recip_dtls.loan_number
2660: );
2661: igf_sl_gen.update_cl_chg_status(p_v_loan_number => rec_c_recip_dtls.loan_number);
2662: log_to_fnd(p_v_module => 'sub_create_file',
2663: p_v_string => ' Call out to igf_sl_gen.update_cl_chg_status successful for loan number ='||rec_c_recip_dtls.loan_number
2664: );
2665: OPEN c_sl_lor_loc (

Line 2663: p_v_string => ' Call out to igf_sl_gen.update_cl_chg_status successful for loan number ='||rec_c_recip_dtls.loan_number

2659: p_v_string => 'invoking igf_sl_gen.update_cl_chg_status for loan number ='||rec_c_recip_dtls.loan_number
2660: );
2661: igf_sl_gen.update_cl_chg_status(p_v_loan_number => rec_c_recip_dtls.loan_number);
2662: log_to_fnd(p_v_module => 'sub_create_file',
2663: p_v_string => ' Call out to igf_sl_gen.update_cl_chg_status successful for loan number ='||rec_c_recip_dtls.loan_number
2664: );
2665: OPEN c_sl_lor_loc (
2666: cp_n_loan_id => rec_c_recip_dtls.loan_id,
2667: cp_n_origination_id => rec_c_recip_dtls.origination_id