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_GEN_003 dependencies on IGF_AW_PACKAGING

Line 778: l_disb_round_factor := igf_aw_packaging.get_disb_round_factor(p_fund_id);

774: get_fund_rec cur_get_fund%ROWTYPE;
775: l_disb_net_amt NUMBER(12,3) := 0;
776:
777: BEGIN
778: l_disb_round_factor := igf_aw_packaging.get_disb_round_factor(p_fund_id);
779:
780: OPEN cur_get_fund(p_fund_id => p_fund_id);
781: FETCH cur_get_fund INTO get_fund_rec;
782: CLOSE cur_get_fund;

Line 942: 'igf.plsql.igf_aw_packaging.round_off_disbursements.debug ',

938: ' igf.plsql.igf_aw_gen_003.round_off_disbursements.debug ',
939: 'Disbursement amounts before and after applying rounding logic');
940:
941: fnd_log.string(fnd_log.level_statement,
942: 'igf.plsql.igf_aw_packaging.round_off_disbursements.debug ',
943: ' Disbursement number: ' ||l_disb_no||
944: ' Old Disbursement amount: ' ||l_disb_rec.disb_gross_amt||
945: ' New disbursement amount after applying rounding logic: ' ||NVL(l_disb_structure_rec(l_disb_no).disb_amt, 0));
946: END IF;

Line 1066: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1062: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1063: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1064: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1065: ) IS
1066: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1067: terms.ld_cal_type ld_cal_type,
1068: terms.ld_sequence_number ld_sequence_number,
1069: teach_periods.tp_cal_type tp_cal_type,
1070: teach_periods.tp_sequence_number tp_sequence_number,

Line 1111: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1107: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1108: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1109: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1110: ) IS
1111: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1112: terms.ld_cal_type ld_cal_type,
1113: terms.ld_sequence_number ld_sequence_number,
1114: teach_periods.tp_cal_type tp_cal_type,
1115: teach_periods.tp_sequence_number tp_sequence_number,

Line 1146: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1142: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1143: cp_num_terms NUMBER,
1144: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1145: ) IS
1146: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1147: terms.ld_cal_type ld_cal_type,
1148: terms.ld_sequence_number ld_sequence_number,
1149: teach_periods.tp_cal_type tp_cal_type,
1150: teach_periods.tp_sequence_number tp_sequence_number,

Line 1188: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1184: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1185: cp_num_terms NUMBER,
1186: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1187: ) IS
1188: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1189: terms.ld_cal_type ld_cal_type,
1190: terms.ld_sequence_number ld_sequence_number,
1191: teach_periods.tp_cal_type tp_cal_type,
1192: teach_periods.tp_sequence_number tp_sequence_number,

Line 1220: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1216: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1217: cp_total_coa_amount NUMBER,
1218: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1219: ) IS
1220: SELECT NVL(igf_aw_packaging.get_date_instance (cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1221: terms.ld_cal_type ld_cal_type,
1222: terms.ld_sequence_number ld_sequence_number,
1223: teach_periods.tp_cal_type tp_cal_type,
1224: teach_periods.tp_sequence_number tp_sequence_number,

Line 1257: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1253: CURSOR c_auto_disb_pell(
1254: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1255: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1256: ) IS
1257: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1258: terms.ld_cal_type ld_cal_type,
1259: terms.ld_sequence_number ld_sequence_number,
1260: teach_periods.tp_cal_type tp_cal_type,
1261: teach_periods.tp_sequence_number tp_sequence_number,

Line 1291: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1287: CURSOR c_auto_disb_wcoa_pell(
1288: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1289: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
1290: ) IS
1291: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1292: terms.ld_cal_type ld_cal_type,
1293: terms.ld_sequence_number ld_sequence_number,
1294: teach_periods.tp_cal_type tp_cal_type,
1295: teach_periods.tp_sequence_number tp_sequence_number,

Line 1317: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1313: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1314: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1315: cp_num_terms NUMBER
1316: ) IS
1317: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1318: terms.ld_cal_type ld_cal_type,
1319: terms.ld_sequence_number ld_sequence_number,
1320: teach_periods.tp_cal_type tp_cal_type,
1321: teach_periods.tp_sequence_number tp_sequence_number,

Line 1348: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1344: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1345: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1346: cp_num_terms NUMBER
1347: ) IS
1348: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1349: terms.ld_cal_type ld_cal_type,
1350: terms.ld_sequence_number ld_sequence_number,
1351: teach_periods.tp_cal_type tp_cal_type,
1352: teach_periods.tp_sequence_number tp_sequence_number,

Line 1371: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,

1367: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1368: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
1369: cp_total_coa_amount NUMBER
1370: ) IS
1371: SELECT NVL(igf_aw_packaging.get_date_instance(cp_base_id,teach_periods.date_offset_cd,terms.ld_cal_type,terms.ld_sequence_number),teach_periods.start_date) disb_dt,
1372: terms.ld_cal_type ld_cal_type,
1373: terms.ld_sequence_number ld_sequence_number,
1374: teach_periods.tp_cal_type tp_cal_type,
1375: teach_periods.tp_sequence_number tp_sequence_number,

Line 2290: igf_aw_packaging.add_todo(p_fund_id,get_base_rec.base_id);

2286: --
2287: -- Add To Do Items to student which are defined at the fund level
2288: --
2289:
2290: igf_aw_packaging.add_todo(p_fund_id,get_base_rec.base_id);
2291:
2292: -- Apply NSLDS offset to the first disbursment
2293: IF NOT lb_nslds_ind THEN
2294: OPEN c_disb(p_award_id,1);