DBA Data[Home] [Help]

APPS.IGS_FI_WAV_UTILS_001 dependencies on IGS_FI_WAIVER_PGMS

Line 23: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

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,

Line 24: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%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,

Line 25: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%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,

Line 26: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%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,

Line 27: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%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,
31: x_eligible_amount OUT NOCOPY NUMBER );

Line 28: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%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 );
32:

Line 35: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%TYPE,

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,

Line 36: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%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,

Line 37: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%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,

Line 38: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%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,

Line 39: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%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,

Line 40: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%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,

Line 41: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%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,

Line 50: p_v_fee_cal_type IN igs_fi_waiver_pgms.fee_cal_type%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,

Line 51: p_n_fee_ci_seq_number IN igs_fi_waiver_pgms.fee_ci_sequence_number%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,

Line 52: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%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,

Line 53: p_v_target_fee_type IN igs_fi_waiver_pgms.target_fee_type%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,

Line 54: p_v_adj_fee_type IN igs_fi_waiver_pgms.adjustment_fee_type%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,

Line 55: p_n_credit_type_id IN igs_fi_waiver_pgms.credit_type_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,

Line 56: p_v_waiver_method_code IN igs_fi_waiver_pgms.waiver_method_code%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,

Line 57: p_v_waiver_mode_code IN igs_fi_waiver_pgms.waiver_mode_code%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,