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_CUST_PROF_CLASS_AMT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11


  SELECT NULL
    FROM ar_lookups
   WHERE lookup_type = p_type
     AND lookup_code = p_code
     AND    ( ENABLED_FLAG = 'Y' AND
             TRUNC( SYSDATE ) BETWEEN
              TRUNC(NVL( START_DATE_ACTIVE,SYSDATE ) ) AND
              TRUNC(NVL( END_DATE_ACTIVE,SYSDATE ) ) );

Line: 171


  SELECT NULL
    FROM gl_daily_conversion_types
   WHERE conversion_type <> 'EMU FIXED'
     AND conversion_type = p_exchange_rate_type;

Line: 223


  SELECT NULL
    FROM fnd_currencies
   WHERE currency_code = p_currency_code;

Line: 325


PROCEDURE insert_row
(P_PROFILE_CLASS_AMOUNT_ID      IN NUMBER,
 P_PROFILE_CLASS_ID             IN NUMBER,
 P_CURRENCY_CODE                IN VARCHAR2,
 P_TRX_CREDIT_LIMIT             IN NUMBER,
 P_OVERALL_CREDIT_LIMIT         IN NUMBER,
 P_MIN_DUNNING_AMOUNT           IN NUMBER,
 P_MAX_INTEREST_CHARGE          IN NUMBER,
 P_MIN_INTEREST_CHARGE          IN NUMBER,
 P_MIN_STATEMENT_AMOUNT         IN NUMBER,
 P_AUTO_REC_MIN_RECEIPT_AMOUNT  IN NUMBER,
 P_MIN_DUNNING_INVOICE_AMOUNT   IN NUMBER,
 P_INTEREST_RATE                IN NUMBER,
 P_EXPIRATION_DATE              IN DATE,
 P_EXCHANGE_RATE_TYPE           IN VARCHAR2,
 P_MIN_FC_INVOICE_OVERDUE_TYPE  IN VARCHAR2,
 P_MIN_FC_INVOICE_PERCENT       IN NUMBER,
 P_MIN_FC_INVOICE_AMOUNT        IN NUMBER,
 P_MIN_FC_BALANCE_OVERDUE_TYPE  IN VARCHAR2,
 P_MIN_FC_BALANCE_PERCENT       IN NUMBER,
 P_MIN_FC_BALANCE_AMOUNT        IN NUMBER,
 P_INTEREST_TYPE                IN VARCHAR2,
 P_INTEREST_FIXED_AMOUNT        IN NUMBER,
 P_INTEREST_SCHEDULE_ID         IN NUMBER,
 P_PENALTY_TYPE                 IN VARCHAR2,
 P_PENALTY_RATE                 IN NUMBER,
 P_PENALTY_FIXED_AMOUNT         IN NUMBER,
 P_PENALTY_SCHEDULE_ID          IN NUMBER,
 P_ATTRIBUTE_CATEGORY           IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE1                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE2                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE3                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE4                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE5                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE6                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE7                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE8                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE9                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE10                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE11                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE12                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE13                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE14                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE15                  IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE_CATEGORY      IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE1              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE2              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE3              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE4              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE5              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE6              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE7              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE8              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE9              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE10             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE11             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE12             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE13             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE14             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE15             IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE1            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE2            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE3            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE4            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE5            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE6            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE7            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE8            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE9            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE10           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE11           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE12           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE13           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE14           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE15           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE16           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE17           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE18           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE19           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE20           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE_CATEGORY    IN VARCHAR2 DEFAULT NULL,
 P_LAST_UPDATED_BY              IN NUMBER   DEFAULT -1,
 P_CREATED_BY                   IN NUMBER   DEFAULT -1,
 P_CREATION_DATE                IN DATE     DEFAULT SYSDATE,
 P_LAST_UPDATE_LOGIN            IN NUMBER   DEFAULT -1,
 x_return_status                OUT NOCOPY  VARCHAR2,
 x_msg_count                    OUT NOCOPY  NUMBER,
 x_msg_data                     OUT NOCOPY  VARCHAR2)
IS
  CURSOR cseq IS
  SELECT hz_cust_prof_class_amts_s.nextval
  from   dual;

Line: 419


 arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row +');

Line: 457


 arp_standard.debug(' Inserting into hz_cust_prof_class_amts+');

