[Home] [Help]
392: some parameters and placed a call to Private API.Removed finp_get_cur generic procedure which fetches currency code
393: as the same has been moved to procedure transfer_disb_dtls_to_sf
394: agairola 07-Mar-2003 Bug# 2814089: Following modifications have been done
395: 1. The cursor cur_api has been modified to select person_number
396: from igs_pe_person_base_v
397: 2. For the parameter p_student_sponsor='SPONSOR', the value of the
398: parameter passed to cur_api is changed to p_cur_disb.person_id.
399: 3. The credit description is modified for the sponsor transaction as
400: Negative Charge Adjustment : Person Number : Full Name
428: l_cur_desc cur_desc%ROWTYPE;
429:
430: CURSOR cur_api(cp_person_id igs_pe_person_v.person_id%TYPE) IS
431: SELECT person_number,full_name
432: FROM igs_pe_person_base_v
433: WHERE person_id = cp_person_id;
434: l_cur_api cur_api%ROWTYPE;
435:
436: l_credit_activity_id igs_fi_cr_activities.credit_activity_id%TYPE;
603: vvutukur 11-Apr-2003 Enh#2831554.Internal Credits API Build. Removed finp_get_cur generic procedure which fetches currency code
604: as the same has been moved to procedure transfer_disb_dtls_to_sf.
605: agairola 07-Mar-2003 Bug# 2814089: Following modifications have been done
606: 1. The cursor cur_api has been modified to select person_number
607: from igs_pe_person_base_v
608: 2. For the parameter p_student_sponsor='SPONSOR', the value of the
609: parameter passed to cur_api is changed to p_cur_disb.person_id.
610: 3. The invoice description is modified for the sponsor transaction as
611: Person Number : Full Name
634: l_cur_desc cur_desc%ROWTYPE;
635:
636: CURSOR cur_api(cp_person_id igs_pe_person_v.person_id%TYPE) IS
637: SELECT person_number,full_name
638: FROM igs_pe_person_base_v
639: WHERE person_id = cp_person_id;
640: l_cur_api cur_api%ROWTYPE;
641:
642: CURSOR c_igs_fi_fee_type (cp_v_fee_type igs_fi_fee_type_all.fee_type%TYPE) IS
843: form layout.
844: vvutukur 26-Feb-2003 Enh#2758823.FA117 Build. Modified the call to igf_db_awd_disb_dtl_pkg.update_row to pass TRUNC(SYSDATE)
845: instead of SYSDATE for the parameter x_sf_status_date.
846: smadathi 31-dec-2002 Bug 2620359. Modified the cursor cur_person to fetch the person number
847: from igs_pe_person_base_v instead of the igs_pe_person. This is done
848: due to Non-Meargability and higher value of shared memory beyong the acceptable limit
849: vvutukur 20-Nov-2002 Enh#2584986.Added new parameter p_d_gl_date.Also modified the calls to call_charges_api
850: and call_credits_api to pass this p_d_gl_date parameter.Also added this p_d_gl_date
851: parameter to the call to igs_fi_prc_refunds.process_plus.
856: Fee Cal Parameters Derived for the Load Cal are passed for charges Creation
857: ********************************************************************************************** */
858: CURSOR cur_person(cp_person_id igs_pe_person_v.person_id%TYPE) IS
859: SELECT person_number
860: FROM igs_pe_person_base_v
861: WHERE person_id=cp_person_id;
862: l_cur_person cur_person%ROWTYPE;
863:
864: CURSOR cur_cr_type(cp_credit_type_id igs_fi_cr_types_all.credit_type_name%TYPE) IS
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
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;
1436: