[Home] [Help]
27: Before creating loan record, check whether the award accepted amount is in whole numbers.
28: --------------------------------------------------------------------------------------------
29: bvisvana 25-Aug-2005 Bug # 4568942. Grade Level not matching with enrollment data.
30: (Wrong argument type) g_fund_id is replaced with (correct argument type)
31: g_adplans_id while calling the Class standing wrapper igf_aw_packng_subfns.get_class_stnd
32: --------------------------------------------------------------------------------------------
33: bvisvana 18-Aug-2005 Bug # 4464629 - Removed the global variable gv_dl_version.
34: This is not used anywhere and this is causing unexpected behaviour.
35: ---------------------------------------------------------------------------------------------------------------
1063: pmarada 23-Aug-2001 Get Enrollmen, Grade-level dtls
1064: from FA-Base-Hist table
1065: Enh Bug 1818617
1066: skoppula 29-May-2002 The class standing shall be picked
1067: up from igf_aw_packng_subfns.get_class_stnd
1068: instead from igf_ap_fa_base_h. This is
1069: done to determine which class standing
1070: to be used - Actual or Predictive
1071: Bug:2385334
1115:
1116: l_person_number := igf_gr_gen.get_per_num ( p_base_id);
1117: -- Call to get the class standing and program_type
1118: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1119: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.return_entities.debug','The values passed to igf_aw_packng_subfns.get_class_stnd base id :' || p_base_id);
1120: END IF;
1121:
1122: lv_class_standing := igf_aw_packng_subfns.get_class_stnd( p_base_id,
1123: g_person_id,
1118: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1119: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.return_entities.debug','The values passed to igf_aw_packng_subfns.get_class_stnd base id :' || p_base_id);
1120: END IF;
1121:
1122: lv_class_standing := igf_aw_packng_subfns.get_class_stnd( p_base_id,
1123: g_person_id,
1124: g_adplans_id,
1125: g_award_id,
1126: lv_program_type ) ;
1124: g_adplans_id,
1125: g_award_id,
1126: lv_program_type ) ;
1127: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.return_entities.debug','The class standing from igf_aw_packng_subfns.get_class_stnd :' || lv_class_standing);
1129: END IF;
1130:
1131: IF lv_class_standing IS NULL OR lv_program_type IS NULL THEN
1132: -- Bug # 5078693 - bvisvana - Message out that Class standing has to be defined.
2631:
2632: ln_seq_number igf_sl_loans_all.seq_num%TYPE;
2633: l_msg_name fnd_new_messages.message_name%TYPE;
2634: l_aid NUMBER;
2635: l_loan_tab igf_aw_packng_subfns.std_loan_tab;
2636:
2637: ld_loan_prd_start_dt DATE;
2638: ld_loan_prd_end_dt DATE;
2639: l_mapping VARCHAR2(1);
2707: IF award_rec_temp.fed_fund_code NOT IN ('PRK','DLP','FLP','ALT','GPLUSFL') THEN
2708: l_aid := 0;
2709: l_msg_name := NULL;
2710: -- since the fund amount is already awarded to the student then l_aid is passed as 0.
2711: igf_aw_packng_subfns.check_loan_limits (
2712: l_base_id => award_rec_temp.base_id,
2713: fund_type => award_rec_temp.fed_fund_code,
2714: l_award_id => award_rec_temp.award_id,
2715: l_adplans_id => award_rec_temp.adplans_id,
3247: chk_pidgroup_rec cur_chk_pidgroup%ROWTYPE;
3248:
3249: l_msg_name fnd_new_messages.message_name%TYPE;
3250: l_aid NUMBER;
3251: l_loan_tab igf_aw_packng_subfns.std_loan_tab;
3252:
3253: lb_dl_setup BOOLEAN;
3254: lb_cl_setup BOOLEAN;
3255: l_list VARCHAR2(32767);
3274:
3275: retcode := 0;
3276: l_msg_name := NULL;
3277: l_aid := 0;
3278: l_loan_tab := igf_aw_packng_subfns.std_loan_tab();
3279: l_found_loans := 'N';
3280: l_head := 'N';
3281:
3282: