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_AP_FA_BASE_REC

Line 92: || igf_ap_fa_base_rec_pkg.update_row call.

88: || get_loan_fee2 and added l_auto_late_ind
89: || for teh CL Loans
90: || ugummall 25-SEP-2003 FA 126 - Multiple FA Offices.
91: || added new parameter assoc_org_num to
92: || igf_ap_fa_base_rec_pkg.update_row call.
93: ||
94: bkkumar 27-Aug-2003 Bug# 3071157 Added explicit date format mask to the
95: to_date() function.
96: sjadhav 06-Aug-2003 Bug 3062062

Line 325: base_id igf_ap_fa_base_rec_all.base_id%TYPE,

321: );
322:
323:
324: TYPE std_aid IS RECORD(
325: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
326: need_f igf_ap_fa_base_rec_all.need_f%TYPE,
327: awarded_aid igf_aw_award_all.offered_amt%TYPE
328: );
329:

Line 326: need_f igf_ap_fa_base_rec_all.need_f%TYPE,

322:
323:
324: TYPE std_aid IS RECORD(
325: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
326: need_f igf_ap_fa_base_rec_all.need_f%TYPE,
327: awarded_aid igf_aw_award_all.offered_amt%TYPE
328: );
329:
330: TYPE std_aid_tab IS TABLE OF std_aid;

Line 333: base_id igf_ap_fa_base_rec_all.base_id%TYPE,

329:
330: TYPE std_aid_tab IS TABLE OF std_aid;
331:
332: TYPE fund_awd IS RECORD(
333: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
334: fund_id igf_aw_fund_mast_all.fund_id%TYPE,
335: awd_prct NUMBER
336: );
337:

Line 344: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

340: g_fund_awd_prct std_fund_awd := std_fund_awd();
341: g_awarded_aid std_aid_tab := std_aid_tab();
342:
343: FUNCTION check_disb(
344: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
345: p_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
346: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
347: ) RETURN BOOLEAN AS
348: ------------------------------------------------------------------

Line 380: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

376: AND aprd.ld_sequence_number = terms.ld_sequence_number
377: AND aprd.award_prd_cd = cp_award_prd_code;
378:
379: CURSOR c_term(
380: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
381: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
382: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
383: ) IS
384: SELECT COUNT(tp.adteach_id) tp,

Line 608: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

604: RETURN l_prog_eligibility;
605: END get_prog_elig;
606:
607: FUNCTION get_term_start_date(
608: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
609: p_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
610: p_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE
611: )
612: RETURN DATE

Line 711: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

707: app_exception.raise_exception;
708: END get_plan_desc;
709:
710: PROCEDURE setAPProcStat(
711: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
712: p_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
713: p_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE
714: ) AS
715: ------------------------------------------------------------------

Line 756: FROM igf_ap_fa_base_rec_all fa

752:
753: CURSOR c_cal IS
754: SELECT fa.ci_cal_type,
755: fa.ci_sequence_number
756: FROM igf_ap_fa_base_rec_all fa
757: WHERE fa.base_id = p_base_id;
758:
759: BEGIN
760:

Line 834: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

