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.AMS_CAL_CRT_PVT SQL Statements

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

Line: 86


      SELECT ams_calendar_criteria_s.NEXTVAL
      FROM dual;

Line: 89


      SELECT 1
      FROM ams_calendar_criteria
      WHERE criteria_id = l_id;

Line: 134


           l_cal_crt_rec_rec.last_update_date      := SYSDATE;

Line: 135


           l_cal_crt_rec_rec.last_updated_by       := FND_GLOBAL.user_id;

Line: 138


           l_cal_crt_rec_rec.last_update_login     := FND_GLOBAL.conc_login_id;

Line: 177


      Ams_Cal_Crt_Pkg.Insert_Row(
          px_criteria_id  => l_criteria_id,
          p_object_type_code  => l_cal_crt_rec_rec.object_type_code,
          p_custom_setup_id  => l_cal_crt_rec_rec.custom_setup_id,
          p_activity_type_code  => l_cal_crt_rec_rec.activity_type_code,
          p_activity_id  => l_cal_crt_rec_rec.activity_id,
          p_status_id  => l_cal_crt_rec_rec.status_id,
          p_priority_id  => l_cal_crt_rec_rec.priority_id,
          p_object_id  => l_cal_crt_rec_rec.object_id,
          p_criteria_start_date  => l_cal_crt_rec_rec.criteria_start_date,
          p_criteria_end_date  => l_cal_crt_rec_rec.criteria_end_date,
          p_criteria_deleted  => l_cal_crt_rec_rec.criteria_deleted,
          p_criteria_enabled  => l_cal_crt_rec_rec.criteria_enabled,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_creation_date  => SYSDATE,
          p_created_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.conc_login_id,
          px_object_version_number  => l_object_version_number
);

Line: 289


PROCEDURE Update_Cal_Crt(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN  NUMBER       := FND_API.G_VALID_LEVEL_FULL,

    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_cal_crt_rec_rec               IN    cal_crt_rec_rec_type
    )
 IS
CURSOR c_get_cal_crt(criteria_id NUMBER) IS
    SELECT *
    FROM  ams_calendar_criteria
    WHERE  criteria_id = p_cal_crt_rec_rec.criteria_id;

Line: 306


L_API_NAME                  CONSTANT VARCHAR2(30) := 'Update_Cal_Crt';

Line: 316


      SAVEPOINT update_cal_crt_pvt;

Line: 339


   l_tar_cal_crt_rec_rec.last_update_date      := SYSDATE;

Line: 340


   l_tar_cal_crt_rec_rec.last_updated_by       := FND_GLOBAL.user_id;

Line: 341


   l_tar_cal_crt_rec_rec.last_update_login     := FND_GLOBAL.conc_login_id;

Line: 345


   AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_deleted: ' || l_tar_cal_crt_rec_rec.criteria_deleted);

Line: 352


      AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

Line: 354


      IF ( (l_tar_cal_crt_rec_rec.criteria_deleted = 'Y') AND (l_tar_cal_crt_rec_rec.criteria_enabled = 'Y') ) THEN
   x_return_status := FND_API.g_ret_sts_error;

Line: 358


      FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_ENABLED_DELETE');

Line: 366


     AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
     p_token_name   => 'INFO',
     p_token_value  => 'Cal_Crt'
     ) ;

Line: 383


    p_token_value  => 'Last_Update_Date') ;

Line: 406


            p_validation_mode => JTF_PLSQL_API.g_update,
            p_cal_crt_rec_rec  =>  l_tar_cal_crt_rec_rec,
            x_return_status    => x_return_status,
            x_msg_count        => x_msg_count,
            x_msg_data         => x_msg_data);

Line: 419


   AMS_UTILITY_PVT.debug_message('Calling Table Handler Update');

Line: 422


   Ams_Cal_Crt_Pkg.Update_Row(
          p_criteria_id  => l_tar_cal_crt_rec_rec.criteria_id,
          p_object_type_code  => l_tar_cal_crt_rec_rec.object_type_code,
          p_custom_setup_id  => l_tar_cal_crt_rec_rec.custom_setup_id,
          p_activity_type_code  => l_tar_cal_crt_rec_rec.activity_type_code,
          p_activity_id  => l_tar_cal_crt_rec_rec.activity_id,
          p_status_id  => l_tar_cal_crt_rec_rec.status_id,
          p_priority_id  => l_tar_cal_crt_rec_rec.priority_id,
          p_object_id  => l_tar_cal_crt_rec_rec.object_id,
          p_criteria_start_date  => l_tar_cal_crt_rec_rec.criteria_start_date,
          p_criteria_end_date  => l_tar_cal_crt_rec_rec.criteria_end_date,
          p_criteria_deleted  => l_tar_cal_crt_rec_rec.criteria_deleted,
          p_criteria_enabled  => l_tar_cal_crt_rec_rec.criteria_enabled,
          p_last_update_date  => SYSDATE,
          p_last_updated_by  => FND_GLOBAL.USER_ID,
          p_last_update_login  => FND_GLOBAL.conc_login_id,
          p_object_version_number  => l_tar_cal_crt_rec_rec.object_version_number
     );

Line: 467


     ROLLBACK TO UPDATE_Cal_Crt_PVT;

Line: 477


     ROLLBACK TO UPDATE_Cal_Crt_PVT;

