APPS.AMS_SCHEDULER_B_PKG SQL Statements

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

Line: 35

PROCEDURE Insert_Row(
          px_scheduler_id   IN OUT NOCOPY NUMBER,
          p_created_by    NUMBER,
          p_creation_date    DATE,
          p_last_updated_by    NUMBER,
          p_last_update_date    DATE,
          p_last_update_login    NUMBER,
          px_object_version_number   IN OUT NOCOPY NUMBER,
          p_object_type    VARCHAR2,
          p_object_id    NUMBER,
          p_frequency    NUMBER,
          p_frequency_type    VARCHAR2)

 IS

   l_last_update_date DATE;

Line: 57

   AMS_UTILITY_PVT.debug_message('ANIRBAN table handler '||p_last_update_date);

Line: 59

   l_last_update_date := p_last_update_date;

Line: 60

   IF p_last_update_date IS NULL
   THEN l_last_update_date := sysdate;

Line: 64

   AMS_UTILITY_PVT.debug_message('ANIRBAN table handler '||l_last_update_date);

Line: 66

   INSERT INTO AMS_SCHEDULER(
           scheduler_id,
           created_by,
           creation_date,
           last_updated_by,
           last_update_date,
           last_update_login,
           object_version_number,
           object_type,
           object_id,
           frequency,
           frequency_type
           ) VALUES (
           DECODE( px_scheduler_id, FND_API.g_miss_num, NULL, px_scheduler_id)
           , DECODE( p_created_by, FND_API.g_miss_num, 1, p_created_by)
           , DECODE( p_creation_date, FND_API.g_miss_date, sysdate, p_creation_date)
           , DECODE( p_last_updated_by, FND_API.g_miss_num, 1, p_last_updated_by)
           , DECODE( p_last_update_date, FND_API.g_miss_date, sysdate, l_last_update_date)
           , DECODE( p_last_update_login, FND_API.g_miss_num, 1, p_last_update_login)
           , DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number)
           , DECODE( p_object_type, FND_API.g_miss_char, NULL, p_object_type)
           , DECODE( p_object_id, FND_API.g_miss_num, NULL, p_object_id)
           , DECODE( p_frequency, FND_API.g_miss_num, NULL, p_frequency)
           , DECODE( p_frequency_type, FND_API.g_miss_char, NULL, p_frequency_type)
           );

Line: 94

END Insert_Row;

Line: 107

PROCEDURE Update_Row(
          p_scheduler_id  NUMBER,
          p_created_by    NUMBER,
          p_creation_date    DATE,
          p_last_updated_by    NUMBER,
          p_last_update_date    DATE,
          p_last_update_login    NUMBER,
          p_object_version_number  NUMBER,
          p_object_type    VARCHAR2,
          p_object_id    NUMBER,
          p_frequency    NUMBER,
          p_frequency_type    VARCHAR2)
 IS
 BEGIN
    Update AMS_SCHEDULER
    SET
              scheduler_id = DECODE( p_scheduler_id, FND_API.g_miss_num, scheduler_id, p_scheduler_id),
              created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
              creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
              last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
              last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
              last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
              object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
              object_type = DECODE( p_object_type, FND_API.g_miss_char, object_type, p_object_type),
              object_id = DECODE( p_object_id, FND_API.g_miss_num, object_id, p_object_id),
              frequency = DECODE( p_frequency, FND_API.g_miss_num, frequency, p_frequency),
              frequency_type = DECODE( p_frequency_type, FND_API.g_miss_char, frequency_type, p_frequency_type)
   WHERE scheduler_id = p_scheduler_id
   AND   object_version_number = p_object_version_number;

Line: 139

END Update_Row;

Line: 152

PROCEDURE Delete_Row(
    p_scheduler_id  NUMBER)

 IS
 BEGIN
   DELETE FROM AMS_SCHEDULER
    WHERE SCHEDULER_ID = p_scheduler_id;

Line: 163

 END Delete_Row ;

Line: 182

        SELECT *
         FROM AMS_SCHEDULER
        WHERE SCHEDULER_ID =  p_scheduler_id
        FOR UPDATE of SCHEDULER_ID NOWAIT;

Line: 192

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