APPS.OKL_BPD_MAN_RCT_HANDLE_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 68: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;

64: l_receipt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL;
65:
66: l_xcr_id NUMBER;
67:
68: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
69: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
70:
71: l_trans_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL; -- entered currency code
72:

Line 79: l_outstanding_amt AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT 0;

75: l_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
76: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
77: l_tot_amount_to_apply AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT 0;
78: l_unapplied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
79: l_outstanding_amt AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%TYPE DEFAULT 0;
80:
81: l_prev_applied_amt AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL;
82: l_remaining_amt NUMBER DEFAULT NULL;
83:

Line 197: CURSOR c_get_pymt_dtls(cp_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE) IS

193: WHERE CNSLD.ID = cp_stream_id;
194: -------------------------------------------------------------------------------
195:
196: -- Obtain the payment details for the invoice
197: CURSOR c_get_pymt_dtls(cp_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE) IS
198: SELECT
199: APS.AMOUNT_DUE_REMAINING
200: FROM
201: AR_PAYMENT_SCHEDULES_ALL APS

Line 201: AR_PAYMENT_SCHEDULES_ALL APS

197: CURSOR c_get_pymt_dtls(cp_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE) IS
198: SELECT
199: APS.AMOUNT_DUE_REMAINING
200: FROM
201: AR_PAYMENT_SCHEDULES_ALL APS
202: WHERE
203: APS.CUSTOMER_TRX_ID = cp_customer_trx_id;
204: -------------------------------------------------------------------------------
205: BEGIN

Line 659: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;

655: l_conversion_rate GL_DAILY_RATES_V.CONVERSION_RATE%TYPE DEFAULT 0;
656: l_applied_amount_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL;
657:
658: l_xcr_id NUMBER;
659: l_customer_trx_id AR_PAYMENT_SCHEDULES_ALL.CUSTOMER_TRX_ID%TYPE DEFAULT NULL;
660: l_cash_receipt_id AR_CASH_RECEIPTS_ALL.CASH_RECEIPT_ID%TYPE DEFAULT p_receipt_id;
661:
662: l_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE DEFAULT NULL;
663: l_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;