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

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

Line: 34


        x_totaldeleted  OUT NOCOPY NUMBER,
        x_data          OUT NOCOPY cac_sync_task.task_tbl,
        x_exclusion_data  OUT NOCOPY cac_sync_task.exclusion_tbl,
        x_attendee_data     OUT NOCOPY Cac_Sync_Task.attendee_tbl
     )
     IS
        -- Added a group calendar feature
        -- Used to store the list of group resource ids for the current resource
        l_resources  cac_sync_task_common.resource_list_tbl;

Line: 55


      SELECT a.assignee_role, a.assignment_status_id,
                 a.resource_id, a.resource_type_code
      FROM   jtf_task_all_assignments a
      WHERE  a.task_id = b_task_id;

Line: 62


        Select resource_id,
        source_phone, source_email, source_job_title,
        source_first_name, source_middle_name, source_last_name
      from
       JTF_RS_RESOURCE_EXTNS
      where
       resource_id =b_resource_id;

Line: 72


       Select
       cp.party_id,
       pp.person_first_name,
       pp.person_middle_name,
       pp.person_last_name,
       cp.primary_phone_country_code,
       cp.primary_phone_area_code,
       cp.primary_phone_number,
       cp.primary_phone_extension,
       cp.email_address,
       ctct.job_title
      from
       HZ_PARTIES pp, HZ_PARTIES cp, HZ_RELATIONSHIPS rel, HZ_ORG_CONTACTS ctct
       where cp.party_id = rel.party_id
       and rel.relationship_id = ctct.party_relationship_id
       and rel.subject_id = pp.party_id
       and rel.directional_flag = 'F'
       and cp.party_id =b_resource_id;

Line: 109


        x_totaldeleted := 0;

Line: 188


           cac_sync_task_common.get_all_deleted_tasks(
               p_request_type       => p_request_type,
               p_syncanchor         => l_syncanchor,
               p_recordindex        => nvl(x_data.count,0) + 1,
               p_resource_id        => g_login_resource_id,
               p_principal_id       => p_principal_id,
               p_resource_type      => l_resource_type,
               p_source_object_type => l_source_object_type,
               p_get_data           => p_get_data,
               --p_new_syncanchor     => l_new_syncanchor,
               x_totaldeleted       => x_totaldeleted,
               x_data               => x_data
           );

Line: 360


        x_totaldeleted  OUT NOCOPY NUMBER
     )
     IS
        l_syncanchor    DATE;

Line: 371


        x_totaldeleted  := 0;

Line: 379


           p_sync_type     => 'IS',  --it will not delete the booking data,only on get list we will delete booking data
           x_totalnew      => x_totalnew,
           x_totalmodified => x_totalmodified,
           x_totaldeleted  => x_totaldeleted,
           x_data          => l_data,
           x_exclusion_data => l_exclusion_data,
           x_attendee_data  => l_attendee_data
        );

Line: 387


        x_total := x_totalnew + x_totalmodified + x_totaldeleted;

Line: 407


        l_totaldeleted  NUMBER;

Line: 420


           x_totaldeleted  => l_totaldeleted,
           x_data          => l_data,
           x_exclusion_data => x_exclusion_data,
           x_attendee_data  => x_attendee_data
           );

Line: 437


           SELECT jta_sync_task_mapping_s.nextval
             INTO x_results (i).syncid
             FROM DUAL;

Line: 444


     PROCEDURE update_data (p_tasks      IN OUT NOCOPY cac_sync_task.task_tbl
                           ,p_exclusions IN OUT NOCOPY cac_sync_task.exclusion_tbl)
     IS
         l_resource_id        NUMBER;

Line: 463


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'sync id ' ||p_tasks(i).syncId||' for task name '|| p_tasks(i).subject);

Line: 464


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'task id ' ||p_tasks(i).task_id||' for task name '|| p_tasks(i).subject);

Line: 465


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'objectcode ' ||p_tasks(i).objectCode||' for task name '|| p_tasks(i).objectCode);

Line: 466


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'subject ' ||p_tasks(i).subject||' for task name '|| p_tasks(i).subject);

Line: 467


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'description ' ||p_tasks(i).description||' for task name '|| p_tasks(i).subject);

Line: 469


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'dateSelected ' ||p_tasks(i).dateSelected||' for task name '|| p_tasks(i).subject);

Line: 470


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'plannedStartDate ' ||p_tasks(i).plannedStartDate||' for task name '|| p_tasks(i).subject);

Line: 471


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'plannedEndDate ' ||p_tasks(i).plannedEndDate||' for task name '|| p_tasks(i).objectCode);

Line: 472


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'scheduledStartDate ' ||p_tasks(i).scheduledStartDate||' for task name '|| p_tasks(i).subject);

Line: 473


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'scheduledEndDate ' ||p_tasks(i).scheduledEndDate||' for task name '|| p_tasks(i).subject);

Line: 475


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'actualStartDate ' ||p_tasks(i).actualStartDate||' for task name '|| p_tasks(i).subject);

Line: 476


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'actualendDate ' ||p_tasks(i).actualendDate||' for task name '|| p_tasks(i).subject);

Line: 477


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'statusId ' ||p_tasks(i).statusId||' for task name '|| p_tasks(i).objectCode);

Line: 478


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'priorityId ' ||p_tasks(i).priorityId||' for task name '|| p_tasks(i).subject);

Line: 479


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'alarmFlag ' ||p_tasks(i).alarmFlag||' for task name '|| p_tasks(i).subject);

