APPS.OKL_AUTO_CASH_APPL_RULES_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 236: FROM RA_CUSTOMER_TRX_ALL

232:
233: --
234: CURSOR c_get_arinv ( l_inv_ref IN VARCHAR2,cp_org_id IN NUMBER) IS
235: SELECT TRX_NUMBER, invoice_currency_code
236: FROM RA_CUSTOMER_TRX_ALL
237: WHERE TRX_NUMBER= l_inv_ref
238: AND org_id = cp_org_id;
239:
240: l_trx_number NUMBER;

Line 2603: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;

2599: --and its corresponding invoice lines with its applied amount
2600: PROCEDURE GET_APPLICATIONS ( p_rcpt_tbl IN okl_rcpt_dtls_tbl_type
2601: ,x_appl_tbl OUT NOCOPY okl_appl_dtls_tbl_type) IS
2602:
2603: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2604: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2605: line_counter NUMBER;
2606: hdr_counter NUMBER;
2607: i NUMBER;

Line 2604: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;

2600: PROCEDURE GET_APPLICATIONS ( p_rcpt_tbl IN okl_rcpt_dtls_tbl_type
2601: ,x_appl_tbl OUT NOCOPY okl_appl_dtls_tbl_type) IS
2602:
2603: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2604: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2605: line_counter NUMBER;
2606: hdr_counter NUMBER;
2607: i NUMBER;
2608: j NUMBER;

Line 2922: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;

2918: l_return_status VARCHAR2(1);
2919: l_msg_count NUMBER;
2920: l_msg_data VARCHAR2(2000);
2921:
2922: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2923: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2924: line_counter NUMBER;
2925: hdr_counter NUMBER;
2926:

Line 2923: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;

2919: l_msg_count NUMBER;
2920: l_msg_data VARCHAR2(2000);
2921:
2922: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2923: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2924: line_counter NUMBER;
2925: hdr_counter NUMBER;
2926:
2927: ------------------------------