[Home] [Help]
102: igf_aw_awd_disb disb,
103: igf_aw_award awd,
104: igf_aw_fund_mast fnd,
105: igf_aw_fund_cat fcat,
106: igf_ap_fa_base_rec fab
107: WHERE disb_dlt.award_id = disb.award_id
108: AND disb_dlt.disb_num = disb.disb_num
109: AND disb.award_id = awd.award_id
110: AND fnd.fund_id = awd.fund_id
213: Known limitations,enhancements,remarks:
214: Change History
215: Who When What
216: smadathi 31-dec-2002 Bug 2719776. Modified the cursor cur_val select to fetch
217: the records from view igf_ap_fa_base_rec instead of
218: igf_ap_fa_con_v. This fix is done to remove
219: Non-mergable view exists in the select and to reduce shared memory
220: within the acceptable limit
221: ********************************************************************************************** */
221: ********************************************************************************************** */
222:
223: CURSOR cur_val IS
224: SELECT 'X'
225: FROM igf_ap_fa_base_rec
226: WHERE base_id = p_base_id
227: AND ci_cal_type =p_cal_type
228: AND ci_sequence_number=p_sequence_number;
229: l_temp VARCHAR2(1);
1407: smadathi 06-Jan-2003 Bug 2684895. Removed the logging of person group id. Instead
1408: used call to igs_fi_gen_005.finp_get_prsid_grp_code to
1409: log person group code.
1410: smadathi 31-dec-2002 Bug 2719776. Modified the cursor cur_person select to fetch
1411: the records from view igf_ap_fa_base_rec and igs_pe_person_base_v
1412: instead of igf_ap_fa_con_v. This fix is done to remove
1413: Non-mergable view exists in the select and to reduce shared memory
1414: within the acceptable limit
1415: smadathi 31-DEC-2002 Bug 2719776. Logic has been modified to raise user defined exception
1427:
1428: CURSOR cur_person IS
1429: SELECT pe.person_number person_number ,
1430: fabase.person_id person_id
1431: FROM igf_ap_fa_base_rec fabase,
1432: igs_pe_person_base_v pe
1433: WHERE fabase.person_id = pe.person_id
1434: AND base_id= p_base_id;
1435: l_cur_person cur_person%ROWTYPE;
1439: FROM igf_aw_fund_mast
1440: WHERE fund_id = p_fund_id;
1441: l_cur_fund cur_fund%ROWTYPE;
1442:
1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)
1446: IS
1447: SELECT base_id
1440: WHERE fund_id = p_fund_id;
1441: l_cur_fund cur_fund%ROWTYPE;
1442:
1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)
1446: IS
1447: SELECT base_id
1448: FROM igf_ap_fa_base_rec
1441: l_cur_fund cur_fund%ROWTYPE;
1442:
1443: CURSOR cur_base(cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)
1446: IS
1447: SELECT base_id
1448: FROM igf_ap_fa_base_rec
1449: WHERE person_id = cp_person_id
1444: cp_ci_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
1445: cp_ci_sequence_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE)
1446: IS
1447: SELECT base_id
1448: FROM igf_ap_fa_base_rec
1449: WHERE person_id = cp_person_id
1450: AND ci_cal_type = cp_ci_cal_type
1451: AND ci_sequence_number = cp_ci_sequence_number;
1452:
1478: l_v_curr_desc fnd_currencies_tl.name%TYPE;
1479: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
1480: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
1481: lv_profile_value VARCHAR2(30);
1482: lv_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
1483: lv_group_type igs_pe_persid_group_v.group_type%TYPE;
1484:
1485: BEGIN
1486: