APPS.ARP_BALANCE_CHECK dependencies on AR_PAYMENT_SCHEDULES

Line 6: P_ps_rec ar_payment_schedules%ROWTYPE;

2: /* $Header: ARBALCHS.pls 120.4.12020000.2 2012/08/08 09:24:23 ankuagar ship $ */
3:
4: out_of_balance EXCEPTION;
5: amount_mismatch EXCEPTION;
6: P_ps_rec ar_payment_schedules%ROWTYPE;
7: P_ps_rec_pmt ar_payment_schedules%ROWTYPE;
8: P_reg_cm VARCHAR(2) default 'N';
9:
10: TYPE unbalanced_receipt IS RECORD (

Line 7: P_ps_rec_pmt ar_payment_schedules%ROWTYPE;

3:
4: out_of_balance EXCEPTION;
5: amount_mismatch EXCEPTION;
6: P_ps_rec ar_payment_schedules%ROWTYPE;
7: P_ps_rec_pmt ar_payment_schedules%ROWTYPE;
8: P_reg_cm VARCHAR(2) default 'N';
9:
10: TYPE unbalanced_receipt IS RECORD (
11: cash_receipt_id NUMBER,

Line 132: | are stamped correctly in ar_payment_schedules when the payment schedule

128: | PROCEDURE Check_Ps_Date
129: |
130: | DESCRIPTION
131: | This Procedure checks if the gl_date_closed and actual_date_closed
132: | are stamped correctly in ar_payment_schedules when the payment schedule
133: | is closed. It returns the correct values which can can then be sent to the
134: | Fix_Ps_Date procedure to correct the data corruption
135: | PARAMETERS
136: | p_ps_id IN Payment Schedule id

Line 142: p_ps_rec IN ar_payment_schedules%ROWTYPE,

138: | p_gl_date_closed OUT New Value for GL Closed Date
139: | p_actual_date_closed OUT New Value for Actual Closed Date
140: * ======================================================================*/
141: PROCEDURE CHECK_PS_DATE(
142: p_ps_rec IN ar_payment_schedules%ROWTYPE,
143: p_corrupt_type OUT NOCOPY VARCHAR2,
144: p_gl_date_closed OUT NOCOPY DATE,
145: p_actual_date_closed OUT NOCOPY DATE);
146:

Line 152: | in ar_payment_schedules. The correct values need to be fetched from the procedure

148: | PROCEDURE Fix_Ps_Date
149: |
150: | DESCRIPTION
151: | This procedure corrects the data for the fields gl_date_closed and actual_date_closed
152: | in ar_payment_schedules. The correct values need to be fetched from the procedure
153: | CHECK_PS_DATE
154: |
155: | PARAMETERS
156: | p_ps_id IN Payment Schedule id