APPS.CSZ_INTERACTION_PVT SQL Statements

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

Line: 10

   SR_UPDATE CONSTANT VARCHAR(30) := 'Cs Sr Upd';

Line: 157

          SELECT resource_id INTO l_interaction_rec.resource_id FROM jtf_rs_resource_extns  WHERE user_id = p_user_id;

Line: 167

          select FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS') into l_wrap_id from dual;

Line: 178

           select outcome_id, result_id, reason_id into l_outcome_id, l_result_id, l_reason_id from jtf_ih_wrap_ups_vl where wrap_id = l_wrap_id;

Line: 186

        l_action_value := SR_UPDATE;

Line: 189

           SELECT nvl(action_id,0) into l_action_id
           FROM jtf_ih_actions_tl
           WHERE action = l_action_value
           AND rownum < 2;

Line: 196

              Fnd_Message.SET_NAME('CS','Action Id could not be found for SR Update action');

Line: 245

         select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;

Line: 297

   /* logic       :  Update activity to closed, then update*/
   /*                interaction and close media item.     */
   /*------------------------------------------------------*/

   PROCEDURE end_interaction
     ( p_interaction_id           IN   NUMBER,
       p_event                    IN   VARCHAR2,
       p_cust_party_id            IN   NUMBER,
       p_resp_appl_id             IN   NUMBER,
       p_resp_id                  IN   NUMBER,
       p_user_id                  IN   NUMBER,
       p_login_Id                 IN   NUMBER,
       x_return_status            OUT NOCOPY  VARCHAR2,
       x_msg_count                OUT NOCOPY  NUMBER,
       x_msg_data                 OUT NOCOPY  VARCHAR2) as

       l_media_rec       JTF_IH_PUB.media_rec_type;

Line: 356

       select media_id into l_media_id from jtf_ih_activities_vl
       where interaction_id = p_interaction_id;

Line: 374

        l_action_value := SR_UPDATE;

Line: 381

       SELECT nvl(action_id,0) into l_action_id
       FROM jtf_ih_actions_tl
       WHERE action = l_action_value
       AND rownum < 2;

Line: 402

       select action_item_id into l_activity_rec.action_item_id from jtf_ih_action_items_tl where short_description = SR_MODULE;

Line: 415

       JTF_IH_PUB.update_activity(
           l_api_version,
           l_init_msg_list,
           l_commit,
           p_resp_appl_id,
           p_resp_id,
           p_user_id,
           p_login_id,
           l_return_status,
           l_msg_count,
           l_msg_data,
           l_activity_rec,
           l_activity_id );

Line: 445

       SELECT resource_id INTO l_interaction_rec.resource_id FROM jtf_rs_resource_extns  WHERE user_id = p_user_id;

Line: 458

       select FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS') into l_wrap_id from dual;

Line: 471

       select outcome_id, result_id, reason_id into l_outcome_id, l_result_id, l_reason_id from jtf_ih_wrap_ups_vl where wrap_id = l_wrap_id;