APPS.JTF_IH_PUB_PS SQL Statements

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

Line: 59

   	     SELECT count(*) into l_count
         FROM fnd_application
         WHERE application_id = p_int_val_rec.handler_id;

Line: 80

   	     SELECT count(*) into l_count
         FROM hz_parties
         WHERE party_id = p_int_val_rec.party_id;

Line: 101

   	     SELECT count(*) into l_count
         FROM jtf_rs_resource_extns
         WHERE resource_id = p_int_val_rec.resource_id;

Line: 122

   	     SELECT count(*) into l_count
         FROM jtf_ih_outcomes_B
         WHERE outcome_id = p_int_val_rec.outcome_id;

Line: 139

   	     SELECT count(*) into l_count
         FROM jtf_ih_results_B
         WHERE result_id = p_int_val_rec.result_id;

Line: 156

   	     SELECT count(*) into l_count
         FROM jtf_ih_reasons_B
         WHERE reason_id = p_int_val_rec.reason_id;

Line: 172

   	     SELECT count(*) into l_count
         FROM jtf_ih_scripts
         WHERE script_id = p_int_val_rec.script_id;

Line: 189

   	     SELECT count(*) into l_count
         FROM ams_source_codes
         WHERE source_code_id = p_int_val_rec.source_code_id;

Line: 205

   	     SELECT count(*) into l_count
         FROM jtf_ih_interactions
         WHERE interaction_id = p_int_val_rec.parent_id;

Line: 388

   	     SELECT count(*) into l_count
         FROM jtf_ih_interactions
         WHERE interaction_id = p_act_val_rec.interaction_id;

Line: 409

   	     SELECT count(*) into l_count
         FROM jtf_ih_action_items_b
         WHERE action_item_id = p_act_val_rec.action_item_id;

Line: 425

   	     SELECT count(*) into l_count
         FROM jtf_ih_outcomes_B
         WHERE outcome_id = p_act_val_rec.outcome_id;

Line: 443

   	     SELECT count(*) into l_count
         FROM jtf_ih_actions_b
         WHERE action_id = p_act_val_rec.action_id;

Line: 458

   	     SELECT count(*) into l_count
         FROM jtf_ih_results_B
         WHERE result_id = p_act_val_rec.result_id;

Line: 475

   	     SELECT count(*) into l_count
         FROM jtf_ih_reasons_B
         WHERE reason_id = p_act_val_rec.reason_id;

Line: 492

   	     SELECT count(*) into l_count
         FROM ams_source_codes
         WHERE source_code_id = p_act_val_rec.source_code_id;

Line: 508

   	     SELECT count(*) into l_count
         FROM jtf_ih_media_items
         WHERE media_id = p_act_val_rec.media_id;

Line: 583

   	     SELECT count(*) into l_count
         FROM jtf_ih_sources
         WHERE source_id = p_media_item_val.source_id;

Line: 659

		SELECT count(*) into l_count
		FROM fnd_application
		WHERE application_id = p_media_lc_rec.handler_id;

Line: 676

		SELECT count(*) into l_count
		FROM jtf_ih_media_items
		WHERE media_id = p_media_lc_rec.media_id;

Line: 822

    SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;

Line: 825

		insert into jtf_ih_Media_Items
		(
			 DURATION,
			 DIRECTION,
			 END_DATE_TIME,
			 SOURCE_ITEM_CREATE_DATE_TIME,
			 INTERACTION_PERFORMED,
			 SOURCE_ITEM_ID,
			 START_DATE_TIME,
			 MEDIA_ID,
			 SOURCE_ID,
			 MEDIA_ITEM_TYPE,
			 CREATED_BY,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 LAST_UPDATE_DATE,
			 LAST_UPDATE_LOGIN,
			 MEDIA_ITEM_REF,
			 MEDIA_DATA
		) values (
			 l_int_val_rec.duration,
			 l_int_val_rec.direction,
			 l_int_val_rec.end_date_time,
			 l_int_val_rec.source_item_create_date_time,
			 l_int_val_rec.interaction_performed,
			 l_int_val_rec.source_item_id,
			 l_int_val_rec.start_date_time,
			 l_int_val_rec.media_id,
			 l_int_val_rec.source_id,
			 l_int_val_rec.media_item_type,
			 p_user_id,
			 SysDate,
			 p_user_id,
			 SysDate,
			 p_login_id,
			 l_int_val_rec.media_item_ref,
			 l_int_val_rec.media_data
			 );

Line: 878

        SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_mlcs(idx).milcs_id FROM dual;

Line: 881

				insert into jtf_ih_media_item_lc_segs
				(
					 START_DATE_TIME,
					 TYPE_TYPE,
					 TYPE_ID,
					 DURATION,
					 END_DATE_TIME,
					 MILCS_ID,
					 MILCS_TYPE_ID,
					 MEDIA_ID,
					 HANDLER_ID,
					 CREATED_BY,
					 CREATION_DATE,
					 LAST_UPDATED_BY,
					 LAST_UPDATE_DATE,
					 LAST_UPDATE_LOGIN
 					)
					values
				  (
				   l_mlcs(idx).start_date_time,
				   l_mlcs(idx).type_type,
					 l_mlcs(idx).type_id,
					 l_mlcs(idx).duration,
					 l_mlcs(idx).end_date_time,
					 l_mlcs(idx).milcs_id,
					 l_mlcs(idx).milcs_type_id,
					 l_int_val_rec.media_id,
					 l_mlcs(idx).handler_id,
					 p_user_id,
					 Sysdate,
					 p_user_id,
					 Sysdate,
					 p_login_id
					);

Line: 1029

    SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;

Line: 1032

	insert into jtf_ih_Media_Items
		(
			 DURATION,
			 DIRECTION,
			 END_DATE_TIME,
			 SOURCE_ITEM_CREATE_DATE_TIME,
			 INTERACTION_PERFORMED,
			 SOURCE_ITEM_ID,
			 START_DATE_TIME,
			 MEDIA_ID,
			 SOURCE_ID,
			 MEDIA_ITEM_TYPE,
			 CREATED_BY,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 LAST_UPDATE_DATE,
			 LAST_UPDATE_LOGIN,
			 MEDIA_ITEM_REF,
			 MEDIA_DATA
		) values (
			 p_media_rec.duration,
			 p_media_rec.direction,
			 p_media_rec.end_date_time,
			 p_media_rec.source_item_create_date_time,
			 p_media_rec.interaction_performed,
			 p_media_rec.source_item_id,
			 p_media_rec.start_date_time,
			 l_media_id,
			 p_media_rec.source_id,
			 p_media_rec.media_item_type,
			 p_user_id,
			 SysDate,
			 p_user_id,
			 SysDate,
			 p_login_id,
			 p_media_rec.media_item_ref,
			 p_media_rec.media_data
		);

Line: 1070

	----DBMS_OUTPUT.PUT_LINE('PAST Insert data in JTF_IH_PUB_PS.Create_MediaItem');

Line: 1183

    SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_milcs_id FROM dual;

Line: 1186

	insert into jtf_ih_media_item_lc_segs
	(
			 START_DATE_TIME,
			 TYPE_TYPE,
			 TYPE_ID,
			 DURATION,
			 END_DATE_TIME,
			 MILCS_ID,
			 MILCS_TYPE_ID,
			 MEDIA_ID,
			 HANDLER_ID,
			 RESOURCE_ID,
			 CREATED_BY,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 LAST_UPDATE_DATE,
			 LAST_UPDATE_LOGIN
 	)
	values
	(
			p_media_lc_rec.start_date_time,
			p_media_lc_rec.type_type,
			p_media_lc_rec.type_id,
			p_media_lc_rec.duration,
			p_media_lc_rec.end_date_time,
			l_milcs_id,
			p_media_lc_rec.milcs_type_id,
			p_media_lc_rec.media_id,
			p_media_lc_rec.handler_id,
			p_media_lc_rec.resource_id,
			p_user_id,
			Sysdate,
			p_user_id,
			Sysdate,
			p_login_id
	);

Line: 1222

	--DBMS_OUTPUT.PUT_LINE('PAST insert data in JTF_IH_PUB_PS.Create_MediaLifecycle');

Line: 1339

        SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;

Line: 1343

		INSERT INTO jtf_ih_Interactions
	 	(
			 CREATED_BY,
			 REFERENCE_FORM,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 DURATION,
			 LAST_UPDATE_DATE,
			 LAST_UPDATE_LOGIN,
			 END_DATE_TIME,
			 FOLLOW_UP_ACTION,
			 NON_PRODUCTIVE_TIME_AMOUNT,
			 RESULT_ID,
			 REASON_ID,
			 START_DATE_TIME,
			 OUTCOME_ID,
			 PREVIEW_TIME_AMOUNT,
			 PRODUCTIVE_TIME_AMOUNT,
			 HANDLER_ID,
			 INTER_INTERACTION_DURATION,
			 INTERACTION_ID,
			 WRAP_UP_TIME_AMOUNT,
			 SCRIPT_ID,
			 PARTY_ID,
			 RESOURCE_ID,
			 OBJECT_ID,
       			 OBJECT_TYPE,
       			 SOURCE_CODE_ID,
       			 SOURCE_CODE,
			 ATTRIBUTE1,
			 ATTRIBUTE2,
			 ATTRIBUTE3,
			 ATTRIBUTE4,
			 ATTRIBUTE5,
			 ATTRIBUTE6,
			 ATTRIBUTE7,
			 ATTRIBUTE8,
			 ATTRIBUTE9,
			 ATTRIBUTE10,
			 ATTRIBUTE11,
			 ATTRIBUTE12,
			 ATTRIBUTE13,
			 ATTRIBUTE14,
			 ATTRIBUTE15,
			 ATTRIBUTE_CATEGORY,
			 ACTIVE
			)
			VALUES
			(
			 p_user_id,
			 l_int_val_rec.reference_form,
			 Sysdate,
			 p_user_id,
			 l_int_val_rec.duration,
			 Sysdate,
			 p_login_id,
			 l_int_val_rec.end_date_time,
			 l_int_val_rec.follow_up_action,
			 l_int_val_rec.non_productive_time_amount,
			 l_int_val_rec.result_id,
			 l_int_val_rec.reason_id,
			 l_int_val_rec.start_date_time,
			 l_int_val_rec.outcome_id,
			 l_int_val_rec.preview_time_amount,
			 l_int_val_rec.productive_time_amount,
			 l_int_val_rec.handler_id,
			 l_int_val_rec.inter_interaction_duration,
			 l_int_val_rec.interaction_id,
			 l_int_val_rec.wrapup_time_amount,
			 l_int_val_rec.script_id,
			 l_int_val_rec.party_id,
			 l_int_val_rec.resource_id,
			 l_int_val_rec.object_id,
			 l_int_val_rec.object_type,
			 l_int_val_rec.source_code_id,
			 l_int_val_rec.source_code,
			 l_int_val_rec.attribute1,
			 l_int_val_rec.attribute2,
			 l_int_val_rec.attribute3,
			 l_int_val_rec.attribute4,
			 l_int_val_rec.attribute5,
			 l_int_val_rec.attribute6,
			 l_int_val_rec.attribute7,
			 l_int_val_rec.attribute8,
			 l_int_val_rec.attribute9,
			 l_int_val_rec.attribute10,
			 l_int_val_rec.attribute11,
			 l_int_val_rec.attribute12,
			 l_int_val_rec.attribute13,
			 l_int_val_rec.attribute14,
			 l_int_val_rec.attribute15,
			 l_int_val_rec.attribute_category,
			 'Y'
			);

