7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
10: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
11: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
12: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
10: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
11: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
12: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
9: ,p_cons_bill_id IN OKL_CNSLD_AR_HDRS_V.ID%TYPE DEFAULT NULL
10: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
11: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
12: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
17: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
10: ,p_cons_bill_num IN OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE DEFAULT NULL
11: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
12: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
17: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
18: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
11: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL
12: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
17: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
18: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
19: ,p_contract_num IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL
12: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE DEFAULT NULL
13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
17: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
18: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
19: ,p_contract_num IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL
20: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE DEFAULT NULL
14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE DEFAULT NULL
15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE DEFAULT NULL
16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
17: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
18: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
19: ,p_contract_num IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL
20: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
21: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE DEFAULT NULL
17: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE DEFAULT NULL
18: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
19: ,p_contract_num IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL
20: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
21: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
22: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
23: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
24: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE
18: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
19: ,p_contract_num IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL
20: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
21: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
22: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
23: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
24: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE
25: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
26: ,p_create_receipt_flag IN VARCHAR2
19: ,p_contract_num IN OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE DEFAULT NULL
20: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
21: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
22: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
23: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
24: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE
25: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
26: ,p_create_receipt_flag IN VARCHAR2
27: ) IS
20: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE DEFAULT NULL
21: ,p_customer_num IN AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE DEFAULT NULL
22: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE DEFAULT NULL
23: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE DEFAULT NULL
24: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE
25: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
26: ,p_create_receipt_flag IN VARCHAR2
27: ) IS
28:
33: l_msg_data VARCHAR2(2000);
34:
35: lp_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
36: lp_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
37: lp_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
38: lp_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
34:
35: lp_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
36: lp_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
37: lp_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
38: lp_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
35: lp_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
36: lp_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
37: lp_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
38: lp_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
43: lp_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
36: lp_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
37: lp_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
38: lp_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
43: lp_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
44: lp_contract_id OKC_K_HEADERS_B.ID%TYPE;
37: lp_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
38: lp_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
43: lp_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
44: lp_contract_id OKC_K_HEADERS_B.ID%TYPE;
45: lp_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
38: lp_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
43: lp_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
44: lp_contract_id OKC_K_HEADERS_B.ID%TYPE;
45: lp_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
46: lp_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
43: lp_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
44: lp_contract_id OKC_K_HEADERS_B.ID%TYPE;
45: lp_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
46: lp_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
47: lp_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
43: lp_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
44: lp_contract_id OKC_K_HEADERS_B.ID%TYPE;
45: lp_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
46: lp_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
47: lp_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
48: lp_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
49: lp_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
50: lp_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
44: lp_contract_id OKC_K_HEADERS_B.ID%TYPE;
45: lp_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
46: lp_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
47: lp_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
48: lp_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
49: lp_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
50: lp_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
51: lp_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE;
52:
45: lp_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
46: lp_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
47: lp_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
48: lp_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
49: lp_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
50: lp_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
51: lp_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE;
52:
53: lx_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
46: lp_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
47: lp_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
48: lp_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
49: lp_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
50: lp_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
51: lp_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE;
52:
53: lx_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
54: lx_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
51: lp_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE;
52:
53: lx_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
54: lx_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
55: lx_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
56: lx_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
52:
53: lx_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
54: lx_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
55: lx_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
56: lx_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
53: lx_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;
54: lx_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
55: lx_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
56: lx_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
61: lx_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
54: lx_cons_bill_num OKL_CNSLD_AR_HDRS_V.CONSOLIDATED_INVOICE_NUMBER%TYPE;
55: lx_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
56: lx_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
61: lx_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
62: lx_contract_id OKC_K_HEADERS_B.ID%TYPE;
55: lx_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;
56: lx_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
61: lx_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
62: lx_contract_id OKC_K_HEADERS_B.ID%TYPE;
63: lx_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
56: lx_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%TYPE;
57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
61: lx_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
62: lx_contract_id OKC_K_HEADERS_B.ID%TYPE;
63: lx_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
64: lx_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%TYPE;
58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%TYPE;
59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_ID%TYPE;
60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
61: lx_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
62: lx_contract_id OKC_K_HEADERS_B.ID%TYPE;
63: lx_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
64: lx_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
65: lx_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_NUMBER%TYPE;
61: lx_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%TYPE;
62: lx_contract_id OKC_K_HEADERS_B.ID%TYPE;
63: lx_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
64: lx_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
65: lx_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
66: lx_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
67: lx_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
68: lx_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
62: lx_contract_id OKC_K_HEADERS_B.ID%TYPE;
63: lx_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
64: lx_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
65: lx_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
66: lx_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
67: lx_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
68: lx_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
69: lx_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE;
70:
63: lx_contract_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
64: lx_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
65: lx_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
66: lx_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
67: lx_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
68: lx_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
69: lx_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE;
70:
71: BEGIN
64: lx_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_id%TYPE;
65: lx_customer_num AR_CASH_RECEIPTS_ALL.PAY_FROM_CUSTOMER%TYPE;
66: lx_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%TYPE;
67: lx_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%TYPE;
68: lx_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE;
69: lx_comments AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE;
70:
71: BEGIN
72: