19: ***************************************************************** */
20:
21: PROCEDURE get_eligible_waiver_amt(
22: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
23: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
24: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
25: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
26: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
27: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
20:
21: PROCEDURE get_eligible_waiver_amt(
22: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
23: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
24: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
25: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
26: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
27: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
28: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
21: PROCEDURE get_eligible_waiver_amt(
22: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
23: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
24: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
25: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
26: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
27: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
28: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
29: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
22: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
23: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
24: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
25: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
26: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
27: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
28: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
29: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
30: x_return_status OUT NOCOPY VARCHAR2,
23: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
24: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
25: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
26: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
27: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
28: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
29: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_eligible_amount OUT NOCOPY NUMBER );
24: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
25: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
26: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
27: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
28: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
29: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_eligible_amount OUT NOCOPY NUMBER );
32:
31: x_eligible_amount OUT NOCOPY NUMBER );
32:
33: PROCEDURE apply_waivers(
34: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
35: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
36: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
32:
33: PROCEDURE apply_waivers(
34: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
35: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
36: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
40: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
33: PROCEDURE apply_waivers(
34: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
35: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
36: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
40: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
41: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
34: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
35: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
36: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
40: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
41: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
42: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
35: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
36: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
40: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
41: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
42: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
36: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
40: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
41: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
42: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
44: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
40: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
41: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
42: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
44: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
45: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
46: x_return_status OUT NOCOPY VARCHAR2 );
47:
48: PROCEDURE create_ss_waiver_transactions(
49: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
50: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
51: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
47:
48: PROCEDURE create_ss_waiver_transactions(
49: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
50: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
51: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
48: PROCEDURE create_ss_waiver_transactions(
49: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
50: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
51: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
56: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
49: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
50: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
51: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
56: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
57: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
50: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
51: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
56: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
57: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
58: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
51: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
56: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
57: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
58: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
59: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
56: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
57: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
58: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
59: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
60: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
56: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
57: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
58: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
59: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
60: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
61: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,