Line: 1437

			--DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB_PS.Create_Interaction');

Line: 1454

			  	SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;

Line: 1456

			insert into jtf_ih_Activities
			(
           OBJECT_ID,
					 OBJECT_TYPE,
           SOURCE_CODE_ID,
           SOURCE_CODE,
					 DURATION,
					 DESCRIPTION,
					 DOC_ID,
					 END_DATE_TIME,
					 ACTIVITY_ID,
					 RESULT_ID,
					 REASON_ID,
					 START_DATE_TIME,
					 INTERACTION_ACTION_TYPE,
					 MEDIA_ID,
					 OUTCOME_ID,
					 ACTION_ITEM_ID,
					 INTERACTION_ID,
					 TASK_ID,
					 CREATION_DATE,
					 CREATED_BY,
					 LAST_UPDATED_BY,
					 LAST_UPDATE_DATE,
					 LAST_UPDATE_LOGIN,
					 ACTION_ID,
					 ACTIVE
					)
					values
				  (
				   l_activities(idx).object_id,
					 l_activities(idx).object_type,
					 l_activities(idx).source_code_id,
					 l_activities(idx).source_code,
					 l_activities(idx).duration,
					 l_activities(idx).description,
					 l_activities(idx).doc_id,
					 l_activities(idx).end_date_time,
					 l_activities(idx).activity_id,
					 l_activities(idx).result_id,
					 l_activities(idx).reason_id,
				   l_activities(idx).start_date_time,
					 l_activities(idx).interaction_action_type,
					 l_activities(idx).media_id,
					 l_activities(idx).outcome_id,
					 l_activities(idx).action_item_id,
			     l_int_val_rec.interaction_id,
					 l_activities(idx).task_id,
					 Sysdate,
					 p_user_id,
					 p_user_id,
					 Sysdate,
					 p_login_id,
					 l_activities(idx).action_id,
					 'Y'
					);

Line: 1515

				insert into jtf_ih_interaction_inters
				(
					 INTERACT_INTERACTION_ID,
					 INTERACT_INTERACTION_IDRELATES,
					 CREATED_BY,
					 CREATION_DATE,
 					 LAST_UPDATED_BY,
					 LAST_UPDATE_DATE,
					 LAST_UPDATE_LOGIN
					)
					values
				  (
			     l_int_val_rec.interaction_id,
			     l_int_val_rec.parent_id,
					 p_user_id,
					 Sysdate,
					 p_user_id,
					 Sysdate,
					 p_user_id
 					);

Line: 1638

		SELECT count(*) into actionCount
		FROM jtf_ih_Activities
		where outcome_id = p_outcome_id
		and  result_id = p_result_id
		and reason_id = p_reason_id
		and media_id = p_media_id
		;

Line: 1746

		SELECT count(*) into interactionCount
		FROM jtf_ih_Interactions
		where outcome_id = p_outcome_id
		and result_id = p_result_id
		and reason_id = p_reason_id
		and ((attribute1 = p_attribute1) or (p_attribute1 is NULL and attribute1 is NULL))
		and ((attribute2 = p_attribute2) or (p_attribute2 is NULL and attribute2 is NULL))
		and ((attribute3 = p_attribute3) or (p_attribute3 is NULL and attribute3 is NULL))
		and ((attribute4 = p_attribute4) or (p_attribute4 is NULL and attribute4 is NULL))
		and ((attribute5 = p_attribute5) or (p_attribute5 is NULL and attribute5 is NULL))
		and ((attribute6 = p_attribute6) or (p_attribute6 is NULL and attribute6 is NULL))
		and ((attribute7 = p_attribute7) or (p_attribute7 is NULL and attribute7 is NULL))
		and ((attribute8 = p_attribute8) or (p_attribute8 is NULL and attribute8 is NULL))
		and ((attribute9 = p_attribute9) or (p_attribute9 is NULL and attribute9 is NULL))
		and ((attribute10 = p_attribute10) or (p_attribute10 is NULL and attribute10 is NULL))
		and ((attribute11 = p_attribute11) or (p_attribute11 is NULL and attribute11 is NULL))
		and ((attribute12 = p_attribute12) or (p_attribute12 is NULL and attribute12 is NULL))
		and ((attribute13 = p_attribute13) or (p_attribute13 is NULL and attribute13 is NULL))
		and ((attribute14 = p_attribute14) or (p_attribute14 is NULL and attribute14 is NULL))
		and ((attribute15 = p_attribute15) or (p_attribute15 is NULL and attribute15 is NULL))
		and ((p_attribute_category = p_attribute_category) or (p_attribute_category is NULL and p_attribute_category is NULL))
		;

Line: 1920

		SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;

Line: 1922

		INSERT INTO jtf_ih_interactions
		(
			 CREATED_BY,
			 REFERENCE_FORM,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 DURATION,
			 LAST_UPDATE_DATE,
			 LAST_UPDATE_LOGIN,
			 END_DATE_TIME,
			 FOLLOW_UP_ACTION,
			 NON_PRODUCTIVE_TIME_AMOUNT,
			 RESULT_ID,
			 REASON_ID,
			 START_DATE_TIME,
			 OUTCOME_ID,
			 PREVIEW_TIME_AMOUNT,
			 PRODUCTIVE_TIME_AMOUNT,
			 HANDLER_ID,
			 INTER_INTERACTION_DURATION,
			 INTERACTION_ID,
			 WRAP_UP_TIME_AMOUNT,
			 SCRIPT_ID,
			 PARTY_ID,
			 RESOURCE_ID,
			 OBJECT_ID,
       		 OBJECT_TYPE,
       		 SOURCE_CODE_ID,
       		 SOURCE_CODE,
			 ATTRIBUTE1,
			 ATTRIBUTE2,
			 ATTRIBUTE3,
			 ATTRIBUTE4,
			 ATTRIBUTE5,
			 ATTRIBUTE6,
			 ATTRIBUTE7,
			 ATTRIBUTE8,
			 ATTRIBUTE9,
			 ATTRIBUTE10,
			 ATTRIBUTE11,
			 ATTRIBUTE12,
			 ATTRIBUTE13,
			 ATTRIBUTE14,
			 ATTRIBUTE15,
			 ATTRIBUTE_CATEGORY,
			 ACTIVE
			)
			VALUES
			(
			 p_user_id,
			 p_interaction_rec.reference_form,
			 Sysdate,
			 p_user_id,
			 l_duration,
			 Sysdate,
			 p_login_id,
			 p_interaction_rec.end_date_time,
			 p_interaction_rec.follow_up_action,
			 p_interaction_rec.non_productive_time_amount,
			 p_interaction_rec.result_id,
			 p_interaction_rec.reason_id,
			 l_start_date_time,
			 p_interaction_rec.outcome_id,
			 p_interaction_rec.preview_time_amount,
			 l_productive_time_amount,
			 p_interaction_rec.handler_id,
			 p_interaction_rec.inter_interaction_duration,
			 l_interaction_id,
			 p_interaction_rec.wrapup_time_amount,
			 p_interaction_rec.script_id,
			 p_interaction_rec.party_id,
			 p_interaction_rec.resource_id,
			 p_interaction_rec.object_id,
			 p_interaction_rec.object_type,
			 p_interaction_rec.source_code_id,
			 p_interaction_rec.source_code,
			 p_interaction_rec.attribute1,
			 p_interaction_rec.attribute2,
			 p_interaction_rec.attribute3,
			 p_interaction_rec.attribute4,
			 p_interaction_rec.attribute5,
			 p_interaction_rec.attribute6,
			 p_interaction_rec.attribute7,
			 p_interaction_rec.attribute8,
			 p_interaction_rec.attribute9,
			 p_interaction_rec.attribute10,
			 p_interaction_rec.attribute11,
			 p_interaction_rec.attribute12,
			 p_interaction_rec.attribute13,
			 p_interaction_rec.attribute14,
			 p_interaction_rec.attribute15,
			 p_interaction_rec.attribute_category,
			 l_active
			);

Line: 2016

		--DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interactions in JTF_IH_PUB_PS.Open_Interaction');

