[Home] [Help]
17: --vvutukur 20-Jan-2004 Bug#3348787.Modified function test_mode.
18: --uudayapr 26-SEP-2003 Bug:3055356 - Replaced the Default Intiallization of sysdate to l_release_dt
19: -- when null ,Added code for message log in group_waiver_proc procedure.
20: --pathipat 24-Jun-2003 Bug: 3018104 - Impact of changes to person id group views
21: -- Replaced igs_pe_persid_group_v with igs_pe_persid_group in group_waiver_proc()
22: --shtatiko 22-APR-2003 Enh# 2831569, Modified group_waiver_proc
23: --vvutukur 21-Jan-2003 Bug#2751136.Modifications done in procedure group_waiver_proc and function lookup_desc.
24: -- SYKRISHN 03-JAN2003 Bug 2684895 - Logged person group code instead of person group id
25: -- used igs_fi_gen_005.finp_get_prsid_grp_code()
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 ,
189: p_c_fee_type_2 IN igs_fi_inv_int.fee_type%TYPE ,
215: -- log file and error out the process.
216: -- Added the Code for logging message to log file when start date and end date
217: -- is provided when the action is release.
218: --pathipat 24-Jun-2003 Bug: 3018104 - Impact of changes to person id group views
219: -- Replaced igs_pe_persid_group_v with igs_pe_persid_group in c_grp_id
220: --shtatiko 22-APR-2003 Enh# 2831569, Added check for Manage Accounts System Option
221: --vvvutukur 21-Jan-2003 Bug#2751136.Removed app_exception.raise_exception whenever a parameter validation fails, instead, used a variable
222: -- l_valid to identify the failure of validation,after logging the error message. After all the parameters are validated,
223: -- set the retcode to 2 and stopped processing further.Also, used message IGS_FI_NO_PERS_PGRP instead of
248: l_n_party_id hz_parties.party_id%TYPE;
249:
250:
251:
252: CURSOR c_grp_id (cp_group_id igs_pe_persid_group_v.group_id%TYPE) IS
253: SELECT 'X'
254: FROM igs_pe_persid_group
255: WHERE group_id = cp_group_id
256: AND closed_ind = 'N'
280: AND s.s_cal_status = 'ACTIVE';
281:
282: l_v_cal_per VARCHAR2(1);
283:
284: CURSOR c_pers_group (cp_person_grp igs_pe_persid_group_v.group_id%TYPE) IS
285: SELECT person_id
286: FROM igs_pe_prsid_grp_mem
287: WHERE group_id = cp_person_grp
288: AND (start_date <= TRUNC(SYSDATE) OR start_date IS NULL)