Line: 481


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'alarmDate ' ||p_tasks(i).alarmDate||' for task name '|| p_tasks(i).subject);

Line: 482


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'privateFlag ' ||p_tasks(i).privateFlag||' for task name '|| p_tasks(i).subject);

Line: 483


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'catgory ' ||p_tasks(i).category||' for task name '|| p_tasks(i).objectCode);

Line: 484


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'resource Id ' ||p_tasks(i).resourceId||' for task name '|| p_tasks(i).subject);

Line: 485


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'resourc type ' ||p_tasks(i).resourceType||' for task name '|| p_tasks(i).subject);

Line: 487


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'assignemtn id ' ||p_tasks(i).task_assignment_id||' for task name '|| p_tasks(i).subject);

Line: 488


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'result id ' ||p_tasks(i).resultId||' for task name '|| p_tasks(i).subject);

Line: 489


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'resultSystemMessage ' ||p_tasks(i).resultSystemMessage||' for task name '|| p_tasks(i).objectCode);

Line: 490


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'unit_of_measure ' ||p_tasks(i).unit_of_measure||' for task name '|| p_tasks(i).subject);

Line: 492


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'occurs_which ' ||p_tasks(i).occurs_which||' for task name '|| p_tasks(i).subject);

Line: 493


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'occurs every ' ||p_tasks(i).occurs_every ||' for task name '|| p_tasks(i).subject);

Line: 494


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'date of month ' ||p_tasks(i).date_of_month||' for task name '|| p_tasks(i).subject);

Line: 495


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'locations ' ||p_tasks(i).locations||' for task name '|| p_tasks(i).objectCode);

Line: 496


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'principal id ' ||p_tasks(i).principal_id||' for task name '|| p_tasks(i).subject);

Line: 497


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'free busy type ' ||p_tasks(i).free_busy_type||' for task name '|| p_tasks(i).subject);

Line: 498


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'dial in ' ||p_tasks(i).dial_in||' for task name '|| p_tasks(i).subject);

Line: 500


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'sunday ' ||p_tasks(i).sunday ||' for task name '|| p_tasks(i).subject);

Line: 501


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'monday ' ||p_tasks(i).monday||' for task name '|| p_tasks(i).subject);

Line: 502


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'tuesday ' ||p_tasks(i).tuesday||' for task name '|| p_tasks(i).subject);

Line: 503


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'wednesday ' ||p_tasks(i).wednesday||' for task name '|| p_tasks(i).subject);

Line: 504


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'thursday ' ||p_tasks(i).thursday||' for task name '|| p_tasks(i).subject);

Line: 505


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'friday ' ||p_tasks(i).friday||' for task name '|| p_tasks(i).subject);

Line: 506


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_dataa', 'saturday ' ||p_tasks(i).saturday||' for task name '|| p_tasks(i).subject);

Line: 507


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'date_of_month ' ||p_tasks(i).date_of_month||' for task name '|| p_tasks(i).subject);

Line: 508


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'unit_of_measure ' ||p_tasks(i).unit_of_measure||' for task name '|| p_tasks(i).subject);

Line: 509


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'start_date ' ||p_tasks(i).start_date||' for task name '|| p_tasks(i).subject);

Line: 510


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'end_date ' ||p_tasks(i).end_date||' for task name '|| p_tasks(i).subject);

Line: 543


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'recurrence rule is same so calling update_existing_data');

Line: 546


                    cac_sync_task_common.update_existing_data( p_task_rec      => p_tasks(i)
                                                             , p_exclusion_tbl => p_exclusions
                                                             , p_resource_id   => l_resource_id
                                                             , p_resource_type => l_resource_type);

Line: 563


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'calling delete_task and then create task inside update_data');

Line: 566


                 cac_sync_task_common.delete_task_data (p_task_rec=>p_tasks(i));

Line: 584


    FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'cac_sync_task.update_data', 'updating sync mapping after deletion and creation of data');

Line: 587


              UPDATE jta_sync_task_mapping
               SET task_sync_id      = l_old_sync_id,
                   last_update_date  = sysdate,
                   last_updated_by   = fnd_global.user_id,
                   last_update_login = fnd_global.login_id

                  WHERE    task_id = l_new_task_id
                   and   principal_id = l_principal_id;

Line: 622


    END update_data;

Line: 624


     PROCEDURE delete_data (
        p_tasks        IN OUT NOCOPY cac_sync_task.task_tbl
     )
     IS
        l_task_id NUMBER;

Line: 629


        l_delete_flag VARCHAR2(1);

Line: 656


               cac_sync_task_common.check_delete_data(
                      p_task_id     => l_task_id,
                      p_resource_id => l_resource_id,
                      p_objectcode  => l_source_object_type_code,
                      x_status_id   => l_status_id,
                      x_delete_flag => l_delete_flag);

Line: 663


               IF l_delete_flag = 'D'
               THEN


                   cac_sync_task_common.delete_task_data(p_task_rec => p_tasks(i));

Line: 669


               ELSIF l_delete_flag = 'U'

               THEN

                   cac_sync_task_common.reject_task_data(p_task_rec => p_tasks(i));

Line: 675


               ELSE -- l_delete_flag = 'X'


                   p_tasks (i).syncanchor := cac_sync_task_common.convert_server_to_gmt (SYSDATE);

Line: 683


               END IF; -- l_delete_flag

Line: 701


   END delete_data;