[Home] [Help]
29: --vvutukur 05-Jul-2002 Modified group_waiver_proc procedure to exclude reversed charges
30: -- from being selected through cursor c_per_chg as part of Bug#2405762.
31: --jbegum 13-Jun-2002 Bug#2412433 Added a validation checking if the Balance Type passed
32: -- is a STANDARD Balance.If it is then concurrent process errors out.
33: --sarakshi 28-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
34: --sbaliga 25-feb-2002 Modified procedure group_waiver_proc as part of #2144600
35: -------------------------------------------------------------------
36:
37: FUNCTION fee_perd (p_cal_type IN igs_ca_inst.cal_type%TYPE ,
180: p_c_bal_type IN igs_lookups_view.lookup_code%TYPE ,
181: p_d_start_dt IN VARCHAR2 ,
182: p_d_end_dt IN VARCHAR2 ,
183: p_d_release_dt IN VARCHAR2 ,
184: p_n_person_id IN igs_pe_person_v.person_id%TYPE ,
185: p_n_pers_id_grp_id IN igs_pe_persid_group_v.group_id%TYPE ,
186: p_c_fee_period IN VARCHAR2 ,
187: /* Removed the parameters p_n_sub_acc_1 and p_n_sub_acc_2, as a part of Bug # 2564643 */
188: p_c_fee_type_1 IN igs_fi_inv_int.fee_type%TYPE ,
239: l_release_dt igs_fi_inv_wav_det.end_dt%TYPE ;
240: l_rowid igs_fi_inv_wav_det_v.row_id%TYPE ;
241: l_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ;
242: l_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ;
243: l_per_num igs_pe_person_v.person_number%TYPE ;
244: l_msg_str VARCHAR2(1000) ;
245:
246: TYPE tab_party_rec IS TABLE OF hz_parties.party_id%TYPE INDEX BY BINARY_INTEGER;
247: v_tab_party_rec tab_party_rec ;
294: FROM hz_parties
295: WHERE party_id = cp_person_id
296: AND party_type IN ('ORGANIZATION','PERSON');
297:
298: CURSOR c_per_chg (cp_person_id igs_pe_person_v.person_id%TYPE ,
299: cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,
300: cp_fee_ci_seq_no igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE ,
301: /* Removed the cursor parameters cp_sub_acc1 and cp_sub_acc2 as a part of the Bug # 2564643 */
302: cp_fee_type1 igs_fi_inv_int.fee_type%TYPE ,