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;
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;
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;
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;
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;
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;
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;
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:
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;
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;
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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:
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;
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;
627: AND cs.SCHEDULE_NAME(+) = DECODE(cpa.jgzz_attribute7,
628: 'D','D_UPG_'||cpa.jgzz_attribute8,
629: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
630:
631: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
632: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
633: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
628: 'D','D_UPG_'||cpa.jgzz_attribute8,
629: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
630:
631: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
632: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
633: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
629: 'M','M_UPG_'||cpa.jgzz_attribute9,NULL);
630:
631: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
632: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
633: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
630:
631: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
632: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
633: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
631: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
632: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
633: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
639: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
632: l_EXCHANGE_RATE_TYPE DBMS_SQL.VARCHAR2_TABLE;
633: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
639: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
633: l_MIN_FC_INVOICE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
639: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
641: l_interest_rate DBMS_SQL.NUMBER_TABLE;
634: l_MIN_FC_INVOICE_AMOUNT DBMS_SQL.NUMBER_TABLE;
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
639: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
641: l_interest_rate DBMS_SQL.NUMBER_TABLE;
642:
635: l_MIN_FC_BALANCE_OVERDUE_TYPE DBMS_SQL.VARCHAR2_TABLE;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
639: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
641: l_interest_rate DBMS_SQL.NUMBER_TABLE;
642:
643: g_bulk_fetch_rows NUMBER := 10000;
636: l_MIN_INTEREST_CHARGE DBMS_SQL.NUMBER_TABLE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
639: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
641: l_interest_rate DBMS_SQL.NUMBER_TABLE;
642:
643: g_bulk_fetch_rows NUMBER := 10000;
644: l_last_fetch BOOLEAN := FALSE;
637: l_INTEREST_TYPE DBMS_SQL.VARCHAR2_TABLE;
638: l_INTEREST_SCHEDULE_ID DBMS_SQL.NUMBER_TABLE;
639: l_PENALTY_TYPE DBMS_SQL.VARCHAR2_TABLE;
640: l_PENALTY_FIXED_AMOUNT DBMS_SQL.NUMBER_TABLE;
641: l_interest_rate DBMS_SQL.NUMBER_TABLE;
642:
643: g_bulk_fetch_rows NUMBER := 10000;
644: l_last_fetch BOOLEAN := FALSE;
645:
791: WHERE cp.rowid >= p_start_rowid
792: AND cp.rowid <= p_end_rowid
793: AND cp.PROFILE_CLASS_ID = cpa.PROFILE_CLASS_ID(+);
794:
795: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
796: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
797: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
792: AND cp.rowid <= p_end_rowid
793: AND cp.PROFILE_CLASS_ID = cpa.PROFILE_CLASS_ID(+);
794:
795: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
796: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
797: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
793: AND cp.PROFILE_CLASS_ID = cpa.PROFILE_CLASS_ID(+);
794:
795: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
796: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
797: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
794:
795: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
796: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
797: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
795: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
796: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
797: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
796: l_LATE_CHARGE_CALCULATION_TRX DBMS_SQL.VARCHAR2_TABLE;
797: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
804: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
797: l_CREDIT_ITEMS_FLAG DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
804: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
805: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
798: l_DISPUTED_TRANSACTIONS_FLAG DBMS_SQL.VARCHAR2_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
804: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
805: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
806: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
799: l_LATE_CHARGE_TYPE DBMS_SQL.VARCHAR2_TABLE;
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
804: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
805: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
806: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
807:
800: l_LATE_CHARGE_TERM_ID DBMS_SQL.NUMBER_TABLE;
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
804: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
805: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
806: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
807:
808:
801: l_INTEREST_CALCULATION_PERIOD DBMS_SQL.VARCHAR2_TABLE;
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
804: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
805: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
806: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
807:
808:
809:
802: l_HOLD_CHARGED_INVOICES_FLAG DBMS_SQL.VARCHAR2_TABLE;
803: l_MULTIPLE_INTEREST_RATES_FLAG DBMS_SQL.VARCHAR2_TABLE;
804: l_CHARGE_BEGIN_DATE DBMS_SQL.DATE_TABLE;
805: l_INTEREST_CHARGES DBMS_SQL.VARCHAR2_TABLE;
806: l_Message_text_id DBMS_SQL.NUMBER_TABLE;
807:
808:
809:
810: g_bulk_fetch_rows NUMBER := 10000;
963: AND adj.type = 'CHARGES'
964: ) trun
965: WHERE trun.rk = 1;
966:
967: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
968: l_csu_last_charge_date DBMS_SQL.DATE_TABLE;
969:
970: g_bulk_fetch_rows NUMBER := 10000;
971: l_last_fetch BOOLEAN := FALSE;
964: ) trun
965: WHERE trun.rk = 1;
966:
967: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
968: l_csu_last_charge_date DBMS_SQL.DATE_TABLE;
969:
970: g_bulk_fetch_rows NUMBER := 10000;
971: l_last_fetch BOOLEAN := FALSE;
972:
1093: AND ractt.name(+) = 'Interest Invoice'
1094: AND sysp.rowid >= p_start_rowid
1095: AND sysp.rowid <= p_end_rowid;
1096:
1097: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
1098: l_batch_source_id DBMS_SQL.NUMBER_TABLE;
1099: l_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
1100:
1101: g_bulk_fetch_rows NUMBER := 10000;
1094: AND sysp.rowid >= p_start_rowid
1095: AND sysp.rowid <= p_end_rowid;
1096:
1097: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
1098: l_batch_source_id DBMS_SQL.NUMBER_TABLE;
1099: l_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
1100:
1101: g_bulk_fetch_rows NUMBER := 10000;
1102: l_last_fetch BOOLEAN := FALSE;
1095: AND sysp.rowid <= p_end_rowid;
1096:
1097: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;
1098: l_batch_source_id DBMS_SQL.NUMBER_TABLE;
1099: l_cust_trx_type_id DBMS_SQL.NUMBER_TABLE;
1100:
1101: g_bulk_fetch_rows NUMBER := 10000;
1102: l_last_fetch BOOLEAN := FALSE;
1103: