APPS.IGR_IN_JTF_INTERACTIONS_PKG SQL Statements

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

Line: 14

    SELECT resource_id
    FROM jtf_rs_resource_extns
    WHERE user_id = Igr_in_jtf_interactions_pkg.g_user_id;

Line: 23

    SELECT outcome_id, short_description
    FROM jtf_ih_outcomes_vl
    WHERE outcome_code = l_outcome;

Line: 28

    SELECT result_id, short_description
    FROM jtf_ih_results_vl
    WHERE result_code = l_result;

Line: 33

    SELECT reason_id, short_description
    FROM jtf_ih_reasons_vl
    WHERE reason_code = l_reason;

Line: 148

   SELECT person_number
   FROM   igs_pe_person_base_v
   WHERE  person_id = p_person_id;

Line: 221

   SELECT action_id
   FROM jtf_ih_actions_vl
   WHERE action = p_action;

Line: 226

   SELECT action_item_id
   FROM jtf_ih_action_items_vl
   WHERE action_item = p_action_item;

Line: 305

PROCEDURE update_activity(p_activity_id            IN NUMBER,
			  p_action_id              IN VARCHAR2,
			  p_Action_item_id         IN VARCHAR2,
			  p_doc_source_object_name IN VARCHAR2,
			  p_outcome_id             IN NUMBER,
			  p_result_id              IN NUMBER,
			  p_reason_id              IN NUMBER,
                          p_ret_status             OUT NOCOPY VARCHAR2,
                          p_msg_data               OUT NOCOPY VARCHAR2,
                          p_msg_count              OUT NOCOPY NUMBER ) IS

   l_activity_rec               jtf_ih_pub.activity_rec_type := jtf_ih_pub.init_activity_rec;

Line: 341

      JTF_IH_PUB.update_activity(p_api_version    => Igr_in_jtf_interactions_pkg.g_api_version,
				 p_init_msg_list  => Igr_in_jtf_interactions_pkg.g_true,
				 p_commit         => Igr_in_jtf_interactions_pkg.g_false,
				 p_resp_appl_id   => Igr_in_jtf_interactions_pkg.g_resp_appl_id,
				 p_resp_id        => Igr_in_jtf_interactions_pkg.g_resp_id,
				 p_user_id        => Igr_in_jtf_interactions_pkg.g_user_id,
				 p_login_id       => Igr_in_jtf_interactions_pkg.g_login_id,
				 x_return_status  => l_return_status,
				 x_msg_count      => l_msg_count,
				 x_msg_data       => l_msg_data,
				 p_activity_rec   => l_activity_rec);

Line: 360

END update_activity;

Line: 379

   SELECT active, outcome_id, reason_id, result_id
   FROM jtf_ih_interactions
   WHERE interaction_id = Igr_in_jtf_interactions_pkg.g_int_id;

Line: 425

	    -- Activity cannot be updated since there is no active interaction
	    FND_MESSAGE.SET_NAME('IGS','IGS_AD_JTF_CLS_INT_FLD');