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_AW_PACKAGING dependencies on IGF_AW_COA_GEN

Line 858: l_efc_months := igf_aw_coa_gen.coa_duration(p_base_id,g_awd_prd);

854: l_efc_ay NUMBER := 0;
855: BEGIN
856:
857: -- Get the month for which EFC should be calcualted
858: l_efc_months := igf_aw_coa_gen.coa_duration(p_base_id,g_awd_prd);
859:
860: IF l_efc_months > 12 OR l_efc_months < 0 THEN
861: l_efc_months := 12;
862: END IF;

Line 1014: igf_aw_coa_gen.coa_amount(fa_detail.base_id,g_awd_prd) coa_f

1010: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,
1011: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
1012: ) IS
1013: SELECT fa_detail.base_id,
1014: igf_aw_coa_gen.coa_amount(fa_detail.base_id,g_awd_prd) coa_f
1015: FROM igf_ap_fa_base_rec fa_detail
1016: WHERE fa_detail.ci_cal_type = x_ci_cal_type
1017: AND fa_detail.ci_sequence_number = x_ci_sequence_number
1018: AND fa_detail.target_group = x_group_code;

Line 4203: IF NOT igf_aw_coa_gen.isCOALocked(l_base_id) THEN

4199: END IF; -- End of l-post check
4200:
4201: --check for COA Lock profile i.e. 'IGF: Lock COA Budget for Student'
4202: IF get_coa_lock_prof_val = 'AWARDED' THEN
4203: IF NOT igf_aw_coa_gen.isCOALocked(l_base_id) THEN
4204: lv_locking_success := igf_aw_coa_gen.doLock(l_base_id);
4205: END IF;
4206: END IF;
4207:

Line 4204: lv_locking_success := igf_aw_coa_gen.doLock(l_base_id);

4200:
4201: --check for COA Lock profile i.e. 'IGF: Lock COA Budget for Student'
4202: IF get_coa_lock_prof_val = 'AWARDED' THEN
4203: IF NOT igf_aw_coa_gen.isCOALocked(l_base_id) THEN
4204: lv_locking_success := igf_aw_coa_gen.doLock(l_base_id);
4205: END IF;
4206: END IF;
4207:
4208: /*

Line 5358: x_offered_amt => igf_aw_coa_gen.award_amount(p_base_id,g_awd_prd,l_awds.award_id),

5354: x_process_id => l_process_id ,
5355: x_sl_number => l_sl_number,
5356: x_fund_id => p_fund_id,
5357: x_base_id => p_base_id,
5358: x_offered_amt => igf_aw_coa_gen.award_amount(p_base_id,g_awd_prd,l_awds.award_id),
5359: x_accepted_amt => 0,
5360: x_paid_amt => 0,
5361: x_need_reduction_amt => NULL,
5362: x_flag => 'AL',

Line 5392: x_offered_amt => igf_aw_coa_gen.award_amount(p_base_id,g_awd_prd,l_awds.award_id),

5388: x_process_id => l_process_id ,
5389: x_sl_number => l_sl_number,
5390: x_fund_id => p_fund_id,
5391: x_base_id => p_base_id,
5392: x_offered_amt => igf_aw_coa_gen.award_amount(p_base_id,g_awd_prd,l_awds.award_id),
5393: x_accepted_amt => 0,
5394: x_paid_amt => 0,
5395: x_need_reduction_amt => NULL,
5396: x_flag => 'AU',

Line 6194: IF igf_aw_coa_gen.canUseAnticipVal THEN

6190: -- awarding period that has a valid anticipated key program data.
6191: -- Note, if we are getting the Key Program details from anticipated data
6192: -- the version number is not available
6193:
6194: IF igf_aw_coa_gen.canUseAnticipVal THEN
6195: OPEN c_get_ant_prog (
6196: cp_ci_cal_type => l_ci_cal_type,
6197: cp_sequence_number => l_ci_sequence_number,
6198: cp_base_id => l_base_id,

Line 6236: END IF; -- End igf_aw_coa_gen.canUseAnticipVal

6232: fnd_log.string(fnd_log.level_statement,
6233: 'igf.plsql.igf_aw_packaging.load_funds.debug '|| g_req_id,
6234: 'Key program details are not available in both actual and anticipated data for fund: ' ||l_fund_ld.fund_code|| ', base_id ' ||l_base_id|| '. But still continue to award the student.');
6235: END IF;
6236: END IF; -- End igf_aw_coa_gen.canUseAnticipVal
6237: END IF; -- l_stud_program_cd IS NULL (Admissions)
6238: END IF; -- l_stud_program_cd IS NULL (Enrollment)
6239:
6240: -- Get the Fund Source of the current Fund code

Line 7213: l_efc_months := igf_aw_coa_gen.coa_duration(p_base_id,g_awd_prd);

7209: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.calc_need.debug '|| g_req_id,'c_rem_efc%NOTFOUND-so calculating values');
7210: END IF;
7211:
7212: -- Get the month for which EFC should be calcualted
7213: l_efc_months := igf_aw_coa_gen.coa_duration(p_base_id,g_awd_prd);
7214: IF l_efc_months > 12 OR l_efc_months < 0 THEN
7215: l_efc_months := 12;
7216: END IF;
7217:

Line 7882: l_fabase.coa_f := igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd);

7878:
7879: /* Get the students COA Months. Get the students efc. */
7880: l_efc_i := l_pell_efc;
7881:
7882: l_fabase.coa_f := igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd);
7883: l_fabase.coa_i := l_fabase.coa_f;
7884: l_fabase.coa_fixed := igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd,'Y');
7885:
7886: -- If the process is not run for the Single fund, then Load all Formula Group Policies