Line: 469


 INSERT INTO hz_cust_prof_class_Amts
 (PROFILE_CLASS_AMOUNT_ID      ,
  PROFILE_CLASS_ID             ,
  CURRENCY_CODE                ,
  TRX_CREDIT_LIMIT             ,
  OVERALL_CREDIT_LIMIT         ,
  MIN_DUNNING_AMOUNT           ,
  MAX_INTEREST_CHARGE          ,
  MIN_INTEREST_CHARGE          ,
  MIN_STATEMENT_AMOUNT         ,
  AUTO_REC_MIN_RECEIPT_AMOUNT  ,
  MIN_DUNNING_INVOICE_AMOUNT   ,
  INTEREST_RATE                ,
  EXPIRATION_DATE              ,
  EXCHANGE_RATE_TYPE           ,
  MIN_FC_INVOICE_OVERDUE_TYPE  ,
  MIN_FC_INVOICE_PERCENT       ,
  MIN_FC_INVOICE_AMOUNT        ,
  MIN_FC_BALANCE_OVERDUE_TYPE  ,
  MIN_FC_BALANCE_PERCENT       ,
  MIN_FC_BALANCE_AMOUNT        ,
  INTEREST_TYPE                ,
  INTEREST_FIXED_AMOUNT        ,
  INTEREST_SCHEDULE_ID         ,
  PENALTY_TYPE                 ,
  PENALTY_RATE                 ,
  PENALTY_FIXED_AMOUNT         ,
  PENALTY_SCHEDULE_ID          ,
  ATTRIBUTE_CATEGORY           ,
  ATTRIBUTE1                   ,
  ATTRIBUTE2                   ,
  ATTRIBUTE3                   ,
  ATTRIBUTE4                   ,
  ATTRIBUTE5                   ,
  ATTRIBUTE6                   ,
  ATTRIBUTE7                   ,
  ATTRIBUTE8                   ,
  ATTRIBUTE9                   ,
  ATTRIBUTE10                  ,
  ATTRIBUTE11                  ,
  ATTRIBUTE12                  ,
  ATTRIBUTE13                  ,
  ATTRIBUTE14                  ,
  ATTRIBUTE15                  ,
  JGZZ_ATTRIBUTE_CATEGORY      ,
  JGZZ_ATTRIBUTE1              ,
  JGZZ_ATTRIBUTE2              ,
  JGZZ_ATTRIBUTE3              ,
  JGZZ_ATTRIBUTE4              ,
  JGZZ_ATTRIBUTE5              ,
  JGZZ_ATTRIBUTE6              ,
  JGZZ_ATTRIBUTE7              ,
  JGZZ_ATTRIBUTE8              ,
  JGZZ_ATTRIBUTE9              ,
  JGZZ_ATTRIBUTE10             ,
  JGZZ_ATTRIBUTE11             ,
  JGZZ_ATTRIBUTE12             ,
  JGZZ_ATTRIBUTE13             ,
  JGZZ_ATTRIBUTE14             ,
  JGZZ_ATTRIBUTE15             ,
  GLOBAL_ATTRIBUTE1            ,
  GLOBAL_ATTRIBUTE2            ,
  GLOBAL_ATTRIBUTE3            ,
  GLOBAL_ATTRIBUTE4            ,
  GLOBAL_ATTRIBUTE5            ,
  GLOBAL_ATTRIBUTE6            ,
  GLOBAL_ATTRIBUTE7            ,
  GLOBAL_ATTRIBUTE8            ,
  GLOBAL_ATTRIBUTE9            ,
  GLOBAL_ATTRIBUTE10           ,
  GLOBAL_ATTRIBUTE11           ,
  GLOBAL_ATTRIBUTE12           ,
  GLOBAL_ATTRIBUTE13           ,
  GLOBAL_ATTRIBUTE14           ,
  GLOBAL_ATTRIBUTE15           ,
  GLOBAL_ATTRIBUTE16           ,
  GLOBAL_ATTRIBUTE17           ,
  GLOBAL_ATTRIBUTE18           ,
  GLOBAL_ATTRIBUTE19           ,
  GLOBAL_ATTRIBUTE20           ,
  GLOBAL_ATTRIBUTE_CATEGORY    ,
  LAST_UPDATED_BY              ,
  LAST_UPDATE_DATE             ,
  CREATED_BY                   ,
  CREATION_DATE                ,
  LAST_UPDATE_LOGIN
  ) VALUES (
  l_cust_prof_class_amt_id       ,
  P_PROFILE_CLASS_ID             ,
  P_CURRENCY_CODE                ,
  P_TRX_CREDIT_LIMIT             ,
  P_OVERALL_CREDIT_LIMIT         ,
  P_MIN_DUNNING_AMOUNT           ,
  P_MAX_INTEREST_CHARGE          ,
  P_MIN_INTEREST_CHARGE          ,
  P_MIN_STATEMENT_AMOUNT         ,
  P_AUTO_REC_MIN_RECEIPT_AMOUNT  ,
  P_MIN_DUNNING_INVOICE_AMOUNT   ,
  P_INTEREST_RATE                ,
  P_EXPIRATION_DATE              ,
  P_EXCHANGE_RATE_TYPE           ,
  P_MIN_FC_INVOICE_OVERDUE_TYPE  ,
  P_MIN_FC_INVOICE_PERCENT       ,
  P_MIN_FC_INVOICE_AMOUNT        ,
  P_MIN_FC_BALANCE_OVERDUE_TYPE  ,
  P_MIN_FC_BALANCE_PERCENT       ,
  P_MIN_FC_BALANCE_AMOUNT        ,
  P_INTEREST_TYPE                ,
  P_INTEREST_FIXED_AMOUNT        ,
  P_INTEREST_SCHEDULE_ID         ,
  P_PENALTY_TYPE                 ,
  P_PENALTY_RATE                 ,
  P_PENALTY_FIXED_AMOUNT         ,
  P_PENALTY_SCHEDULE_ID          ,
  P_ATTRIBUTE_CATEGORY           ,
  P_ATTRIBUTE1                   ,
  P_ATTRIBUTE2                   ,
  P_ATTRIBUTE3                   ,
  P_ATTRIBUTE4                   ,
  P_ATTRIBUTE5                   ,
  P_ATTRIBUTE6                   ,
  P_ATTRIBUTE7                   ,
  P_ATTRIBUTE8                   ,
  P_ATTRIBUTE9                   ,
  P_ATTRIBUTE10                  ,
  P_ATTRIBUTE11                  ,
  P_ATTRIBUTE12                  ,
  P_ATTRIBUTE13                  ,
  P_ATTRIBUTE14                  ,
  P_ATTRIBUTE15                  ,
  P_JGZZ_ATTRIBUTE_CATEGORY      ,
  P_JGZZ_ATTRIBUTE1              ,
  P_JGZZ_ATTRIBUTE2              ,
  P_JGZZ_ATTRIBUTE3              ,
  P_JGZZ_ATTRIBUTE4              ,
  P_JGZZ_ATTRIBUTE5              ,
  P_JGZZ_ATTRIBUTE6              ,
  P_JGZZ_ATTRIBUTE7              ,
  P_JGZZ_ATTRIBUTE8              ,
  P_JGZZ_ATTRIBUTE9              ,
  P_JGZZ_ATTRIBUTE10             ,
  P_JGZZ_ATTRIBUTE11             ,
  P_JGZZ_ATTRIBUTE12             ,
  P_JGZZ_ATTRIBUTE13             ,
  P_JGZZ_ATTRIBUTE14             ,
  P_JGZZ_ATTRIBUTE15             ,
  P_GLOBAL_ATTRIBUTE1            ,
  P_GLOBAL_ATTRIBUTE2            ,
  P_GLOBAL_ATTRIBUTE3            ,
  P_GLOBAL_ATTRIBUTE4            ,
  P_GLOBAL_ATTRIBUTE5            ,
  P_GLOBAL_ATTRIBUTE6            ,
  P_GLOBAL_ATTRIBUTE7            ,
  P_GLOBAL_ATTRIBUTE8            ,
  P_GLOBAL_ATTRIBUTE9            ,
  P_GLOBAL_ATTRIBUTE10           ,
  P_GLOBAL_ATTRIBUTE11           ,
  P_GLOBAL_ATTRIBUTE12           ,
  P_GLOBAL_ATTRIBUTE13           ,
  P_GLOBAL_ATTRIBUTE14           ,
  P_GLOBAL_ATTRIBUTE15           ,
  P_GLOBAL_ATTRIBUTE16           ,
  P_GLOBAL_ATTRIBUTE17           ,
  P_GLOBAL_ATTRIBUTE18           ,
  P_GLOBAL_ATTRIBUTE19           ,
  P_GLOBAL_ATTRIBUTE20           ,
  P_GLOBAL_ATTRIBUTE_CATEGORY    ,
  P_LAST_UPDATED_BY              ,
  SYSDATE                        ,
  P_CREATED_BY                   ,
  P_CREATION_DATE                ,
  P_LAST_UPDATE_LOGIN);

