DBA Data[Home] [Help]

APPS.OKL_CASH_APPL_RULES_PUB dependencies on OKL_TRX_CSH_RECEIPT_V

Line 11: ,p_currency_code IN OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE DEFAULT NULL

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

Line 12: ,p_currency_conv_type IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%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

Line 13: ,p_currency_conv_date IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%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

Line 14: ,p_currency_conv_rate IN OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%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

Line 15: ,p_irm_id IN OKL_TRX_CSH_RECEIPT_V.IRM_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

Line 16: ,p_check_number IN OKL_TRX_CSH_RECEIPT_V.CHECK_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

Line 17: ,p_rcpt_amount IN OKL_TRX_CSH_RECEIPT_V.AMOUNT%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

Line 20: ,p_customer_id IN OKL_TRX_CSH_RECEIPT_V.ILE_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
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

Line 22: ,p_gl_date IN OKL_TRX_CSH_RECEIPT_V.GL_DATE%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
25: ,p_comments IN AR_CASH_RECEIPTS_ALL.COMMENTS%TYPE DEFAULT NULL
26: ,p_create_receipt_flag IN VARCHAR2

Line 23: ,p_receipt_date IN OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%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
27: ) IS

Line 24: ,p_bank_account_id IN OKL_TRX_CSH_RECEIPT_V.IBA_ID%TYPE

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:

Line 37: lp_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%TYPE;

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;

Line 38: lp_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%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;

Line 39: lp_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%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;

Line 40: lp_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%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;

Line 41: lp_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_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;

Line 42: lp_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_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;

Line 43: lp_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%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;

Line 46: lp_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_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;
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;

Line 48: lp_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%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:

Line 49: lp_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%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:
53: lx_cons_bill_id OKL_CNSLD_AR_HDRS_V.ID%TYPE;

Line 50: lp_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_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;

Line 55: lx_currency_code OKL_TRX_CSH_RECEIPT_V.CURRENCY_CODE%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;

Line 56: lx_currency_conv_type OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_TYPE%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;

Line 57: lx_currency_conv_date OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE_DATE%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;

Line 58: lx_currency_conv_rate OKL_TRX_CSH_RECEIPT_V.EXCHANGE_RATE%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;

Line 59: lx_irm_id OKL_TRX_CSH_RECEIPT_V.IRM_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;

Line 60: lx_check_number OKL_TRX_CSH_RECEIPT_V.CHECK_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;

Line 61: lx_rcpt_amount OKL_TRX_CSH_RECEIPT_V.AMOUNT%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;

Line 64: lx_customer_id OKL_TRX_CSH_RECEIPT_V.ILE_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;
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;

Line 66: lx_gl_date OKL_TRX_CSH_RECEIPT_V.GL_DATE%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:

Line 67: lx_receipt_date OKL_TRX_CSH_RECEIPT_V.DATE_EFFECTIVE%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:
71: BEGIN

Line 68: lx_bank_account_id OKL_TRX_CSH_RECEIPT_V.IBA_ID%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
72: