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_DL_VALIDATION dependencies on IGS_CA_INST_ALL

Line 298: FUNCTION dl_lar_validate(p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,

294: END IF;
295: END loan_limit_validation;
296:
297: /* MAIN PROCEDURE */
298: FUNCTION dl_lar_validate(p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
299: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
300: p_loan_catg fnd_lookups.lookup_code%TYPE,
301: p_loan_number igf_sl_loans_all.loan_number%TYPE,
302: p_call_mode VARCHAR2,

Line 299: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,

295: END loan_limit_validation;
296:
297: /* MAIN PROCEDURE */
298: FUNCTION dl_lar_validate(p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
299: p_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE,
300: p_loan_catg fnd_lookups.lookup_code%TYPE,
301: p_loan_number igf_sl_loans_all.loan_number%TYPE,
302: p_call_mode VARCHAR2,
303: p_school_code VARCHAR2 )

Line 341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;

337: lv_loan_catg igf_sl_reqd_fields.loan_type%TYPE;
338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;

Line 342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;

338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;

Line 343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;

339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;

Line 344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;

340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
345: l_status_1 igf_sl_loans_all.loan_status%TYPE;
346: l_status_2 igf_sl_loans_all.loan_status%TYPE;
347: l_status_3 igf_sl_loans_all.loan_status%TYPE;
348: l_fed_fund_1 igf_aw_fund_cat_all.fed_fund_code%TYPE;

Line 919: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;

915:
916: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
917: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
918: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
919: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
920: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
921: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
922: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
923: lv_message VARCHAR2(100);

Line 920: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;

916: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
917: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
918: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
919: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
920: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
921: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
922: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
923: lv_message VARCHAR2(100);
924: l_p_phone VARCHAR2(80);

Line 921: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;

917: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
918: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
919: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
920: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
921: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
922: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
923: lv_message VARCHAR2(100);
924: l_p_phone VARCHAR2(80);
925: l_s_phone VARCHAR2(80);

Line 922: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;

918: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
919: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
920: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
921: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
922: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;
923: lv_message VARCHAR2(100);
924: l_p_phone VARCHAR2(80);
925: l_s_phone VARCHAR2(80);
926: lv_special_school VARCHAR2(30);

Line 1892: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,

1888:
1889: END cod_loan_validations;
1890:
1891: FUNCTION check_full_participant (
1892: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1893: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1894: p_fund_type IN VARCHAR2
1895: )
1896: RETURN BOOLEAN

Line 1893: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,

1889: END cod_loan_validations;
1890:
1891: FUNCTION check_full_participant (
1892: p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
1893: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1894: p_fund_type IN VARCHAR2
1895: )
1896: RETURN BOOLEAN
1897: AS

Line 1910: CURSOR cur_get_participants_codes ( cp_cal_type igs_ca_inst_all.cal_type%TYPE,

1906: (reverse chronological order - newest change first)
1907: ***************************************************************/
1908:
1909: -- Cursor to get pell participant code and direct loan participant code
1910: CURSOR cur_get_participants_codes ( cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1911: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
1912: SELECT bam.dl_participant_code, bam.pell_participant_code
1913: FROM igf_ap_batch_aw_map_all bam
1914: WHERE bam.ci_cal_type = cp_cal_type

Line 1911: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS

1907: ***************************************************************/
1908:
1909: -- Cursor to get pell participant code and direct loan participant code
1910: CURSOR cur_get_participants_codes ( cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1911: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) IS
1912: SELECT bam.dl_participant_code, bam.pell_participant_code
1913: FROM igf_ap_batch_aw_map_all bam
1914: WHERE bam.ci_cal_type = cp_cal_type
1915: AND bam.ci_sequence_number = cp_sequence_number