Line: 642


  arp_standard.debug(' Inserting into hz_cust_prof_class_amts-');

Line: 644


arp_standard.debug('ar_cust_prof_class_amt_pkg.insert_row -');

Line: 650


    arp_standard.debug('EXCEPTION  IN ar_cust_prof_class_amt_pkg.insert_row:'||x_msg_data);

Line: 660


    arp_standard.debug('EXCEPTION OTHERS IN ar_cust_prof_class_amt_pkg.insert_row:'||SQLERRM);

Line: 672


  SELECT PROFILE_CLASS_AMOUNT_ID      ,
         PROFILE_CLASS_ID             ,
         CURRENCY_CODE                ,
         TRX_CREDIT_LIMIT             ,
         OVERALL_CREDIT_LIMIT         ,
         MIN_DUNNING_AMOUNT           ,
         MAX_INTEREST_CHARGE          ,
         MIN_INTEREST_CHARGE          ,
         MIN_STATEMENT_AMOUNT         ,
         AUTO_REC_MIN_RECEIPT_AMOUNT  ,
         MIN_DUNNING_INVOICE_AMOUNT   ,
         INTEREST_RATE                ,
         EXPIRATION_DATE              ,
         EXCHANGE_RATE_TYPE           ,
         MIN_FC_INVOICE_OVERDUE_TYPE  ,
         MIN_FC_INVOICE_PERCENT       ,
         MIN_FC_INVOICE_AMOUNT        ,
         MIN_FC_BALANCE_OVERDUE_TYPE  ,
         MIN_FC_BALANCE_PERCENT       ,
         MIN_FC_BALANCE_AMOUNT        ,
         INTEREST_TYPE                ,
         INTEREST_FIXED_AMOUNT        ,
         INTEREST_SCHEDULE_ID         ,
         PENALTY_TYPE                 ,
         PENALTY_RATE                 ,
         PENALTY_FIXED_AMOUNT         ,
         PENALTY_SCHEDULE_ID          ,
         ATTRIBUTE_CATEGORY           ,
         ATTRIBUTE1                   ,
         ATTRIBUTE2                   ,
         ATTRIBUTE3                   ,
         ATTRIBUTE4                   ,
         ATTRIBUTE5                   ,
         ATTRIBUTE6                   ,
         ATTRIBUTE7                   ,
         ATTRIBUTE8                   ,
         ATTRIBUTE9                   ,
         ATTRIBUTE10                  ,
         ATTRIBUTE11                  ,
         ATTRIBUTE12                  ,
         ATTRIBUTE13                  ,
         ATTRIBUTE14                  ,
         ATTRIBUTE15                  ,
         JGZZ_ATTRIBUTE_CATEGORY      ,
         JGZZ_ATTRIBUTE1              ,
         JGZZ_ATTRIBUTE2              ,
         JGZZ_ATTRIBUTE3              ,
         JGZZ_ATTRIBUTE4              ,
         JGZZ_ATTRIBUTE5              ,
         JGZZ_ATTRIBUTE6              ,
         JGZZ_ATTRIBUTE7              ,
         JGZZ_ATTRIBUTE8              ,
         JGZZ_ATTRIBUTE9              ,
         JGZZ_ATTRIBUTE10             ,
         JGZZ_ATTRIBUTE11             ,
         JGZZ_ATTRIBUTE12             ,
         JGZZ_ATTRIBUTE13             ,
         JGZZ_ATTRIBUTE14             ,
         JGZZ_ATTRIBUTE15             ,
         GLOBAL_ATTRIBUTE1            ,
         GLOBAL_ATTRIBUTE2            ,
         GLOBAL_ATTRIBUTE3            ,
         GLOBAL_ATTRIBUTE4            ,
         GLOBAL_ATTRIBUTE5            ,
         GLOBAL_ATTRIBUTE6            ,
         GLOBAL_ATTRIBUTE7            ,
         GLOBAL_ATTRIBUTE8            ,
         GLOBAL_ATTRIBUTE9            ,
         GLOBAL_ATTRIBUTE10           ,
         GLOBAL_ATTRIBUTE11           ,
         GLOBAL_ATTRIBUTE12           ,
         GLOBAL_ATTRIBUTE13           ,
         GLOBAL_ATTRIBUTE14           ,
         GLOBAL_ATTRIBUTE15           ,
         GLOBAL_ATTRIBUTE16           ,
         GLOBAL_ATTRIBUTE17           ,
         GLOBAL_ATTRIBUTE18           ,
         GLOBAL_ATTRIBUTE19           ,
         GLOBAL_ATTRIBUTE20           ,
         GLOBAL_ATTRIBUTE_CATEGORY    ,
         LAST_UPDATED_BY              ,
         LAST_UPDATE_DATE             ,
         CREATED_BY                   ,
         CREATION_DATE                ,
         LAST_UPDATE_LOGIN
    FROM hz_cust_prof_class_amts
   WHERE PROFILE_CLASS_AMOUNT_ID = p_info_rec.PROFILE_CLASS_AMOUNT_ID
   FOR UPDATE OF hz_cust_prof_class_amts.PROFILE_CLASS_AMOUNT_ID NOWAIT;

