28: ,invoice_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL
29: ,invoice_currency_code VARCHAR2(30)
30: ,invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE DEFAULT NULL
31: ,invoice_line_number RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER%TYPE DEFAULT NULL
32: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
33: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL
34: ,trans_to_receipt_rate NUMBER
35: );
36:
29: ,invoice_currency_code VARCHAR2(30)
30: ,invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE DEFAULT NULL
31: ,invoice_line_number RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER%TYPE DEFAULT NULL
32: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
33: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL
34: ,trans_to_receipt_rate NUMBER
35: );
36:
37: TYPE okl_rcpt_dtls_tbl_type IS TABLE OF okl_rcpt_dtls_rec_type
39:
40: TYPE okl_inv_hdr_rec_type IS RECORD ( invoice_id NUMBER DEFAULT NULL
41: ,invoice_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL
42: ,invoice_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
43: ,freight_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
44: ,charges_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
45: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
46: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
47: ,gl_date DATE DEFAULT NULL
40: TYPE okl_inv_hdr_rec_type IS RECORD ( invoice_id NUMBER DEFAULT NULL
41: ,invoice_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL
42: ,invoice_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
43: ,freight_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
44: ,charges_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
45: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
46: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
47: ,gl_date DATE DEFAULT NULL
48: ,trans_to_receipt_rate NUMBER
41: ,invoice_number RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE DEFAULT NULL
42: ,invoice_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
43: ,freight_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
44: ,charges_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
45: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
46: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
47: ,gl_date DATE DEFAULT NULL
48: ,trans_to_receipt_rate NUMBER
49: );
42: ,invoice_currency_code AR_CASH_RECEIPTS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
43: ,freight_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
44: ,charges_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
45: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
46: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
47: ,gl_date DATE DEFAULT NULL
48: ,trans_to_receipt_rate NUMBER
49: );
50:
49: );
50:
51: TYPE okl_inv_line_rec_type IS RECORD ( invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE DEFAULT NULL
52: ,invoice_line_number RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER%TYPE DEFAULT NULL
53: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
54: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL
55: ,original_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
56: ,line_applied AR_RECEIVABLE_APPLICATIONS_ALL.LINE_APPLIED%TYPE DEFAULT NULL
57: ,tax_applied AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE DEFAULT NULL
50:
51: TYPE okl_inv_line_rec_type IS RECORD ( invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE DEFAULT NULL
52: ,invoice_line_number RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER%TYPE DEFAULT NULL
53: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
54: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL
55: ,original_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
56: ,line_applied AR_RECEIVABLE_APPLICATIONS_ALL.LINE_APPLIED%TYPE DEFAULT NULL
57: ,tax_applied AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE DEFAULT NULL
58: ,trans_to_receipt_rate NUMBER
51: TYPE okl_inv_line_rec_type IS RECORD ( invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.customer_trx_line_id%TYPE DEFAULT NULL
52: ,invoice_line_number RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER%TYPE DEFAULT NULL
53: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
54: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL
55: ,original_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
56: ,line_applied AR_RECEIVABLE_APPLICATIONS_ALL.LINE_APPLIED%TYPE DEFAULT NULL
57: ,tax_applied AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE DEFAULT NULL
58: ,trans_to_receipt_rate NUMBER
59: );
52: ,invoice_line_number RA_CUSTOMER_TRX_LINES_ALL.LINE_NUMBER%TYPE DEFAULT NULL
53: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
54: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL
55: ,original_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
56: ,line_applied AR_RECEIVABLE_APPLICATIONS_ALL.LINE_APPLIED%TYPE DEFAULT NULL
57: ,tax_applied AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE DEFAULT NULL
58: ,trans_to_receipt_rate NUMBER
59: );
60: TYPE okl_inv_line_tbl_type IS TABLE OF okl_inv_line_rec_type
53: ,amount_applied AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
54: ,amount_applied_from AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED_FROM%TYPE DEFAULT NULL
55: ,original_applied_amount AR_RECEIVABLE_APPLICATIONS_ALL.AMOUNT_APPLIED%TYPE DEFAULT NULL
56: ,line_applied AR_RECEIVABLE_APPLICATIONS_ALL.LINE_APPLIED%TYPE DEFAULT NULL
57: ,tax_applied AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE DEFAULT NULL
58: ,trans_to_receipt_rate NUMBER
59: );
60: TYPE okl_inv_line_tbl_type IS TABLE OF okl_inv_line_rec_type
61: INDEX BY BINARY_INTEGER;