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_LATE_CHARGE_UPG dependencies on DBMS_SQL

Line 292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

288: AND cs.SCHEDULE_NAME(+) = DECODE(cpa.jgzz_attribute7,
289: 'D','D_UPG_'||cpa.jgzz_attribute8,
290: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
291:
292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
293: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 293: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

289: 'D','D_UPG_'||cpa.jgzz_attribute8,
290: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
291:
292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
293: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

Line 294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;

290: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
291:
292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
293: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;

291:
292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
293: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

Line 296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;

292: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
293: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

293: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
301: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;

294: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
301: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
302: l_interest_rate DBMS_SQL.NUMBER_TABLE;

Line 299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

295: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
301: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
302: l_interest_rate DBMS_SQL.NUMBER_TABLE;
303:

Line 300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;

296: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
301: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
302: l_interest_rate DBMS_SQL.NUMBER_TABLE;
303:
304: g_bulk_fetch_rows NUMBER := 10000;

Line 301: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;

297: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
301: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
302: l_interest_rate DBMS_SQL.NUMBER_TABLE;
303:
304: g_bulk_fetch_rows NUMBER := 10000;
305: l_last_fetch BOOLEAN := FALSE;

Line 302: l_interest_rate DBMS_SQL.NUMBER_TABLE;

298: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
299: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
300: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
301: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
302: l_interest_rate DBMS_SQL.NUMBER_TABLE;
303:
304: g_bulk_fetch_rows NUMBER := 10000;
305: l_last_fetch BOOLEAN := FALSE;
306:

Line 457: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

453: WHERE cp.rowid >= p_start_rowid
454: AND cp.rowid <= p_end_rowid
455: AND cp.CUST_ACCOUNT_PROFILE_ID = cpa.CUST_ACCOUNT_PROFILE_ID(+);
456:
457: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
458: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 458: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

454: AND cp.rowid <= p_end_rowid
455: AND cp.CUST_ACCOUNT_PROFILE_ID = cpa.CUST_ACCOUNT_PROFILE_ID(+);
456:
457: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
458: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

Line 459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;

455: AND cp.CUST_ACCOUNT_PROFILE_ID = cpa.CUST_ACCOUNT_PROFILE_ID(+);
456:
457: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
458: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;

Line 460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;

456:
457: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
458: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;

457: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
458: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

458: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;

Line 463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;

459: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;

Line 464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;

460: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
468: l_Message_text_id DBMS_SQL.NUMBER_TABLE;

Line 465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;

461: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
468: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
469: l_cons_bill_level DBMS_SQL.VARCHAR2_TABLE;

Line 466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;

462: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
468: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
469: l_cons_bill_level DBMS_SQL.VARCHAR2_TABLE;
470:

Line 467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;

463: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
468: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
469: l_cons_bill_level DBMS_SQL.VARCHAR2_TABLE;
470:
471:

Line 468: l_Message_text_id DBMS_SQL.NUMBER_TABLE;

464: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
468: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
469: l_cons_bill_level DBMS_SQL.VARCHAR2_TABLE;
470:
471:
472: g_bulk_fetch_rows NUMBER := 10000;

Line 469: l_cons_bill_level DBMS_SQL.VARCHAR2_TABLE;

465: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
466: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
467: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
468: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
469: l_cons_bill_level DBMS_SQL.VARCHAR2_TABLE;
470:
471:
472: g_bulk_fetch_rows NUMBER := 10000;
473: l_last_fetch BOOLEAN := FALSE;

Line 633: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

629: AND cs.SCHEDULE_NAME(+) = DECODE(cpa.jgzz_attribute7,
630: 'D','D_UPG_'||cpa.jgzz_attribute8,
631: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
632:
633: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
634: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 634: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;

630: 'D','D_UPG_'||cpa.jgzz_attribute8,
631: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
632:
633: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
634: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

Line 635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;

631: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
632:
633: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
634: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;

632:
633: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
634: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

Line 637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;

633: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
634: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;

634: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
642: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;

635: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
642: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
643: l_interest_rate DBMS_SQL.NUMBER_TABLE;

Line 640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;

636: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
642: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
643: l_interest_rate DBMS_SQL.NUMBER_TABLE;
644:

Line 641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;

637: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
642: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
643: l_interest_rate DBMS_SQL.NUMBER_TABLE;
644:
645: g_bulk_fetch_rows NUMBER := 10000;

Line 642: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;

638: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
642: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
643: l_interest_rate DBMS_SQL.NUMBER_TABLE;
644:
645: g_bulk_fetch_rows NUMBER := 10000;
646: l_last_fetch BOOLEAN := FALSE;

Line 643: l_interest_rate DBMS_SQL.NUMBER_TABLE;

639: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
641: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
642: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
643: l_interest_rate DBMS_SQL.NUMBER_TABLE;
644:
645: g_bulk_fetch_rows NUMBER := 10000;
646: l_last_fetch BOOLEAN := FALSE;
647:

Line 797: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

793: WHERE cp.rowid >= p_start_rowid
794: AND cp.rowid <= p_end_rowid
795: AND cp.PROFILE_CLASS_ID = cpa.PROFILE_CLASS_ID(+);
796:
797: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
798: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;

Line 798: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;

794: AND cp.rowid <= p_end_rowid
795: AND cp.PROFILE_CLASS_ID = cpa.PROFILE_CLASS_ID(+);
796:
797: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
798: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

Line 799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;

795: AND cp.PROFILE_CLASS_ID = cpa.PROFILE_CLASS_ID(+);
796:
797: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
798: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;

Line 800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;

796:
797: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
798: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;

797: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
798: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;

Line 802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;

798: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;

Line 803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;

799: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
807: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;

Line 804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;

800: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
807: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
808: l_Message_text_id DBMS_SQL.NUMBER_TABLE;

Line 805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;

801: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
807: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
808: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
809:

Line 806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;

802: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
807: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
808: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
809:
810:

Line 807: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;

803: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
807: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
808: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
809:
810:
811:

Line 808: l_Message_text_id DBMS_SQL.NUMBER_TABLE;

804: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
805: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
806: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
807: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
808: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
809:
810:
811:
812: g_bulk_fetch_rows NUMBER := 10000;

Line 969: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

965: AND adj.type = 'CHARGES'
966: ) trun
967: WHERE trun.rk = 1;
968:
969: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
970: l_csu_last_charge_date DBMS_SQL.DATE_TABLE;
971:
972: g_bulk_fetch_rows NUMBER := 10000;
973: l_last_fetch BOOLEAN := FALSE;

Line 970: l_csu_last_charge_date DBMS_SQL.DATE_TABLE;

966: ) trun
967: WHERE trun.rk = 1;
968:
969: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
970: l_csu_last_charge_date DBMS_SQL.DATE_TABLE;
971:
972: g_bulk_fetch_rows NUMBER := 10000;
973: l_last_fetch BOOLEAN := FALSE;
974:

Line 1099: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

1095: AND ractt.name(+) = 'Interest Invoice'
1096: AND sysp.rowid >= p_start_rowid
1097: AND sysp.rowid <= p_end_rowid;
1098:
1099: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
1100: l_batch_source_id DBMS_SQL.NUMBER_TABLE;
1101: l_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
1102:
1103: g_bulk_fetch_rows NUMBER := 10000;

Line 1100: l_batch_source_id DBMS_SQL.NUMBER_TABLE;

1096: AND sysp.rowid >= p_start_rowid
1097: AND sysp.rowid <= p_end_rowid;
1098:
1099: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
1100: l_batch_source_id DBMS_SQL.NUMBER_TABLE;
1101: l_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
1102:
1103: g_bulk_fetch_rows NUMBER := 10000;
1104: l_last_fetch BOOLEAN := FALSE;

Line 1101: l_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;

1097: AND sysp.rowid <= p_end_rowid;
1098:
1099: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
1100: l_batch_source_id DBMS_SQL.NUMBER_TABLE;
1101: l_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
1102:
1103: g_bulk_fetch_rows NUMBER := 10000;
1104: l_last_fetch BOOLEAN := FALSE;
1105: