eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CALC_LATE_CHARGE dependencies on DBMS_SQL

Line 1691: v_cursor := dbms_sql.open_cursor;

1687: IF l_debug_flag = 'Y' THEN
1688: debug(l_ins_statement);
1689: END IF;
1690:
1691: v_cursor := dbms_sql.open_cursor;
1692:
1693: dbms_sql.parse(v_cursor,l_ins_statement,DBMS_SQL.NATIVE);
1694:
1695: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);

Line 1693: dbms_sql.parse(v_cursor,l_ins_statement,DBMS_SQL.NATIVE);

1689: END IF;
1690:
1691: v_cursor := dbms_sql.open_cursor;
1692:
1693: dbms_sql.parse(v_cursor,l_ins_statement,DBMS_SQL.NATIVE);
1694:
1695: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);
1696: END IF;
1697:

Line 1695: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);

1691: v_cursor := dbms_sql.open_cursor;
1692:
1693: dbms_sql.parse(v_cursor,l_ins_statement,DBMS_SQL.NATIVE);
1694:
1695: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);
1696: END IF;
1697:
1698: IF l_customer_name_to IS NOT NULL THEN
1699: dbms_sql.bind_variable(v_cursor, ':l_customer_name_to', l_customer_name_to);

Line 1699: dbms_sql.bind_variable(v_cursor, ':l_customer_name_to', l_customer_name_to);

1695: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);
1696: END IF;
1697:
1698: IF l_customer_name_to IS NOT NULL THEN
1699: dbms_sql.bind_variable(v_cursor, ':l_customer_name_to', l_customer_name_to);
1700: END IF;
1701:
1702: IF l_customer_number_from IS NOT NULL THEN
1703: dbms_sql.bind_variable(v_cursor, ':l_customer_number_from', l_customer_number_from);

Line 1703: dbms_sql.bind_variable(v_cursor, ':l_customer_number_from', l_customer_number_from);

1699: dbms_sql.bind_variable(v_cursor, ':l_customer_name_to', l_customer_name_to);
1700: END IF;
1701:
1702: IF l_customer_number_from IS NOT NULL THEN
1703: dbms_sql.bind_variable(v_cursor, ':l_customer_number_from', l_customer_number_from);
1704: END IF;
1705:
1706: IF l_customer_number_to IS NOT NULL THEN
1707: dbms_sql.bind_variable(v_cursor, ':l_customer_number_to', l_customer_number_to);

Line 1707: dbms_sql.bind_variable(v_cursor, ':l_customer_number_to', l_customer_number_to);

1703: dbms_sql.bind_variable(v_cursor, ':l_customer_number_from', l_customer_number_from);
1704: END IF;
1705:
1706: IF l_customer_number_to IS NOT NULL THEN
1707: dbms_sql.bind_variable(v_cursor, ':l_customer_number_to', l_customer_number_to);
1708: END IF;
1709:
1710: dbms_sql.bind_variable(v_cursor, ':l_request_id', l_request_id);
1711:

Line 1710: dbms_sql.bind_variable(v_cursor, ':l_request_id', l_request_id);

1706: IF l_customer_number_to IS NOT NULL THEN
1707: dbms_sql.bind_variable(v_cursor, ':l_customer_number_to', l_customer_number_to);
1708: END IF;
1709:
1710: dbms_sql.bind_variable(v_cursor, ':l_request_id', l_request_id);
1711:
1712: IF l_currency_code IS NOT NULL THEN
1713: dbms_sql.bind_variable(v_cursor, ':l_currency_code', l_currency_code);
1714: END IF;

Line 1713: dbms_sql.bind_variable(v_cursor, ':l_currency_code', l_currency_code);

1709:
1710: dbms_sql.bind_variable(v_cursor, ':l_request_id', l_request_id);
1711:
1712: IF l_currency_code IS NOT NULL THEN
1713: dbms_sql.bind_variable(v_cursor, ':l_currency_code', l_currency_code);
1714: END IF;
1715:
1716: IF l_cust_site_use_id IS NOT NULL THEN
1717: dbms_sql.bind_variable(v_cursor, ':l_cust_site_use_id', l_cust_site_use_id);

Line 1717: dbms_sql.bind_variable(v_cursor, ':l_cust_site_use_id', l_cust_site_use_id);