830: app_exception.raise_exception;
831: END setAPProcStat;
832:
833: PROCEDURE calc_students_needs(
834: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
835: p_coa igf_ap_fa_base_rec_all.coa_f%TYPE
836: ) AS
837: /*
838: || Created By : brajendr

Line 835: p_coa igf_ap_fa_base_rec_all.coa_f%TYPE

831: END setAPProcStat;
832:
833: PROCEDURE calc_students_needs(
834: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
835: p_coa igf_ap_fa_base_rec_all.coa_f%TYPE
836: ) AS
837: /*
838: || Created By : brajendr
839: || Created On :

Line 1010: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ,

1006:
1007: -- All students who fall within the current Target group are processed
1008: CURSOR c_group(
1009: x_group_code igf_aw_target_grp_all.group_cd%TYPE ,
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

Line 1011: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

1007: -- All students who fall within the current Target group are processed
1008: CURSOR c_group(
1009: x_group_code igf_aw_target_grp_all.group_cd%TYPE ,
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

Line 1015: FROM igf_ap_fa_base_rec fa_detail

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;
1019:

Line 1664: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1660: END cancel_invalid_award;
1661:
1662: PROCEDURE cancel_awards(
1663: p_process_id igf_aw_award_t.process_id%TYPE,
1664: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1665: ) AS
1666: ------------------------------------------------------------------
1667: --Created by : veramach, Oracle India
1668: --Date created: 27-Oct-2004

Line 1682: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

1678:
1679: -- Get cancelled awards
1680: CURSOR c_cancelled_awards(
1681: cp_process_id igf_aw_award_t.process_id%TYPE,
1682: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
1683: ) IS
1684: SELECT awdt.award_id
1685: FROM igf_aw_award_t awdt
1686: WHERE process_id = cp_process_id

Line 2094: || Previously they were got from IGF_AP_FA_BASE_REC_ALL table. Passed

2090: || award they are cancelled.
2091: || museshad 02-Jun-2005 Build# FA157 - Bug# 4382371.
2092: || As per the new logic 'Award Notification Status' and 'Award Notification
2093: || Status Date' are got at the award level (from IGF_AW_AWARD_ALL table).
2094: || Previously they were got from IGF_AP_FA_BASE_REC_ALL table. Passed
2095: || NULL to these columns in the TBH call for
2096: || IGF_AP_FA_BASE_REC_ALL table.
2097: || ayedubat 12-OCT-04 Changed the TBH calls of igf_aw_awd_disb_pkg package to add a new column,
2098: || PAYMENT_PRD_ST_DATE as part of FA 149 build bug # 3416863

Line 2096: || IGF_AP_FA_BASE_REC_ALL table.

2092: || As per the new logic 'Award Notification Status' and 'Award Notification
2093: || Status Date' are got at the award level (from IGF_AW_AWARD_ALL table).
2094: || Previously they were got from IGF_AP_FA_BASE_REC_ALL table. Passed
2095: || NULL to these columns in the TBH call for
2096: || IGF_AP_FA_BASE_REC_ALL table.
2097: || ayedubat 12-OCT-04 Changed the TBH calls of igf_aw_awd_disb_pkg package to add a new column,
2098: || PAYMENT_PRD_ST_DATE as part of FA 149 build bug # 3416863
2099: || bkkumar 02-04-04 FACR116 - Added the new paramter p_alt_rel_code to the
2100: || get_loan_fee1 , get_loan_fee2 , get_cl_hold_rel_ind

Line 2112: || igf_ap_fa_base_rec_pkg.update_row call.

2108: || get_loan_fee2 and added l_auto_late_ind
2109: || for teh CL Loans
2110: || ugummall 25-SEP-2003 FA 126 - Multiple FA Offices.
2111: || added new parameter assoc_org_num to
2112: || igf_ap_fa_base_rec_pkg.update_row call.
2113: || rasahoo 23-Apl-2003 Bug # 2860836
2114: || Added exception handling for resolving
2115: || locking problem created by fund manager
2116: || brajendr 07-Mar-2003 Bug # 2829487

Line 2221: CURSOR c_nslds ( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ) IS

2217:
2218: -- Get the NSLDS details of the student, used while creating the Loan Awards
2219: -- Student should be having at least one loan award in his student life.
2220: -- so person id was used to check the existance in diferent awd years
2221: CURSOR c_nslds ( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ) IS
2222: SELECT 'x'
2223: FROM igf_ap_nslds_data nslds,
2224: igf_ap_fa_base_rec_all fabase
2225: WHERE fabase.base_id = nslds.base_id AND

Line 2224: igf_ap_fa_base_rec_all fabase

2220: -- so person id was used to check the existance in diferent awd years
2221: CURSOR c_nslds ( cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE ) IS
2222: SELECT 'x'
2223: FROM igf_ap_nslds_data nslds,
2224: igf_ap_fa_base_rec_all fabase
2225: WHERE fabase.base_id = nslds.base_id AND
2226: fabase.person_id = cp_person_id AND
2227: nslds.nslds_loan_prog_code_1 IS NOT NULL;
2228:

Line 2233: CURSOR c_fabase(cp_baseid igf_ap_fa_base_rec.base_id%TYPE) IS

2229: x_nslds c_nslds%ROWTYPE;
2230:
2231: -- Select all the detials of the student whose Notification is not 'Ready' OR 'Do not send'
2232: -- Used to create award / disbursement notifiactions for the student when there is change in Existing awards or new awards
2233: CURSOR c_fabase(cp_baseid igf_ap_fa_base_rec.base_id%TYPE) IS
2234: SELECT fabase.*
2235: FROM igf_ap_fa_base_rec fabase
2236: WHERE base_id = cp_baseid
2237: AND (notification_status NOT IN ('R','D') OR notification_status IS NULL);

Line 2235: FROM igf_ap_fa_base_rec fabase

2231: -- Select all the detials of the student whose Notification is not 'Ready' OR 'Do not send'
2232: -- Used to create award / disbursement notifiactions for the student when there is change in Existing awards or new awards
2233: CURSOR c_fabase(cp_baseid igf_ap_fa_base_rec.base_id%TYPE) IS
2234: SELECT fabase.*
2235: FROM igf_ap_fa_base_rec fabase
2236: WHERE base_id = cp_baseid
2237: AND (notification_status NOT IN ('R','D') OR notification_status IS NULL);
2238:
2239: l_fabase c_fabase%ROWTYPE;

Line 2305: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

2301: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
2302:
2303: -- Get payment ISIR transaction number
2304: CURSOR c_trans_num(
2305: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
2306: ) IS
2307: SELECT transaction_num
2308: FROM igf_ap_isir_matched_all
2309: WHERE base_id = cp_base_id

Line 4079: igf_ap_fa_base_rec_pkg.update_row(

4075: IF c_fabase%FOUND THEN
4076: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
4077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_packaging.post_award.debug '|| g_req_id,'updating fa base table');
4078: END IF;
4079: igf_ap_fa_base_rec_pkg.update_row(
4080: x_rowid => l_fabase.row_id,
4081: x_base_id => l_fabase.base_id,
4082: x_ci_cal_type => l_fabase.ci_cal_type,
4083: x_person_id => l_fabase.person_id,

Line 4362: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

4358:
4359: FUNCTION awardsExist(
4360: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4361: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4362: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4363: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4364: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
4365: ) RETURN BOOLEAN AS
4366: ------------------------------------------------------------------

Line 4490: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE

4486: END IF;
4487: END isOriginated;
4488:
4489: FUNCTION getFedVerifStatus(
4490: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4491: ) RETURN VARCHAR2 AS
4492: ------------------------------------------------------------------
4493: --Created by : veramach, Oracle India
4494: --Date created: 13-Oct-2004

Line 4507: FROM igf_ap_fa_base_rec_all

4503: -------------------------------------------------------------------
4504:
4505: CURSOR c_verif IS
4506: SELECT fed_verif_status
4507: FROM igf_ap_fa_base_rec_all
4508: WHERE base_id = p_base_id;
4509: l_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
4510: BEGIN
4511: l_verif_status := NULL;

Line 4509: l_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;

4505: CURSOR c_verif IS
4506: SELECT fed_verif_status
4507: FROM igf_ap_fa_base_rec_all
4508: WHERE base_id = p_base_id;
4509: l_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
4510: BEGIN
4511: l_verif_status := NULL;
4512: OPEN c_verif;
4513: FETCH c_verif INTO l_verif_status;

Line 4576: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

4572: END IF;
4573: END doesAwardSpanOutsideAP;
4574:
4575: FUNCTION chk_gplus_loan_limits (
4576: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
4577: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
4578: p_adplans_id IN igf_aw_awd_dist_plans.adplans_id%TYPE,
4579: p_aid IN NUMBER,
4580: p_std_loan_tab IN igf_aw_packng_subfns.std_loan_tab,

Line 4688: p_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,

4684: RETURN FALSE;
4685: END chk_gplus_loan_limits;
4686:
4687: PROCEDURE merge_funds(
4688: p_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
4689: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4690: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4691: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
4692: ) AS

Line 4689: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

4685: END chk_gplus_loan_limits;
4686:
4687: PROCEDURE merge_funds(
4688: p_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
4689: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4690: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4691: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
4692: ) AS
4693: ------------------------------------------------------------------

Line 4690: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

4686:
4687: PROCEDURE merge_funds(
4688: p_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
4689: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4690: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4691: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
4692: ) AS
4693: ------------------------------------------------------------------
4694: --Created by : veramach, Oracle India

Line 4691: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

4687: PROCEDURE merge_funds(
4688: p_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
4689: p_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4690: p_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4691: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
4692: ) AS
4693: ------------------------------------------------------------------
4694: --Created by : veramach, Oracle India
4695: --Date created: 19-Oct-2004

Line 4711: cp_target_group igf_ap_fa_base_rec_all.target_group%TYPE,

4707: -------------------------------------------------------------------
4708:
4709: -- Get funds which are not from the award group and are candidates for re-packaging
4710: CURSOR c_rep_funds(
4711: cp_target_group igf_ap_fa_base_rec_all.target_group%TYPE,
4712: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4713: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4714: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4715: ) IS

Line 4712: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

4708:
4709: -- Get funds which are not from the award group and are candidates for re-packaging
4710: CURSOR c_rep_funds(
4711: cp_target_group igf_ap_fa_base_rec_all.target_group%TYPE,
4712: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4713: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4714: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4715: ) IS
4716: SELECT 'x'

Line 4713: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

4709: -- Get funds which are not from the award group and are candidates for re-packaging
4710: CURSOR c_rep_funds(
4711: cp_target_group igf_ap_fa_base_rec_all.target_group%TYPE,
4712: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4713: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4714: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4715: ) IS
4716: SELECT 'x'
4717: FROM igf_aw_award_t

Line 4714: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

4710: CURSOR c_rep_funds(
4711: cp_target_group igf_ap_fa_base_rec_all.target_group%TYPE,
4712: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4713: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4714: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4715: ) IS
4716: SELECT 'x'
4717: FROM igf_aw_award_t
4718: WHERE base_id = cp_base_id

Line 4730: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

4726: l_rep_funds c_rep_funds%ROWTYPE;
4727:
4728: --check if there are non-mergable funds. If seq_no is null means the fund is not from the target group
4729: CURSOR c_non_merge(
4730: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4731: ) IS
4732: SELECT awd.fund_id
4733: FROM igf_aw_award_t awd
4734: WHERE awd.temp_char_val1 IS NULL

Line 4745: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

4741: l_non_merge c_non_merge%ROWTYPE;
4742:
4743: -- Get priorities for all funds
4744: CURSOR c_merge(
4745: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4746: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4747: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4748: ) IS
4749: SELECT ROWNUM priority,

Line 4746: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

4742:
4743: -- Get priorities for all funds
4744: CURSOR c_merge(
4745: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4746: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4747: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4748: ) IS
4749: SELECT ROWNUM priority,
4750: awd.*

Line 4747: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

4743: -- Get priorities for all funds
4744: CURSOR c_merge(
4745: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
4746: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
4747: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4748: ) IS
4749: SELECT ROWNUM priority,
4750: awd.*
4751: FROM igf_aw_fn_rpkg_prty prty,

Line 4860: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

4856: PROCEDURE load_awards(
4857: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4858: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4859: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4860: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4861: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4862: p_lock_award_flag igf_aw_fund_mast_all.lock_award_flag%TYPE,
4863: p_re_pkg_verif_flag igf_aw_fund_mast_all.re_pkg_verif_flag%TYPE,
4864: p_donot_repkg_if_code igf_aw_fund_mast_all.donot_repkg_if_code%TYPE,

Line 4889: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

4885: CURSOR c_awds(
4886: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
4887: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4888: cp_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
4889: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
4890: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
4891: ) IS
4892: SELECT awd.award_id,
4893: awd.offered_amt,

Line 4985: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

4981:
4982: -- Check for locked awards for the Student in the current fund
4983: CURSOR c_chk_locked_award(
4984: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4985: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
4986: )
4987: IS
4988: SELECT 'x'
4989: FROM igf_aw_award_t_all

Line 5000: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

4996:
4997: -- Returns all existing awards which are not locked
4998: CURSOR c_get_unlocked_award (
4999: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5000: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5001: )
5002: IS
5003: SELECT awd_t.rowid, awd_t.*
5004: FROM igf_aw_award_t_all awd_t

Line 5025: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

5021: l_overaward NUMBER;
5022:
5023: CURSOR c_pell_cnt(
5024: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5025: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5026: ) IS
5027: SELECT SUM(DECODE(awd.award_status,'CANCELLED',1,0)) cancelled_awd,
5028: SUM(DECODE(awd.award_status,'OFFERED',1,'ACCEPTED',1,0)) off_acc_awd
5029: FROM igf_aw_award_t_all awdt,

Line 5040: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

5036: l_pell_cnt c_pell_cnt%ROWTYPE;
5037:
5038: CURSOR c_lock_pell_awd(
5039: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5040: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5041: ) IS
5042: SELECT awdt.ROWID row_id,
5043: awdt.*
5044: FROM igf_aw_award_t_all awdt,

Line 5055: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

5051: l_lock_pell_awd c_lock_pell_awd%ROWTYPE;
5052:
5053: CURSOR c_lock_pell_awd1(
5054: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5055: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5056: cp_award_id igf_aw_award_all.award_id%TYPE
5057: ) IS
5058: SELECT awdt.ROWID row_id,
5059: awdt.*

Line 5068: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

5064: AND awdt.process_id = l_process_id;
5065:
5066: CURSOR c_latest_awd(
5067: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5068: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5069: ) IS
5070: SELECT awd.award_id
5071: FROM igf_aw_award_t_all awdt,
5072: igf_aw_award_all awd

Line 5567: l_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,

5563: END IF;
5564: END load_awards;
5565:
5566: PROCEDURE load_funds(
5567: l_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
5568: l_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
5569: l_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
5570: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
5571: l_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE

Line 5568: l_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

5564: END load_awards;
5565:
5566: PROCEDURE load_funds(
5567: l_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
5568: l_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
5569: l_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
5570: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
5571: l_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
5572: ) IS

Line 5569: l_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

5565:
5566: PROCEDURE load_funds(
5567: l_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
5568: l_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
5569: l_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
5570: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
5571: l_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
5572: ) IS
5573: /*

Line 5570: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

5566: PROCEDURE load_funds(
5567: l_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
5568: l_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
5569: l_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
5570: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
5571: l_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
5572: ) IS
5573: /*
5574: || Created By : cdcruz

Line 5571: l_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE

5567: l_target_group IN igf_ap_fa_base_rec_all.target_group%TYPE,
5568: l_ci_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
5569: l_ci_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
5570: l_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
5571: l_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE
5572: ) IS
5573: /*
5574: || Created By : cdcruz
5575: || Created On : 14-NOV-2000

Line 5684: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

5680:
5681: -- Remove the funds from the students list who does not belong to the Person ID group defined at the Traget group funds.
5682:
5683: CURSOR c_rmv_funds(
5684: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5685: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5686: cp_seq_no igf_aw_awd_frml_det_all.seq_no%TYPE,
5687: cp_formula_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5688: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,

Line 5756: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

5752: );
5753: l_dp_ap c_dp_ap%ROWTYPE;
5754:
5755: CURSOR c_other_awards(
5756: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5757: cp_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
5758: cp_group_code igf_aw_awd_frml_det_all.formula_code%TYPE,
5759: cp_ci_cal_type igf_aw_awd_frml_det_all.ci_cal_type%TYPE,
5760: cp_ci_sequence_number igf_aw_awd_frml_det_all.ci_sequence_number%TYPE

Line 5805: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

5801: -- key program data is taken into consideration.
5802: CURSOR c_get_ant_prog(
5803: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
5804: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
5805: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5806: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
5807: )
5808: IS
5809: SELECT ant_data.program_cd prog,

Line 5837: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

5833:
5834: -- Gets all the existing awards for a particular fund for a particular student
5835: CURSOR c_get_cancel_awds(
5836: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5837: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5838: cp_process_id igf_aw_award_t_all.process_id%TYPE
5839: )
5840: IS
5841: SELECT awd_t.rowid, awd_t.*

Line 5853: CURSOR c_get_prog_frm_adm(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

5849: -- Get Key program data from Admissions
5850: -- A student can have more than one record in Admissions. But we will
5851: -- consider only those students who have a single Admission record.
5852: -- The 'COUNT(person_id)' predicate is used to implement this
5853: CURSOR c_get_prog_frm_adm(cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
5854: IS
5855: SELECT adm.course_cd key_prog, adm.crv_version_number key_prog_ver
5856: FROM
5857: igs_ad_ps_appl_inst_all adm,

Line 5859: igf_ap_fa_base_rec_all fabase

5855: SELECT adm.course_cd key_prog, adm.crv_version_number key_prog_ver
5856: FROM
5857: igs_ad_ps_appl_inst_all adm,
5858: igs_ad_ou_stat s_adm_st,
5859: igf_ap_fa_base_rec_all fabase
5860: WHERE
5861: adm.person_id = fabase.person_id AND
5862: fabase.base_id = cp_base_id AND
5863: adm.adm_outcome_status = s_adm_st.adm_outcome_status AND

Line 5932: FROM igf_ap_fa_base_rec fabase

5928:
5929: --Bug #5021084. Passing Group ID if the group type is STATIC.
5930: IF lv_group_type = 'STATIC' THEN
5931: OPEN c_rmv_funds_check FOR 'SELECT 1
5932: FROM igf_ap_fa_base_rec fabase
5933: WHERE fabase.base_id = :base_id
5934: AND fabase.person_id in ( '||lv_sql_stmt||') ' USING l_base_id, lc_rmv_funds.pe_group_id;
5935: ELSIF lv_group_type = 'DYNAMIC' THEN
5936: OPEN c_rmv_funds_check FOR 'SELECT 1

Line 5937: FROM igf_ap_fa_base_rec fabase

5933: WHERE fabase.base_id = :base_id
5934: AND fabase.person_id in ( '||lv_sql_stmt||') ' USING l_base_id, lc_rmv_funds.pe_group_id;
5935: ELSIF lv_group_type = 'DYNAMIC' THEN
5936: OPEN c_rmv_funds_check FOR 'SELECT 1
5937: FROM igf_ap_fa_base_rec fabase
5938: WHERE fabase.base_id = :base_id
5939: AND fabase.person_id in ( '||lv_sql_stmt||') ' USING l_base_id;
5940: END IF;
5941:

Line 6601: x_base_id igf_ap_fa_base_rec.base_id%TYPE

6597:
6598: -- Get all the funds which were rejected earlier for reconsidering
6599: CURSOR c_init_flag(
6600: x_process_is NUMBER,
6601: x_base_id igf_ap_fa_base_rec.base_id%TYPE
6602: ) IS
6603: SELECT *
6604: FROM igf_aw_award_t
6605: WHERE process_id = x_process_is

Line 7013: p_coa_f IN igf_ap_fa_base_rec.coa_f%TYPE,

7009:
7010:
7011: PROCEDURE calc_need(
7012: p_base_id IN NUMBER,
7013: p_coa_f IN igf_ap_fa_base_rec.coa_f%TYPE,
7014: p_awds IN OUT NOCOPY std_awards
7015: ) IS
7016: /*
7017: || Created By : skoppula

Line 7072: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

7068: l_need_VB_AC_i NUMBER := 0;
7069:
7070: -- Get efc for Institutional methodology
7071: CURSOR c_efc_i(
7072: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
7073: ) IS
7074: SELECT coa_duration_efc_amt
7075: FROM igf_ap_css_profile_all
7076: WHERE active_profile = 'Y'

Line 7471: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE

7467: RAISE;
7468: END calc_need;
7469:
7470: FUNCTION hasActiveIsir(
7471: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
7472: ) RETURN NUMBER AS
7473: ------------------------------------------------------------------
7474: --Created by : veramach, Oracle India
7475: --Date created: 14-Oct-2004

Line 7502: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE

7498: RETURN l_isir_id;
7499: END hasActiveIsir;
7500:
7501: FUNCTION hasActiveProfile(
7502: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
7503: ) RETURN NUMBER AS
7504: ------------------------------------------------------------------
7505: --Created by : veramach, Oracle India
7506: --Date created: 14-Oct-2004

Line 7536: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE

7532: FUNCTION get_award_process_status(
7533: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
7534: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
7535: p_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE,
7536: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE
7537: ) RETURN VARCHAR2 AS
7538: ------------------------------------------------------------------
7539: --Created by : veramach, Oracle India
7540: --Date created: 25-Oct-2004

Line 7642: CURSOR c_awds ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE )

7638: */
7639:
7640: -- Get the student existing award Details
7641:
7642: CURSOR c_awds ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE )
7643: IS
7644: SELECT awd.award_id,
7645: awd.offered_amt award,
7646: fm.fund_id fund_id,