Line: 2020

				INSERT INTO jtf_ih_interaction_inters
				(
					 INTERACT_INTERACTION_ID,
					 INTERACT_INTERACTION_IDRELATES,
					 CREATED_BY,
					 CREATION_DATE,
 					 LAST_UPDATED_BY,
					 LAST_UPDATE_DATE,
					 LAST_UPDATE_LOGIN
				)
				VALUES
				(
					l_interaction_id,
					p_interaction_rec.parent_id,
					p_user_id,
					Sysdate,
					p_user_id,
					Sysdate,
					p_user_id
 				);

Line: 2041

		--DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB_PS.Open_Interaction');

Line: 2079

PROCEDURE Update_Interaction  -- created by Jean Zhu 01/11/2000
(
	p_api_version		IN	NUMBER,
	p_init_msg_list		IN	VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_commit		IN	VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_resp_appl_id		IN	NUMBER	DEFAULT NULL,
	p_resp_id		IN	NUMBER	DEFAULT NULL,
	p_user_id		IN	NUMBER,
	p_login_id		IN	NUMBER	DEFAULT NULL,
	x_return_status		OUT	VARCHAR2,
	x_msg_count		OUT	NUMBER,
	x_msg_data		OUT	VARCHAR2,
	p_interaction_rec	IN	interaction_rec_type
)
AS
		 l_api_name         CONSTANT VARCHAR2(30) := 'Update_Interaction';

Line: 2105

		SAVEPOINT update_interaction_pub;

Line: 2112

		--DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Update_Interaction');

Line: 2142

		--DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_Interaction');

Line: 2157

		--DBMS_OUTPUT.PUT_LINE('PAST Validate_Interaction_Record in JTF_IH_PUB_PS.Update_Interaction');

Line: 2161

		-- Update table JTF_IH_INTERACTIONS
		--
		IF (p_interaction_rec.interaction_id IS NULL) THEN
			jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'interaction_id');

Line: 2168

   			SELECT count(*) into l_count
			FROM jtf_ih_interactions
			WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2177

				SELECT active into l_active
				FROM jtf_ih_interactions
				WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2181

					SELECT start_date_time into l_start_date_time FROM jtf_ih_interactions
					WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2222

						UPDATE jtf_ih_interactions SET REFERENCE_FORM = p_interaction_rec.reference_form
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2226

						UPDATE jtf_ih_interactions SET FOLLOW_UP_ACTION = p_interaction_rec.follow_up_action
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2230

						UPDATE jtf_ih_interactions SET DURATION = l_duration
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2234

						UPDATE jtf_ih_interactions SET END_DATE_TIME = p_interaction_rec.end_date_time
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2238

						UPDATE jtf_ih_interactions SET INTER_INTERACTION_DURATION = p_interaction_rec.inter_interaction_duration
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2242

						UPDATE jtf_ih_interactions SET NON_PRODUCTIVE_TIME_AMOUNT = p_interaction_rec.non_productive_time_amount
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2246

						UPDATE jtf_ih_interactions SET PREVIEW_TIME_AMOUNT = p_interaction_rec.preview_time_amount
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2250

						UPDATE jtf_ih_interactions SET PRODUCTIVE_TIME_AMOUNT = l_productive_time_amount
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2254

						UPDATE jtf_ih_interactions SET WRAP_UP_TIME_AMOUNT = p_interaction_rec.wrapUp_time_amount
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2258

						UPDATE jtf_ih_interactions SET HANDLER_ID = p_interaction_rec.handler_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2262

						UPDATE jtf_ih_interactions SET SCRIPT_ID = p_interaction_rec.script_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2266

						UPDATE jtf_ih_interactions SET OUTCOME_ID = p_interaction_rec.outcome_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2270

						UPDATE jtf_ih_interactions SET RESULT_ID = p_interaction_rec.result_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2274

						UPDATE jtf_ih_interactions SET REASON_ID = p_interaction_rec.reason_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2278

						UPDATE jtf_ih_interactions SET RESOURCE_ID = p_interaction_rec.resource_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2282

						UPDATE jtf_ih_interactions SET OBJECT_ID = p_interaction_rec.object_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2286

						UPDATE jtf_ih_interactions SET OBJECT_TYPE = p_interaction_rec.object_type
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2290

						UPDATE jtf_ih_interactions SET SOURCE_CODE_ID = p_interaction_rec.source_code_id
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2294

						UPDATE jtf_ih_interactions SET SOURCE_CODE = p_interaction_rec.source_code
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2298

						UPDATE jtf_ih_interactions SET ATTRIBUTE1 = p_interaction_rec.attribute1
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2302

						UPDATE jtf_ih_interactions SET ATTRIBUTE2 = p_interaction_rec.attribute2
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2306

						UPDATE jtf_ih_interactions SET ATTRIBUTE3 = p_interaction_rec.attribute3
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2310

						UPDATE jtf_ih_interactions SET ATTRIBUTE4 = p_interaction_rec.attribute4
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2314

						UPDATE jtf_ih_interactions SET ATTRIBUTE5 = p_interaction_rec.attribute5
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2318

						UPDATE jtf_ih_interactions SET ATTRIBUTE6 = p_interaction_rec.attribute6
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2322

						UPDATE jtf_ih_interactions SET ATTRIBUTE7 = p_interaction_rec.attribute7
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2326

						UPDATE jtf_ih_interactions SET ATTRIBUTE8 = p_interaction_rec.attribute8
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2330

						UPDATE jtf_ih_interactions SET ATTRIBUTE9 = p_interaction_rec.attribute9
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2334

						UPDATE jtf_ih_interactions SET ATTRIBUTE10 = p_interaction_rec.attribute10
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2338

						UPDATE jtf_ih_interactions SET ATTRIBUTE11 = p_interaction_rec.attribute11
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2342

						UPDATE jtf_ih_interactions SET ATTRIBUTE12 = p_interaction_rec.attribute12
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2346

						UPDATE jtf_ih_interactions SET ATTRIBUTE13 = p_interaction_rec.attribute13
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2350

						UPDATE jtf_ih_interactions SET ATTRIBUTE14 = p_interaction_rec.attribute14
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2354

						UPDATE jtf_ih_interactions SET ATTRIBUTE15 = p_interaction_rec.attribute15
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2358

						UPDATE jtf_ih_interactions SET ATTRIBUTE_CATEGORY = p_interaction_rec.attribute_category
						WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2364

		--DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_interactions in JTF_IH_PUB_PS.Update_Interaction');

Line: 2368

			SELECT count(*) into l_count
			FROM jtf_ih_interaction_inters
			WHERE interact_interaction_id = p_interaction_rec.interaction_id and
				  interact_interaction_idrelates = 	p_interaction_rec.parent_id;

Line: 2373

				INSERT INTO jtf_ih_interaction_inters
				(
					 INTERACT_INTERACTION_ID,
					 INTERACT_INTERACTION_IDRELATES,
					 CREATED_BY,
					 CREATION_DATE,
 					 LAST_UPDATED_BY,
					 LAST_UPDATE_DATE,
					 LAST_UPDATE_LOGIN
				)
				VALUES
				(
					p_interaction_rec.interaction_id,
					p_interaction_rec.parent_id,
					p_user_id,
					Sysdate,
					p_user_id,
					Sysdate,
					p_user_id
 				);

Line: 2395

		--DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_Interaction_inters in JTF_IH_PUB_PS.Update_Interaction');

Line: 2407

			ROLLBACK TO update_interaction_pub;

Line: 2413

			ROLLBACK TO update_interaction_pub;

Line: 2419

			ROLLBACK TO update_interaction_pub;

Line: 2427

	END Update_Interaction;

Line: 2452

			SELECT activity_id FROM jtf_ih_activities
			WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2495

		-- Update interaction
		--
		Update_Interaction
		(	p_api_version,
			p_init_msg_list,
			p_commit,
			p_resp_appl_id,
			p_resp_id,
			p_user_id,
			p_login_id,
			x_return_status,
			x_msg_count,
			x_msg_data,
			p_interaction_rec);

Line: 2509

		--DBMS_OUTPUT.PUT_LINE('PAST Update_Interaction in JTF_IH_PUB_PS.Close_Interaction');

Line: 2511

   	    SELECT outcome_id into l_outcome_id
        FROM jtf_ih_interactions
        WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2521

		SELECT end_date_time into l_end_date_time
        FROM jtf_ih_interactions
        WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2530

		UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time
				WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2535

   			SELECT outcome_id into l_outcome_id
			FROM jtf_ih_activities
			WHERE activity_id = v_activity_id_c.activity_id;

Line: 2546

   			SELECT action_item_id into l_action_item_id
			FROM jtf_ih_activities
			WHERE activity_id = v_activity_id_c.activity_id;

Line: 2556

			SELECT end_date_time into l_end_date_time
			FROM jtf_ih_activities
			WHERE activity_id = v_activity_id_c.activity_id;

Line: 2562

			UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time
					WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 2565

		--DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB_PS.Close_Interaction');

Line: 2705

		SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;

Line: 2707

		INSERT INTO jtf_ih_Activities
		(
			ACTIVITY_ID,
			OBJECT_ID,
			OBJECT_TYPE,
			SOURCE_CODE_ID,
			SOURCE_CODE,
			DURATION,
			DESCRIPTION,
			DOC_ID,
			DOC_REF,
			END_DATE_TIME,
			RESULT_ID,
			REASON_ID,
			START_DATE_TIME,
			ACTION_ID,
			INTERACTION_ACTION_TYPE,
			MEDIA_ID,
			OUTCOME_ID,
			ACTION_ITEM_ID,
			INTERACTION_ID,
			TASK_ID,
			CREATION_DATE,
			CREATED_BY,
			LAST_UPDATED_BY,
			LAST_UPDATE_DATE,
			LAST_UPDATE_LOGIN,
			ACTIVE
		)
		VALUES
		(
			l_activity_id,
			p_activity_rec.object_id,
		    p_activity_rec.object_type,
			p_activity_rec.source_code_id,
			p_activity_rec.source_code,
			l_duration,
			p_activity_rec.description,
			p_activity_rec.doc_id,
			p_activity_rec.doc_ref,
			p_activity_rec.end_date_time,
			p_activity_rec.result_id,
			p_activity_rec.reason_id,
			l_start_date_time,
			p_activity_rec.action_id,
			p_activity_rec.interaction_action_type,
			p_activity_rec.media_id,
			p_activity_rec.outcome_id,
			p_activity_rec.action_item_id,
			p_activity_rec.interaction_id,
			p_activity_rec.task_id,
			Sysdate,
			p_user_id,
			p_user_id,
			Sysdate,
			p_login_id,
			l_active
		);