Line 7884: l_fabase.coa_fixed := igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd,'Y');

7880: l_efc_i := l_pell_efc;
7881:
7882: l_fabase.coa_f := igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd);
7883: l_fabase.coa_i := l_fabase.coa_f;
7884: l_fabase.coa_fixed := igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd,'Y');
7885:
7886: -- If the process is not run for the Single fund, then Load all Formula Group Policies
7887: -- Get all the overrides set at the formula levels and load the Temp table
7888: IF g_sf_packaging = 'F' THEN

Line 8060: l_awds.award := igf_aw_coa_gen.award_amount(l_fabase.base_id,g_awd_prd,l_awds.award_id);

8056: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8057: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'opened c_awds for l_fabase.base_id:'||l_fabase.base_id);
8058: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'calling calc_need using l_fabase.coa_f:'||l_fabase.coa_f||' l_fabase.coa_i:'||l_fabase.coa_i);
8059: END IF;
8060: l_awds.award := igf_aw_coa_gen.award_amount(l_fabase.base_id,g_awd_prd,l_awds.award_id);
8061: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
8062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'Calling calc_need');
8063: END IF;
8064: calc_need(

Line 8066: igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd),

8062: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.stud_run.debug '|| g_req_id,'Calling calc_need');
8063: END IF;
8064: calc_need(
8065: l_fabase.base_id,
8066: igf_aw_coa_gen.coa_amount(l_fabase.base_id,g_awd_prd),
8067: l_awds
8068: );
8069: END LOOP;
8070: CLOSE c_awds;

Line 8928: l_efc_months := igf_aw_coa_gen.coa_duration(l_fabase.base_id,g_awd_prd);

8924: -- Bug NUMBER: 2402622 (Need Analysis Issues)
8925: -- Calculation of teaching period months and federal verification status
8926: -- are moved out NOCOPY of fund loop as they are independent of fund
8927: -- Get the EFC months
8928: l_efc_months := igf_aw_coa_gen.coa_duration(l_fabase.base_id,g_awd_prd);
8929:
8930: IF l_efc_months > 12 OR l_efc_months < 1 THEN
8931: l_efc_months := 12;
8932: END IF;

Line 9554: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_gen.process_stud.debug','l_term_start:'||l_term_start);

9550: p_ld_start_date => l_term_start,
9551: p_ld_end_date => l_term_end
9552: );
9553: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9554: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_gen.process_stud.debug','l_term_start:'||l_term_start);
9555: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_gen.process_stud.debug','l_term_end:'||l_term_end);
9556: END IF;
9557: IF l_term_end < TRUNC(SYSDATE) THEN
9558: --term has lapsed

Line 9555: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_gen.process_stud.debug','l_term_end:'||l_term_end);

9551: p_ld_end_date => l_term_end
9552: );
9553: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9554: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_gen.process_stud.debug','l_term_start:'||l_term_start);
9555: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_coa_gen.process_stud.debug','l_term_end:'||l_term_end);
9556: END IF;
9557: IF l_term_end < TRUNC(SYSDATE) THEN
9558: --term has lapsed
9559: l_first_disb_dt := NULL;

Line 9830: l_existing_awards := igf_aw_coa_gen.award_amount(l_fabase.base_id,g_awd_prd);

