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.

APPS.IGS_FI_WAV_UTILS_001 dependencies on IGS_FI_WAIVER_PGMS

Line 37: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

33:
34: -- Procedure to validate the parameters passed to get Eligible Waiver Amount
35: PROCEDURE validate_elg_wavamt_params(
36: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
37: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

Line 38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

34: -- Procedure to validate the parameters passed to get Eligible Waiver Amount
35: PROCEDURE validate_elg_wavamt_params(
36: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
37: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
42: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

Line 39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

35: PROCEDURE validate_elg_wavamt_params(
36: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
37: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
42: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

36: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
37: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
42: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
44: x_return_status OUT NOCOPY VARCHAR2);

Line 41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

37: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
42: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
44: x_return_status OUT NOCOPY VARCHAR2);
45:

Line 42: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

38: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
39: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
40: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
41: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
42: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
43: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
44: x_return_status OUT NOCOPY VARCHAR2);
45:
46: -- Procedure to validate the parameters passed to Apply Waivers procedure

Line 49: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

45:
46: -- Procedure to validate the parameters passed to Apply Waivers procedure
47: PROCEDURE validate_applywav_params(
48: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
49: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

Line 50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

46: -- Procedure to validate the parameters passed to Apply Waivers procedure
47: PROCEDURE validate_applywav_params(
48: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
49: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

Line 51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

47: PROCEDURE validate_applywav_params(
48: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
49: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

Line 52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

48: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
49: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
56: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

Line 53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

49: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
56: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
57: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

50: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
56: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
57: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
58: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,

Line 55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

51: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
52: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
53: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
54: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
55: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
56: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
57: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
58: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
59: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 65: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

61:
62: -- Procedure to Apply the Waiver Credit against the Waiver Adjustment Charges
63: PROCEDURE process_wavadj_charges(
64: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
65: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
66: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
67: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
68: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
69: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

Line 66: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

62: -- Procedure to Apply the Waiver Credit against the Waiver Adjustment Charges
63: PROCEDURE process_wavadj_charges(
64: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
65: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
66: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
67: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
68: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
69: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
70: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 67: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

63: PROCEDURE process_wavadj_charges(
64: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
65: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
66: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
67: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
68: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
69: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
70: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
71: p_n_credit_amount IN OUT NOCOPY NUMBER,

Line 68: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

64: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
65: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
66: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
67: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
68: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
69: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
70: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
71: p_n_credit_amount IN OUT NOCOPY NUMBER,
72: x_return_status OUT NOCOPY VARCHAR2);

Line 79: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

75: -- student account except the Rentension Charges
76: PROCEDURE process_stdnt_charges(
77: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
78: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
79: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
80: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
81: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
82: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
83: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 80: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

76: PROCEDURE process_stdnt_charges(
77: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
78: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
79: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
80: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
81: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
82: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
83: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
84: p_n_credit_amount IN OUT NOCOPY NUMBER,

Line 81: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

77: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
78: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
79: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
80: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
81: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
82: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
83: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
84: p_n_credit_amount IN OUT NOCOPY NUMBER,
85: x_return_status OUT NOCOPY VARCHAR2);

Line 101: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

97: -- Procedure to create the Waiver Adjustment Charge and
98: -- apply the charge against the waiver credit
99: PROCEDURE create_wavadj_charge(
100: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
101: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
102: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
103: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
104: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
105: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

Line 102: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

98: -- apply the charge against the waiver credit
99: PROCEDURE create_wavadj_charge(
100: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
101: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
102: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
103: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
104: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
105: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
106: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,

Line 103: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

99: PROCEDURE create_wavadj_charge(
100: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
101: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
102: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
103: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
104: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
105: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
106: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
107: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,

Line 104: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

100: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
101: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
102: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
103: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
104: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
105: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
106: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
107: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
108: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 116: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

112: -- which has some positive amount due exists
113: PROCEDURE process_due_wavadj_charges(
114: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
115: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
116: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
117: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
118: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
119: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
120: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 117: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

113: PROCEDURE process_due_wavadj_charges(
114: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
115: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
116: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
117: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
118: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
119: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
120: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2);

Line 118: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

114: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
115: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
116: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
117: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
118: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
119: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
120: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2);
122:

Line 119: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

115: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
116: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
117: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
118: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
119: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
120: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
121: x_return_status OUT NOCOPY VARCHAR2);
122:
123: --

Line 129: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

125: --
126:
127: PROCEDURE get_eligible_waiver_amt(
128: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
129: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

Line 130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

126:
127: PROCEDURE get_eligible_waiver_amt(
128: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
129: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
134: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

Line 131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

127: PROCEDURE get_eligible_waiver_amt(
128: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
129: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
134: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
135: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

128: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
129: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
134: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
135: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
136: x_return_status OUT NOCOPY VARCHAR2,

Line 133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

129: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
134: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
135: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_eligible_amount OUT NOCOPY NUMBER ) AS

Line 134: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

130: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
131: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
132: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
133: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
134: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
135: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_eligible_amount OUT NOCOPY NUMBER ) AS
138: /******************************************************************

Line 346: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

342:
343:
344: PROCEDURE apply_waivers(
345: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
346: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

Line 347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

343:
344: PROCEDURE apply_waivers(
345: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
346: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

Line 348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

344: PROCEDURE apply_waivers(
345: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
346: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

Line 349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

345: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
346: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
353: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

Line 350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

346: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
353: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
354: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

347: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
353: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
354: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
355: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,

Line 352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

348: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
349: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
350: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
351: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
352: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
353: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
354: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
355: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
356: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 769: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

765: --
766:
767: PROCEDURE validate_elg_wavamt_params(
768: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
769: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

Line 770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

766:
767: PROCEDURE validate_elg_wavamt_params(
768: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
769: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
774: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

Line 771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

767: PROCEDURE validate_elg_wavamt_params(
768: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
769: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
774: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
775: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

768: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
769: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
774: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
775: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
776: x_return_status OUT NOCOPY VARCHAR2) AS

Line 773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

769: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
774: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
775: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
776: x_return_status OUT NOCOPY VARCHAR2) AS
777: /******************************************************************

Line 774: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

770: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
771: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
772: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
773: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
774: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
775: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
776: x_return_status OUT NOCOPY VARCHAR2) AS
777: /******************************************************************
778: Created By : Anji Yedubati

Line 849: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

845: END validate_elg_wavamt_params;
846:
847: PROCEDURE validate_applywav_params(
848: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
849: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

Line 850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

846:
847: PROCEDURE validate_applywav_params(
848: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
849: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

Line 851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

847: PROCEDURE validate_applywav_params(
848: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
849: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

Line 852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

848: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
849: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
856: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,

Line 853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

849: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
856: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
857: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

850: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
856: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
857: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
858: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,

Line 855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

851: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
852: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
853: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
854: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
855: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
856: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
857: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
858: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
859: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 935: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

931: END validate_applywav_params;
932:
933: PROCEDURE process_wavadj_charges(
934: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
935: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
936: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
937: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
938: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
939: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

Line 936: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

932:
933: PROCEDURE process_wavadj_charges(
934: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
935: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
936: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
937: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
938: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
939: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
940: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 937: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

933: PROCEDURE process_wavadj_charges(
934: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
935: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
936: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
937: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
938: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
939: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
940: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
941: p_n_credit_amount IN OUT NOCOPY NUMBER,

Line 938: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

934: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
935: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
936: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
937: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
938: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
939: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
940: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
941: p_n_credit_amount IN OUT NOCOPY NUMBER,
942: x_return_status OUT NOCOPY VARCHAR2) AS

Line 1070: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

1066:
1067: PROCEDURE process_stdnt_charges(
1068: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1069: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1070: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1071: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1072: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1073: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1074: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 1071: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

1067: PROCEDURE process_stdnt_charges(
1068: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1069: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1070: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1071: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1072: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1073: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1074: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1075: p_n_credit_amount IN OUT NOCOPY NUMBER,

Line 1072: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

1068: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1069: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1070: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1071: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1072: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1073: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1074: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1075: p_n_credit_amount IN OUT NOCOPY NUMBER,
1076: x_return_status OUT NOCOPY VARCHAR2) AS

Line 1380: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

1376: END adjust_stdnt_charges;
1377:
1378: PROCEDURE create_wavadj_charge(
1379: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1380: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1381: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1382: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1383: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1384: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,

Line 1381: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

1377:
1378: PROCEDURE create_wavadj_charge(
1379: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1380: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1381: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1382: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1383: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1384: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1385: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,

Line 1382: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

1378: PROCEDURE create_wavadj_charge(
1379: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1380: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1381: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1382: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1383: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1384: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1385: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1386: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,

Line 1383: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

1379: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1380: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1381: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1382: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1383: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1384: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1385: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1386: p_n_waiver_amt IN igs_fi_inv_int_all.invoice_amount%TYPE,
1387: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 1493: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

1489:
1490: PROCEDURE process_due_wavadj_charges(
1491: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1492: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1493: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1494: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1495: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1496: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1497: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

Line 1494: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

1490: PROCEDURE process_due_wavadj_charges(
1491: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1492: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1493: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1494: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1495: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1496: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1497: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1498: x_return_status OUT NOCOPY VARCHAR2) AS

Line 1495: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

1491: p_n_source_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1492: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1493: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1494: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1495: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1496: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1497: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1498: x_return_status OUT NOCOPY VARCHAR2) AS
1499: /******************************************************************

Line 1496: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

1492: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1493: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1494: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1495: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1496: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1497: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1498: x_return_status OUT NOCOPY VARCHAR2) AS
1499: /******************************************************************
1500: Created By : Anji Yedubati

Line 1841: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

1837:
1838:
1839: PROCEDURE create_ss_waiver_transactions(
1840: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1841: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

Line 1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,

1838:
1839: PROCEDURE create_ss_waiver_transactions(
1840: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1841: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,

Line 1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,

1839: PROCEDURE create_ss_waiver_transactions(
1840: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1841: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

Line 1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,

1840: p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
1841: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

Line 1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,

1841: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,
1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,

Line 1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,

1842: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%TYPE,
1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1850: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,

Line 1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,

1843: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1850: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
1851: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,

Line 1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,

1844: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%TYPE,
1845: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%TYPE,
1846: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_id%TYPE,
1847: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%TYPE,
1848: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%TYPE,
1849: p_n_source_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1850: p_n_waiver_amount IN igs_fi_credits_all.amount%TYPE,
1851: p_v_currency_cd IN igs_fi_inv_int_all.currency_cd%TYPE,
1852: p_d_gl_date IN igs_fi_invln_int_all.gl_date%TYPE,