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 2613: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;

2609: --and its corresponding invoice lines with its applied amount
2610: PROCEDURE GET_APPLICATIONS ( p_rcpt_tbl IN okl_rcpt_dtls_tbl_type
2611: ,x_appl_tbl OUT NOCOPY okl_appl_dtls_tbl_type) IS
2612:
2613: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2614: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2615: line_counter NUMBER;
2616: hdr_counter NUMBER;
2617: i NUMBER;

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

2610: PROCEDURE GET_APPLICATIONS ( p_rcpt_tbl IN okl_rcpt_dtls_tbl_type
2611: ,x_appl_tbl OUT NOCOPY okl_appl_dtls_tbl_type) IS
2612:
2613: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2614: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2615: line_counter NUMBER;
2616: hdr_counter NUMBER;
2617: i NUMBER;
2618: j NUMBER;

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

2928: l_return_status VARCHAR2(1);
2929: l_msg_count NUMBER;
2930: l_msg_data VARCHAR2(2000);
2931:
2932: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2933: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2934: line_counter NUMBER;
2935: hdr_counter NUMBER;
2936:

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

2929: l_msg_count NUMBER;
2930: l_msg_data VARCHAR2(2000);
2931:
2932: l_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2933: l_prev_inv_num RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL;
2934: line_counter NUMBER;
2935: hdr_counter NUMBER;
2936:
2937: ------------------------------