Line: 486


     ROLLBACK TO UPDATE_Cal_Crt_PVT;

Line: 498


End Update_Cal_Crt;

Line: 533


PROCEDURE Delete_Cal_Crt(
    p_api_version_number         IN   NUMBER,
    p_init_msg_list              IN   VARCHAR2     := FND_API.G_FALSE,
    p_commit                     IN   VARCHAR2     := FND_API.G_FALSE,
    p_validation_level           IN   NUMBER       := FND_API.G_VALID_LEVEL_FULL,
    x_return_status              OUT NOCOPY  VARCHAR2,
    x_msg_count                  OUT NOCOPY  NUMBER,
    x_msg_data                   OUT NOCOPY  VARCHAR2,
    p_criteria_id                   IN  NUMBER,
    p_object_version_number      IN   NUMBER
    )

 IS
L_API_NAME                  CONSTANT VARCHAR2(30) := 'Delete_Cal_Crt';

Line: 551


      SAVEPOINT delete_cal_crt_pvt;

Line: 578


      AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

Line: 581


      Ams_Cal_Crt_Pkg.Delete_Row(
          p_criteria_id  => p_criteria_id,
          p_object_version_number => p_object_version_number     );

Line: 608


     ROLLBACK TO DELETE_Cal_Crt_PVT;

Line: 617


     ROLLBACK TO DELETE_Cal_Crt_PVT;

Line: 627


     ROLLBACK TO DELETE_Cal_Crt_PVT;

Line: 639


End Delete_Cal_Crt;

Line: 779


      SELECT 'X'
      FROM ams_calendar_criteria
      WHERE  ( criteria_deleted = 'N'
        AND object_type_code = p_cal_crt_rec_rec.object_type_code
        AND DECODE(custom_setup_id, null, 1,
            DECODE(p_cal_crt_rec_rec.custom_setup_id, null, 0, p_cal_crt_rec_rec.custom_setup_id)) =
            DECODE(custom_setup_id, null, 1, custom_setup_id)
        AND DECODE(activity_type_code, null, '1',
            DECODE(p_cal_crt_rec_rec.activity_type_code, null, 'xxx', p_cal_crt_rec_rec.activity_type_code)) =
            DECODE(activity_type_code, null, '1', activity_type_code)
        AND DECODE(activity_id, null, 1,
            DECODE(p_cal_crt_rec_rec.activity_id, null, 0, p_cal_crt_rec_rec.activity_id)) =
            DECODE(activity_id, null, 1, activity_id)
        AND DECODE(status_id, null, 1,
            DECODE(p_cal_crt_rec_rec.status_id, null, 0, p_cal_crt_rec_rec.status_id)) =
            DECODE(status_id, null, 1, status_id)
        AND DECODE(priority_id, null, '1',
            DECODE(p_cal_crt_rec_rec.priority_id, null, 'xxx', p_cal_crt_rec_rec.priority_id)) =
            DECODE(priority_id, null, '1', priority_id)
        AND DECODE(object_id, null, 1,
            DECODE(p_cal_crt_rec_rec.object_id, null, 0, p_cal_crt_rec_rec.object_id)) =
            DECODE(object_id, null, 1, object_id)
        AND DECODE(criteria_start_date, null, SYSDATE,
            DECODE(p_cal_crt_rec_rec.criteria_start_date, null, (SYSDATE - 1000000), p_cal_crt_rec_rec.criteria_start_date)) >=
            DECODE(criteria_start_date, null, SYSDATE, criteria_start_date)
        AND DECODE(criteria_end_date, null, SYSDATE, nvl(p_cal_crt_rec_rec.criteria_end_date,
            (SYSDATE + 1000000))) <= nvl(criteria_end_date, SYSDATE)
--        AND DECODE(criteria_end_date, null, SYSDATE, DECODE(p_cal_crt_rec_rec.criteria_end_date, null, (SYSDATE + 1000000),
         --p_cal_crt_rec_rec.criteria_end_date)) <= DECODE(criteria_end_date, null, SYSDATE, criteria_end_date)
        );

Line: 866


      IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM OR p_cal_crt_rec_rec.last_update_login IS NULL THEN
               AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

Line: 881


      IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN
               AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

Line: 981


      SELECT *
      FROM ams_calendar_criteria
      WHERE criteria_id = p_cal_crt_rec_rec.criteria_id;

Line: 1039


   IF p_cal_crt_rec_rec.criteria_deleted IS NULL THEN
      x_complete_rec.criteria_deleted := l_cal_crt_rec_rec.criteria_deleted;

Line: 1048


   IF p_cal_crt_rec_rec.last_update_date IS NULL THEN
      x_complete_rec.last_update_date := l_cal_crt_rec_rec.last_update_date;

Line: 1052


   IF p_cal_crt_rec_rec.last_updated_by IS NULL THEN
      x_complete_rec.last_updated_by := l_cal_crt_rec_rec.last_updated_by;

Line: 1065


   IF p_cal_crt_rec_rec.last_update_login IS NULL THEN
      x_complete_rec.last_update_login := l_cal_crt_rec_rec.last_update_login;

Line: 1094


   IF p_cal_crt_rec_rec.criteria_deleted IS NULL THEN
      x_cal_crt_rec_rec.criteria_enabled := 'N';