52: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
53: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
54:
55: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
56: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
57:
58: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
59: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
60: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
102: ------------------------------
103:
104: CURSOR c_get_receivables_trx_id (cp_set_of_books_id IN NUMBER) IS
105: SELECT RECEIVABLES_TRX_ID, NAME
106: FROM ar_receivables_trx_all
107: WHERE set_of_books_id = cp_set_of_books_id
108: AND name = 'OKL Adjustment';
109:
110:
366: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE DEFAULT NULL;
367: l_amount AR_ADJUSTMENTS.AMOUNT%TYPE;
368:
369: l_receivables_trx_id AR_ADJUSTMENTS.RECEIVABLES_TRX_ID%TYPE;
370: l_receivables_trx_name AR_RECEIVABLES_TRX_ALL.NAME%TYPE;
371:
372: l_code_combination_id AR_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE;
373: l_apply_date AR_ADJUSTMENTS.APPLY_DATE%TYPE;
374: l_gl_date AR_ADJUSTMENTS.GL_DATE%TYPE;
430: ------------------------------
431:
432: CURSOR c_get_receivables_trx_id (cp_set_of_books_id IN NUMBER) IS
433: SELECT RECEIVABLES_TRX_ID, NAME
434: FROM ar_receivables_trx_all
435: WHERE set_of_books_id = cp_set_of_books_id
436: AND name = 'OKL Adjustment';
437:
438: