APPS.CAC_SYNC_TASK_MAP_PKG SQL Statements

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

Line: 11

 |   - This package is used to insert/update/delete sync task            |
 |                      mapping record.                                  |
 |                                                                       |
 | NOTES                                                                 |
 |                                                                       |
 | Date          Developer        Change                                 |
 | ------        ---------------  -------------------------------------- |
 | 18-Jan-2002   gjashnan         Created.                               |
 | 22-Feb-2002   cjang            Refactoring                            |
 | 11-Mar-2002   cjang            Bug Fix update_row to update task_id   |
 |                                Remove task_id = p_task_id             |
 |                                   in update_row()                     |
 | 09-May-2002   cjang            Removed the obsolete columns in insert_row
 +======================================================================*/
   PROCEDURE insert_row (
      p_task_sync_id IN NUMBER,
      p_task_id      IN NUMBER,
      p_resource_id  IN NUMBER,
      p_principal_id  IN NUMBER
   )
   IS
      l_current_date DATE := SYSDATE;

Line: 36

      INSERT INTO jta_sync_task_mapping
      (task_sync_id,
       task_id,
       created_by,
       creation_date,
       last_updated_by,
       last_update_date,
       last_update_login,
       resource_id,
       principal_id
      )
      VALUES
      (p_task_sync_id,
       p_task_id,
       l_user_id,
       l_current_date,
       l_user_id,
       l_current_date,
       l_login_id,
       p_resource_id,
       p_principal_id
      );

Line: 58

   END insert_row;

Line: 60

   PROCEDURE update_row (
      p_task_sync_id IN NUMBER,
      p_task_id      IN NUMBER,
      p_resource_id  IN NUMBER,
      p_principal_id IN NUMBER
   )
   IS
      l_current_date DATE := SYSDATE;

Line: 71

      UPDATE jta_sync_task_mapping
         SET resource_id       = p_resource_id,
             task_sync_id      = p_task_sync_id,
             task_id           = p_task_id,
             last_update_date  = l_current_date,
             last_updated_by   = l_user_id,
             last_update_login = l_login_id,
             principal_id    = p_principal_id
       WHERE task_sync_id = p_task_sync_id;

Line: 80

   END update_row;

Line: 82

   PROCEDURE delete_row (
      p_task_sync_id IN NUMBER
   )
   IS
   BEGIN
      DELETE
        FROM jta_sync_task_mapping
       WHERE task_sync_id = p_task_sync_id;

Line: 90

   END delete_row;