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.

[Home] [Help]

APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_FI_BALANCE_RULES

Line 98: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE,

94: p_person_id_grp IN igs_pe_prsid_grp_mem_v.group_id%TYPE,
95: p_fee_period IN VARCHAR2,
96: p_fee_cal_type IN igs_fi_inv_int.fee_cal_type%TYPE,
97: p_fee_ci_sequence_number IN igs_fi_inv_int.fee_ci_sequence_number%TYPE,
98: p_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
99: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%TYPE,
100: p_test_run IN VARCHAR2
101: ) RETURN BOOLEAN IS
102: /***************************************************

Line 279: p_balance_type IN igs_fi_balance_rules.balance_name%type,

275: RETCODE OUT NOCOPY NUMBER,
276: p_person_id IN igs_pe_person.person_id%type,
277: p_person_id_grp IN igs_pe_prsid_grp_mem_v.group_id%type,
278: p_FEE_PERIOD IN VARCHAR2,
279: p_balance_type IN igs_fi_balance_rules.balance_name%type,
280: p_dcnt_reason_cd IN igs_en_dcnt_reasoncd_v.discontinuation_reason_cd%type,
281: p_test_run IN VARCHAR2
282: ) AS
283:

Line 336: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,

332: -- and which have been created due to the Fee Assessment Run and have the Unit Section details
333: -- and the records do not have waiver details
334:
335: CURSOR cur_person_chrgs(cp_n_person_id IN hz_parties.party_id%type,
336: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
337: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
338: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
339: ) IS
340: SELECT hd.person_id person_id,

Line 368: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,

364: BETWEEN wd.start_dt and wd.end_dt))
365: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
366:
367: CURSOR cur_person_group_chrgs(cp_n_person_id_grp IN igs_pe_prsid_grp_mem_all.group_id%TYPE,
368: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
369: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
370: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
371: ) IS
372: SELECT hd.person_id person_id,

Line 403: CURSOR cur_all_person_chrgs(cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,

399: BETWEEN wd.start_dt and wd.end_dt))
400: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
401:
402:
403: CURSOR cur_all_person_chrgs(cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
404: cp_v_fee_cal_type IN Igs_fi_inv_int_all.fee_cal_type%TYPE,
405: cp_n_fee_ci_sequence_number IN Igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
406: ) IS
407: SELECT hd.person_id person_id,

Line 496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;

492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;
496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
497: l_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;
498: l_version_number igs_fi_balance_rules.version_number%TYPE;
499:
500: l_flag BOOLEAN := TRUE;

Line 497: l_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;

493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;
496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
497: l_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;
498: l_version_number igs_fi_balance_rules.version_number%TYPE;
499:
500: l_flag BOOLEAN := TRUE;
501: l_enr_dtls cur_enrl_dt%ROWTYPE;

Line 498: l_version_number igs_fi_balance_rules.version_number%TYPE;

494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;
496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
497: l_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;
498: l_version_number igs_fi_balance_rules.version_number%TYPE;
499:
500: l_flag BOOLEAN := TRUE;
501: l_enr_dtls cur_enrl_dt%ROWTYPE;
502: l_str_enrl VARCHAR2(4000);