Line: 852


         l_info_rec.LAST_UPDATED_BY              ,
         l_info_rec.LAST_UPDATE_DATE             ,
         l_info_rec.CREATED_BY                   ,
         l_info_rec.CREATION_DATE                ,
         l_info_rec.LAST_UPDATE_LOGIN;

Line: 943


        AND elementequal(l_info_rec.LAST_UPDATE_DATE       ,  p_info_rec.LAST_UPDATE_DATE)   )
   THEN
      RETURN;

Line: 978


PROCEDURE update_row
(P_PROFILE_CLASS_AMOUNT_ID      IN NUMBER,
 P_CURRENCY_CODE                IN VARCHAR2,
 P_TRX_CREDIT_LIMIT             IN NUMBER,
 P_OVERALL_CREDIT_LIMIT         IN NUMBER,
 P_MIN_DUNNING_AMOUNT           IN NUMBER,
 P_MAX_INTEREST_CHARGE          IN NUMBER,
 P_MIN_INTEREST_CHARGE          IN NUMBER,
 P_MIN_STATEMENT_AMOUNT         IN NUMBER,
 P_AUTO_REC_MIN_RECEIPT_AMOUNT  IN NUMBER,
 P_MIN_DUNNING_INVOICE_AMOUNT   IN NUMBER,
 P_INTEREST_RATE                IN NUMBER,
 P_EXPIRATION_DATE              IN DATE,
 P_EXCHANGE_RATE_TYPE           IN VARCHAR2,
 P_MIN_FC_INVOICE_OVERDUE_TYPE  IN VARCHAR2,
 P_MIN_FC_INVOICE_PERCENT       IN NUMBER,
 P_MIN_FC_INVOICE_AMOUNT        IN NUMBER,
 P_MIN_FC_BALANCE_OVERDUE_TYPE  IN VARCHAR2,
 P_MIN_FC_BALANCE_PERCENT       IN NUMBER,
 P_MIN_FC_BALANCE_AMOUNT        IN NUMBER,
 P_INTEREST_TYPE                IN VARCHAR2,
 P_INTEREST_FIXED_AMOUNT        IN NUMBER,
 P_INTEREST_SCHEDULE_ID         IN NUMBER,
 P_PENALTY_TYPE                 IN VARCHAR2,
 P_PENALTY_RATE                 IN NUMBER,
 P_PENALTY_FIXED_AMOUNT         IN NUMBER,
 P_PENALTY_SCHEDULE_ID          IN NUMBER,
 P_ATTRIBUTE_CATEGORY           IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE1                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE2                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE3                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE4                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE5                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE6                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE7                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE8                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE9                   IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE10                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE11                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE12                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE13                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE14                  IN VARCHAR2 DEFAULT NULL,
 P_ATTRIBUTE15                  IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE_CATEGORY      IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE1              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE2              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE3              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE4              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE5              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE6              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE7              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE8              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE9              IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE10             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE11             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE12             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE13             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE14             IN VARCHAR2 DEFAULT NULL,
 P_JGZZ_ATTRIBUTE15             IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE1            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE2            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE3            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE4            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE5            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE6            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE7            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE8            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE9            IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE10           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE11           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE12           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE13           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE14           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE15           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE16           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE17           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE18           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE19           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE20           IN VARCHAR2 DEFAULT NULL,
 P_GLOBAL_ATTRIBUTE_CATEGORY    IN VARCHAR2 DEFAULT NULL,
 P_LAST_UPDATED_BY              IN NUMBER   DEFAULT -1,
 P_LAST_UPDATE_LOGIN            IN NUMBER   DEFAULT -1,
 x_return_status                OUT NOCOPY  VARCHAR2,
 x_msg_count                    OUT NOCOPY  NUMBER,
 x_msg_data                     OUT NOCOPY  VARCHAR2)
IS
BEGIN
arp_standard.debug('ar_cust_prof_class_amt_pkg.update_row +');

Line: 1107


 UPDATE hz_cust_prof_class_Amts
 SET
  CURRENCY_CODE               = P_CURRENCY_CODE,
  TRX_CREDIT_LIMIT            = P_TRX_CREDIT_LIMIT,
  OVERALL_CREDIT_LIMIT        = P_OVERALL_CREDIT_LIMIT,
  MIN_DUNNING_AMOUNT          = P_MIN_DUNNING_AMOUNT,
  MAX_INTEREST_CHARGE         = P_MAX_INTEREST_CHARGE,
  MIN_INTEREST_CHARGE         = P_MIN_INTEREST_CHARGE,
  MIN_STATEMENT_AMOUNT        = P_MIN_STATEMENT_AMOUNT,
  AUTO_REC_MIN_RECEIPT_AMOUNT = P_AUTO_REC_MIN_RECEIPT_AMOUNT,
  MIN_DUNNING_INVOICE_AMOUNT  = P_MIN_DUNNING_INVOICE_AMOUNT,
  INTEREST_RATE               = P_INTEREST_RATE,
  EXPIRATION_DATE             = P_EXPIRATION_DATE,
  EXCHANGE_RATE_TYPE          = P_EXCHANGE_RATE_TYPE,
  MIN_FC_INVOICE_OVERDUE_TYPE = P_MIN_FC_INVOICE_OVERDUE_TYPE,
  MIN_FC_INVOICE_PERCENT      = P_MIN_FC_INVOICE_PERCENT,
  MIN_FC_INVOICE_AMOUNT       = P_MIN_FC_INVOICE_AMOUNT,
  MIN_FC_BALANCE_OVERDUE_TYPE = P_MIN_FC_BALANCE_OVERDUE_TYPE,
  MIN_FC_BALANCE_PERCENT      = P_MIN_FC_BALANCE_PERCENT,
  MIN_FC_BALANCE_AMOUNT       = P_MIN_FC_BALANCE_AMOUNT,
  INTEREST_TYPE               = P_INTEREST_TYPE,
  INTEREST_FIXED_AMOUNT       = P_INTEREST_FIXED_AMOUNT,
  INTEREST_SCHEDULE_ID        = P_INTEREST_SCHEDULE_ID,
  PENALTY_TYPE                = P_PENALTY_TYPE,
  PENALTY_RATE                = P_PENALTY_RATE,
  PENALTY_FIXED_AMOUNT        = P_PENALTY_FIXED_AMOUNT,
  PENALTY_SCHEDULE_ID         = P_PENALTY_SCHEDULE_ID,
  ATTRIBUTE_CATEGORY          = P_ATTRIBUTE_CATEGORY,
  ATTRIBUTE1                  = P_ATTRIBUTE1,
  ATTRIBUTE2                  = P_ATTRIBUTE2,
  ATTRIBUTE3                  = P_ATTRIBUTE3,
  ATTRIBUTE4                  = P_ATTRIBUTE4,
  ATTRIBUTE5                  = P_ATTRIBUTE5,
  ATTRIBUTE6                  = P_ATTRIBUTE6,
  ATTRIBUTE7                  = P_ATTRIBUTE7,
  ATTRIBUTE8                  = P_ATTRIBUTE8,
  ATTRIBUTE9                  = P_ATTRIBUTE9,
  ATTRIBUTE10                 = P_ATTRIBUTE10,
  ATTRIBUTE11                 = P_ATTRIBUTE11,
  ATTRIBUTE12                 = P_ATTRIBUTE12,
  ATTRIBUTE13                 = P_ATTRIBUTE13,
  ATTRIBUTE14                 = P_ATTRIBUTE14,
  ATTRIBUTE15                 = P_ATTRIBUTE15,
  JGZZ_ATTRIBUTE_CATEGORY     = P_JGZZ_ATTRIBUTE_CATEGORY,
  JGZZ_ATTRIBUTE1             = P_JGZZ_ATTRIBUTE1,
  JGZZ_ATTRIBUTE2             = P_JGZZ_ATTRIBUTE2,
  JGZZ_ATTRIBUTE3             = P_JGZZ_ATTRIBUTE3,
  JGZZ_ATTRIBUTE4             = P_JGZZ_ATTRIBUTE4,
  JGZZ_ATTRIBUTE5             = P_JGZZ_ATTRIBUTE5,
  JGZZ_ATTRIBUTE6             = P_JGZZ_ATTRIBUTE6,
  JGZZ_ATTRIBUTE7             = P_JGZZ_ATTRIBUTE7,
  JGZZ_ATTRIBUTE8             = P_JGZZ_ATTRIBUTE8,
  JGZZ_ATTRIBUTE9             = P_JGZZ_ATTRIBUTE9,
  JGZZ_ATTRIBUTE10            = P_JGZZ_ATTRIBUTE10,
  JGZZ_ATTRIBUTE11            = P_JGZZ_ATTRIBUTE11,
  JGZZ_ATTRIBUTE12            = P_JGZZ_ATTRIBUTE12,
  JGZZ_ATTRIBUTE13            = P_JGZZ_ATTRIBUTE13,
  JGZZ_ATTRIBUTE14            = P_JGZZ_ATTRIBUTE14,
  JGZZ_ATTRIBUTE15            = P_JGZZ_ATTRIBUTE15,
  GLOBAL_ATTRIBUTE1           = P_GLOBAL_ATTRIBUTE1,
  GLOBAL_ATTRIBUTE2           = P_GLOBAL_ATTRIBUTE2,
  GLOBAL_ATTRIBUTE3           = P_GLOBAL_ATTRIBUTE3,
  GLOBAL_ATTRIBUTE4           = P_GLOBAL_ATTRIBUTE4,
  GLOBAL_ATTRIBUTE5           = P_GLOBAL_ATTRIBUTE5,
  GLOBAL_ATTRIBUTE6           = P_GLOBAL_ATTRIBUTE6,
  GLOBAL_ATTRIBUTE7           = P_GLOBAL_ATTRIBUTE7,
  GLOBAL_ATTRIBUTE8           = P_GLOBAL_ATTRIBUTE8,
  GLOBAL_ATTRIBUTE9           = P_GLOBAL_ATTRIBUTE9,
  GLOBAL_ATTRIBUTE10          = P_GLOBAL_ATTRIBUTE10,
  GLOBAL_ATTRIBUTE11          = P_GLOBAL_ATTRIBUTE11,
  GLOBAL_ATTRIBUTE12          = P_GLOBAL_ATTRIBUTE12,
  GLOBAL_ATTRIBUTE13          = P_GLOBAL_ATTRIBUTE13,
  GLOBAL_ATTRIBUTE14          = P_GLOBAL_ATTRIBUTE14,
  GLOBAL_ATTRIBUTE15          = P_GLOBAL_ATTRIBUTE15,
  GLOBAL_ATTRIBUTE16          = P_GLOBAL_ATTRIBUTE16,
  GLOBAL_ATTRIBUTE17          = P_GLOBAL_ATTRIBUTE17,
  GLOBAL_ATTRIBUTE18          = P_GLOBAL_ATTRIBUTE18,
  GLOBAL_ATTRIBUTE19          = P_GLOBAL_ATTRIBUTE19,
  GLOBAL_ATTRIBUTE20          = P_GLOBAL_ATTRIBUTE20,
  GLOBAL_ATTRIBUTE_CATEGORY   = P_GLOBAL_ATTRIBUTE_CATEGORY,
  LAST_UPDATED_BY             = P_LAST_UPDATED_BY,
  LAST_UPDATE_DATE            = SYSDATE,
  LAST_UPDATE_LOGIN           = P_LAST_UPDATE_LOGIN
 WHERE PROFILE_CLASS_AMOUNT_ID = P_PROFILE_CLASS_AMOUNT_ID;

