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

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

Line: 7


PROCEDURE Insert_schedule_Row
(P_SCHEDULE_ID            IN  NUMBER,
 P_SCHEDULE_NAME          IN  VARCHAR2,
 P_SCHEDULE_DESCRIPTION   IN  VARCHAR2,
 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_OBJECT_VERSION_NUMBER  IN  NUMBER,
 x_return_status          IN  OUT NOCOPY VARCHAR2)
IS
BEGIN
 arp_standard.debug('Insert_schedule_Row +');

Line: 32


  INSERT INTO AR_CHARGE_SCHEDULES
  (SCHEDULE_ID       ,
   SCHEDULE_NAME     ,
   SCHEDULE_DESCRIPTION,
   ATTRIBUTE_CATEGORY,
   ATTRIBUTE1        ,
   ATTRIBUTE2        ,
   ATTRIBUTE3        ,
   ATTRIBUTE4        ,
   ATTRIBUTE5        ,
   ATTRIBUTE6        ,
   ATTRIBUTE7        ,
   ATTRIBUTE8        ,
   ATTRIBUTE9        ,
   ATTRIBUTE10       ,
   ATTRIBUTE11       ,
   ATTRIBUTE12       ,
   ATTRIBUTE13       ,
   ATTRIBUTE14       ,
   ATTRIBUTE15       ,
   OBJECT_VERSION_NUMBER,
   CREATED_BY        ,
   CREATION_DATE     ,
   LAST_UPDATED_BY   ,
   LAST_UPDATE_DATE  ,
   LAST_UPDATE_LOGIN)
  VALUES
  (P_SCHEDULE_ID       ,
   P_SCHEDULE_NAME     ,
   DECODE(P_SCHEDULE_DESCRIPTION,FND_API.G_MISS_CHAR,NULL,P_SCHEDULE_DESCRIPTION),
   DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
   DECODE(P_ATTRIBUTE1        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
   DECODE(P_ATTRIBUTE2        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
   DECODE(P_ATTRIBUTE3        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
   DECODE(P_ATTRIBUTE4        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
   DECODE(P_ATTRIBUTE5        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
   DECODE(P_ATTRIBUTE6        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
   DECODE(P_ATTRIBUTE7        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
   DECODE(P_ATTRIBUTE8        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
   DECODE(P_ATTRIBUTE9        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
   DECODE(P_ATTRIBUTE10       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
   DECODE(P_ATTRIBUTE11       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
   DECODE(P_ATTRIBUTE12       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
   DECODE(P_ATTRIBUTE13       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
   DECODE(P_ATTRIBUTE14       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
   DECODE(P_ATTRIBUTE15       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
   p_object_version_number,
   NVL(FND_GLOBAL.user_id,-1),
   TRUNC(SYSDATE),
   NVL(FND_GLOBAL.user_id,-1),
   TRUNC(SYSDATE),
   NVL(FND_GLOBAL.login_id,-1));

Line: 85


 arp_standard.debug('Insert_schedule_Row -');

Line: 90


     FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);

Line: 92


END Insert_schedule_Row;

Line: 96


PROCEDURE Update_schedule_Row
(P_SCHEDULE_ID            IN  NUMBER,
 P_SCHEDULE_DESCRIPTION   IN  VARCHAR2,
 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,
 X_OBJECT_VERSION_NUMBER  IN  OUT NOCOPY NUMBER,
 x_return_status          IN  OUT NOCOPY VARCHAR2)
IS
BEGIN
 arp_standard.debug('Insert_schedule_Row +');

Line: 120


  UPDATE AR_CHARGE_SCHEDULES SET
    SCHEDULE_DESCRIPTION = DECODE(P_SCHEDULE_DESCRIPTION,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , SCHEDULE_DESCRIPTION, P_SCHEDULE_DESCRIPTION  ),
    ATTRIBUTE_CATEGORY    = DECODE(P_ATTRIBUTE_CATEGORY,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
    ATTRIBUTE1            = DECODE(P_ATTRIBUTE1,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE1, P_ATTRIBUTE1),
    ATTRIBUTE2            = DECODE(P_ATTRIBUTE2,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE2, P_ATTRIBUTE2),
    ATTRIBUTE3            = DECODE(P_ATTRIBUTE3,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE3, P_ATTRIBUTE3),
    ATTRIBUTE4            = DECODE(P_ATTRIBUTE4,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE4, P_ATTRIBUTE4),
    ATTRIBUTE5            = DECODE(P_ATTRIBUTE5,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE5, P_ATTRIBUTE5),
    ATTRIBUTE6            = DECODE(P_ATTRIBUTE6,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE6, P_ATTRIBUTE6),
    ATTRIBUTE7            = DECODE(P_ATTRIBUTE7,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE7, P_ATTRIBUTE7),
    ATTRIBUTE8            = DECODE(P_ATTRIBUTE8,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE8, P_ATTRIBUTE8),
    ATTRIBUTE9            = DECODE(P_ATTRIBUTE9,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE9, P_ATTRIBUTE9),
    ATTRIBUTE10           = DECODE(P_ATTRIBUTE10,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE10, P_ATTRIBUTE10),
    ATTRIBUTE11           = DECODE(P_ATTRIBUTE11,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE11, P_ATTRIBUTE11),
    ATTRIBUTE12           = DECODE(P_ATTRIBUTE12,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE12, P_ATTRIBUTE12),
    ATTRIBUTE13           = DECODE(P_ATTRIBUTE13,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE13, P_ATTRIBUTE13),
    ATTRIBUTE14           = DECODE(P_ATTRIBUTE14,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE14, P_ATTRIBUTE14),
    ATTRIBUTE15           = DECODE(P_ATTRIBUTE15,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE15, P_ATTRIBUTE15),
    OBJECT_VERSION_NUMBER   = OBJECT_VERSION_NUMBER + 1,
    LAST_UPDATE_DATE        = TRUNC(SYSDATE),
    LAST_UPDATED_BY         = NVL(FND_GLOBAL.user_id,-1),
    LAST_UPDATE_LOGIN       = NVL(FND_GLOBAL.login_id,-1)
 WHERE SCHEDULE_ID = P_SCHEDULE_ID
 RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;

Line: 178


 arp_standard.debug('Insert_schedule_Row -');

Line: 183


     FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_schedule_Row:'||SQLERRM);

Line: 185


END Update_schedule_Row;

Line: 192


PROCEDURE Insert_Head_Row
(P_SCHEDULE_HEADER_ID     IN NUMBER,
 P_SCHEDULE_ID            IN NUMBER,
 P_SCHEDULE_HEADER_TYPE   IN VARCHAR2,
 P_AGING_BUCKET_ID        IN NUMBER,
 P_START_DATE             IN DATE,
 P_END_DATE               IN DATE,
 P_STATUS                 IN VARCHAR2,
 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_OBJECT_VERSION_NUMBER  IN NUMBER,
 x_return_status          IN OUT NOCOPY VARCHAR2)
IS
BEGIN
 arp_standard.debug('Insert_Head_Row +');

Line: 221


  INSERT INTO AR_charge_SCHEDULE_HDRS
  (SCHEDULE_HEADER_ID,
   SCHEDULE_ID       ,
   SCHEDULE_HEADER_TYPE,
   AGING_BUCKET_ID   ,
   START_DATE        ,
   END_DATE          ,
   STATUS            ,
   ATTRIBUTE_CATEGORY,
   ATTRIBUTE1        ,
   ATTRIBUTE2        ,
   ATTRIBUTE3        ,
   ATTRIBUTE4        ,
   ATTRIBUTE5        ,
   ATTRIBUTE6        ,
   ATTRIBUTE7        ,
   ATTRIBUTE8        ,
   ATTRIBUTE9        ,
   ATTRIBUTE10       ,
   ATTRIBUTE11       ,
   ATTRIBUTE12       ,
   ATTRIBUTE13       ,
   ATTRIBUTE14       ,
   ATTRIBUTE15       ,
   OBJECT_VERSION_NUMBER,
   CREATED_BY        ,
   CREATION_DATE     ,
   LAST_UPDATED_BY   ,
   LAST_UPDATE_DATE  ,
   LAST_UPDATE_LOGIN)
  VALUES
  (P_SCHEDULE_HEADER_ID  ,
   P_SCHEDULE_ID         ,
   P_SCHEDULE_HEADER_TYPE,
   P_AGING_BUCKET_ID     ,
   P_START_DATE          ,
   DECODE(P_END_DATE   ,FND_API.G_MISS_DATE,NULL,P_END_DATE),
   P_STATUS              ,
   DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
   DECODE(P_ATTRIBUTE1        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
   DECODE(P_ATTRIBUTE2        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
   DECODE(P_ATTRIBUTE3        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
   DECODE(P_ATTRIBUTE4        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
   DECODE(P_ATTRIBUTE5        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
   DECODE(P_ATTRIBUTE6        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
   DECODE(P_ATTRIBUTE7        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
   DECODE(P_ATTRIBUTE8        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
   DECODE(P_ATTRIBUTE9        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
   DECODE(P_ATTRIBUTE10       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
   DECODE(P_ATTRIBUTE11       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
   DECODE(P_ATTRIBUTE12       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
   DECODE(P_ATTRIBUTE13       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
   DECODE(P_ATTRIBUTE14       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
   DECODE(P_ATTRIBUTE15       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
   P_OBJECT_VERSION_NUMBER,
   NVL(FND_GLOBAL.user_id,-1),
   TRUNC(SYSDATE),
   NVL(FND_GLOBAL.user_id,-1),
   TRUNC(SYSDATE),
   NVL(FND_GLOBAL.login_id,-1));

Line: 282


 arp_standard.debug('Insert_Head_Row -');

Line: 287


     FND_MESSAGE.SET_TOKEN('ERROR' ,'Insert_Head_Row:'||SQLERRM);

Line: 289


END Insert_Head_Row;

Line: 300


PROCEDURE Update_Head_Row
(P_SCHEDULE_HEADER_ID     IN NUMBER,
 P_END_DATE               IN DATE,
 P_STATUS                 IN VARCHAR2,
 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,
 x_OBJECT_VERSION_NUMBER  OUT NOCOPY NUMBER,
 x_return_status          IN OUT NOCOPY VARCHAR2)
IS
BEGIN
 arp_standard.debug('Update_Head_Row +');

Line: 326


 UPDATE ar_charge_schedule_hdrs SET
    END_DATE              = DECODE(P_END_DATE,
                                     FND_API.G_MISS_DATE, NULL,
                                     NULL               , END_DATE, P_END_DATE    ),
    STATUS                = DECODE(P_STATUS,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , STATUS, P_STATUS    ),
    ATTRIBUTE_CATEGORY    = DECODE(P_ATTRIBUTE_CATEGORY,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
    ATTRIBUTE1            = DECODE(P_ATTRIBUTE1,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE1, P_ATTRIBUTE1),
    ATTRIBUTE2            = DECODE(P_ATTRIBUTE2,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE2, P_ATTRIBUTE2),
    ATTRIBUTE3            = DECODE(P_ATTRIBUTE3,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE3, P_ATTRIBUTE3),
    ATTRIBUTE4            = DECODE(P_ATTRIBUTE4,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE4, P_ATTRIBUTE4),
    ATTRIBUTE5            = DECODE(P_ATTRIBUTE5,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE5, P_ATTRIBUTE5),
    ATTRIBUTE6            = DECODE(P_ATTRIBUTE6,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE6, P_ATTRIBUTE6),
    ATTRIBUTE7            = DECODE(P_ATTRIBUTE7,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE7, P_ATTRIBUTE7),
    ATTRIBUTE8            = DECODE(P_ATTRIBUTE8,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE8, P_ATTRIBUTE8),
    ATTRIBUTE9            = DECODE(P_ATTRIBUTE9,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE9, P_ATTRIBUTE9),
    ATTRIBUTE10           = DECODE(P_ATTRIBUTE10,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE10, P_ATTRIBUTE10),
    ATTRIBUTE11           = DECODE(P_ATTRIBUTE11,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE11, P_ATTRIBUTE11),
    ATTRIBUTE12           = DECODE(P_ATTRIBUTE12,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE12, P_ATTRIBUTE12),
    ATTRIBUTE13           = DECODE(P_ATTRIBUTE13,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE13, P_ATTRIBUTE13),
    ATTRIBUTE14           = DECODE(P_ATTRIBUTE14,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE14, P_ATTRIBUTE14),
    ATTRIBUTE15           = DECODE(P_ATTRIBUTE15,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE15, P_ATTRIBUTE15),
    OBJECT_VERSION_NUMBER   = OBJECT_VERSION_NUMBER + 1,
    LAST_UPDATE_DATE        = TRUNC(SYSDATE),
    LAST_UPDATED_BY         = NVL(FND_GLOBAL.user_id,-1),
    LAST_UPDATE_LOGIN       = NVL(FND_GLOBAL.login_id,-1)
 WHERE SCHEDULE_HEADER_ID = P_SCHEDULE_HEADER_ID
 RETURNING OBJECT_VERSION_NUMBER INTO x_OBJECT_VERSION_NUMBER;

Line: 388


 arp_standard.debug('Update_Head_Row -');

Line: 393


     FND_MESSAGE.SET_TOKEN('ERROR' ,'Update_Head_Row:'||SQLERRM);

Line: 395


END Update_Head_Row;

Line: 402


PROCEDURE Insert_Line_Row
(P_SCHEDULE_LINE_ID       IN NUMBER,
 P_SCHEDULE_HEADER_ID     IN NUMBER,
 P_SCHEDULE_ID            IN NUMBER,
 P_AGING_BUCKET_ID        IN NUMBER,
 P_AGING_BUCKET_LINE_ID   IN NUMBER,
 P_AMOUNT                 IN NUMBER,
 P_RATE                   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_OBJECT_VERSION_NUMBER  IN NUMBER,
 x_return_status          IN OUT NOCOPY VARCHAR2)
IS
BEGIN
 arp_standard.debug('Insert_Line_Row +');

Line: 431


  INSERT INTO AR_charge_SCHEDULE_LINES
  (SCHEDULE_LINE_ID   ,
   SCHEDULE_HEADER_ID ,
   SCHEDULE_ID        ,
   AGING_BUCKET_ID    ,
   AGING_BUCKET_LINE_ID,
   AMOUNT             ,
   RATE               ,
   ATTRIBUTE_CATEGORY ,
   ATTRIBUTE1         ,
   ATTRIBUTE2         ,
   ATTRIBUTE3         ,
   ATTRIBUTE4         ,
   ATTRIBUTE5         ,
   ATTRIBUTE6         ,
   ATTRIBUTE7         ,
   ATTRIBUTE8         ,
   ATTRIBUTE9         ,
   ATTRIBUTE10        ,
   ATTRIBUTE11        ,
   ATTRIBUTE12        ,
   ATTRIBUTE13        ,
   ATTRIBUTE14        ,
   ATTRIBUTE15        ,
   OBJECT_VERSION_NUMBER,
   CREATED_BY         ,
   CREATION_DATE      ,
   LAST_UPDATED_BY    ,
   LAST_UPDATE_DATE   ,
   LAST_UPDATE_LOGIN)
  VALUES
  (P_SCHEDULE_LINE_ID   ,
   P_SCHEDULE_HEADER_ID ,
   P_SCHEDULE_ID        ,
   P_AGING_BUCKET_ID    ,
   P_AGING_BUCKET_LINE_ID,
   DECODE(P_AMOUNT, FND_API.G_MISS_NUM, NULL, P_AMOUNT),
   DECODE(P_RATE  , FND_API.G_MISS_NUM, NULL, P_RATE  ),
   DECODE(P_ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE_CATEGORY),
   DECODE(P_ATTRIBUTE1        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE1),
   DECODE(P_ATTRIBUTE2        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE2),
   DECODE(P_ATTRIBUTE3        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE3),
   DECODE(P_ATTRIBUTE4        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE4),
   DECODE(P_ATTRIBUTE5        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE5),
   DECODE(P_ATTRIBUTE6        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE6),
   DECODE(P_ATTRIBUTE7        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE7),
   DECODE(P_ATTRIBUTE8        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE8),
   DECODE(P_ATTRIBUTE9        ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE9),
   DECODE(P_ATTRIBUTE10       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE10),
   DECODE(P_ATTRIBUTE11       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE11),
   DECODE(P_ATTRIBUTE12       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE12),
   DECODE(P_ATTRIBUTE13       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE13),
   DECODE(P_ATTRIBUTE14       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE14),
   DECODE(P_ATTRIBUTE15       ,FND_API.G_MISS_CHAR,NULL,P_ATTRIBUTE15),
   P_OBJECT_VERSION_NUMBER,
   NVL(FND_GLOBAL.user_id,-1),
   TRUNC(SYSDATE),
   NVL(FND_GLOBAL.user_id,-1),
   TRUNC(SYSDATE),
   NVL(FND_GLOBAL.login_id,-1));

Line: 492


 arp_standard.debug('Insert_Line_Row -');

Line: 499


END Insert_Line_Row;

Line: 502


PROCEDURE update_Line_Row
(P_SCHEDULE_LINE_ID       IN NUMBER,
 P_AMOUNT                 IN NUMBER,
 P_RATE                   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,
 X_OBJECT_VERSION_NUMBER  IN OUT NOCOPY NUMBER,
 x_return_status          IN OUT NOCOPY VARCHAR2)
IS
BEGIN
 arp_standard.debug('Update_Line_Row +');

Line: 528


  UPDATE AR_charge_SCHEDULE_LINES SET
   AMOUNT             = DECODE(p_amount,
                                 fnd_api.g_miss_num, NULL,
                                 NULL              ,AMOUNT,p_amount),
   RATE               = DECODE(p_rate,
                                 fnd_api.g_miss_num, NULL,
                                 NULL              ,RATE,p_rate),
    ATTRIBUTE_CATEGORY    = DECODE(P_ATTRIBUTE_CATEGORY,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE_CATEGORY, P_ATTRIBUTE_CATEGORY),
    ATTRIBUTE1            = DECODE(P_ATTRIBUTE1,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE1, P_ATTRIBUTE1),
    ATTRIBUTE2            = DECODE(P_ATTRIBUTE2,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE2, P_ATTRIBUTE2),
    ATTRIBUTE3            = DECODE(P_ATTRIBUTE3,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE3, P_ATTRIBUTE3),
    ATTRIBUTE4            = DECODE(P_ATTRIBUTE4,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE4, P_ATTRIBUTE4),
    ATTRIBUTE5            = DECODE(P_ATTRIBUTE5,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE5, P_ATTRIBUTE5),
    ATTRIBUTE6            = DECODE(P_ATTRIBUTE6,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE6, P_ATTRIBUTE6),
    ATTRIBUTE7            = DECODE(P_ATTRIBUTE7,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE7, P_ATTRIBUTE7),
    ATTRIBUTE8            = DECODE(P_ATTRIBUTE8,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE8, P_ATTRIBUTE8),
    ATTRIBUTE9            = DECODE(P_ATTRIBUTE9,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE9, P_ATTRIBUTE9),
    ATTRIBUTE10           = DECODE(P_ATTRIBUTE10,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE10, P_ATTRIBUTE10),
    ATTRIBUTE11           = DECODE(P_ATTRIBUTE11,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE11, P_ATTRIBUTE11),
    ATTRIBUTE12           = DECODE(P_ATTRIBUTE12,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE12, P_ATTRIBUTE12),
    ATTRIBUTE13           = DECODE(P_ATTRIBUTE13,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE13, P_ATTRIBUTE13),
    ATTRIBUTE14           = DECODE(P_ATTRIBUTE14,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE14, P_ATTRIBUTE14),
    ATTRIBUTE15           = DECODE(P_ATTRIBUTE15,
                                     FND_API.G_MISS_CHAR, NULL,
                                     NULL               , ATTRIBUTE15, P_ATTRIBUTE15),
    OBJECT_VERSION_NUMBER   = X_OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE        = TRUNC(SYSDATE),
    LAST_UPDATED_BY         = NVL(FND_GLOBAL.user_id,-1),
    LAST_UPDATE_LOGIN       = NVL(FND_GLOBAL.login_id,-1)
  WHERE SCHEDULE_LINE_ID = P_SCHEDULE_LINE_ID;

Line: 590


 arp_standard.debug('Update_Line_Row -');

Line: 597


END Update_Line_Row;

Line: 609


  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: 671


  IF p_mode = 'INSERT' THEN
    IF p_schedule_name IS NULL OR p_schedule_name = FND_API.G_MISS_CHAR THEN
       FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

Line: 697


  SELECT NULL
    FROM ar_charge_schedules
   WHERE schedule_id = p_schedule_id;

Line: 702


  SELECT NULL
    FROM ar_aging_buckets
   WHERE aging_bucket_id = P_AGING_BUCKET_ID;

Line: 707


  SELECT start_date,
         end_date
    FROM ar_charge_schedule_hdrs
   WHERE schedule_id = p_schedule_id
     AND status      = 'A';

Line: 714


  SELECT start_date,
         end_date
    FROM ar_charge_schedule_hdrs
   WHERE schedule_id = p_schedule_id
     AND schedule_header_id <> P_SCHEDULE_HEADER_ID
     AND status      = 'A';

Line: 731


  IF p_mode IN ('INSERT') THEN
    -------------------------------------
    -- Validate schedule_id
    -------------------------------------
    arp_standard.debug('  Validate schedule_id +');

Line: 885


  IF p_mode IN ('UPDATE') THEN
    -------------------------------------------------------------
    -- Validate STATUS lookup code in lookup type REGISTRY_STATUS
    -------------------------------------------------------------
    arp_standard.debug('  Validate status +');

Line: 984


 SELECT aging_bucket_id,
        schedule_id,
        schedule_header_id
   FROM ar_charge_schedule_hdrs
  WHERE schedule_header_id = p_schedule_header_id;

Line: 994


 SELECT NULL
   FROM ar_aging_buckets        a,
        ar_aging_bucket_lines_b b
  WHERE a.aging_bucket_id = p_aging_bucket_id
    AND a.status          = 'A'
    AND a.aging_bucket_id = b.aging_bucket_id
    AND b.aging_bucket_line_id = p_aging_bucket_line_id;

Line: 1007


 SELECT NULL
   FROM ar_charge_schedule_lines
  WHERE schedule_header_id      = p_SCHEDULE_HEADER_ID
    AND aging_bucket_id         = p_aging_bucket_id
    AND aging_bucket_line_id    = p_aging_bucket_line_id;

Line: 1014


 SELECT lookup_code
   FROM ar_charge_schedule_hdrs a,
        ar_lookups                  b
  WHERE a.schedule_header_id  = P_SCHEDULE_HEADER_ID
    AND b.lookup_type         = 'SCHEDULE_HEADER_TYPE'
    AND b.lookup_code         = a.schedule_header_type;

Line: 1217


  SELECT ar_charge_schedules_s.nextval
    FROM DUAL;

Line: 1240


   p_mode                  => 'INSERT',
   x_return_status         => x_return_status);

Line: 1254


  Insert_schedule_Row
  (P_SCHEDULE_ID         => l_schedule_id,
   P_SCHEDULE_NAME       => P_SCHEDULE_NAME,
   P_SCHEDULE_DESCRIPTION=> P_SCHEDULE_DESCRIPTION,
   P_ATTRIBUTE_CATEGORY  => P_ATTRIBUTE_CATEGORY,
   P_ATTRIBUTE1          => P_ATTRIBUTE1,
   P_ATTRIBUTE2          => P_ATTRIBUTE2,
   P_ATTRIBUTE3          => P_ATTRIBUTE3,
   P_ATTRIBUTE4          => P_ATTRIBUTE4,
   P_ATTRIBUTE5          => P_ATTRIBUTE5,
   P_ATTRIBUTE6          => P_ATTRIBUTE6,
   P_ATTRIBUTE7          => P_ATTRIBUTE7,
   P_ATTRIBUTE8          => P_ATTRIBUTE8,
   P_ATTRIBUTE9          => P_ATTRIBUTE9,
   P_ATTRIBUTE10         => P_ATTRIBUTE10,
   P_ATTRIBUTE11         => P_ATTRIBUTE11,
   P_ATTRIBUTE12         => P_ATTRIBUTE12,
   P_ATTRIBUTE13         => P_ATTRIBUTE13,
   P_ATTRIBUTE14         => P_ATTRIBUTE14,
   P_ATTRIBUTE15         => P_ATTRIBUTE15,
   P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
   x_return_status       => x_return_status);

Line: 1309


PROCEDURE update_schedule
(p_init_msg_list         IN  VARCHAR2 := fnd_api.g_false,
 P_SCHEDULE_ID           IN  NUMBER,
 P_SCHEDULE_DESCRIPTION  IN  VARCHAR2,
 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,
 X_OBJECT_VERSION_NUMBER IN  OUT NOCOPY NUMBER,
 x_return_status         OUT NOCOPY VARCHAR2,
 x_msg_count             OUT NOCOPY NUMBER,
 x_msg_data              OUT NOCOPY VARCHAR2)
IS
  CURSOR c IS
  SELECT SCHEDULE_ID        ,
         SCHEDULE_NAME      ,
         SCHEDULE_DESCRIPTION,
         ATTRIBUTE_CATEGORY ,
         ATTRIBUTE1         ,
         ATTRIBUTE2         ,
         ATTRIBUTE3         ,
         ATTRIBUTE4         ,
         ATTRIBUTE5         ,
         ATTRIBUTE6         ,
         ATTRIBUTE7         ,
         ATTRIBUTE8         ,
         ATTRIBUTE9         ,
         ATTRIBUTE10        ,
         ATTRIBUTE11        ,
         ATTRIBUTE12        ,
         ATTRIBUTE13        ,
         ATTRIBUTE14        ,
         ATTRIBUTE15        ,
         OBJECT_VERSION_NUMBER
    FROM ar_charge_schedules
   WHERE schedule_id = P_SCHEDULE_ID
   FOR UPDATE NOWAIT;

Line: 1360


  arp_standard.debug('update_schedule +');

Line: 1364


  SAVEPOINT  update_schedule;

Line: 1422


   p_mode                  => 'UPDATE',
   x_return_status         => x_return_status);

Line: 1429


  Update_schedule_row
    (P_SCHEDULE_ID          => P_SCHEDULE_ID,
     P_SCHEDULE_DESCRIPTION => P_SCHEDULE_DESCRIPTION,
     P_ATTRIBUTE_CATEGORY   => P_ATTRIBUTE_CATEGORY,
     P_ATTRIBUTE1           => P_ATTRIBUTE1,
     P_ATTRIBUTE2           => P_ATTRIBUTE2,
     P_ATTRIBUTE3           => p_attribute3,
     P_ATTRIBUTE4           => p_attribute4,
     P_ATTRIBUTE5           => p_attribute5,
     P_ATTRIBUTE6           => p_attribute6,
     P_ATTRIBUTE7           => p_attribute7,
     P_ATTRIBUTE8           => p_attribute8,
     P_ATTRIBUTE9           => p_attribute9,
     P_ATTRIBUTE10          => p_attribute10,
     P_ATTRIBUTE11          => p_attribute11,
     P_ATTRIBUTE12          => p_attribute12,
     P_ATTRIBUTE13          => p_attribute13,
     P_ATTRIBUTE14          => p_attribute14,
     P_ATTRIBUTE15          => p_attribute15,
     X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
     x_return_status        => x_return_status);

Line: 1455


  arp_standard.debug('Update_schedule -');

Line: 1459


     ROLLBACK TO Update_schedule;

Line: 1464


     arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);

Line: 1467


     ROLLBACK TO Update_schedule;

Line: 1476


     arp_standard.debug('EXCEPTION Update_schedule:'||x_msg_data);

Line: 1514


  SELECT ar_charge_schedule_hdrs_s.nextval
    FROM DUAL;

Line: 1542


   p_mode                   => 'INSERT',
   x_return_status          => x_return_status);

Line: 1554


  Insert_Head_Row
  (P_SCHEDULE_HEADER_ID  => l_header_id,
   P_SCHEDULE_ID         => p_schedule_id,
   P_SCHEDULE_HEADER_TYPE => P_SCHEDULE_HEADER_TYPE,
   P_AGING_BUCKET_ID     => P_AGING_BUCKET_ID,
   P_START_DATE          => p_start_date,
   P_END_DATE            => p_end_date,
   P_STATUS              => P_STATUS,
   P_ATTRIBUTE_CATEGORY  => P_ATTRIBUTE_CATEGORY,
   P_ATTRIBUTE1          => P_ATTRIBUTE1,
   P_ATTRIBUTE2          => P_ATTRIBUTE2,
   P_ATTRIBUTE3          => P_ATTRIBUTE3,
   P_ATTRIBUTE4          => P_ATTRIBUTE4,
   P_ATTRIBUTE5          => P_ATTRIBUTE5,
   P_ATTRIBUTE6          => P_ATTRIBUTE6,
   P_ATTRIBUTE7          => P_ATTRIBUTE7,
   P_ATTRIBUTE8          => P_ATTRIBUTE8,
   P_ATTRIBUTE9          => P_ATTRIBUTE9,
   P_ATTRIBUTE10         => P_ATTRIBUTE10,
   P_ATTRIBUTE11         => P_ATTRIBUTE11,
   P_ATTRIBUTE12         => P_ATTRIBUTE12,
   P_ATTRIBUTE13         => P_ATTRIBUTE13,
   P_ATTRIBUTE14         => P_ATTRIBUTE14,
   P_ATTRIBUTE15         => P_ATTRIBUTE15,
   P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER,
   x_return_status       => x_return_status);

Line: 1613


PROCEDURE Update_schedule_header
(p_init_msg_list          IN VARCHAR2 := fnd_api.g_false,
 P_SCHEDULE_HEADER_ID     IN NUMBER,
 P_END_DATE               IN DATE,
 P_STATUS                 IN VARCHAR2,
 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,
 X_OBJECT_VERSION_NUMBER  IN OUT NOCOPY NUMBER,
 x_return_status          OUT NOCOPY VARCHAR2,
 x_msg_count              OUT NOCOPY NUMBER,
 x_msg_data               OUT NOCOPY VARCHAR2)
IS
  CURSOR c IS
  SELECT SCHEDULE_ID        ,
         SCHEDULE_HEADER_ID ,
         SCHEDULE_HEADER_TYPE,
         AGING_BUCKET_ID    ,
         START_DATE         ,
         END_DATE           ,
         ATTRIBUTE_CATEGORY ,
         ATTRIBUTE1         ,
         ATTRIBUTE2         ,
         ATTRIBUTE3         ,
         ATTRIBUTE4         ,
         ATTRIBUTE5         ,
         ATTRIBUTE6         ,
         ATTRIBUTE7         ,
         ATTRIBUTE8         ,
         ATTRIBUTE9         ,
         ATTRIBUTE10        ,
         ATTRIBUTE11        ,
         ATTRIBUTE12        ,
         ATTRIBUTE13        ,
         ATTRIBUTE14        ,
         ATTRIBUTE15        ,
         OBJECT_VERSION_NUMBER,
         STATUS
    FROM ar_charge_schedule_hdrs
   WHERE schedule_header_id = P_SCHEDULE_HEADER_ID
   FOR UPDATE NOWAIT;

Line: 1670


  arp_standard.debug('Update_schedule_header +');

Line: 1675


  savepoint Update_schedule_header;

Line: 1743


    p_mode                   => 'UPDATE',
    x_return_status          => x_return_status);

Line: 1751


   Update_Head_Row
    (P_SCHEDULE_HEADER_ID   => l_rec.SCHEDULE_HEADER_ID,
     P_END_DATE             => p_end_date,
     P_STATUS               => P_STATUS,
     P_ATTRIBUTE_CATEGORY   => P_ATTRIBUTE_CATEGORY,
     P_ATTRIBUTE1           => P_ATTRIBUTE1,
     P_ATTRIBUTE2           => P_ATTRIBUTE2,
     P_ATTRIBUTE3           => p_attribute3,
     P_ATTRIBUTE4           => p_attribute4,
     P_ATTRIBUTE5           => p_attribute5,
     P_ATTRIBUTE6           => p_attribute6,
     P_ATTRIBUTE7           => p_attribute7,
     P_ATTRIBUTE8           => p_attribute8,
     P_ATTRIBUTE9           => p_attribute9,
     P_ATTRIBUTE10          => p_attribute10,
     P_ATTRIBUTE11          => p_attribute11,
     P_ATTRIBUTE12          => p_attribute12,
     P_ATTRIBUTE13          => p_attribute13,
     P_ATTRIBUTE14          => p_attribute14,
     P_ATTRIBUTE15          => p_attribute15,
     X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
     x_return_status        => x_return_status);

Line: 1778


  arp_standard.debug('Update_schedule_header -');

Line: 1782


     ROLLBACK TO Update_schedule_header;

Line: 1787


     arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);

Line: 1790


     ROLLBACK TO Update_schedule_header;

Line: 1799


     arp_standard.debug('EXCEPTION Update_schedule_header:'||x_msg_data);

Line: 1835


  SELECT ar_charge_schedule_lines_s.NEXTVAL
    FROM dual;

Line: 1863


   P_MODE                   => 'INSERT',
   x_return_status          => x_return_status);

Line: 1876


  Insert_Line_Row
   (P_SCHEDULE_LINE_ID       => l_line_id,
    P_SCHEDULE_HEADER_ID     => P_SCHEDULE_HEADER_ID,
    P_SCHEDULE_ID            => P_SCHEDULE_ID,
    P_AGING_BUCKET_ID        => P_AGING_BUCKET_ID,
    P_AGING_BUCKET_LINE_ID   => P_AGING_BUCKET_LINE_ID,
    P_AMOUNT                 => P_AMOUNT,
    P_RATE                   => P_RATE,
    P_ATTRIBUTE_CATEGORY     => P_ATTRIBUTE_CATEGORY,
    P_ATTRIBUTE1             => P_ATTRIBUTE1,
    P_ATTRIBUTE2             => P_ATTRIBUTE2,
    P_ATTRIBUTE3             => P_ATTRIBUTE3,
    P_ATTRIBUTE4             => P_ATTRIBUTE4,
    P_ATTRIBUTE5             => P_ATTRIBUTE5,
    P_ATTRIBUTE6             => P_ATTRIBUTE6,
    P_ATTRIBUTE7             => P_ATTRIBUTE7,
    P_ATTRIBUTE8             => P_ATTRIBUTE8,
    P_ATTRIBUTE9             => P_ATTRIBUTE9,
    P_ATTRIBUTE10            => P_ATTRIBUTE10,
    P_ATTRIBUTE11            => P_ATTRIBUTE11,
    P_ATTRIBUTE12            => P_ATTRIBUTE12,
    P_ATTRIBUTE13            => P_ATTRIBUTE13,
    P_ATTRIBUTE14            => P_ATTRIBUTE14,
    P_ATTRIBUTE15            => P_ATTRIBUTE15,
    P_OBJECT_VERSION_NUMBER  => P_OBJECT_VERSION_NUMBER,
    x_return_status          => x_return_status);

Line: 1933


PROCEDURE Update_schedule_line
(p_init_msg_list          IN VARCHAR2 := fnd_api.g_false,
 P_SCHEDULE_line_ID       IN NUMBER,
 P_amount                 IN NUMBER,
 P_rate                   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,
 X_OBJECT_VERSION_NUMBER  IN OUT NOCOPY NUMBER,
 x_return_status          OUT NOCOPY VARCHAR2,
 x_msg_count              OUT NOCOPY NUMBER,
 x_msg_data               OUT NOCOPY VARCHAR2)
IS
  CURSOR c IS
  SELECT SCHEDULE_ID        ,
         SCHEDULE_HEADER_ID ,
         schedule_line_id   ,
         amount       ,
         rate         ,
         ATTRIBUTE_CATEGORY ,
         ATTRIBUTE1         ,
         ATTRIBUTE2         ,
         ATTRIBUTE3         ,
         ATTRIBUTE4         ,
         ATTRIBUTE5         ,
         ATTRIBUTE6         ,
         ATTRIBUTE7         ,
         ATTRIBUTE8         ,
         ATTRIBUTE9         ,
         ATTRIBUTE10        ,
         ATTRIBUTE11        ,
         ATTRIBUTE12        ,
         ATTRIBUTE13        ,
         ATTRIBUTE14        ,
         ATTRIBUTE15        ,
         OBJECT_VERSION_NUMBER
    FROM ar_charge_schedule_lines
   WHERE schedule_line_id = P_SCHEDULE_LINE_ID
   FOR UPDATE NOWAIT;

Line: 1988


  arp_standard.debug('Update_schedule_line +');

Line: 1994


  savepoint Update_schedule_line;

Line: 2059


   P_MODE                   => 'UPDATE',
   x_return_status          => x_return_status);

Line: 2067


   Update_line_Row
    (P_SCHEDULE_line_ID   => l_rec.SCHEDULE_line_ID,
     P_amount             => p_amount,
     P_rate               => P_rate,
     P_ATTRIBUTE_CATEGORY   => P_ATTRIBUTE_CATEGORY,
     P_ATTRIBUTE1           => P_ATTRIBUTE1,
     P_ATTRIBUTE2           => P_ATTRIBUTE2,
     P_ATTRIBUTE3           => p_attribute3,
     P_ATTRIBUTE4           => p_attribute4,
     P_ATTRIBUTE5           => p_attribute5,
     P_ATTRIBUTE6           => p_attribute6,
     P_ATTRIBUTE7           => p_attribute7,
     P_ATTRIBUTE8           => p_attribute8,
     P_ATTRIBUTE9           => p_attribute9,
     P_ATTRIBUTE10          => p_attribute10,
     P_ATTRIBUTE11          => p_attribute11,
     P_ATTRIBUTE12          => p_attribute12,
     P_ATTRIBUTE13          => p_attribute13,
     P_ATTRIBUTE14          => p_attribute14,
     P_ATTRIBUTE15          => p_attribute15,
     X_OBJECT_VERSION_NUMBER=> X_OBJECT_VERSION_NUMBER,
     x_return_status        => x_return_status);

Line: 2094


  arp_standard.debug('Update_schedule_line -');

Line: 2098


     ROLLBACK TO Update_schedule_line;

Line: 2103


     arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);

Line: 2106


     ROLLBACK TO Update_schedule_header;

Line: 2115


     arp_standard.debug('EXCEPTION Update_schedule_line:'||x_msg_data);