Line 7670: FROM igf_ap_fa_base_rec_all fa,

7666:
7667: -- Get the person Number for log
7668: CURSOR c_person_number( x_base_id igf_ap_fa_con_v.base_id%TYPE ) IS
7669: SELECT pe.party_number person_number, fa.packaging_status
7670: FROM igf_ap_fa_base_rec_all fa,
7671: hz_parties pe
7672: WHERE fa.base_id = x_base_id
7673: AND pe.party_id = fa.person_id;
7674:

Line 7678: CURSOR c_fabase ( x_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS

7674:
7675: l_person_number c_person_number%ROWTYPE;
7676:
7677: -- Get the Base record details
7678: CURSOR c_fabase ( x_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
7679: SELECT fabase.*
7680: FROM igf_ap_fa_base_rec fabase
7681: WHERE fabase.base_id = x_base_id;
7682:

Line 7680: FROM igf_ap_fa_base_rec fabase

7676:
7677: -- Get the Base record details
7678: CURSOR c_fabase ( x_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
7679: SELECT fabase.*
7680: FROM igf_ap_fa_base_rec fabase
7681: WHERE fabase.base_id = x_base_id;
7682:
7683: l_fabase c_fabase%ROWTYPE;
7684:

Line 7688: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

7684:
7685: -- Retrieves all the Formula Policies
7686: CURSOR c_frml_plcy(
7687: x_group_cd igf_aw_target_grp_all.group_cd%TYPE,
7688: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
7689: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
7690: ) IS
7691: SELECT tgrp.*
7692: FROM igf_aw_target_grp_all tgrp

Line 7689: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

7685: -- Retrieves all the Formula Policies
7686: CURSOR c_frml_plcy(
7687: x_group_cd igf_aw_target_grp_all.group_cd%TYPE,
7688: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
7689: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE
7690: ) IS
7691: SELECT tgrp.*
7692: FROM igf_aw_target_grp_all tgrp
7693: WHERE tgrp.cal_type = x_ci_cal_type

Line 7700: CURSOR c_rem_fund(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

7696:
7697: l_frml_plcy c_frml_plcy%ROWTYPE;
7698:
7699: -- Get the funds from the Temp table which are not yet awarded
7700: CURSOR c_rem_fund(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
7701: SELECT COUNT(*)
7702: FROM igf_aw_award_t
7703: WHERE process_id = l_process_id
7704: AND base_id = x_base_id

Line 8293: l_fabase IN igf_ap_fa_base_rec%ROWTYPE,

8289: END IF;
8290: END isPhaseInParticipant;
8291:
8292: PROCEDURE process_stud(
8293: l_fabase IN igf_ap_fa_base_rec%ROWTYPE,
8294: l_use_fixed_costs IN VARCHAR2,
8295: l_post IN VARCHAR2,
8296: l_run_mode IN VARCHAR2,
8297: l_fund_id OUT NOCOPY NUMBER,

Line 8343: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

8339: -- Retrieves all the funds that are part of the Formula Code in Sequence
8340: -- It has a link to igf_aw_award_t with a flag = 'CF' ie the valid funds
8341: CURSOR c_fund(
8342: x_group_code igf_aw_target_grp_all.group_cd%TYPE,
8343: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
8344: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
8345: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
8346: x_process_id NUMBER
8347: ) IS

Line 8344: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,

8340: -- It has a link to igf_aw_award_t with a flag = 'CF' ie the valid funds
8341: CURSOR c_fund(
8342: x_group_code igf_aw_target_grp_all.group_cd%TYPE,
8343: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
8344: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
8345: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
8346: x_process_id NUMBER
8347: ) IS
8348: SELECT TO_NUMBER(awt.temp_char_val1) seq_no,

Line 8345: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

8341: CURSOR c_fund(
8342: x_group_code igf_aw_target_grp_all.group_cd%TYPE,
8343: x_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
8344: x_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
8345: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
8346: x_process_id NUMBER
8347: ) IS
8348: SELECT TO_NUMBER(awt.temp_char_val1) seq_no,
8349: awt.fund_id fund_id,

Line 8468: CURSOR c_person_number( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS

8464:
8465: l_max_yr_amt c_max_yr_amt%ROWTYPE;
8466:
8467: --Cursor to fetch the Person Number for the base id.
8468: CURSOR c_person_number( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
8469: SELECT pe.party_number person_number
8470: FROM hz_parties pe,
8471: igf_ap_fa_base_rec_all fabase
8472: WHERE fabase.base_id = cp_base_id

Line 8471: igf_ap_fa_base_rec_all fabase

8467: --Cursor to fetch the Person Number for the base id.
8468: CURSOR c_person_number( cp_base_id igf_ap_fa_base_rec.base_id%TYPE ) IS
8469: SELECT pe.party_number person_number
8470: FROM hz_parties pe,
8471: igf_ap_fa_base_rec_all fabase
8472: WHERE fabase.base_id = cp_base_id
8473: AND pe.party_id = fabase.person_id;
8474:
8475: l_person_number c_person_number%ROWTYPE;

Line 8482: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

8478: -- Gets the max amt + max terms the student got a fund in a lifetime
8479: --
8480: -- ???? Common Terms
8481: CURSOR cur_max_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,
8482: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
8483: IS
8484: SELECT
8485: NVL(SUM(NVL(disb.disb_gross_amt,0)),0) lf_total,
8486: COUNT(DISTINCT awd.award_id) lf_count

Line 8491: igf_ap_fa_base_rec_all fabase

8487: FROM
8488: igf_aw_awd_disb_all disb,
8489: igf_aw_award_all awd,
8490: igf_aw_fund_mast_all fmast,
8491: igf_ap_fa_base_rec_all fabase
8492: WHERE fmast.fund_code = cp_fund_code
8493: AND disb.award_id = awd.award_id
8494: AND awd.fund_id = fmast.fund_id
8495: AND awd.base_id = fabase.base_id

Line 8506: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)

8502: --
8503: -- Cursor to Aggregate Award and Count
8504: --
8505: CURSOR cur_agg_lf_count ( cp_fund_code igf_aw_fund_mast_all.fund_code%TYPE ,
8506: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
8507: IS
8508: SELECT NVL(SUM(NVL(awd.offered_amt,0)),0) lf_total,
8509: COUNT(awd.award_id) lf_count
8510: FROM igf_aw_award_all awd,

Line 8512: igf_ap_fa_base_rec fabase,

8508: SELECT NVL(SUM(NVL(awd.offered_amt,0)),0) lf_total,
8509: COUNT(awd.award_id) lf_count
8510: FROM igf_aw_award_all awd,
8511: igf_aw_fund_mast_all fmast,
8512: igf_ap_fa_base_rec fabase,
8513: igf_ap_batch_aw_map_all bam
8514: WHERE fmast.fund_code = cp_fund_code
8515: AND awd.fund_id = fmast.fund_id
8516: AND awd.base_id = fabase.base_id

Line 8630: cp_base_id igf_ap_fa_base_rec.base_id%TYPE,

8626: l_chk_fund NUMBER;
8627:
8628: -- Get all the Loan Awards of the students which were already awarded or yet to be awarded
8629: CURSOR c_std_ln_awd(
8630: cp_base_id igf_ap_fa_base_rec.base_id%TYPE,
8631: cp_process_id igf_aw_award_t.process_id%TYPE
8632: ) IS
8633: SELECT fcat.fund_code fund_code,
8634: fed_fund_code,

Line 8673: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

8669:
8670: -- Get the details of term percent
8671: CURSOR c_get_term_prsnt(
8672: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
8673: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
8674: ) IS
8675: SELECT terms.ld_perct_num,
8676: terms.ld_cal_type,
8677: terms.ld_sequence_number

Line 8757: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

8753: lv_prof_value VARCHAR2(10);
8754:
8755: -- Find if student already has FM awards
8756: CURSOR c_fm_awards(
8757: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
8758: cp_process_id igf_aw_award_t.process_id%TYPE
8759: ) IS
8760: SELECT fmast.fm_fc_methd fm_fc_methd
8761: FROM igf_aw_fund_mast_all fmast,

Line 11691: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

11687:
11688: CURSOR c_awd_det(
11689: x_fund_id igf_aw_fund_mast.fund_id%TYPE,
11690: x_process_id NUMBER,
11691: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11692: x_seq_no NUMBER,
11693: x_award_id igf_aw_award_all.award_id%TYPE
11694: ) IS
11695: SELECT awdt.*

Line 11893: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

11889:
11890: -- Get the Teching and load calendar details of the fund for creating the disbursements
11891: CURSOR c_tp_perct(
11892: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
11893: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
11894: ) IS
11895: 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,
11896: terms.ld_cal_type ld_cal_type,
11897: terms.ld_sequence_number ld_sequence_number,

Line 11924: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

11920: l_tp_perct c_tp_perct%ROWTYPE;
11921:
11922: --Added this cursor for processing student without COA when COA can be exceeded
11923: CURSOR c_auto_disb_wcoa(
11924: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11925: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
11926: ) IS
11927: 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,
11928: terms.ld_cal_type ld_cal_type,

Line 11946: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

11942:
11943:
11944: CURSOR c_auto_disb_equal(
11945: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
11946: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11947: cp_num_teach_periods NUMBER
11948: ) IS
11949: 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,
11950: terms.ld_cal_type ld_cal_type,

Line 11976: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

11972: ORDER BY 1;
11973:
11974: -- Added this cursor to process students without COA when COA can be exceeded
11975: CURSOR c_auto_disb_equal_wcoa(
11976: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11977: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
11978: cp_num_teach_periods NUMBER
11979: ) IS
11980: 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,

Line 11998: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

11994: ORDER BY 1;
11995:
11996: -- Get total terms
11997: CURSOR cur_terms_count(
11998: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11999: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
12000: ) IS
12001: SELECT COUNT(*)
12002: FROM igf_aw_dp_terms terms,

Line 12026: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

12022: l_terms_count NUMBER := 0;
12023:
12024: CURSOR c_auto_disb_coa_match(
12025: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
12026: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12027: cp_total_coa_amount NUMBER
12028: ) IS
12029: 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,
12030: terms.ld_cal_type ld_cal_type,

Line 12056: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

12052: ORDER BY 1;
12053:
12054: -- Get COA
12055: CURSOR c_coa(
12056: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12057: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
12058: ) IS
12059: SELECT SUM(amount) coa
12060: FROM igf_aw_coa_itm_terms coa_terms,

Line 12074: ln_coa igf_ap_fa_base_rec_all.coa_f%TYPE;

12070: AND adplans.sequence_number = aprd.ci_sequence_number
12071: AND aprd.ld_cal_type = terms.ld_cal_type
12072: AND aprd.ld_sequence_number = terms.ld_sequence_number
12073: AND aprd.award_prd_cd = g_awd_prd;
12074: ln_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
12075:
12076:
12077: cnt NUMBER := 0;
12078: lv_rowid VARCHAR2(30);

Line 12114: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

12110:
12111: -- Get extra pell disbursements
12112: CURSOR c_pell_new_disb(
12113: cp_award_id igf_aw_award_all.award_id%TYPE,
12114: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
12115: ) IS
12116: SELECT awdt.*
12117: FROM igf_aw_award_t awdt
12118: WHERE process_id = l_process_id

Line 12124: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,

12120: AND award_id = cp_award_id
12121: AND flag = 'GR';
12122:
12123: CURSOR c_base_attendance(
12124: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12125: cp_award_id igf_aw_award_all.award_id%TYPE,
12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
12128: ) IS

Line 12659: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE

12655: END get_disbursements;
12656:
12657: PROCEDURE add_todo(
12658: p_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
12659: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
12660: ) IS
12661: /*
12662: || Created By : skoppula
12663: || Created On : 02-JAN-2002

Line 12676: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

12672:
12673: -- Get all the To Do Items which needs to be assigned to the student
12674: -- Fetch all To Do Items defined at the fund level and remove all To Do which are already assigned to the student
12675: CURSOR c_fnd_todo(
12676: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
12677: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE
12678: ) IS
12679: SELECT tdmst.todo_number,
12680: tdmst.required_for_application,

Line 12710: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

12706: l_fd_td_rec c_fnd_todo%ROWTYPE;
12707: lv_rowid VARCHAR2(30);
12708:
12709: CURSOR c_person_id(
12710: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
12711: ) IS
12712: SELECT person_id
12713: FROM igf_ap_fa_base_rec_all
12714: WHERE base_id = cp_base_id;

Line 12713: FROM igf_ap_fa_base_rec_all

12709: CURSOR c_person_id(
12710: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
12711: ) IS
12712: SELECT person_id
12713: FROM igf_ap_fa_base_rec_all
12714: WHERE base_id = cp_base_id;
12715: l_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
12716:
12717: CURSOR c_active_lender(

Line 12715: l_person_id igf_ap_fa_base_rec_all.person_id%TYPE;

12711: ) IS
12712: SELECT person_id
12713: FROM igf_ap_fa_base_rec_all
12714: WHERE base_id = cp_base_id;
12715: l_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
12716:
12717: CURSOR c_active_lender(
12718: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
12719: ) IS

Line 12718: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE

12714: WHERE base_id = cp_base_id;
12715: l_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
12716:
12717: CURSOR c_active_lender(
12718: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
12719: ) IS
12720: SELECT relationship_cd
12721: FROM igf_sl_cl_pref_lenders
12722: WHERE person_id = cp_person_id

Line 12801: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

12797: END add_todo;
12798:
12799:
12800: FUNCTION get_date_instance(
12801: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
12802: p_dt_alias IN igs_ca_da.dt_alias%TYPE,
12803: p_cal_type IN igs_ca_inst.cal_type%TYPE,
12804: p_cal_sequence IN igs_ca_inst.sequence_number%TYPE
12805: ) RETURN DATE IS

Line 12852: FROM igf_ap_fa_base_rec fabase

12848:
12849: -- Fetch the student for a given Base_id or fetch all students for a given group code
12850: CURSOR cur_sf_std IS
12851: SELECT fabase.*
12852: FROM igf_ap_fa_base_rec fabase
12853: WHERE fabase.ci_cal_type = p_ci_cal_type
12854: AND fabase.ci_Sequence_number = p_ci_sequence_number
12855: AND fabase.base_id = NVL(p_base_id, fabase.base_id);
12856: l_sf_std_rec cur_sf_std%ROWTYPE;

Line 12865: TYPE l_persid_std_recTyp IS RECORD ( base_id igf_ap_fa_base_rec.base_id%TYPE, coa_f igf_ap_fa_base_rec.coa_f%TYPE );

12861: lv_sql_stmt VARCHAR(32767) ;
12862:
12863: TYPE cur_sf_persidCurTyp IS REF CURSOR ;
12864: cur_sf_persid cur_sf_persidCurTyp ;
12865: TYPE l_persid_std_recTyp IS RECORD ( base_id igf_ap_fa_base_rec.base_id%TYPE, coa_f igf_ap_fa_base_rec.coa_f%TYPE );
12866: l_persid_std_rec l_persid_std_recTyp ;
12867:
12868:
12869: -- Get the details of students from the Temp Table in the descending order of their needs

Line 12925: FROM igf_ap_fa_base_rec fabase

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;
12929: ELSIF lv_group_type = 'DYNAMIC' THEN

Line 12931: FROM igf_ap_fa_base_rec fabase

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;
12935: END IF;

Line 13086: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

13082: l_fund igf_aw_fund_mast_all.fund_code%TYPE;
13083:
13084: -- Get person number
13085: CURSOR c_person_number(
13086: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
13087: ) IS
13088: SELECT party_number
13089: FROM hz_parties parties,
13090: igf_ap_fa_base_rec_all fabase

Line 13090: igf_ap_fa_base_rec_all fabase

13086: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
13087: ) IS
13088: SELECT party_number
13089: FROM hz_parties parties,
13090: igf_ap_fa_base_rec_all fabase
13091: WHERE fabase.person_id = parties.party_id
13092: AND fabase.base_id = cp_base_id;
13093: l_person_number hz_parties.party_number%TYPE;
13094:

Line 13327: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,

13323:
13324: -- Fetch all the student when the Target Group and Person Number is not specified who
13325: -- has valid Payment ISIR ID and also valid Target Group in descending order of their need
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,

Line 13328: cp_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE

13324: -- Fetch all the student when the Target Group and Person Number is not specified who
13325: -- has valid Payment ISIR ID and also valid Target Group in descending order of their need
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

Line 13331: FROM igf_ap_fa_base_rec_all fabase,

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
13335: AND fabase.target_group IS NOT NULL