22: --
23: -- Statement Lines
24: --
25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
23: -- Statement Lines
24: --
25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
24: --
25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
39: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
39: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
40: csl_create_misc_trx_flag CE_TRANSACTION_CODES.create_misc_trx_flag%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
39: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
40: csl_create_misc_trx_flag CE_TRANSACTION_CODES.create_misc_trx_flag%TYPE;
41: csl_matching_against CE_TRANSACTION_CODES.matching_against%TYPE;
42: csl_correction_method CE_TRANSACTION_CODES.correction_method%TYPE;
43: csl_reconcile_flag CE_TRANSACTION_CODES.reconcile_flag%TYPE;
44: csl_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
45: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
46: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
47: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
48: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
49: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
50: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
47: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
48: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
49: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
50: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
51: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
50: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
51: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
56: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
57: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
58: --
51: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
56: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
57: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
58: --
59: -- Passed as parameters
52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
56: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
57: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
58: --
59: -- Passed as parameters
60: --