Line: 1194


arp_standard.debug('ar_cust_prof_class_amt_pkg.update_row -');

Line: 1202


     arp_standard.debug('EXCEPTION ar_cust_prof_class_amt_pkg.update_row:'||x_msg_data);

Line: 1212


    arp_standard.debug('EXCEPTION OTHERS IN ar_cust_prof_class_amt_pkg.update_row:'||SQLERRM);

Line: 1219


PROCEDURE Insert_Negative_Class_Amt
(         X_Customer_Profile_Class_Id      NUMBER,
          X_Created_By                     NUMBER,
          X_Creation_Date                  DATE,
          X_Currency_Code                  VARCHAR2,
          X_Cust_Prof_Class_Amount_Id      NUMBER,
          X_Last_Updated_By                NUMBER,
          X_Last_Update_Date               DATE,
          X_Auto_Rec_Min_Receipt_Amount    NUMBER,
          X_Last_Update_Login              NUMBER,
          X_Max_Interest_Charge            NUMBER,
          X_Min_Dunning_Amount             NUMBER,
          X_Min_Statement_Amount           NUMBER,
          X_Overall_Credit_Limit           NUMBER,
          X_Trx_Credit_Limit               NUMBER,
          X_Attribute_Category             VARCHAR2,
          X_Attribute1                     VARCHAR2,
          X_Attribute2                     VARCHAR2,
          X_Attribute3                     VARCHAR2,
          X_Attribute4                     VARCHAR2,
          X_Attribute5                     VARCHAR2,
          X_Attribute6                     VARCHAR2,
          X_Attribute7                     VARCHAR2,
          X_Attribute8                     VARCHAR2,
          X_Attribute9                     VARCHAR2,
          X_Attribute10                    VARCHAR2,
          X_Attribute11                    VARCHAR2,
          X_Attribute12                    VARCHAR2,
          X_Attribute13                    VARCHAR2,
          X_Attribute14                    VARCHAR2,
          X_Attribute15                    VARCHAR2,
          X_Interest_Rate                  NUMBER,
          X_Min_Fc_Balance_Amount          NUMBER,
          X_Min_Fc_Invoice_Amount          NUMBER,
          X_Min_Dunning_Invoice_Amount     NUMBER,
          X_Jgzz_attribute_Category             VARCHAR2,
          X_Jgzz_attribute1                     VARCHAR2,
          X_Jgzz_attribute2                     VARCHAR2,
          X_Jgzz_attribute3                     VARCHAR2,
          X_Jgzz_attribute4                     VARCHAR2,
          X_Jgzz_attribute5                     VARCHAR2,
          X_Jgzz_attribute6                     VARCHAR2,
          X_Jgzz_attribute7                     VARCHAR2,
          X_Jgzz_attribute8                     VARCHAR2,
          X_Jgzz_attribute9                     VARCHAR2,
          X_Jgzz_attribute10                    VARCHAR2,
          X_Jgzz_attribute11                    VARCHAR2,
          X_Jgzz_attribute12                    VARCHAR2,
          X_Jgzz_attribute13                    VARCHAR2,
          X_Jgzz_attribute14                    VARCHAR2,
          X_Jgzz_attribute15                    VARCHAR2,
          --Late Charges
          X_EXCHANGE_RATE_TYPE                  VARCHAR2,
          X_MIN_FC_INVOICE_OVERDUE_TYPE         VARCHAR2,
          X_MIN_FC_INVOICE_PERCENT              NUMBER,
          X_MIN_FC_BALANCE_OVERDUE_TYPE         VARCHAR2,
          X_MIN_FC_BALANCE_PERCENT              NUMBER,
          X_INTEREST_TYPE                       VARCHAR2,
          X_INTEREST_FIXED_AMOUNT               NUMBER,
          X_INTEREST_SCHEDULE_ID                NUMBER,
          X_PENALTY_TYPE                        VARCHAR2,
          X_PENALTY_RATE                        NUMBER,
          X_PENALTY_FIXED_AMOUNT                NUMBER,
          X_PENALTY_SCHEDULE_ID                 NUMBER,
          X_MIN_INTEREST_CHARGE                 NUMBER
) IS

