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 1300: v_cursor := dbms_sql.open_cursor;

1296: IF l_debug_flag = 'Y' THEN
1297: debug(l_ins_statement);
1298: END IF;
1299:
1300: v_cursor := dbms_sql.open_cursor;
1301:
1302: dbms_sql.parse(v_cursor,l_ins_statement,DBMS_SQL.NATIVE);
1303:
1304: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);

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

1298: END IF;
1299:
1300: v_cursor := dbms_sql.open_cursor;
1301:
1302: dbms_sql.parse(v_cursor,l_ins_statement,DBMS_SQL.NATIVE);
1303:
1304: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);
1305: END IF;
1306:

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

1300: v_cursor := dbms_sql.open_cursor;
1301:
1302: dbms_sql.parse(v_cursor,l_ins_statement,DBMS_SQL.NATIVE);
1303:
1304: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);
1305: END IF;
1306:
1307: IF l_customer_name_to IS NOT NULL THEN
1308: dbms_sql.bind_variable(v_cursor, ':l_customer_name_to', l_customer_name_to);

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

1304: IF l_customer_name_from IS NOT NULL THEN dbms_sql.bind_variable(v_cursor, ':l_customer_name_from', l_customer_name_from);
1305: END IF;
1306:
1307: IF l_customer_name_to IS NOT NULL THEN
1308: dbms_sql.bind_variable(v_cursor, ':l_customer_name_to', l_customer_name_to);
1309: END IF;
1310:
1311: IF l_customer_number_from IS NOT NULL THEN
1312: dbms_sql.bind_variable(v_cursor, ':l_customer_number_from', l_customer_number_from);

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

1308: dbms_sql.bind_variable(v_cursor, ':l_customer_name_to', l_customer_name_to);
1309: END IF;
1310:
1311: IF l_customer_number_from IS NOT NULL THEN
1312: dbms_sql.bind_variable(v_cursor, ':l_customer_number_from', l_customer_number_from);
1313: END IF;
1314:
1315: IF l_customer_number_to IS NOT NULL THEN
1316: dbms_sql.bind_variable(v_cursor, ':l_customer_number_to', l_customer_number_to);

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

1312: dbms_sql.bind_variable(v_cursor, ':l_customer_number_from', l_customer_number_from);
1313: END IF;
1314:
1315: IF l_customer_number_to IS NOT NULL THEN
1316: dbms_sql.bind_variable(v_cursor, ':l_customer_number_to', l_customer_number_to);
1317: END IF;
1318:
1319: dbms_sql.bind_variable(v_cursor, ':l_request_id', l_request_id);
1320:

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

1315: IF l_customer_number_to IS NOT NULL THEN
1316: dbms_sql.bind_variable(v_cursor, ':l_customer_number_to', l_customer_number_to);
1317: END IF;
1318:
1319: dbms_sql.bind_variable(v_cursor, ':l_request_id', l_request_id);
1320:
1321: IF l_currency_code IS NOT NULL THEN
1322: dbms_sql.bind_variable(v_cursor, ':l_currency_code', l_currency_code);
1323: END IF;

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

1318:
1319: dbms_sql.bind_variable(v_cursor, ':l_request_id', l_request_id);
1320:
1321: IF l_currency_code IS NOT NULL THEN
1322: dbms_sql.bind_variable(v_cursor, ':l_currency_code', l_currency_code);
1323: END IF;
1324:
1325: IF l_cust_site_use_id IS NOT NULL THEN
1326: dbms_sql.bind_variable(v_cursor, ':l_cust_site_use_id', l_cust_site_use_id);

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

1322: dbms_sql.bind_variable(v_cursor, ':l_currency_code', l_currency_code);
1323: END IF;
1324:
1325: IF l_cust_site_use_id IS NOT NULL THEN
1326: dbms_sql.bind_variable(v_cursor, ':l_cust_site_use_id', l_cust_site_use_id);
1327: END IF;
1328:
1329: dbms_sql.bind_variable(v_cursor, ':l_fin_charge_date',l_fin_charge_date);
1330:

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

1325: IF l_cust_site_use_id IS NOT NULL THEN
1326: dbms_sql.bind_variable(v_cursor, ':l_cust_site_use_id', l_cust_site_use_id);
1327: END IF;
1328:
1329: dbms_sql.bind_variable(v_cursor, ':l_fin_charge_date',l_fin_charge_date);
1330:
1331: IF l_org_id IS NOT NULL THEN
1332: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1333: END IF;

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

1328:
1329: dbms_sql.bind_variable(v_cursor, ':l_fin_charge_date',l_fin_charge_date);
1330:
1331: IF l_org_id IS NOT NULL THEN
1332: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1333: END IF;
1334:
1335: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1336: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);

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

1331: IF l_org_id IS NOT NULL THEN
1332: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1333: END IF;
1334:
1335: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1336: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1337: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1338:
1339: l_ignore := dbms_sql.execute(v_cursor);

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

1332: dbms_sql.bind_variable(v_cursor, ':l_org_id', l_org_id);
1333: END IF;
1334:
1335: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1336: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1337: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1338:
1339: l_ignore := dbms_sql.execute(v_cursor);
1340:

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

1333: END IF;
1334:
1335: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1336: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1337: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1338:
1339: l_ignore := dbms_sql.execute(v_cursor);
1340:
1341: /*Late Charge Changes for charge per tier Enhacement 6469663*/

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

1335: dbms_sql.bind_variable(v_cursor, ':l_use_late_charge_site',l_use_late_charge_site);
1336: dbms_sql.bind_variable(v_cursor, ':l_worker_number',l_worker_number);
1337: dbms_sql.bind_variable(v_cursor, ':l_total_workers', l_total_workers);
1338:
1339: l_ignore := dbms_sql.execute(v_cursor);
1340:
1341: /*Late Charge Changes for charge per tier Enhacement 6469663*/
1342: l_first_rec := TRUE;
1343: FOR setup in wrong_setup(p_fin_charge_date)

Line 5916: interest_batch_id DBMS_SQL.NUMBER_TABLE,

5912: where request_id = l_request_id
5913: for update of transferred_status nowait;
5914:
5915: TYPE l_int_batch_rec_type IS RECORD(
5916: interest_batch_id DBMS_SQL.NUMBER_TABLE,
5917: batch_name DBMS_SQL.VARCHAR2_TABLE,
5918: transferred_status DBMS_SQL.VARCHAR2_TABLE);
5919:
5920: l_int_batch_tbl l_int_batch_rec_type;

Line 5917: batch_name DBMS_SQL.VARCHAR2_TABLE,

5913: for update of transferred_status nowait;
5914:
5915: TYPE l_int_batch_rec_type IS RECORD(
5916: interest_batch_id DBMS_SQL.NUMBER_TABLE,
5917: batch_name DBMS_SQL.VARCHAR2_TABLE,
5918: transferred_status DBMS_SQL.VARCHAR2_TABLE);
5919:
5920: l_int_batch_tbl l_int_batch_rec_type;
5921: l_bulk_fetch_rows number := 1000;

Line 5918: transferred_status DBMS_SQL.VARCHAR2_TABLE);

5914:
5915: TYPE l_int_batch_rec_type IS RECORD(
5916: interest_batch_id DBMS_SQL.NUMBER_TABLE,
5917: batch_name DBMS_SQL.VARCHAR2_TABLE,
5918: transferred_status DBMS_SQL.VARCHAR2_TABLE);
5919:
5920: l_int_batch_tbl l_int_batch_rec_type;
5921: l_bulk_fetch_rows number := 1000;
5922: l_last_fetch_rows boolean := FALSE;

Line 5995: org_id DBMS_SQL.NUMBER_TABLE,

5991: customer_site_use_id,
5992: currency_code;
5993:
5994: TYPE l_customer_sites_rec_type IS RECORD(
5995: org_id DBMS_SQL.NUMBER_TABLE,
5996: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
5997: customer_id DBMS_SQL.NUMBER_TABLE,
5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,

Line 5996: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,

5992: currency_code;
5993:
5994: TYPE l_customer_sites_rec_type IS RECORD(
5995: org_id DBMS_SQL.NUMBER_TABLE,
5996: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
5997: customer_id DBMS_SQL.NUMBER_TABLE,
5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,

Line 5997: customer_id DBMS_SQL.NUMBER_TABLE,

5993:
5994: TYPE l_customer_sites_rec_type IS RECORD(
5995: org_id DBMS_SQL.NUMBER_TABLE,
5996: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
5997: customer_id DBMS_SQL.NUMBER_TABLE,
5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,

Line 5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

5994: TYPE l_customer_sites_rec_type IS RECORD(
5995: org_id DBMS_SQL.NUMBER_TABLE,
5996: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
5997: customer_id DBMS_SQL.NUMBER_TABLE,
5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,

Line 5999: currency_code DBMS_SQL.VARCHAR2_TABLE,

5995: org_id DBMS_SQL.NUMBER_TABLE,
5996: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
5997: customer_id DBMS_SQL.NUMBER_TABLE,
5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,

Line 6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,

5996: lc_cust_sites_id DBMS_SQL.NUMBER_TABLE,
5997: customer_id DBMS_SQL.NUMBER_TABLE,
5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

Line 6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,

5997: customer_id DBMS_SQL.NUMBER_TABLE,
5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

Line 6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,

5998: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,

Line 6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,

5999: currency_code DBMS_SQL.VARCHAR2_TABLE,
6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

Line 6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

6000: late_charge_calculation_trx DBMS_SQL.VARCHAR2_TABLE,
6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

6001: credit_items_flag DBMS_SQL.VARCHAR2_TABLE,
6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6006: interest_period_days DBMS_SQL.NUMBER_TABLE,

6002: disputed_transactions_flag DBMS_SQL.VARCHAR2_TABLE,
6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,

Line 6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

6003: payment_grace_days DBMS_SQL.NUMBER_TABLE,
6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

6004: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,

Line 6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,

6005: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,

Line 6010: message_text_id DBMS_SQL.NUMBER_TABLE,

6006: interest_period_days DBMS_SQL.NUMBER_TABLE,
6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

Line 6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,

6007: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

Line 6012: charge_begin_date DBMS_SQL.DATE_TABLE,

6008: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

Line 6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,

6009: hold_charged_invoices_flag DBMS_SQL.VARCHAR2_TABLE,
6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,

Line 6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

6010: message_text_id DBMS_SQL.NUMBER_TABLE,
6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,

Line 6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

6011: multiple_interest_rates_flag DBMS_SQL.VARCHAR2_TABLE,
6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,

Line 6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

6012: charge_begin_date DBMS_SQL.DATE_TABLE,
6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,

Line 6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,

6013: cust_acct_profile_amt_id DBMS_SQL.NUMBER_TABLE,
6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,

6014: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,

6015: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,

Line 6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,

6016: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,

Line 6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,

6017: min_fc_invoice_percent DBMS_SQL.NUMBER_TABLE,
6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,

Line 6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,

6018: min_fc_balance_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,

Line 6023: interest_type DBMS_SQL.VARCHAR2_TABLE,

6019: min_fc_balance_amount DBMS_SQL.NUMBER_TABLE,
6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,

Line 6024: interest_Rate DBMS_SQL.NUMBER_TABLE,

6020: min_fc_balance_percent DBMS_SQL.NUMBER_TABLE,
6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,

Line 6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,

6021: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,
6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,

Line 6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,

6022: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,
6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6030: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,

Line 6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,

6023: interest_type DBMS_SQL.VARCHAR2_TABLE,
6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,
6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6030: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6031: last_accrue_charge_date DBMS_SQL.DATE_TABLE);

Line 6028: penalty_rate DBMS_SQL.NUMBER_TABLE,

6024: interest_Rate DBMS_SQL.NUMBER_TABLE,
6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,
6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6030: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6031: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6032:

Line 6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,

6025: interest_fixed_amount DBMS_SQL.NUMBER_TABLE,
6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,
6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6030: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6031: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6032:
6033: l_lc_cust_sites_tbl l_customer_sites_rec_type;

Line 6030: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,

6026: interest_schedule_id DBMS_SQL.NUMBER_TABLE,
6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,
6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6030: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6031: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6032:
6033: l_lc_cust_sites_tbl l_customer_sites_rec_type;
6034: l_bulk_fetch_rows number := 1000;

Line 6031: last_accrue_charge_date DBMS_SQL.DATE_TABLE);

6027: penalty_type DBMS_SQL.VARCHAR2_TABLE,
6028: penalty_rate DBMS_SQL.NUMBER_TABLE,
6029: penalty_fixed_amount DBMS_SQL.NUMBER_TABLE,
6030: penalty_schedule_id DBMS_SQL.NUMBER_TABLE,
6031: last_accrue_charge_date DBMS_SQL.DATE_TABLE);
6032:
6033: l_lc_cust_sites_tbl l_customer_sites_rec_type;
6034: l_bulk_fetch_rows number := 1000;
6035: l_last_fetch_rows boolean := FALSE;

Line 6117: org_id DBMS_SQL.NUMBER_TABLE,

6113: customer_site_use_id,
6114: currency_code;
6115:
6116: TYPE l_cust_balance_type IS RECORD(
6117: org_id DBMS_SQL.NUMBER_TABLE,
6118: customer_id DBMS_SQL.NUMBER_TABLE,
6119: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6120: currency_code DBMS_SQL.VARCHAR2_TABLE,
6121: customer_open_balance DBMS_SQL.NUMBER_TABLE,

Line 6118: customer_id DBMS_SQL.NUMBER_TABLE,

6114: currency_code;
6115:
6116: TYPE l_cust_balance_type IS RECORD(
6117: org_id DBMS_SQL.NUMBER_TABLE,
6118: customer_id DBMS_SQL.NUMBER_TABLE,
6119: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6120: currency_code DBMS_SQL.VARCHAR2_TABLE,
6121: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6122: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);

Line 6119: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

6115:
6116: TYPE l_cust_balance_type IS RECORD(
6117: org_id DBMS_SQL.NUMBER_TABLE,
6118: customer_id DBMS_SQL.NUMBER_TABLE,
6119: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6120: currency_code DBMS_SQL.VARCHAR2_TABLE,
6121: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6122: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6123:

Line 6120: currency_code DBMS_SQL.VARCHAR2_TABLE,

6116: TYPE l_cust_balance_type IS RECORD(
6117: org_id DBMS_SQL.NUMBER_TABLE,
6118: customer_id DBMS_SQL.NUMBER_TABLE,
6119: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6120: currency_code DBMS_SQL.VARCHAR2_TABLE,
6121: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6122: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6123:
6124: l_cust_balance_tbl l_cust_balance_type;

Line 6121: customer_open_balance DBMS_SQL.NUMBER_TABLE,

6117: org_id DBMS_SQL.NUMBER_TABLE,
6118: customer_id DBMS_SQL.NUMBER_TABLE,
6119: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6120: currency_code DBMS_SQL.VARCHAR2_TABLE,
6121: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6122: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6123:
6124: l_cust_balance_tbl l_cust_balance_type;
6125: l_bulk_fetch_rows number := 1000;

Line 6122: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);

6118: customer_id DBMS_SQL.NUMBER_TABLE,
6119: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6120: currency_code DBMS_SQL.VARCHAR2_TABLE,
6121: customer_open_balance DBMS_SQL.NUMBER_TABLE,
6122: customer_overdue_balance DBMS_SQL.NUMBER_TABLE);
6123:
6124: l_cust_balance_tbl l_cust_balance_type;
6125: l_bulk_fetch_rows number := 1000;
6126: l_last_fetch_rows boolean := FALSE;

Line 6179: customer_id DBMS_SQL.NUMBER_TABLE,

6175: currency_code,
6176: legal_entity_id;
6177:
6178: TYPE l_cust_credits_rec_type IS RECORD(
6179: customer_id DBMS_SQL.NUMBER_TABLE,
6180: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6181: currency_code DBMS_SQL.VARCHAR2_TABLE,
6182: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6183: credit_amount DBMS_SQL.NUMBER_TABLE);

Line 6180: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

6176: legal_entity_id;
6177:
6178: TYPE l_cust_credits_rec_type IS RECORD(
6179: customer_id DBMS_SQL.NUMBER_TABLE,
6180: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6181: currency_code DBMS_SQL.VARCHAR2_TABLE,
6182: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6183: credit_amount DBMS_SQL.NUMBER_TABLE);
6184:

Line 6181: currency_code DBMS_SQL.VARCHAR2_TABLE,

6177:
6178: TYPE l_cust_credits_rec_type IS RECORD(
6179: customer_id DBMS_SQL.NUMBER_TABLE,
6180: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6181: currency_code DBMS_SQL.VARCHAR2_TABLE,
6182: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6183: credit_amount DBMS_SQL.NUMBER_TABLE);
6184:
6185: l_cust_credits_tbl l_cust_credits_rec_type;

Line 6182: legal_entity_id DBMS_SQL.NUMBER_TABLE,

6178: TYPE l_cust_credits_rec_type IS RECORD(
6179: customer_id DBMS_SQL.NUMBER_TABLE,
6180: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6181: currency_code DBMS_SQL.VARCHAR2_TABLE,
6182: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6183: credit_amount DBMS_SQL.NUMBER_TABLE);
6184:
6185: l_cust_credits_tbl l_cust_credits_rec_type;
6186: l_bulk_fetch_rows number := 1000;

Line 6183: credit_amount DBMS_SQL.NUMBER_TABLE);

6179: customer_id DBMS_SQL.NUMBER_TABLE,
6180: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6181: currency_code DBMS_SQL.VARCHAR2_TABLE,
6182: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6183: credit_amount DBMS_SQL.NUMBER_TABLE);
6184:
6185: l_cust_credits_tbl l_cust_credits_rec_type;
6186: l_bulk_fetch_rows number := 1000;
6187: l_last_fetch_rows boolean := FALSE;

Line 6279: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,

6275: rate_start_date,
6276: charge_line_type;
6277:
6278: TYPE l_payment_schedules_rec_type IS RECORD(
6279: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6280: customer_id DBMS_SQL.NUMBER_TABLE,
6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,

Line 6280: customer_id DBMS_SQL.NUMBER_TABLE,

6276: charge_line_type;
6277:
6278: TYPE l_payment_schedules_rec_type IS RECORD(
6279: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6280: customer_id DBMS_SQL.NUMBER_TABLE,
6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,

Line 6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,

6277:
6278: TYPE l_payment_schedules_rec_type IS RECORD(
6279: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6280: customer_id DBMS_SQL.NUMBER_TABLE,
6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,

Line 6282: currency_code DBMS_SQL.VARCHAR2_TABLE,

6278: TYPE l_payment_schedules_rec_type IS RECORD(
6279: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6280: customer_id DBMS_SQL.NUMBER_TABLE,
6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,

Line 6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,

6279: late_charge_trx_id DBMS_SQL.NUMBER_TABLE,
6280: customer_id DBMS_SQL.NUMBER_TABLE,
6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,

Line 6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,

6280: customer_id DBMS_SQL.NUMBER_TABLE,
6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,

Line 6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,

6281: customer_site_use_id DBMS_SQL.NUMBER_TABLE,
6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,

Line 6286: class DBMS_SQL.VARCHAR2_TABLE,

6282: currency_code DBMS_SQL.VARCHAR2_TABLE,
6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,

Line 6287: amount_due_original DBMS_SQL.NUMBER_TABLE,

6283: customer_trx_id DBMS_SQL.NUMBER_TABLE,
6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,

Line 6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,

6284: legal_entity_id DBMS_SQL.NUMBER_TABLE,
6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,

Line 6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,

6285: payment_schedule_id DBMS_SQL.NUMBER_TABLE,
6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

Line 6290: trx_date DBMS_SQL.DATE_TABLE,

6286: class DBMS_SQL.VARCHAR2_TABLE,
6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,

6287: amount_due_original DBMS_SQL.NUMBER_TABLE,
6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,

Line 6292: last_charge_date DBMS_SQL.DATE_TABLE,

6288: amount_due_remaining DBMS_SQL.NUMBER_TABLE,
6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,

Line 6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,

6289: fin_charge_charged DBMS_SQL.NUMBER_TABLE,
6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,

Line 6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,

6290: trx_date DBMS_SQL.DATE_TABLE,
6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,

Line 6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,

6291: cust_trx_type_id DBMS_SQL.NUMBER_TABLE,
6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,

Line 6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,

6292: last_charge_date DBMS_SQL.DATE_TABLE,
6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,

Line 6297: original_balance DBMS_SQL.NUMBER_TABLE,

6293: exchange_rate_type DBMS_SQL.VARCHAR2_TABLE,
6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,

Line 6298: due_date DBMS_SQL.DATE_TABLE,

6294: min_interest_charge DBMS_SQL.NUMBER_TABLE,
6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,

Line 6299: receipt_date DBMS_SQL.DATE_TABLE,

6295: max_interest_charge DBMS_SQL.NUMBER_TABLE,
6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,

Line 6300: finance_charge_date DBMS_SQL.DATE_TABLE,

6296: overdue_late_pay_amount DBMS_SQL.NUMBER_TABLE,
6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,

Line 6301: charge_type DBMS_SQL.VARCHAR2_TABLE,

6297: original_balance DBMS_SQL.NUMBER_TABLE,
6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,

Line 6302: actual_date_closed DBMS_SQL.DATE_TABLE,

6298: due_date DBMS_SQL.DATE_TABLE,
6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,

Line 6303: interest_rate DBMS_SQL.NUMBER_TABLE,

6299: receipt_date DBMS_SQL.DATE_TABLE,
6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,

Line 6304: interest_days DBMS_SQL.NUMBER_TABLE,

6300: finance_charge_date DBMS_SQL.DATE_TABLE,
6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,

Line 6305: rate_start_date DBMS_SQL.DATE_TABLE,

6301: charge_type DBMS_SQL.VARCHAR2_TABLE,
6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,

Line 6306: rate_end_date DBMS_SQL.DATE_TABLE,

6302: actual_date_closed DBMS_SQL.DATE_TABLE,
6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

Line 6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,

6303: interest_rate DBMS_SQL.NUMBER_TABLE,
6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

Line 6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,

6304: interest_days DBMS_SQL.NUMBER_TABLE,
6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,

Line 6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,

6305: rate_start_date DBMS_SQL.DATE_TABLE,
6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

Line 6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,

6306: rate_end_date DBMS_SQL.DATE_TABLE,
6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

Line 6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,

6307: schedule_days_start DBMS_SQL.NUMBER_TABLE,
6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,

Line 6312: interest_period_days DBMS_SQL.NUMBER_TABLE,

6308: schedule_days_to DBMS_SQL.NUMBER_TABLE,
6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,

Line 6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,

6309: late_charge_amount DBMS_SQL.NUMBER_TABLE,
6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

Line 6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,

6310: late_charge_type DBMS_SQL.VARCHAR2_TABLE,
6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

Line 6315: message_text_id DBMS_SQL.NUMBER_TABLE,

6311: late_charge_term_id DBMS_SQL.NUMBER_TABLE,
6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6319: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,

Line 6316: interest_type DBMS_SQL.VARCHAR2_TABLE,

6312: interest_period_days DBMS_SQL.NUMBER_TABLE,
6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6319: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6320: charge_line_type DBMS_SQL.VARCHAR2_TABLE);

Line 6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,

6313: interest_calculation_period DBMS_SQL.VARCHAR2_TABLE,
6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6319: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6320: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6321:

Line 6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,

6314: charge_on_finance_charge_flag DBMS_SQL.VARCHAR2_TABLE,
6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6319: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6320: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6321:
6322: l_payment_schedules_tbl l_payment_schedules_rec_type;

Line 6319: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,

6315: message_text_id DBMS_SQL.NUMBER_TABLE,
6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6319: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6320: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6321:
6322: l_payment_schedules_tbl l_payment_schedules_rec_type;
6323: l_bulk_fetch_rows number := 1000;

Line 6320: charge_line_type DBMS_SQL.VARCHAR2_TABLE);

6316: interest_type DBMS_SQL.VARCHAR2_TABLE,
6317: min_fc_invoice_overdue_type DBMS_SQL.VARCHAR2_TABLE,
6318: min_fc_invoice_amount DBMS_SQL.NUMBER_TABLE,
6319: min_fc_invoice_percent DBMS_SQL.VARCHAR2_TABLE,
6320: charge_line_type DBMS_SQL.VARCHAR2_TABLE);
6321:
6322: l_payment_schedules_tbl l_payment_schedules_rec_type;
6323: l_bulk_fetch_rows number := 1000;
6324: l_last_fetch_rows boolean := FALSE;