1713: dbms_sql.bind_variable(v_cursor, ':l_currency_code', l_currency_code);
1714: END IF;
1715:
1716: IF l_cust_site_use_id IS NOT NULL THEN
1717: dbms_sql.bind_variable(v_cursor, ':l_cust_site_use_id', l_cust_site_use_id);
1718: END IF;
1719:
1720: dbms_sql.bind_variable(v_cursor, ':l_fin_charge_date',l_fin_charge_date);
1721:

Line 1720: dbms_sql.bind_variable(v_cursor, ':l_fin_charge_date',l_fin_charge_date);

1716: IF l_cust_site_use_id IS NOT NULL THEN
1717: dbms_sql.bind_variable(v_cursor, ':l_cust_site_use_id', l_cust_site_use_id);
1718: END IF;
1719:
1720: dbms_sql.bind_variable(v_cursor, ':l_fin_charge_date',l_fin_charge_date);
1721:
1722: IF l_org_id IS NOT NULL THEN
1723: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1724: END IF;

Line 1723: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);

1719:
1720: dbms_sql.bind_variable(v_cursor, ':l_fin_charge_date',l_fin_charge_date);
1721:
1722: IF l_org_id IS NOT NULL THEN
1723: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1724: END IF;
1725:
1726: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1727: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);

Line 1726: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);

1722: IF l_org_id IS NOT NULL THEN
1723: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1724: END IF;
1725:
1726: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1727: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1728: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1729:
1730: l_ignore := dbms_sql.execute(v_cursor);

Line 1727: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);

1723: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1724: END IF;
1725:
1726: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1727: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1728: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1729:
1730: l_ignore := dbms_sql.execute(v_cursor);
1731:

Line 1728: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);

1724: END IF;
1725:
1726: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1727: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1728: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1729:
1730: l_ignore := dbms_sql.execute(v_cursor);
1731:
1732: /*Late Charge Changes for charge per tier Enhacement 6469663*/

Line 1730: l_ignore := dbms_sql.execute(v_cursor);

1726: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1727: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1728: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1729:
1730: l_ignore := dbms_sql.execute(v_cursor);
1731:
1732: /*Late Charge Changes for charge per tier Enhacement 6469663*/
1733: l_first_rec := TRUE;
1734: FOR setup in wrong_setup(p_fin_charge_date)

Line 6422: interest_batch_id DBMS_SQL.NUMBER_TABLE,

6418: where request_id = l_request_id
6419: for update of transferred_status nowait;
6420:
6421: TYPE l_int_batch_rec_type IS RECORD(
6422: interest_batch_id DBMS_SQL.NUMBER_TABLE,
6423: batch_name DBMS_SQL.VARCHAR2_TABLE,
6424: transferred_status DBMS_SQL.VARCHAR2_TABLE);
6425:
6426: l_int_batch_tbl l_int_batch_rec_type;

Line 6423: batch_name DBMS_SQL.VARCHAR2_TABLE,

6419: for update of transferred_status nowait;
6420:
6421: TYPE l_int_batch_rec_type IS RECORD(
6422: interest_batch_id DBMS_SQL.NUMBER_TABLE,
6423: batch_name DBMS_SQL.VARCHAR2_TABLE,
6424: transferred_status DBMS_SQL.VARCHAR2_TABLE);
6425:
6426: l_int_batch_tbl l_int_batch_rec_type;
6427: l_bulk_fetch_rows number := 1000;

Line 6424: transferred_status DBMS_SQL.VARCHAR2_TABLE);

6420:
6421: TYPE l_int_batch_rec_type IS RECORD(
6422: interest_batch_id DBMS_SQL.NUMBER_TABLE,
6423: batch_name DBMS_SQL.VARCHAR2_TABLE,
6424: transferred_status DBMS_SQL.VARCHAR2_TABLE);
6425:
6426: l_int_batch_tbl l_int_batch_rec_type;
6427: l_bulk_fetch_rows number := 1000;
6428: l_last_fetch_rows boolean := FALSE;

Line 6501: org_id DBMS_SQL.NUMBER_TABLE,