BEGIN
  INSERT INTO HZ_CUST_PROF_CLASS_AMTS
  (
         profile_class_id,
         created_by,
         creation_date,
         currency_code,
         profile_class_amount_id,
         last_updated_by,
         last_update_date,
         auto_rec_min_receipt_amount,
         last_update_login,
         max_interest_charge,
         MIN_INTEREST_CHARGE,
         min_dunning_amount,
         min_statement_amount,
         overall_credit_limit,
         trx_credit_limit,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15,
         interest_rate,
         min_fc_balance_amount,
         min_fc_invoice_amount,
         min_dunning_invoice_amount,
         Jgzz_attribute_Category,
         Jgzz_attribute1,
         Jgzz_attribute2,
         Jgzz_attribute3,
         Jgzz_attribute4,
         Jgzz_attribute5,
         Jgzz_attribute6,
         Jgzz_attribute7,
         Jgzz_attribute8,
         Jgzz_attribute9,
         Jgzz_attribute10,
         Jgzz_attribute11,
         Jgzz_attribute12,
         Jgzz_attribute13,
         Jgzz_attribute14,
         Jgzz_attribute15,
         --{Late Charges
         EXCHANGE_RATE_TYPE,
         MIN_FC_INVOICE_OVERDUE_TYPE,
         MIN_FC_INVOICE_PERCENT,
         MIN_FC_BALANCE_OVERDUE_TYPE,
         MIN_FC_BALANCE_PERCENT,
         INTEREST_TYPE       ,
         INTEREST_FIXED_AMOUNT,
         INTEREST_SCHEDULE_ID,
         PENALTY_TYPE        ,
         PENALTY_RATE        ,
         PENALTY_FIXED_AMOUNT,
         PENALTY_SCHEDULE_ID
  )
  VALUES
  (
         X_Customer_Profile_Class_Id,
         X_Created_By,
         X_Creation_Date,
         X_Currency_Code,
         X_Cust_Prof_Class_Amount_Id,
         X_Last_Updated_By,
         X_Last_Update_Date,
         X_Auto_Rec_Min_Receipt_Amount,
         X_Last_Update_Login,
         X_Max_Interest_Charge,
         X_MIN_INTEREST_CHARGE,
         X_Min_Dunning_Amount,
         X_Min_Statement_Amount,
         X_Overall_Credit_Limit,
         X_Trx_Credit_Limit,
         X_Attribute_Category,
         X_Attribute1,
         X_Attribute2,
         X_Attribute3,
         X_Attribute4,
         X_Attribute5,
         X_Attribute6,
         X_Attribute7,
         X_Attribute8,
         X_Attribute9,
         X_Attribute10,
         X_Attribute11,
         X_Attribute12,
         X_Attribute13,
         X_Attribute14,
         X_Attribute15,
         X_Interest_Rate,
         X_Min_Fc_Balance_Amount,
         X_Min_Fc_Invoice_Amount,
         X_Min_Dunning_Invoice_Amount,
         X_Jgzz_attribute_Category,
         X_Jgzz_attribute1,
         X_Jgzz_attribute2,
         X_Jgzz_attribute3,
         X_Jgzz_attribute4,
         X_Jgzz_attribute5,
         X_Jgzz_attribute6,
         X_Jgzz_attribute7,
         X_Jgzz_attribute8,
         X_Jgzz_attribute9,
         X_Jgzz_attribute10,
         X_Jgzz_attribute11,
         X_Jgzz_attribute12,
         X_Jgzz_attribute13,
         X_Jgzz_attribute14,
         X_Jgzz_attribute15,
         --{Late Charges
         X_EXCHANGE_RATE_TYPE,
         X_MIN_FC_INVOICE_OVERDUE_TYPE,
         X_MIN_FC_INVOICE_PERCENT,
         X_MIN_FC_BALANCE_OVERDUE_TYPE,
         X_MIN_FC_BALANCE_PERCENT,
         X_INTEREST_TYPE       ,
         X_INTEREST_FIXED_AMOUNT,
         X_INTEREST_SCHEDULE_ID,
         X_PENALTY_TYPE        ,
         X_PENALTY_RATE        ,
         X_PENALTY_FIXED_AMOUNT,
         X_PENALTY_SCHEDULE_ID
  );

Line: 1423


  INSERT INTO hyu_prof_class_amts
  (
         profile_class_id,
         created_by,
         creation_date,
         currency_code,
         profile_class_amount_id,
         last_updated_by,
         last_update_date,
         auto_rec_min_receipt_amount,
         last_update_login,
         max_interest_charge,
         min_dunning_amount,
         min_statement_amount,
         overall_credit_limit,
         trx_credit_limit,
         attribute_category,
         attribute1,
         attribute2,
         attribute3,
         attribute4,
         attribute5,
         attribute6,
         attribute7,
         attribute8,
         attribute9,
         attribute10,
         attribute11,
         attribute12,
         attribute13,
         attribute14,
         attribute15,
         interest_rate,
         min_fc_balance_amount,
         min_fc_invoice_amount,
         min_dunning_invoice_amount,
         Jgzz_attribute_Category,
         Jgzz_attribute1,
         Jgzz_attribute2,
         Jgzz_attribute3,
         Jgzz_attribute4,
         Jgzz_attribute5,
         Jgzz_attribute6,
         Jgzz_attribute7,
         Jgzz_attribute8,
         Jgzz_attribute9,
         Jgzz_attribute10,
         Jgzz_attribute11,
         Jgzz_attribute12,
         Jgzz_attribute13,
         Jgzz_attribute14,
         Jgzz_attribute15,
         --{Late Charges
         EXCHANGE_RATE_TYPE,
         MIN_FC_INVOICE_OVERDUE_TYPE,
         MIN_FC_INVOICE_PERCENT,
         MIN_FC_BALANCE_OVERDUE_TYPE,
         MIN_FC_BALANCE_PERCENT,
         INTEREST_TYPE       ,
         INTEREST_FIXED_AMOUNT,
         INTEREST_SCHEDULE_ID,
         PENALTY_TYPE        ,
         PENALTY_RATE        ,
         PENALTY_FIXED_AMOUNT,
         PENALTY_SCHEDULE_ID
  )
  VALUES
  (
         X_Customer_Profile_Class_Id,
         X_Created_By,
         X_Creation_Date,
         X_Currency_Code,
         X_Cust_Prof_Class_Amount_Id,
         X_Last_Updated_By,
         X_Last_Update_Date,
         X_Auto_Rec_Min_Receipt_Amount,
         X_Last_Update_Login,
         X_Max_Interest_Charge,
         X_Min_Dunning_Amount,
         X_Min_Statement_Amount,
         X_Overall_Credit_Limit,
         X_Trx_Credit_Limit,
         X_Attribute_Category,
         X_Attribute1,
         X_Attribute2,
         X_Attribute3,
         X_Attribute4,
         X_Attribute5,
         X_Attribute6,
         X_Attribute7,
         X_Attribute8,
         X_Attribute9,
         X_Attribute10,
         X_Attribute11,
         X_Attribute12,
         X_Attribute13,
         X_Attribute14,
         X_Attribute15,
         X_Interest_Rate,
         X_Min_Fc_Balance_Amount,
         X_Min_Fc_Invoice_Amount,
         X_Min_Dunning_Invoice_Amount,
         X_Jgzz_attribute_Category,
         X_Jgzz_attribute1,
         X_Jgzz_attribute2,
         X_Jgzz_attribute3,
         X_Jgzz_attribute4,
         X_Jgzz_attribute5,
         X_Jgzz_attribute6,
         X_Jgzz_attribute7,
         X_Jgzz_attribute8,
         X_Jgzz_attribute9,
         X_Jgzz_attribute10,
         X_Jgzz_attribute11,
         X_Jgzz_attribute12,
         X_Jgzz_attribute13,
         X_Jgzz_attribute14,
         X_Jgzz_attribute15,
         --{Late Charges
         X_EXCHANGE_RATE_TYPE,
         X_MIN_FC_INVOICE_OVERDUE_TYPE,
         X_MIN_FC_INVOICE_PERCENT,
         X_MIN_FC_BALANCE_OVERDUE_TYPE,
         X_MIN_FC_BALANCE_PERCENT,
         X_INTEREST_TYPE       ,
         X_INTEREST_FIXED_AMOUNT,
         X_INTEREST_SCHEDULE_ID,
         X_PENALTY_TYPE        ,
         X_PENALTY_RATE        ,
         X_PENALTY_FIXED_AMOUNT,
         X_PENALTY_SCHEDULE_ID
  );

Line: 1556


END Insert_Negative_Class_Amt;

Line: 1566


  number_in_update number;

Line: 1573


  SELECT count(*), min(profile_class_amount_id) - 1
  INTO   number_in_update, X_Negative_Id
  FROM   HZ_CUST_PROF_CLASS_AMTS
  WHERE  profile_class_amount_id BETWEEN
         (X_Cust_Prof_Class_Amount_Id) * (-100) - 99 AND
         (X_Cust_Prof_Class_Amount_Id) * (-100) - 2;

Line: 1580


 if number_in_update > 0 then
   X_Notify_Flag := 'W';

Line: 1587


PROCEDURE old_amount_insert
(         X_Cust_Prof_Class_Amount_Id      NUMBER,
          X_Negative_Id                    NUMBER,
          X_Customer_Profile_Class_Id      NUMBER
) IS

  CURSOR C is
  select *
  from   hz_cust_prof_class_amts
  where  profile_class_amount_id = X_Cust_Prof_Class_Amount_Id
  FOR UPDATE of profile_class_amount_id NOWAIT;

Line: 1605


      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 1610


  Insert_Negative_Class_Amt
  (
         X_Customer_Profile_Class_Id,
         Amountinfo.created_by,
         Amountinfo.creation_date,
         Amountinfo.currency_code,
         X_Negative_Id,
         Amountinfo.last_updated_by,
         Amountinfo.last_update_date,
         Amountinfo.auto_rec_min_receipt_amount,
         Amountinfo.last_update_login,
         Amountinfo.max_interest_charge,
         Amountinfo.min_dunning_amount,
         Amountinfo.min_statement_amount,
         Amountinfo.overall_credit_limit,
         Amountinfo.trx_credit_limit,
         Amountinfo.attribute_category,
         Amountinfo.attribute1,
         Amountinfo.attribute2,
         Amountinfo.attribute3,
         Amountinfo.attribute4,
         Amountinfo.attribute5,
         Amountinfo.attribute6,
         Amountinfo.attribute7,
         Amountinfo.attribute8,
         Amountinfo.attribute9,
         Amountinfo.attribute10,
         Amountinfo.attribute11,
         Amountinfo.attribute12,
         Amountinfo.attribute13,
         Amountinfo.attribute14,
         Amountinfo.attribute15,
         Amountinfo.interest_rate,
         Amountinfo.min_fc_balance_amount,
         Amountinfo.min_fc_invoice_amount,
         Amountinfo.min_dunning_invoice_amount,
         Amountinfo.jgzz_attribute_category,
         Amountinfo.jgzz_attribute1,
         Amountinfo.jgzz_attribute2,
         Amountinfo.jgzz_attribute3,
         Amountinfo.jgzz_attribute4,
         Amountinfo.jgzz_attribute5,
         Amountinfo.jgzz_attribute6,
         Amountinfo.jgzz_attribute7,
         Amountinfo.jgzz_attribute8,
         Amountinfo.jgzz_attribute9,
         Amountinfo.jgzz_attribute10,
         Amountinfo.jgzz_attribute11,
         Amountinfo.jgzz_attribute12,
         Amountinfo.jgzz_attribute13,
         Amountinfo.jgzz_attribute14,
         Amountinfo.jgzz_attribute15,
         --{Late Charges
         Amountinfo.EXCHANGE_RATE_TYPE,
         Amountinfo.MIN_FC_INVOICE_OVERDUE_TYPE,
         Amountinfo.MIN_FC_INVOICE_PERCENT,
         Amountinfo.MIN_FC_BALANCE_OVERDUE_TYPE,
         Amountinfo.MIN_FC_BALANCE_PERCENT,
         Amountinfo.INTEREST_TYPE       ,
         Amountinfo.INTEREST_FIXED_AMOUNT,
         Amountinfo.INTEREST_SCHEDULE_ID,
         Amountinfo.PENALTY_TYPE        ,
         Amountinfo.PENALTY_RATE        ,
         Amountinfo.PENALTY_FIXED_AMOUNT,
         Amountinfo.PENALTY_SCHEDULE_ID,
         Amountinfo.MIN_INTEREST_CHARGE
    );

Line: 1678


END old_amount_insert;