Line: 2765

		--DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_activities in JTF_IH_PUB_PS.Add_Activity');

Line: 2803

PROCEDURE Update_Activity  -- created by Jean Zhu 01/11/2000
(
	p_api_version		IN	NUMBER,
	p_init_msg_list		IN	VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_commit			IN	VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_resp_appl_id		IN	NUMBER	DEFAULT NULL,
	p_resp_id			IN	NUMBER	DEFAULT NULL,
	p_user_id			IN	NUMBER,
	p_login_id			IN	NUMBER	DEFAULT NULL,
	x_return_status		OUT	VARCHAR2,
	x_msg_count			OUT	NUMBER,
	x_msg_data			OUT	VARCHAR2,
	p_activity_rec		IN	activity_rec_type
)
AS
		 l_api_name         CONSTANT VARCHAR2(30) := 'Update_Activity';

Line: 2828

		SAVEPOINT update_activity_pub;

Line: 2835

		--DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Update_Activity');

Line: 2865

		--DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_Activity');

Line: 2880

		--DBMS_OUTPUT.PUT_LINE('PAST Validate_Activity_Record in JTF_IH_PUB_PS.Update_Activity');

Line: 2883

		-- Update table JTF_IH_INTERACTIONS
		--
		IF (p_activity_rec.activity_id IS NULL) THEN
			jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');

Line: 2890

   			SELECT count(*) into l_count
			FROM jtf_ih_activities
			WHERE activity_id = p_activity_rec.activity_id;

Line: 2899

				SELECT active into l_active FROM jtf_ih_activities
				WHERE activity_id = p_activity_rec.activity_id;

Line: 2902

					SELECT start_date_time into l_start_date_time FROM jtf_ih_activities
					WHERE activity_id = p_activity_rec.activity_id;

Line: 2919

						--DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB_PS.Update_Activity');

Line: 2923

						UPDATE jtf_ih_activities SET DURATION = l_duration
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2927

						UPDATE jtf_ih_activities SET END_DATE_TIME = p_activity_rec.end_date_time
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2931

						UPDATE jtf_ih_activities SET CUST_ACCOUNT_ID = p_activity_rec.cust_account_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2935

						UPDATE jtf_ih_activities SET CUST_ORG_ID = p_activity_rec.cust_org_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2939

						UPDATE jtf_ih_activities SET ROLE = p_activity_rec.role
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2943

						UPDATE jtf_ih_activities SET OUTCOME_ID = p_activity_rec.outcome_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2947

						UPDATE jtf_ih_activities SET RESULT_ID = p_activity_rec.result_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2951

						UPDATE jtf_ih_activities SET REASON_ID = p_activity_rec.reason_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2955

						UPDATE jtf_ih_activities SET TASK_ID = p_activity_rec.task_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2959

						UPDATE jtf_ih_activities SET OBJECT_ID = p_activity_rec.object_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2963

						UPDATE jtf_ih_activities SET OBJECT_TYPE = p_activity_rec.object_type
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2967

						UPDATE jtf_ih_activities SET SOURCE_CODE_ID = p_activity_rec.source_code_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2971

						UPDATE jtf_ih_activities SET SOURCE_CODE = p_activity_rec.source_code
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2975

						UPDATE jtf_ih_activities SET DOC_ID = p_activity_rec.doc_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2979

						UPDATE jtf_ih_activities SET DOC_REF = p_activity_rec.doc_ref
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2983

						UPDATE jtf_ih_activities SET MEDIA_ID = p_activity_rec.media_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2987

						UPDATE jtf_ih_activities SET ACTION_ITEM_ID = p_activity_rec.action_item_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2991

						UPDATE jtf_ih_activities SET INTERACTION_ID = p_activity_rec.interaction_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2995

						UPDATE jtf_ih_activities SET DESCRIPTION = p_activity_rec.description
						WHERE activity_id = p_activity_rec.activity_id;

Line: 2999

						UPDATE jtf_ih_activities SET ACTION_ID = p_activity_rec.action_id
						WHERE activity_id = p_activity_rec.activity_id;

Line: 3003

						UPDATE jtf_ih_activities SET INTERACTION_ACTION_TYPE = p_activity_rec.interaction_action_type
						WHERE activity_id = p_activity_rec.activity_id;

Line: 3009

		--DBMS_OUTPUT.PUT_LINE('PAST update table jtf_ih_activities in JTF_IH_PUB_PS.Update_Activity');

Line: 3020

			ROLLBACK TO update_activity_pub;

