APPS.CAC_VIEW_UTIL_PVT SQL Statements

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

Line: 36

	 SELECT location, dial_in, meeting_mode, meeting_url,
       meeting_id, join_url, playback_url, chat_url, download_url,
       is_standalone_location
	   FROM cac_view_collab_details_vl
	  WHERE task_id = p_source_task_id;

Line: 56

      SELECT cac_view_collab_details_s.nextval
        INTO l_seqnum
       FROM DUAL;

Line: 60

      CAC_VIEW_COLLAB_DETAILS_PKG.INSERT_ROW(
        X_ROWID => l_row_id,
        X_COLLAB_ID => l_seqnum,
        X_TASK_ID => p_target_task_id,
        X_MEETING_MODE => collab_row.meeting_mode,
        X_MEETING_ID => collab_row.meeting_id,
        X_MEETING_URL => collab_row.meeting_url,
        X_JOIN_URL => collab_row.join_url,
        X_PLAYBACK_URL => collab_row.playback_url,
        X_DOWNLOAD_URL => collab_row.download_url,
        X_CHAT_URL => collab_row.chat_url,
        X_IS_STANDALONE_LOCATION => collab_row.is_standalone_location,
        X_LOCATION => collab_row.location,
        X_DIAL_IN => collab_row.dial_in,
        X_CREATION_DATE => SYSDATE,
        X_CREATED_BY => jtf_task_utl.created_by,
        X_LAST_UPDATE_DATE => SYSDATE,
        X_LAST_UPDATED_BY => jtf_task_utl.updated_by,
        X_LAST_UPDATE_LOGIN => fnd_global.login_id);

Line: 90

     * -- Function Name: update_repeat_collab_details
     * -- Description  : This function updates collaboration details record
     * --                for target task_id by copying the data from source
     * --                task_id.
     * -- Parameter    : p_source_task_id = Task Id
     * -- Parameter    : p_target_task_id = Task Id
     * -- Return Type  : VARCHAR2
     * -----------------------------------------------------------------*/
      PROCEDURE update_repeat_collab_details(
       p_source_task_id		IN	 NUMBER,
      p_target_task_id		IN	 NUMBER
   )
   IS
      CURSOR c_collab
      IS
	 SELECT location, dial_in, meeting_mode, meeting_url,
       meeting_id, join_url, playback_url, chat_url, download_url,
       is_standalone_location
	   FROM cac_view_collab_details_vl
	  WHERE task_id = p_source_task_id;

Line: 111

      CURSOR c_collab_update
      IS
	 SELECT collab_id
	   FROM cac_view_collab_details_vl
	  WHERE task_id = p_target_task_id;

Line: 118

     collab_update_row c_collab_update%ROWTYPE;

Line: 123

      SAVEPOINT update_repeat_collab_sp;

Line: 132

      OPEN c_collab_update;

Line: 133

      FETCH c_collab_update INTO collab_update_row;

Line: 135

      IF c_collab_update%NOTFOUND THEN
         CLOSE c_collab_update;

Line: 139

         SELECT cac_view_collab_details_s.nextval
                INTO l_seqnum
         FROM DUAL;

Line: 142

         CAC_VIEW_COLLAB_DETAILS_PKG.INSERT_ROW(
        X_ROWID => l_row_id,
        X_COLLAB_ID => l_seqnum,
        X_TASK_ID => p_target_task_id,
        X_MEETING_MODE => collab_row.meeting_mode,
        X_MEETING_ID => collab_row.meeting_id,
        X_MEETING_URL => collab_row.meeting_url,
        X_JOIN_URL => collab_row.join_url,
        X_PLAYBACK_URL => collab_row.playback_url,
        X_DOWNLOAD_URL => collab_row.download_url,
        X_CHAT_URL => collab_row.chat_url,
        X_IS_STANDALONE_LOCATION => collab_row.is_standalone_location,
        X_LOCATION => collab_row.location,
        X_DIAL_IN => collab_row.dial_in,
        X_CREATION_DATE => SYSDATE,
        X_CREATED_BY => jtf_task_utl.created_by,
        X_LAST_UPDATE_DATE => SYSDATE,
        X_LAST_UPDATED_BY => jtf_task_utl.updated_by,
        X_LAST_UPDATE_LOGIN => fnd_global.login_id);

Line: 163

      CLOSE c_collab_update;

Line: 165

      CAC_VIEW_COLLAB_DETAILS_PKG.UPDATE_ROW (
         X_COLLAB_ID => collab_update_row.collab_id,
         X_TASK_ID => p_target_task_id,
         X_MEETING_MODE => collab_row.meeting_mode,
         X_MEETING_ID => collab_row.meeting_id,
         X_MEETING_URL => collab_row.meeting_url,
         X_JOIN_URL => collab_row.join_url,
         X_PLAYBACK_URL => collab_row.playback_url,
         X_DOWNLOAD_URL => collab_row.download_url,
         X_CHAT_URL => collab_row.chat_url,
         X_IS_STANDALONE_LOCATION => collab_row.is_standalone_location,
         X_LOCATION => collab_row.location,
         X_DIAL_IN => collab_row.dial_in,
         X_LAST_UPDATE_DATE => SYSDATE,
         X_LAST_UPDATED_BY => jtf_task_utl.updated_by,
         X_LAST_UPDATE_LOGIN => fnd_global.login_id
         );

Line: 185

        ROLLBACK TO update_repeat_collab_sp;

Line: 251

       SELECT meaning
         FROM fnd_lookups
        WHERE lookup_type = 'CAC_VIEW_REMINDER_UOM'
          AND lookup_code = b_lookup_code
          AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
                                 AND TRUNC(NVL(end_date_active, SYSDATE));

Line: 516

       SELECT meaning
         FROM fnd_lookups
        WHERE lookup_type = 'CAC_VIEW_DURATION'
          AND lookup_code = b_lookup_code
          AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
                                 AND TRUNC(NVL(end_date_active, SYSDATE));