9826: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
9827: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.process_stud.debug '|| g_req_id,'allow NEED to be exceeded');
9828: END IF;
9829: --aid amount is minimum of COA-existing awards,max award amt
9830: l_existing_awards := igf_aw_coa_gen.award_amount(l_fabase.base_id,g_awd_prd);
9831:
9832: IF l_fmast.max_award_amt IS NOT NULL THEN
9833: IF (l_fabase.coa_f - l_existing_awards) < l_fmast.max_award_amt THEN
9834: l_aid := l_fabase.coa_f - l_existing_awards;

Line 11634: l_coa := igf_aw_coa_gen.coa_amount(l_base_id,p_awd_prd_code);

11630: BEGIN
11631:
11632: -- Get Federal COA of the student.
11633: -- Use these values while calculating the Net Need, COA, EFC or Gross Need for the student.
11634: l_coa := igf_aw_coa_gen.coa_amount(l_base_id,p_awd_prd_code);
11635:
11636: -- The group Policies set are irrespective of the Fund, so the EFC value of the Federal Methodology MUST be taken
11637: IF l_perct_fact = 'EFC' then
11638: l_perct_amt := l_efc_f * (l_perct_val / 100 ) ;

Line 11652: l_awd_aid := igf_aw_coa_gen.award_amount(l_base_id,p_awd_prd_code);

11648: END IF;
11649:
11650: ELSIF l_perct_fact = 'NET_NEED' then
11651:
11652: l_awd_aid := igf_aw_coa_gen.award_amount(l_base_id,p_awd_prd_code);
11653:
11654: IF NVL(NVL(l_coa,0) - (NVL(l_efc_f,0) + NVL(l_awd_aid,0)),0) <=0 THEN
11655: l_perct_amt := 0;
11656: ELSE

Line 12924: OPEN cur_sf_persid FOR 'SELECT fabase.base_id, igf_aw_coa_gen.coa_amount(fabase.base_id,:g_aprd) coa_f

12920: ln_person_count := 0;
12921:
12922: --Bug #5021084. Passing Group ID if the group type is STATIC.
12923: IF lv_group_type = 'STATIC' THEN
12924: OPEN cur_sf_persid FOR 'SELECT fabase.base_id, igf_aw_coa_gen.coa_amount(fabase.base_id,:g_aprd) coa_f
12925: FROM igf_ap_fa_base_rec fabase
12926: WHERE fabase.ci_cal_type = :p_ci_cal_type
12927: AND fabase.ci_sequence_number = :p_ci_sequence_number
12928: AND fabase.person_id IN ( '||lv_sql_stmt||' ) ' USING g_awd_prd,g_ci_cal_type,g_ci_sequence,p_persid_grp;

Line 12930: OPEN cur_sf_persid FOR 'SELECT fabase.base_id, igf_aw_coa_gen.coa_amount(fabase.base_id,:g_aprd) coa_f

12926: WHERE fabase.ci_cal_type = :p_ci_cal_type
12927: AND fabase.ci_sequence_number = :p_ci_sequence_number
12928: AND fabase.person_id IN ( '||lv_sql_stmt||' ) ' USING g_awd_prd,g_ci_cal_type,g_ci_sequence,p_persid_grp;
12929: ELSIF lv_group_type = 'DYNAMIC' THEN
12930: OPEN cur_sf_persid FOR 'SELECT fabase.base_id, igf_aw_coa_gen.coa_amount(fabase.base_id,:g_aprd) coa_f
12931: FROM igf_ap_fa_base_rec fabase
12932: WHERE fabase.ci_cal_type = :p_ci_cal_type
12933: AND fabase.ci_sequence_number = :p_ci_sequence_number
12934: AND fabase.person_id IN ( '||lv_sql_stmt||' ) ' USING g_awd_prd,g_ci_cal_type,g_ci_sequence;

Line 13330: SELECT fabase.base_id,igf_aw_coa_gen.coa_amount(fabase.base_id,g_awd_prd) coa_f

13326: CURSOR c_get_stds(
13327: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
13328: cp_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
13329: ) IS
13330: SELECT fabase.base_id,igf_aw_coa_gen.coa_amount(fabase.base_id,g_awd_prd) coa_f
13331: FROM igf_ap_fa_base_rec_all fabase,
13332: igf_ap_isir_matched_all im
13333: WHERE fabase.ci_cal_type = cp_cal_type
13334: AND fabase.ci_sequence_number = cp_sequence_number