Line: 3026

			ROLLBACK TO update_activity_pub;

Line: 3032

			ROLLBACK TO update_activity_pub;

Line: 3040

	END Update_Activity;

Line: 3065

			SELECT activity_id FROM jtf_ih_activities
			WHERE interaction_id = p_interaction_id;

Line: 3107

   	    SELECT outcome_id into l_outcome_id
        FROM jtf_ih_interactions
        WHERE interaction_id = p_interaction_id;

Line: 3117

		SELECT end_date_time into l_end_date_time
        FROM jtf_ih_interactions
        WHERE interaction_id = p_interaction_id;

Line: 3126

		UPDATE jtf_ih_interactions SET ACTIVE = 'N',end_date_time =l_end_date_time
				WHERE interaction_id = p_interaction_id;

Line: 3131

   			SELECT outcome_id into l_outcome_id
			FROM jtf_ih_activities
			WHERE activity_id = v_activity_id_c.activity_id;

Line: 3142

   			SELECT action_item_id into l_action_item_id
			FROM jtf_ih_activities
			WHERE activity_id = v_activity_id_c.activity_id;

Line: 3152

			SELECT end_date_time into l_end_date_time
			FROM jtf_ih_activities
			WHERE activity_id = v_activity_id_c.activity_id;

Line: 3158

			UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time
					WHERE interaction_id = p_interaction_id;

Line: 3161

		--DBMS_OUTPUT.PUT_LINE('PAST Update ACTIVE in JTF_IH_PUB_PS.Close_Interaction_2');

Line: 3197

PROCEDURE Update_ActivityDuration  -- created by Jean Zhu 01/11/2000
(
	p_api_version		IN	NUMBER,
	p_init_msg_list		IN	VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_commit			IN	VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_resp_appl_id		IN	NUMBER	DEFAULT NULL,
	p_resp_id			IN	NUMBER	DEFAULT NULL,
	p_user_id			IN	NUMBER,
	p_login_id			IN	NUMBER	DEFAULT NULL,
	x_return_status		OUT	VARCHAR2,
	x_msg_count			OUT	NUMBER,
	x_msg_data			OUT	VARCHAR2,
	p_activity_id		IN	NUMBER,
	p_end_date_time		IN  DATE,
	p_duration			IN	NUMBER
)
AS
		 l_api_name         CONSTANT VARCHAR2(30) := 'Update_ActivityDuration';

Line: 3222

		SAVEPOINT update_activityDuration;

Line: 3229

		--DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB_PS.Update_ActivityDuration');

Line: 3259

		--DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB_PS.Update_ActivityDuration');

Line: 3262

		-- Update table JTF_IH_INTERACTIONS
		--
		IF (p_activity_id IS NULL) THEN
			jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');

Line: 3269

			SELECT start_date_time into l_start_date_time
			FROM jtf_ih_activities
			WHERE activity_id = p_activity_id;

Line: 3284

			--DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB_PS.Update_ActivityDuration');

Line: 3286

			UPDATE jtf_ih_activities SET END_DATE_TIME = p_end_date_time,
				 DURATION = p_duration 	WHERE activity_id = p_activity_id;

Line: 3289

			--DBMS_OUTPUT.PUT_LINE('PAST update end_date_time and duration in JTF_IH_PUB_PS.Update_ActivityDuration');

Line: 3301

			ROLLBACK TO update_activityDuration;

Line: 3307

			ROLLBACK TO update_activityDuration;

Line: 3313

			ROLLBACK TO update_activityDuration;

Line: 3321

	END Update_ActivityDuration;

Line: 3342

	PROCEDURE Update_MediaItem
	(
	p_api_version	IN	NUMBER,
	p_init_msg_list	IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
	p_commit	IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
	p_resp_appl_id	IN	NUMBER		DEFAULT NULL,
	p_resp_id	IN	NUMBER		DEFAULT NULL,
	p_user_id	IN	NUMBER,
	p_login_id	IN	NUMBER		DEFAULT NULL,
	x_return_status	OUT	VARCHAR2,
	x_msg_count	OUT	NUMBER,
	x_msg_data	OUT	VARCHAR2,
	p_media_rec	IN	media_rec_type
	) AS
	BEGIN
		NULL;

Line: 3358

	END Update_MediaItem;

Line: 3396

	PROCEDURE Update_MediaLifecycle
	(
	p_api_version	IN	NUMBER,
	p_init_msg_list	IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
	p_commit	IN	VARCHAR2	DEFAULT FND_API.G_FALSE,
	p_resp_appl_id	IN	NUMBER		DEFAULT NULL,
	p_resp_id	IN	NUMBER		DEFAULT NULL,
	p_user_id	IN	NUMBER,
	p_login_id	IN	NUMBER		DEFAULT NULL,
	x_return_status	OUT	VARCHAR2,
	x_msg_count	OUT	NUMBER,
	x_msg_data	OUT	VARCHAR2,
	p_media_lc_rec	IN	media_lc_rec_type
	) AS

	BEGIN
		NULL;

Line: 3413

	END Update_MediaLifecycle;