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_INVLN_INT

Line 59: p_d_gl_date IN igs_fi_invln_int.gl_date%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,
60: x_return_status OUT NOCOPY VARCHAR2);
61:
62: -- Procedure to Apply the Waiver Credit against the Waiver Adjustment Charges
63: PROCEDURE process_wavadj_charges(

Line 70: p_d_gl_date IN igs_fi_invln_int.gl_date%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);
73:
74: -- Procedure to Apply the balance Waiver Credit against the charges in the

Line 83: p_d_gl_date IN igs_fi_invln_int.gl_date%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);
86:
87: -- Procedure to Un apply existing applications for credits other than

Line 93: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

89: -- and apply the unapplied charges against the balance Waiver Credit
90: PROCEDURE adjust_stdnt_charges(
91: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
92: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
93: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
94: p_n_credit_amount IN OUT NOCOPY NUMBER,
95: x_return_status OUT NOCOPY VARCHAR2);
96:
97: -- Procedure to create the Waiver Adjustment Charge and

Line 108: p_d_gl_date IN igs_fi_invln_int.gl_date%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,
109: x_return_status OUT NOCOPY VARCHAR2);
110:
111: -- Procedure to apply the Waiver Adjustment Charges for a Waiver Credit,
112: -- which has some positive amount due exists

Line 120: p_d_gl_date IN igs_fi_invln_int.gl_date%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: --
124: -- Public Procedures

Line 356: p_d_gl_date IN igs_fi_invln_int.gl_date%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,
357: x_return_status OUT NOCOPY VARCHAR2 ) AS
358: /******************************************************************
359: Created By : Anji Yedubati
360: Date Created By : 11-JUL-2005

Line 408: igs_fi_invln_int_all invln

404: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
405: SELECT inv.invoice_id,
406: inv.invoice_amount_due
407: FROM igs_fi_inv_int_all inv,
408: igs_fi_invln_int_all invln
409: WHERE inv.person_id = cp_n_person_id
410: AND inv.fee_type = cp_v_target_fee_type
411: AND inv.fee_cal_type = cp_v_fee_cal_type
412: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 859: p_d_gl_date IN igs_fi_invln_int.gl_date%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,
860: x_return_status OUT NOCOPY VARCHAR2) AS
861: /******************************************************************
862: Created By : Anji Yedubati
863: Date Created By : 19-JUL-2005

Line 940: p_d_gl_date IN igs_fi_invln_int.gl_date%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
943: /******************************************************************
944: Created By : Anji Yedubati

Line 965: igs_fi_invln_int_all invln

961: cp_v_waiver_name igs_fi_credits_all.waiver_name%TYPE) IS
962: SELECT inv.invoice_id,
963: inv.invoice_amount_due
964: FROM igs_fi_inv_int_all inv,
965: igs_fi_invln_int_all invln
966: WHERE inv.person_id = cp_n_person_id
967: AND inv.fee_type = cp_v_adj_fee_type
968: AND inv.fee_cal_type = cp_v_fee_cal_type
969: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 1074: p_d_gl_date IN igs_fi_invln_int.gl_date%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
1077: /******************************************************************
1078: Created By : Anji Yedubati

Line 1100: igs_fi_invln_int_all invln

1096: cp_n_fee_ci_seq_num igs_fi_credits_all.fee_ci_sequence_number%TYPE) IS
1097: SELECT inv.invoice_id,
1098: inv.invoice_amount_due
1099: FROM igs_fi_inv_int_all inv,
1100: igs_fi_invln_int_all invln
1101: WHERE (inv.invoice_id = cp_n_invoice_id OR cp_n_invoice_id IS NULL)
1102: AND inv.person_id = cp_n_person_id
1103: AND inv.fee_type = cp_v_target_fee_type
1104: AND inv.fee_cal_type = cp_v_fee_cal_type

Line 1206: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,

1202:
1203: PROCEDURE adjust_stdnt_charges(
1204: p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
1205: p_n_credit_id IN igs_fi_credits_all.credit_id%TYPE,
1206: p_d_gl_date IN igs_fi_invln_int.gl_date%TYPE,
1207: p_n_credit_amount IN OUT NOCOPY NUMBER,
1208: x_return_status OUT NOCOPY VARCHAR2) AS
1209: /******************************************************************
1210: Created By : Anji Yedubati

Line 1387: p_d_gl_date IN igs_fi_invln_int.gl_date%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,
1388: x_return_status OUT NOCOPY VARCHAR2) AS
1389: /******************************************************************
1390: Created By : Anji Yedubati
1391: Date Created By : 21-JUL-2005

Line 1497: p_d_gl_date IN igs_fi_invln_int.gl_date%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
1501: Date Created By : 21-JUL-2005

Line 1527: igs_fi_invln_int_all invln

1523: inv.invoice_id,
1524: inv.invoice_amount,
1525: inv.invoice_amount_due
1526: FROM igs_fi_inv_int_all inv,
1527: igs_fi_invln_int_all invln
1528: WHERE inv.person_id = cp_n_person_id
1529: AND inv.fee_type = cp_v_adj_fee_type
1530: AND inv.fee_cal_type = cp_v_fee_cal_type
1531: AND inv.fee_ci_sequence_number = cp_n_fee_ci_seq_num

Line 1852: p_d_gl_date IN igs_fi_invln_int_all.gl_date%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,
1853: x_return_status OUT NOCOPY VARCHAR2) IS
1854: /******************************************************************
1855: Created By : Priya Athipatla
1856: Date Created By : 16-Aug-2005