6497: customer_site_use_id,
6498: currency_code;
6499:
6500: TYPE l_customer_sites_rec_type IS RECORD(
6501: org_id DBMS_SQL.NUMBER_TABLE,
6502: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
6503: customer_id DBMS_SQL.NUMBER_TABLE,
6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,

Line 6502: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,

6498: currency_code;
6499:
6500: TYPE l_customer_sites_rec_type IS RECORD(
6501: org_id DBMS_SQL.NUMBER_TABLE,
6502: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
6503: customer_id DBMS_SQL.NUMBER_TABLE,
6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,

Line 6503: customer_id DBMS_SQL.NUMBER_TABLE,

6499:
6500: TYPE l_customer_sites_rec_type IS RECORD(
6501: org_id DBMS_SQL.NUMBER_TABLE,
6502: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
6503: customer_id DBMS_SQL.NUMBER_TABLE,
6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

6500: TYPE l_customer_sites_rec_type IS RECORD(
6501: org_id DBMS_SQL.NUMBER_TABLE,
6502: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
6503: customer_id DBMS_SQL.NUMBER_TABLE,
6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6505: currency_code DBMS_SQL.VARCHAR2_TABLE,

6501: org_id DBMS_SQL.NUMBER_TABLE,
6502: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
6503: customer_id DBMS_SQL.NUMBER_TABLE,
6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,

Line 6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,

6502: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
6503: customer_id DBMS_SQL.NUMBER_TABLE,
6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

Line 6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,

6503: customer_id DBMS_SQL.NUMBER_TABLE,
6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

Line 6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,

6504: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,

Line 6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,

6505: currency_code DBMS_SQL.VARCHAR2_TABLE,
6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

Line 6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

6506: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

6507: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6512: interest_period_days DBMS_SQL.NUMBER_TABLE,

6508: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,

Line 6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

6509: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

6510: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,

Line 6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,

6511: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,

Line 6516: message_text_id DBMS_SQL.NUMBER_TABLE,

6512: interest_period_days DBMS_SQL.NUMBER_TABLE,
6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

Line 6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,

6513: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

Line 6518: charge_begin_date DBMS_SQL.DATE_TABLE,

6514: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

Line 6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,

6515: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,

Line 6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

6516: message_text_id DBMS_SQL.NUMBER_TABLE,
6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,

Line 6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

6517: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,

Line 6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

6518: charge_begin_date DBMS_SQL.DATE_TABLE,
6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,

Line 6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,

6519: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,

6520: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,

6521: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,

Line 6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,

6522: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,

Line 6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,

6523: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,

Line 6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,

6524: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,

Line 6529: interest_type DBMS_SQL.VARCHAR2_TABLE,

6525: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,

Line 6530: interest_Rate DBMS_SQL.NUMBER_TABLE,

6526: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,

Line 6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,

6527: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,
6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,

Line 6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,

6528: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,
6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6536: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,

Line 6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,

6529: interest_type DBMS_SQL.VARCHAR2_TABLE,
6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,
6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6536: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6537: last_accrue_charge_date DBMS_SQL.DATE_TABLE);

Line 6534: penalty_rate DBMS_SQL.NUMBER_TABLE,

6530: interest_Rate DBMS_SQL.NUMBER_TABLE,
6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,
6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6536: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6537: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6538:

Line 6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,

6531: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,
6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6536: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6537: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6538:
6539: l_lc_cust_sites_tbl l_customer_sites_rec_type;

Line 6536: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,

6532: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,
6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6536: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6537: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6538:
6539: l_lc_cust_sites_tbl l_customer_sites_rec_type;
6540: l_bulk_fetch_rows number := 1000;

Line 6537: last_accrue_charge_date DBMS_SQL.DATE_TABLE);

6533: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6534: penalty_rate DBMS_SQL.NUMBER_TABLE,
6535: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6536: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6537: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6538:
6539: l_lc_cust_sites_tbl l_customer_sites_rec_type;
6540: l_bulk_fetch_rows number := 1000;
6541: l_last_fetch_rows boolean := FALSE;

Line 6623: org_id DBMS_SQL.NUMBER_TABLE,

6619: customer_site_use_id,
6620: currency_code;
6621:
6622: TYPE l_cust_balance_type IS RECORD(
6623: org_id DBMS_SQL.NUMBER_TABLE,
6624: customer_id DBMS_SQL.NUMBER_TABLE,
6625: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6626: currency_code DBMS_SQL.VARCHAR2_TABLE,
6627: customer_open_balance DBMS_SQL.NUMBER_TABLE,

Line 6624: customer_id DBMS_SQL.NUMBER_TABLE,

6620: currency_code;
6621:
6622: TYPE l_cust_balance_type IS RECORD(
6623: org_id DBMS_SQL.NUMBER_TABLE,
6624: customer_id DBMS_SQL.NUMBER_TABLE,
6625: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6626: currency_code DBMS_SQL.VARCHAR2_TABLE,
6627: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6628: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);

Line 6625: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

6621:
6622: TYPE l_cust_balance_type IS RECORD(
6623: org_id DBMS_SQL.NUMBER_TABLE,
6624: customer_id DBMS_SQL.NUMBER_TABLE,
6625: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6626: currency_code DBMS_SQL.VARCHAR2_TABLE,
6627: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6628: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6629:

Line 6626: currency_code DBMS_SQL.VARCHAR2_TABLE,

6622: TYPE l_cust_balance_type IS RECORD(
6623: org_id DBMS_SQL.NUMBER_TABLE,
6624: customer_id DBMS_SQL.NUMBER_TABLE,
6625: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6626: currency_code DBMS_SQL.VARCHAR2_TABLE,
6627: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6628: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6629:
6630: l_cust_balance_tbl l_cust_balance_type;

Line 6627: customer_open_balance DBMS_SQL.NUMBER_TABLE,

6623: org_id DBMS_SQL.NUMBER_TABLE,
6624: customer_id DBMS_SQL.NUMBER_TABLE,
6625: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6626: currency_code DBMS_SQL.VARCHAR2_TABLE,
6627: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6628: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6629:
6630: l_cust_balance_tbl l_cust_balance_type;
6631: l_bulk_fetch_rows number := 1000;

Line 6628: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);

6624: customer_id DBMS_SQL.NUMBER_TABLE,
6625: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6626: currency_code DBMS_SQL.VARCHAR2_TABLE,
6627: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6628: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6629:
6630: l_cust_balance_tbl l_cust_balance_type;
6631: l_bulk_fetch_rows number := 1000;
6632: l_last_fetch_rows boolean := FALSE;

Line 6685: customer_id DBMS_SQL.NUMBER_TABLE,

6681: currency_code,
6682: legal_entity_id;
6683:
6684: TYPE l_cust_credits_rec_type IS RECORD(
6685: customer_id DBMS_SQL.NUMBER_TABLE,
6686: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6687: currency_code DBMS_SQL.VARCHAR2_TABLE,
6688: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6689: credit_amount DBMS_SQL.NUMBER_TABLE);

Line 6686: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

6682: legal_entity_id;
6683:
6684: TYPE l_cust_credits_rec_type IS RECORD(
6685: customer_id DBMS_SQL.NUMBER_TABLE,
6686: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6687: currency_code DBMS_SQL.VARCHAR2_TABLE,
6688: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6689: credit_amount DBMS_SQL.NUMBER_TABLE);
6690:

Line 6687: currency_code DBMS_SQL.VARCHAR2_TABLE,

6683:
6684: TYPE l_cust_credits_rec_type IS RECORD(
6685: customer_id DBMS_SQL.NUMBER_TABLE,
6686: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6687: currency_code DBMS_SQL.VARCHAR2_TABLE,
6688: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6689: credit_amount DBMS_SQL.NUMBER_TABLE);
6690:
6691: l_cust_credits_tbl l_cust_credits_rec_type;

Line 6688: legal_entity_id DBMS_SQL.NUMBER_TABLE,

6684: TYPE l_cust_credits_rec_type IS RECORD(
6685: customer_id DBMS_SQL.NUMBER_TABLE,
6686: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6687: currency_code DBMS_SQL.VARCHAR2_TABLE,
6688: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6689: credit_amount DBMS_SQL.NUMBER_TABLE);
6690:
6691: l_cust_credits_tbl l_cust_credits_rec_type;
6692: l_bulk_fetch_rows number := 1000;

Line 6689: credit_amount DBMS_SQL.NUMBER_TABLE);

6685: customer_id DBMS_SQL.NUMBER_TABLE,
6686: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6687: currency_code DBMS_SQL.VARCHAR2_TABLE,
6688: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6689: credit_amount DBMS_SQL.NUMBER_TABLE);
6690:
6691: l_cust_credits_tbl l_cust_credits_rec_type;
6692: l_bulk_fetch_rows number := 1000;
6693: l_last_fetch_rows boolean := FALSE;

Line 6785: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,

6781: rate_start_date,
6782: charge_line_type;
6783:
6784: TYPE l_payment_schedules_rec_type IS RECORD(
6785: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6786: customer_id DBMS_SQL.NUMBER_TABLE,
6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,

Line 6786: customer_id DBMS_SQL.NUMBER_TABLE,

6782: charge_line_type;
6783:
6784: TYPE l_payment_schedules_rec_type IS RECORD(
6785: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6786: customer_id DBMS_SQL.NUMBER_TABLE,
6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,

Line 6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

6783:
6784: TYPE l_payment_schedules_rec_type IS RECORD(
6785: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6786: customer_id DBMS_SQL.NUMBER_TABLE,
6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,

Line 6788: currency_code DBMS_SQL.VARCHAR2_TABLE,

6784: TYPE l_payment_schedules_rec_type IS RECORD(
6785: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6786: customer_id DBMS_SQL.NUMBER_TABLE,
6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,

Line 6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,

6785: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6786: customer_id DBMS_SQL.NUMBER_TABLE,
6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,

Line 6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,

6786: customer_id DBMS_SQL.NUMBER_TABLE,
6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,

Line 6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,

6787: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,

Line 6792: class DBMS_SQL.VARCHAR2_TABLE,

6788: currency_code DBMS_SQL.VARCHAR2_TABLE,
6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,

Line 6793: amount_due_original DBMS_SQL.NUMBER_TABLE,

6789: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,

Line 6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,

6790: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,

Line 6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,

6791: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

Line 6796: trx_date DBMS_SQL.DATE_TABLE,

6792: class DBMS_SQL.VARCHAR2_TABLE,
6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,

6793: amount_due_original DBMS_SQL.NUMBER_TABLE,
6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6798: last_charge_date DBMS_SQL.DATE_TABLE,

6794: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,

Line 6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

6795: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,

Line 6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,

6796: trx_date DBMS_SQL.DATE_TABLE,
6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,

Line 6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,

6797: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,

Line 6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,

6798: last_charge_date DBMS_SQL.DATE_TABLE,
6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,

Line 6803: original_balance DBMS_SQL.NUMBER_TABLE,

6799: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,

Line 6804: due_date DBMS_SQL.DATE_TABLE,

6800: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,

Line 6805: receipt_date DBMS_SQL.DATE_TABLE,

6801: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,

Line 6806: finance_charge_date DBMS_SQL.DATE_TABLE,

6802: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,

Line 6807: charge_type DBMS_SQL.VARCHAR2_TABLE,

6803: original_balance DBMS_SQL.NUMBER_TABLE,
6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,

Line 6808: actual_date_closed DBMS_SQL.DATE_TABLE,

6804: due_date DBMS_SQL.DATE_TABLE,
6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,

Line 6809: interest_rate DBMS_SQL.NUMBER_TABLE,

6805: receipt_date DBMS_SQL.DATE_TABLE,
6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,

Line 6810: interest_days DBMS_SQL.NUMBER_TABLE,

6806: finance_charge_date DBMS_SQL.DATE_TABLE,
6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,

Line 6811: rate_start_date DBMS_SQL.DATE_TABLE,

6807: charge_type DBMS_SQL.VARCHAR2_TABLE,
6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,

Line 6812: rate_end_date DBMS_SQL.DATE_TABLE,

6808: actual_date_closed DBMS_SQL.DATE_TABLE,
6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

Line 6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,

6809: interest_rate DBMS_SQL.NUMBER_TABLE,
6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

Line 6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,

6810: interest_days DBMS_SQL.NUMBER_TABLE,
6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,

Line 6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,

6811: rate_start_date DBMS_SQL.DATE_TABLE,
6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

Line 6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

6812: rate_end_date DBMS_SQL.DATE_TABLE,
6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

6813: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,

Line 6818: interest_period_days DBMS_SQL.NUMBER_TABLE,

6814: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,

Line 6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

6815: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

Line 6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

6816: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

Line 6821: message_text_id DBMS_SQL.NUMBER_TABLE,

6817: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6825: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,

Line 6822: interest_type DBMS_SQL.VARCHAR2_TABLE,

6818: interest_period_days DBMS_SQL.NUMBER_TABLE,
6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6825: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6826: charge_line_type DBMS_SQL.VARCHAR2_TABLE);

Line 6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

6819: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6825: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6826: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6827:

Line 6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

6820: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6825: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6826: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6827:
6828: l_payment_schedules_tbl l_payment_schedules_rec_type;

Line 6825: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,

6821: message_text_id DBMS_SQL.NUMBER_TABLE,
6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6825: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6826: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6827:
6828: l_payment_schedules_tbl l_payment_schedules_rec_type;
6829: l_bulk_fetch_rows number := 1000;

Line 6826: charge_line_type DBMS_SQL.VARCHAR2_TABLE);

6822: interest_type DBMS_SQL.VARCHAR2_TABLE,
6823: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6824: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6825: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6826: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6827:
6828: l_payment_schedules_tbl l_payment_schedules_rec_type;
6829: l_bulk_fetch_rows number := 1000;
6830: l_last_fetch_rows boolean := FALSE;