APPS.JTF_IH_PUB SQL Statements

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

Line: 24

        SELECT source_code into x_source_code
          FROM ams_source_codes
          WHERE source_code_id = x_source_code_id;

Line: 40

         SELECT source_code_id into x_source_code_id
         FROM ams_source_codes
         WHERE source_code = x_source_code;

Line: 121

  SELECT DISTINCT PERSON_ID INTO s_Employee_Number FROM PER_WORKFORCE_CURRENT_X WHERE PARTY_ID = p_Party_id;

Line: 139

  SELECT PARTY_TYPE INTO s_Party_Type FROM HZ_PARTIES WHERE PARTY_ID = p_Party_Id;

Line: 171

   SELECT
      SUBJECT_ID,
      SUBJECT_TYPE,
      OBJECT_ID,
      OBJECT_TYPE
   INTO
      p_Subject_ID,
      p_Subject_Type,
      p_Object_ID,
      p_Object_Type
   FROM HZ_RELATIONSHIPS WHERE PARTY_ID = p_Party_ID AND
      DIRECTIONAL_FLAG = l_direction_flag_perf;

Line: 567

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

Line: 589

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

Line: 611

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

Line: 623

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

Line: 645

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

Line: 661

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

Line: 678

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

Line: 694

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

Line: 718

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

Line: 743

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

Line: 767

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

Line: 788

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

Line: 980

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

Line: 1001

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

Line: 1017

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

Line: 1035

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

Line: 1050

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

Line: 1067

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

Line: 1092

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

Line: 1117

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

Line: 1141

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

Line: 1162

   	     SELECT count(cust_account_id) into l_count
   FROM hz_cust_accounts
   WHERE cust_account_id = p_act_val_rec.cust_account_id;

Line: 1178

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

Line: 1356

	SELECT count(milcs_type_id) into l_count
	FROM jtf_ih_media_itm_lc_seg_tys
	WHERE milcs_type_id = p_media_lc_rec.milcs_type_id;

Line: 1364

	SELECT count(milcs_type_id) into l_count
	FROM jtf_ih_media_itm_lc_seg_tys
	WHERE milcs_code = p_media_lc_rec.milcs_code;

Line: 1378

	SELECT count(milcs_type_id) into l_count
	FROM jtf_ih_media_itm_lc_seg_tys
	WHERE milcs_type_id = p_media_lc_rec.milcs_type_id;

Line: 1389

	SELECT count(milcs_type_id) into l_count
	FROM jtf_ih_media_itm_lc_seg_tys
	WHERE milcs_code = p_media_lc_rec.milcs_code;

Line: 1401

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

Line: 1418

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

Line: 1507

    SELECT activity_id INTO n_Return FROM jtf_ih_activities WHERE activity_id = n_activity_id;

Line: 1522

      SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;

Line: 1524

          SELECT activity_id INTO n_Dummy FROM jtf_ih_activities WHERE activity_id = n_Return;

Line: 1550

    SELECT interaction_id INTO n_Return FROM jtf_ih_interactions WHERE interaction_id = n_interaction_id;

Line: 1565

      SELECT jtf_ih_interactions_s1.NEXTVAL INTO n_Return FROM dual;

Line: 1567

          SELECT interaction_id INTO n_Dummy FROM jtf_ih_interactions WHERE interaction_id = n_Return;

Line: 1592

    SELECT media_id INTO n_Return FROM jtf_ih_media_items WHERE media_id = n_media_id;

Line: 1607

      SELECT jtf_ih_media_items_s1.NEXTVAL INTO n_Return FROM dual;

Line: 1609

          SELECT n_media_id INTO n_Dummy FROM jtf_ih_media_items WHERE media_id = n_Return;

Line: 1635

    SELECT milcs_id INTO n_Return FROM jtf_ih_media_item_lc_segs WHERE milcs_id = n_milcs_id;

Line: 1650

      SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO n_Return FROM dual;

Line: 1652

          SELECT n_milcs_id INTO n_Dummy FROM jtf_ih_media_item_lc_segs WHERE milcs_id = n_Return;

Line: 1719

  l_ao_update_pending_perf VARCHAR2(1);

Line: 1731

   l_ao_update_pending_perf := 'N';

Line: 1838

    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,
        ACTIVE,
        SERVER_GROUP_ID,
        DNIS,
        ANI,
        CLASSIFICATION,
        BULK_WRITER_CODE,
        BULK_BATCH_TYPE,
        BULK_BATCH_ID,
        BULK_INTERACTION_ID,
        media_abandon_flag,
        media_transferred_flag,
        address,
        ao_update_pending,
        soft_closed
    ) values (
        decode( l_int_val_rec.duration, fnd_api.g_miss_num, l_duration_perf, l_int_val_rec.duration),
        decode( l_int_val_rec.direction, fnd_api.g_miss_char, null, l_int_val_rec.direction),
        l_int_val_rec.end_date_time,
        l_int_val_rec.source_item_create_date_time,
        decode( l_int_val_rec.interaction_performed, fnd_api.g_miss_char, null, l_int_val_rec.interaction_performed),
        decode( l_int_val_rec.source_item_id, fnd_api.g_miss_num, null, l_int_val_rec.source_item_id),
        -- Bug # 2184405
        l_int_val_rec.start_date_time,
        l_int_val_rec.media_id,
        decode( l_int_val_rec.source_id, fnd_api.g_miss_num, null, l_int_val_rec.source_id),
        decode( l_int_val_rec.media_item_type, fnd_api.g_miss_char, null, l_int_val_rec.media_item_type),
        p_user_id,
        SysDate,
        p_user_id,
        SysDate,
        p_login_id,
        decode( l_int_val_rec.media_item_ref, fnd_api.g_miss_char, null, l_int_val_rec.media_item_ref),
        decode( l_int_val_rec.media_data, fnd_api.g_miss_char, null, l_int_val_rec.media_data),
        l_active_perf,
        decode( l_int_val_rec.server_group_id, fnd_api.g_miss_num, null, l_int_val_rec.server_group_id),
        decode( l_int_val_rec.dnis, fnd_api.g_miss_char, null, l_int_val_rec.dnis),
        decode( l_int_val_rec.ani, fnd_api.g_miss_char, null, l_int_val_rec.ani),
        decode( l_int_val_rec.classification, fnd_api.g_miss_char, null, l_int_val_rec.classification),
        decode( l_int_val_rec.bulk_writer_code, fnd_api.g_miss_char, null, l_int_val_rec.bulk_writer_code),
        decode( l_int_val_rec.bulk_batch_type, fnd_api.g_miss_char, null, l_int_val_rec.bulk_batch_type),
        decode( l_int_val_rec.bulk_batch_id, fnd_api.g_miss_num, null, l_int_val_rec.bulk_batch_id),
        decode( l_int_val_rec.bulk_interaction_id, fnd_api.g_miss_num, null, l_int_val_rec.bulk_interaction_id),
        decode( l_int_val_rec.media_abandon_flag, fnd_api.g_miss_char, null, l_int_val_rec.media_abandon_flag),
        decode( l_int_val_rec.media_transferred_flag, fnd_api.g_miss_char, null, l_int_val_rec.media_transferred_flag),
        decode( l_int_val_rec.address, fnd_api.g_miss_char, null, l_int_val_rec.address),
        l_ao_update_pending_perf,
        l_soft_closed_perf
    );

Line: 1967

        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,
           ACTIVE,
           BULK_WRITER_CODE,
           BULK_BATCH_TYPE,
           BULK_BATCH_ID,
           BULK_INTERACTION_ID,
           RESOURCE_ID
        )
        values
        (
           l_mlcs(idx).start_date_time,
           decode( l_mlcs(idx).type_type, fnd_api.g_miss_char, null, l_mlcs(idx).type_type),
           decode( l_mlcs(idx).type_id, fnd_api.g_miss_num, null, l_mlcs(idx).type_id),
           decode( l_mlcs(idx).duration, fnd_api.g_miss_num, l_duration_perf, l_mlcs(idx).duration),
           l_mlcs(idx).end_date_time,
           l_mlcs(idx).milcs_id,
           decode( l_mlcs(idx).milcs_type_id, fnd_api.g_miss_num, null, 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,
           l_active_perf,
           decode( l_mlcs(idx).bulk_writer_code, fnd_api.g_miss_char, null, l_mlcs(idx).bulk_writer_code),
           decode( l_mlcs(idx).bulk_batch_type, fnd_api.g_miss_char, null, l_mlcs(idx).bulk_batch_type),
           decode( l_mlcs(idx).bulk_batch_id, fnd_api.g_miss_num, null, l_mlcs(idx).bulk_batch_id),
           decode( l_mlcs(idx).bulk_interaction_id, fnd_api.g_miss_num, null, l_mlcs(idx).bulk_interaction_id),
           decode( l_mlcs(idx).resource_id, fnd_api.g_miss_num, null, l_mlcs(idx).resource_id)
           );

Line: 2116

  l_ao_update_pending_perf VARCHAR2(1);

Line: 2126

   l_ao_update_pending_perf := 'N';

Line: 2269

	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,
			 MEDIA_ABANDON_FLAG,
			 MEDIA_TRANSFERRED_FLAG,
			 ACTIVE,
       		 SERVER_GROUP_ID,
       		 DNIS,
       		 ANI,
       		 CLASSIFICATION,
       		 BULK_WRITER_CODE,
       		 BULK_BATCH_TYPE,
       		 BULK_BATCH_ID,
       		 BULK_INTERACTION_ID,
       		 ADDRESS,
       		 AO_UPDATE_PENDING,
       		 SOFT_CLOSED

		) values (
			 --decode(l_duration,fnd_api.g_miss_num, l_duration_perf, l_duration),
			 decode(l_media_rec.duration,fnd_api.g_miss_num, 0, l_media_rec.duration),
			 decode( p_media_rec.direction, fnd_api.g_miss_char, null, p_media_rec.direction),
			 --l_end_date_time,
			 l_media_rec.end_date_time,
			 --l_source_item_create_date_time,
			 l_media_rec.source_item_create_date_time,
			 decode( p_media_rec.interaction_performed, fnd_api.g_miss_char, null, p_media_rec.interaction_performed),
			 decode( p_media_rec.source_item_id, fnd_api.g_miss_num, null, p_media_rec.source_item_id),
			 --l_start_date_time,
			 l_media_rec.start_date_time,
			 --l_media_id,
			 l_media_rec.media_id,
			 decode( p_media_rec.source_id, fnd_api.g_miss_num, null, p_media_rec.source_id),
       -- Bug# 2309710
			 decode( p_media_rec.media_item_type, fnd_api.g_miss_char, null, p_media_rec.media_item_type),
			 p_user_id,
			 SysDate,
			 p_user_id,
			 SysDate,
			 p_login_id,
			 decode( p_media_rec.media_item_ref, fnd_api.g_miss_char, null,p_media_rec.media_item_ref),
			 decode( p_media_rec.media_data, fnd_api.g_miss_char, null,p_media_rec.media_data),
			 decode( p_media_rec.media_abandon_flag, fnd_api.g_miss_char, null,p_media_rec.media_abandon_flag),
			 decode( p_media_rec.media_transferred_flag, fnd_api.g_miss_char, null,p_media_rec.media_transferred_flag),
			 l_active_perf,
       		 decode( p_media_rec.server_group_id, fnd_api.g_miss_num, null,p_media_rec.server_group_id),
       		 decode( p_media_rec.dnis, fnd_api.g_miss_char, null,p_media_rec.dnis),
       		 decode( p_media_rec.ani, fnd_api.g_miss_char, null,p_media_rec.ani),
       		 decode( p_media_rec.classification, fnd_api.g_miss_char, null, p_media_rec.classification),
			 decode( p_media_rec.bulk_writer_code, fnd_api.g_miss_char, null, p_media_rec.bulk_writer_code),
			 decode( p_media_rec.bulk_batch_type, fnd_api.g_miss_char, null, p_media_rec.bulk_batch_type),
			 decode( p_media_rec.bulk_batch_id, fnd_api.g_miss_num, null, p_media_rec.bulk_batch_id),
			 decode( p_media_rec.bulk_interaction_id, fnd_api.g_miss_num, null, p_media_rec.bulk_interaction_id),
			 --decode( l_address, fnd_api.g_miss_char, null, l_address),
			 decode( l_media_rec.address, fnd_api.g_miss_char, null, l_media_rec.address),
		 l_ao_update_pending_perf,
		 l_soft_closed_perf
		);

Line: 2343

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

Line: 2591

		--select milcs_type_id into l_milcs_type_id
		select milcs_type_id into l_media_lc_rec.milcs_type_id
		from jtf_ih_media_itm_lc_seg_tys
		where milcs_code = p_media_lc_rec.milcs_code;

Line: 2604

	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,
			 ACTIVE,
       BULK_WRITER_CODE,
       BULK_BATCH_TYPE,
       BULK_BATCH_ID,
       BULK_INTERACTION_ID
 	)
	values
	(
			--l_start_date_time,
			l_media_lc_rec.start_date_time,
			decode( p_media_lc_rec.type_type, fnd_api.g_miss_char, null,p_media_lc_rec.type_type),
			decode( p_media_lc_rec.type_id, fnd_api.g_miss_num, null, p_media_lc_rec.type_id),
			--decode( l_duration, fnd_api.g_miss_num, l_duration_perf, l_duration ),
			decode(l_media_lc_rec.duration, fnd_api.g_miss_num, 0, l_media_lc_rec.duration ),
			--l_end_date_time,
			l_media_lc_rec.end_date_time,
			--l_milcs_id,
			l_media_lc_rec.milcs_id,
			--decode( l_milcs_type_id, fnd_api.g_miss_num, null, l_milcs_type_id),
			decode(l_media_lc_rec.milcs_type_id, fnd_api.g_miss_num, null, l_media_lc_rec.milcs_type_id),
			p_media_lc_rec.media_id,
			p_media_lc_rec.handler_id,
			decode( p_media_lc_rec.resource_id, fnd_api.g_miss_num, null, p_media_lc_rec.resource_id),
			p_user_id,
			Sysdate,
			p_user_id,
			Sysdate,
			p_login_id,
			l_active_perf,
		    decode( p_media_lc_rec.bulk_writer_code, fnd_api.g_miss_char, null, p_media_lc_rec.bulk_writer_code),
			decode( p_media_lc_rec.bulk_batch_type, fnd_api.g_miss_char, null, p_media_lc_rec.bulk_batch_type),
			decode( p_media_lc_rec.bulk_batch_id, fnd_api.g_miss_num, null, p_media_lc_rec.bulk_batch_id),
			decode( p_media_lc_rec.bulk_interaction_id, fnd_api.g_miss_num, null, p_media_lc_rec.bulk_interaction_id)
	);

Line: 2655

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

Line: 2938

   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,
      TOUCHPOINT1_TYPE,
      TOUCHPOINT2_TYPE,
      METHOD_CODE,
      BULK_WRITER_CODE,
      BULK_BATCH_TYPE,
      BULK_BATCH_ID,
      BULK_INTERACTION_ID,
      PRIMARY_PARTY_ID,
      CONTACT_REL_PARTY_ID,
      CONTACT_PARTY_ID
   )
   VALUES
   (
      p_user_id,
      decode( l_int_val_rec.reference_form, fnd_api.g_miss_char, null, l_int_val_rec.reference_form),
      Sysdate,
      p_user_id,
      decode( l_int_val_rec.duration, fnd_api.g_miss_num, l_duration_perf, l_int_val_rec.duration),
      Sysdate,
      p_login_id,
      l_int_val_rec.end_date_time,
      decode( l_int_val_rec.follow_up_action, fnd_api.g_miss_char, null, l_int_val_rec.follow_up_action),
      decode( l_int_val_rec.non_productive_time_amount, fnd_api.g_miss_num, null, l_int_val_rec.non_productive_time_amount),
      decode( l_int_val_rec.result_id, fnd_api.g_miss_num, null, l_int_val_rec.result_id),
      decode( l_int_val_rec.reason_id, fnd_api.g_miss_num, null, l_int_val_rec.reason_id),
      l_int_val_rec.start_date_time,
      decode( l_int_val_rec.outcome_id, fnd_api.g_miss_num, null, l_int_val_rec.outcome_id),
      decode( l_int_val_rec.preview_time_amount, fnd_api.g_miss_num, null, l_int_val_rec.preview_time_amount),
      decode( l_int_val_rec.productive_time_amount, fnd_api.g_miss_num, null, l_int_val_rec.productive_time_amount),
      l_int_val_rec.handler_id,
      decode( l_int_val_rec.inter_interaction_duration, fnd_api.g_miss_num, null, l_int_val_rec.inter_interaction_duration),
      l_int_val_rec.interaction_id,
      decode( l_int_val_rec.wrapup_time_amount, fnd_api.g_miss_num, null, l_int_val_rec.wrapup_time_amount),
      decode( l_int_val_rec.script_id, fnd_api.g_miss_num, null, l_int_val_rec.script_id),
      l_int_val_rec.party_id,
      l_int_val_rec.resource_id,
      decode( l_int_val_rec.object_id, fnd_api.g_miss_num, null, l_int_val_rec.object_id),
      decode( l_int_val_rec.object_type, fnd_api.g_miss_char, null, l_int_val_rec.object_type),
      decode( l_int_val_rec.source_code_id, fnd_api.g_miss_num, null, l_int_val_rec.source_code_id),
      decode( l_int_val_rec.source_code, fnd_api.g_miss_char, null, l_int_val_rec.source_code),
      decode( l_int_val_rec.attribute1, fnd_api.g_miss_char, null, l_int_val_rec.attribute1),
      decode( l_int_val_rec.attribute2, fnd_api.g_miss_char, null, l_int_val_rec.attribute2),
      decode( l_int_val_rec.attribute3, fnd_api.g_miss_char, null, l_int_val_rec.attribute3),
      decode( l_int_val_rec.attribute4, fnd_api.g_miss_char, null, l_int_val_rec.attribute4),
      decode( l_int_val_rec.attribute5, fnd_api.g_miss_char, null, l_int_val_rec.attribute5),
      decode( l_int_val_rec.attribute6, fnd_api.g_miss_char, null, l_int_val_rec.attribute6),
      decode( l_int_val_rec.attribute7, fnd_api.g_miss_char, null, l_int_val_rec.attribute7),
      decode( l_int_val_rec.attribute8, fnd_api.g_miss_char, null, l_int_val_rec.attribute8),
      decode( l_int_val_rec.attribute9, fnd_api.g_miss_char, null, l_int_val_rec.attribute9),
      decode( l_int_val_rec.attribute10, fnd_api.g_miss_char, null, l_int_val_rec.attribute10),
      decode( l_int_val_rec.attribute11, fnd_api.g_miss_char, null, l_int_val_rec.attribute11),
      decode( l_int_val_rec.attribute12, fnd_api.g_miss_char, null, l_int_val_rec.attribute12),
      decode( l_int_val_rec.attribute13, fnd_api.g_miss_char, null, l_int_val_rec.attribute13),
      decode( l_int_val_rec.attribute14, fnd_api.g_miss_char, null, l_int_val_rec.attribute14),
      decode( l_int_val_rec.attribute15, fnd_api.g_miss_char, null, l_int_val_rec.attribute15),
      decode( l_int_val_rec.attribute_category, fnd_api.g_miss_char, null, l_int_val_rec.attribute_category),
      l_active_perf,
      decode( l_int_val_rec.touchpoint1_type, fnd_api.g_miss_char, null, l_int_val_rec.touchpoint1_type),
      decode( l_int_val_rec.touchpoint2_type, fnd_api.g_miss_char, null, l_int_val_rec.touchpoint2_type),
      decode( l_int_val_rec.method_code, fnd_api.g_miss_char, null, l_int_val_rec.method_code),
      decode( l_int_val_rec.bulk_writer_code, fnd_api.g_miss_char, null, l_int_val_rec.bulk_writer_code),
      decode( l_int_val_rec.bulk_batch_type, fnd_api.g_miss_char, null, l_int_val_rec.bulk_batch_type),
      decode( l_int_val_rec.bulk_batch_id, fnd_api.g_miss_num, null, l_int_val_rec.bulk_batch_id),
      decode( l_int_val_rec.bulk_interaction_id, fnd_api.g_miss_num, null, l_int_val_rec.bulk_interaction_id),
      decode( l_int_val_rec.primary_party_id, fnd_api.g_miss_num, null, l_int_val_rec.primary_party_id),
      decode( l_int_val_rec.contact_rel_party_id, fnd_api.g_miss_num, null, l_int_val_rec.contact_rel_party_id),
      decode( l_int_val_rec.contact_party_id, fnd_api.g_miss_num, null, l_int_val_rec.contact_party_id)
   );

Line: 3111

   	    SELECT count(resource_id) into l_count
      FROM jtf_rs_resource_extns
      WHERE resource_id = p_activities(idx).resource_id;

Line: 3133

      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,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15,
         ATTRIBUTE_CATEGORY,
         ACTIVE,
         SCRIPT_TRANS_ID,
         ROLE,
         DOC_SOURCE_OBJECT_NAME,
         --, RESOURCE_ID
         -- Added missed columns 09/10/2002
         CUST_ACCOUNT_ID,
         CUST_ORG_ID,
         DOC_REF,
         BULK_WRITER_CODE,
         BULK_BATCH_TYPE,
         BULK_BATCH_ID,
         BULK_INTERACTION_ID
      )
      values
      (
         decode( l_activities(idx).object_id, fnd_api.g_miss_num, null, l_activities(idx).object_id),
         decode( l_activities(idx).object_type, fnd_api.g_miss_char, null, l_activities(idx).object_type),
         decode( l_activities(idx).source_code_id, fnd_api.g_miss_num, null, l_activities(idx).source_code_id),
         decode( l_activities(idx).source_code, fnd_api.g_miss_char, null, l_activities(idx).source_code),
         decode( l_activities(idx).duration, fnd_api.g_miss_num, l_duration_perf, l_activities(idx).duration),
         decode( l_activities(idx).description, fnd_api.g_miss_char, null, l_activities(idx).description),
         decode( l_activities(idx).doc_id, fnd_api.g_miss_num, null, l_activities(idx).doc_id),
         l_activities(idx).end_date_time,
         l_activities(idx).activity_id,
         decode( l_activities(idx).result_id, fnd_api.g_miss_num, null, l_activities(idx).result_id),
         decode( l_activities(idx).reason_id, fnd_api.g_miss_num, null, l_activities(idx).reason_id),
         l_activities(idx).start_date_time,
         decode( l_activities(idx).interaction_action_type, fnd_api.g_miss_char, null, l_activities(idx).interaction_action_type),
         decode( l_activities(idx).media_id, fnd_api.g_miss_num, null, l_activities(idx).media_id),
         decode( l_activities(idx).outcome_id, fnd_api.g_miss_num, null, l_activities(idx).outcome_id),
         decode( l_activities(idx).action_item_id, fnd_api.g_miss_num, null, l_activities(idx).action_item_id),
         l_int_val_rec.interaction_id,
         decode( l_activities(idx).task_id, fnd_api.g_miss_num, null, l_activities(idx).task_id),
         Sysdate,
         p_user_id,
         p_user_id,
         Sysdate,
         p_login_id,
         decode( l_activities(idx).action_id, fnd_api.g_miss_num, null, l_activities(idx).action_id),
         decode( l_activities(idx).attribute1, fnd_api.g_miss_char, null, l_activities(idx).attribute1),
         decode( l_activities(idx).attribute2, fnd_api.g_miss_char, null, l_activities(idx).attribute2),
         decode( l_activities(idx).attribute3, fnd_api.g_miss_char, null, l_activities(idx).attribute3),
         decode( l_activities(idx).attribute4, fnd_api.g_miss_char, null, l_activities(idx).attribute4),
         decode( l_activities(idx).attribute5, fnd_api.g_miss_char, null, l_activities(idx).attribute5),
         decode( l_activities(idx).attribute6, fnd_api.g_miss_char, null, l_activities(idx).attribute6),
         decode( l_activities(idx).attribute7, fnd_api.g_miss_char, null, l_activities(idx).attribute7),
         decode( l_activities(idx).attribute8, fnd_api.g_miss_char, null, l_activities(idx).attribute8),
         decode( l_activities(idx).attribute9, fnd_api.g_miss_char, null, l_activities(idx).attribute9),
         decode( l_activities(idx).attribute10, fnd_api.g_miss_char, null, l_activities(idx).attribute10),
         decode( l_activities(idx).attribute11, fnd_api.g_miss_char, null, l_activities(idx).attribute11),
         decode( l_activities(idx).attribute12, fnd_api.g_miss_char, null, l_activities(idx).attribute12),
         decode( l_activities(idx).attribute13, fnd_api.g_miss_char, null, l_activities(idx).attribute13),
         decode( l_activities(idx).attribute14, fnd_api.g_miss_char, null, l_activities(idx).attribute14),
         decode( l_activities(idx).attribute15, fnd_api.g_miss_char, null, l_activities(idx).attribute15),
         decode( l_activities(idx).attribute_category, fnd_api.g_miss_char, null, l_activities(idx).attribute_category),
         l_active_perf,
         decode( l_activities(idx).script_trans_id, fnd_api.g_miss_num, null, l_activities(idx).script_trans_id),
         decode( l_activities(idx).role, fnd_api.g_miss_char, null, l_activities(idx).role),
         decode( l_activities(idx).doc_source_object_name, fnd_api.g_miss_char, null,l_activities(idx).doc_source_object_name),
         --, l_activities(idx).resource_id
         -- Added missed columns 09/10/2002
         decode( l_activities(idx).cust_account_id, fnd_api.g_miss_num, null, l_activities(idx).cust_account_id),
         decode( l_activities(idx).cust_org_id, fnd_api.g_miss_num, null, l_activities(idx).cust_org_id),
         decode( l_activities(idx).doc_ref, fnd_api.g_miss_char, null, l_activities(idx).doc_ref),
         decode( l_activities(idx).bulk_writer_code, fnd_api.g_miss_char, null, l_activities(idx).bulk_writer_code),
         decode( l_activities(idx).bulk_batch_type, fnd_api.g_miss_char, null, l_activities(idx).bulk_batch_type),
         decode( l_activities(idx).bulk_batch_id, fnd_api.g_miss_num, null, l_activities(idx).bulk_batch_id),
         decode( l_activities(idx).bulk_interaction_id, fnd_api.g_miss_num, null, l_activities(idx).bulk_interaction_id)
      );

Line: 3249

      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: 3478

			SELECT count(activity_id) 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: 3491

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

Line: 3503

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

Line: 3515

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

Line: 3526

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

Line: 3538

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

Line: 3549

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

Line: 3560

			SELECT count(*) into actionCount
			FROM jtf_ih_Activities
			where outcome_id = p_outcome_id
			;

Line: 3570

			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: 3583

			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
			;

Line: 3595

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

Line: 3607

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

Line: 3618

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

Line: 3630

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

Line: 3641

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

Line: 3652

			SELECT count(*) into actionCount
			FROM jtf_ih_Activities
			where outcome_id = p_outcome_id
			;

Line: 3845

		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: 4143

		--SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;

Line: 4158

		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,
			 TOUCHPOINT1_TYPE,
			 TOUCHPOINT2_TYPE,
       METHOD_CODE,
       PRIMARY_PARTY_ID,
       CONTACT_REL_PARTY_ID,
       CONTACT_PARTY_ID
			)
			VALUES
			(
			 p_user_id,
			 decode(p_interaction_rec.reference_form, fnd_api.g_miss_char, null, p_interaction_rec.reference_form),
			 Sysdate,
			 p_user_id,
			 --l_duration,
			 l_interaction_rec.duration,
			 Sysdate,
			 p_login_id,
			 --l_end_date_time,
			 l_interaction_rec.end_date_time,
			 decode( p_interaction_rec.follow_up_action, fnd_api.g_miss_char, null, p_interaction_rec.follow_up_action),
			 decode( p_interaction_rec.non_productive_time_amount, fnd_api.g_miss_num, null, p_interaction_rec.non_productive_time_amount),
			 decode( p_interaction_rec.result_id, fnd_api.g_miss_num, null, p_interaction_rec.result_id),
			 decode( p_interaction_rec.reason_id, fnd_api.g_miss_num, null, p_interaction_rec.reason_id),
			 --l_start_date_time,
			 l_interaction_rec.start_date_time,
			 decode( p_interaction_rec.outcome_id, fnd_api.g_miss_num, null, p_interaction_rec.outcome_id),
			 decode( p_interaction_rec.preview_time_amount, fnd_api.g_miss_num, null, p_interaction_rec.preview_time_amount),
			 --decode(l_productive_time_amount, fnd_api.g_miss_num, null, l_productive_time_amount),
			 decode(l_interaction_rec.productive_time_amount, fnd_api.g_miss_num, null, l_interaction_rec.productive_time_amount),
			 p_interaction_rec.handler_id,
			 decode( p_interaction_rec.inter_interaction_duration, fnd_api.g_miss_num, null, p_interaction_rec.inter_interaction_duration),
			 --l_interaction_id,
			 l_interaction_rec.interaction_id,
			 decode( p_interaction_rec.wrapup_time_amount, fnd_api.g_miss_num, null, p_interaction_rec.wrapup_time_amount),
			 decode( p_interaction_rec.script_id, fnd_api.g_miss_num, null, p_interaction_rec.script_id),
			 p_interaction_rec.party_id,
			 p_interaction_rec.resource_id,
			 decode( p_interaction_rec.object_id, fnd_api.g_miss_num, null, p_interaction_rec.object_id),
			 decode( p_interaction_rec.object_type, fnd_api.g_miss_char, null, p_interaction_rec.object_type),
			 decode( l_interaction_rec.source_code_id, fnd_api.g_miss_num, null, l_interaction_rec.source_code_id),
			 decode( l_interaction_rec.source_code, fnd_api.g_miss_char, null, l_interaction_rec.source_code),
			 decode( p_interaction_rec.attribute1, fnd_api.g_miss_char, null, p_interaction_rec.attribute1),
			 decode( p_interaction_rec.attribute2, fnd_api.g_miss_char, null, p_interaction_rec.attribute2),
			 decode( p_interaction_rec.attribute3, fnd_api.g_miss_char, null, p_interaction_rec.attribute3),
			 decode( p_interaction_rec.attribute4, fnd_api.g_miss_char, null, p_interaction_rec.attribute4),
			 decode( p_interaction_rec.attribute5, fnd_api.g_miss_char, null, p_interaction_rec.attribute5),
			 decode( p_interaction_rec.attribute6, fnd_api.g_miss_char, null, p_interaction_rec.attribute6),
			 decode( p_interaction_rec.attribute7, fnd_api.g_miss_char, null, p_interaction_rec.attribute7),
			 decode( p_interaction_rec.attribute8, fnd_api.g_miss_char, null, p_interaction_rec.attribute8),
			 decode( p_interaction_rec.attribute9, fnd_api.g_miss_char, null, p_interaction_rec.attribute9),
			 decode( p_interaction_rec.attribute10, fnd_api.g_miss_char, null, p_interaction_rec.attribute10),
			 decode( p_interaction_rec.attribute11, fnd_api.g_miss_char, null, p_interaction_rec.attribute11),
			 decode( p_interaction_rec.attribute12, fnd_api.g_miss_char, null, p_interaction_rec.attribute12),
			 decode( p_interaction_rec.attribute13, fnd_api.g_miss_char, null, p_interaction_rec.attribute13),
			 decode( p_interaction_rec.attribute14, fnd_api.g_miss_char, null, p_interaction_rec.attribute14),
			 decode( p_interaction_rec.attribute15, fnd_api.g_miss_char, null, p_interaction_rec.attribute15),
			 decode( p_interaction_rec.attribute_category, fnd_api.g_miss_char, null, p_interaction_rec.attribute_category),
			 l_active,
       decode( p_interaction_rec.touchpoint1_type, fnd_api.g_miss_char, null, p_interaction_rec.touchpoint1_type),
       decode( p_interaction_rec.touchpoint2_type, fnd_api.g_miss_char, null, p_interaction_rec.touchpoint2_type),
       decode( p_interaction_rec.method_code, fnd_api.g_miss_char, null, p_interaction_rec.method_code),
       decode( l_interaction_rec.primary_party_id, fnd_api.g_miss_num, null, l_interaction_rec.primary_party_id),
       decode( l_interaction_rec.contact_rel_party_id, fnd_api.g_miss_num, null, l_interaction_rec.contact_rel_party_id),
       decode( l_interaction_rec.contact_party_id, fnd_api.g_miss_num, null, l_interaction_rec.contact_party_id)
			);

Line: 4270

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

Line: 4274

				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,
					l_interaction_rec.interaction_id,
					p_interaction_rec.parent_id,
					p_user_id,
					Sysdate,
					p_user_id,
					Sysdate,
					p_user_id
 				);

Line: 4297

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

Line: 4390

PROCEDURE Update_Interaction
(
	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 NOCOPY	VARCHAR2,
	x_msg_count		OUT NOCOPY	NUMBER,
	x_msg_data		OUT NOCOPY	VARCHAR2,
	p_interaction_rec	IN	interaction_rec_type,
    -- Bug# 2012159
    p_object_version IN NUMBER DEFAULT NULL
)
AS
		l_api_name   		CONSTANT VARCHAR2(30) := 'Update_Interaction';

Line: 4454

  l_profile_id       VARCHAR2(20);  --profile option id check to update closed interaction

Line: 4456

		SELECT *
		FROM 	JTF_IH_INTERACTIONS
		WHERE 	interaction_id = p_interaction_rec.interaction_id
		FOR UPDATE;

Line: 4467

		SAVEPOINT update_interaction_pub;

Line: 4471

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'B', 'C') THEN
				JTF_IH_PUB_CUHK.update_interaction_pre(
				                     --p_interaction_rec=>l_interaction_rec_hk,
				                     p_interaction_rec=>l_int_rec,
						     x_data=>l_data,
						     x_count=>l_count_hk,
						     x_return_code=>l_return_code);

Line: 4485

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'B', 'V') THEN
				JTF_IH_PUB_VUHK.update_interaction_pre(
				                     --p_interaction_rec=>l_interaction_rec_hk,
				                     p_interaction_rec=>l_int_rec,
						     x_data=>l_data,
						     x_count=>l_count_hk,
						     x_return_code=>l_return_code);

Line: 4504

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

Line: 4534

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

Line: 4581

		  -- If yes then allow update on closed interaction
		  fnd_profile.get('JTF_IH_ALLOW_INT_UPDATE_AFTER_CLOSE',l_profile_id);

Line: 4588

		       fnd_message.set_name('JTF', 'JTF_IH_INT_UPDATE_NOT_ALLOW');

Line: 4596

		--	Check mandatory parameters to determine if their update paramater
		--	is null or of a FND_API.G_MISS type then set to existing DB record
		--	column value if needed.
		--

		--
		-- Check if party_id requies updating
		--

		IF (p_interaction_rec.party_id = fnd_api.g_miss_num) OR (p_interaction_rec.party_id IS NULL)  then
			l_int_rec.party_id := l_interaction_rec.party_id;

Line: 4858

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

Line: 4867

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

Line: 4890

      UPDATE jtf_ih_interaction_inters SET
         INTERACT_INTERACTION_IDRELATES = p_interaction_rec.parent_id,
 					       LAST_UPDATED_BY = p_user_id ,
					       LAST_UPDATE_DATE = SYSDATE,
					       LAST_UPDATE_LOGIN = p_user_id
         WHERE interact_interaction_id = p_interaction_rec.interaction_id;

Line: 5128

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

Line: 5138

		-- 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: 5145

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

Line: 5159

				UPDATE JTF_IH_INTERACTIONS
				SET
			 		REFERENCE_FORM			= l_int_rec.reference_form,
					LAST_UPDATED_BY			= p_user_id,
					DURATION			= l_int_rec.duration,
					LAST_UPDATE_DATE		= sysdate,
					LAST_UPDATE_LOGIN		= p_login_id,
					END_DATE_TIME			= l_int_rec.end_date_time,
					FOLLOW_UP_ACTION		= l_int_rec.follow_up_action,
					NON_PRODUCTIVE_TIME_AMOUNT	= l_int_rec.non_productive_time_amount,
					RESULT_ID			= l_int_rec.result_id,
					REASON_ID			= l_int_rec.reason_id,
					START_DATE_TIME			= l_int_rec.start_date_time,
					OUTCOME_ID			= decode( l_int_rec.outcome_id, fnd_api.g_miss_num, null, l_int_rec.outcome_id),
					PREVIEW_TIME_AMOUNT		= l_int_rec.preview_time_amount,
					PRODUCTIVE_TIME_AMOUNT		= l_int_rec.productive_time_amount,
					HANDLER_ID			= l_int_rec.handler_id,
					INTER_INTERACTION_DURATION	= l_int_rec.inter_interaction_duration,
					WRAP_UP_TIME_AMOUNT		= l_int_rec.wrapUp_time_amount,
					SCRIPT_ID			= l_int_rec.script_id,
					PARTY_ID			= l_int_rec.party_id,
					RESOURCE_ID			= l_int_rec.resource_id,
					OBJECT_ID			= l_int_rec.object_id,
		       		OBJECT_TYPE			= l_int_rec.object_type,
		       		SOURCE_CODE_ID		= decode(l_int_rec.source_code_id,fnd_api.g_miss_num,NULL,l_int_rec.source_code_id),
		       		SOURCE_CODE			= decode(l_int_rec.source_code,fnd_api.g_miss_char,NULL,l_int_rec.source_code),
					ATTRIBUTE1			= l_int_rec.attribute1,
					ATTRIBUTE2			= l_int_rec.attribute2,
					ATTRIBUTE3			= l_int_rec.attribute3,
					ATTRIBUTE4			= l_int_rec.attribute4,
					ATTRIBUTE5			= l_int_rec.attribute5,
					ATTRIBUTE6			= l_int_rec.attribute6,
					ATTRIBUTE7			= l_int_rec.attribute7,
					ATTRIBUTE8			= l_int_rec.attribute8,
					ATTRIBUTE9			= l_int_rec.attribute9,
					ATTRIBUTE10			= l_int_rec.attribute10,
					ATTRIBUTE11			= l_int_rec.attribute11,
					ATTRIBUTE12			= l_int_rec.attribute12,
					ATTRIBUTE13			= l_int_rec.attribute13,
					ATTRIBUTE14			= l_int_rec.attribute14,
					ATTRIBUTE_CATEGORY	= l_int_rec.attribute_category,
					TOUCHPOINT1_TYPE	= l_int_rec.touchpoint1_type,
					TOUCHPOINT2_TYPE	= l_int_rec.touchpoint2_type,
        METHOD_CODE   = l_int_rec.method_code,
        primary_party_id    = l_int_rec.primary_party_id,
        contact_rel_party_id = l_int_rec.contact_rel_party_id,
        contact_party_id    = l_int_rec.contact_party_id
				WHERE CURRENT OF c_Interaction_csr;

Line: 5214

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

Line: 5216

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

Line: 5220

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'A', 'V') THEN
				JTF_IH_PUB_VUHK.update_interaction_post(
				                     --p_interaction_rec=>l_interaction_rec_hk,
				                     p_interaction_rec=>l_int_rec,
						     x_data=>l_data,
						     x_count=>l_count_hk,
						     x_return_code=>l_return_code);

Line: 5234

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_INTERACTION', 'A', 'C') THEN
				JTF_IH_PUB_CUHK.update_interaction_post(
				                     --p_interaction_rec=>l_interaction_rec_hk,
				                     p_interaction_rec=>l_int_rec,
						     x_data=>l_data,
						     x_count=>l_count_hk,
						     x_return_code=>l_return_code);

Line: 5259

			ROLLBACK TO update_interaction_pub;

Line: 5266

			ROLLBACK TO update_interaction_pub;

Line: 5273

			ROLLBACK TO update_interaction_pub;

Line: 5282

	END Update_Interaction;

Line: 5351

		SELECT activity_id FROM jtf_ih_activities
		WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 5422

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

Line: 5449

		-- Update interaction
		--
		Update_Interaction
		(	p_api_version,
			p_init_msg_list,
			--p_commit,
      -- Bug# 2418028
			FND_API.G_FALSE,
			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,
      p_object_version);

Line: 5469

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

Line: 5472

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

Line: 5489

      SELECT end_date_time, start_date_time, duration
      --into l_end_date_time, l_start_date_time, l_duration
      into   l_interaction_rec.end_date_time,
             l_interaction_rec.start_date_time,
             l_interaction_rec.duration
      FROM jtf_ih_interactions
      WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 5543

      SELECT outcome_id, action_item_id, start_date_time, end_date_time, duration
      INTO la_outcome_id, l_action_item_id, la_start_date_time, la_end_date_time, la_duration
      FROM jtf_ih_activities
      WHERE activity_id = v_activity_id_c.activity_id;

Line: 5607

        UPDATE jtf_ih_activities SET ACTIVE = l_active_perf,
               END_DATE_TIME = la_end_date_time, DURATION = la_duration
	WHERE ACTIVITY_ID = v_activity_id_c.activity_id;

Line: 5614

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

Line: 5643

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

Line: 5663

			UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time
					WHERE activity_id = v_activity_id_c.activity_id;*/

Line: 5666

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

Line: 5677

	   UPDATE jtf_ih_interactions
           SET ACTIVE = l_active_perf,
           START_DATE_TIME = l_interaction_rec.start_date_time,
           end_date_time = l_interaction_rec.end_date_time,
           duration = l_interaction_rec.duration
	   WHERE interaction_id = p_interaction_rec.interaction_id;

Line: 5890

   		SELECT active
 		INTO   l_inter_active
 		FROM   JTF_IH_INTERACTIONS
 		WHERE   interaction_id = p_activity_rec.interaction_id;

Line: 5944

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

Line: 5955

      SELECT resource_id INTO l_activity_rec.resource_id
      FROM jtf_ih_interactions WHERE interaction_id = p_activity_rec.interaction_id;

Line: 5962

		--SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;

Line: 5969

		INSERT INTO jtf_ih_Activities
		(
			ACTIVITY_ID,
			OBJECT_ID,
			OBJECT_TYPE,
			SOURCE_CODE_ID,
			SOURCE_CODE,
			DURATION,
			DESCRIPTION,
			DOC_ID,
			DOC_REF,
			DOC_SOURCE_OBJECT_NAME,
			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,
			CUST_ACCOUNT_ID,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
			ACTIVE,
      SCRIPT_TRANS_ID,
      ROLE
--      ,RESOURCE_ID
		)
		VALUES
		(
			--l_activity_id,
			l_activity_rec.activity_id,
			decode( p_activity_rec.object_id, fnd_api.g_miss_num, null, p_activity_rec.object_id),
      decode( p_activity_rec.object_type, fnd_api.g_miss_char, null, p_activity_rec.object_type),
			decode( l_activity_rec.source_code_id, fnd_api.g_miss_num, null, l_activity_rec.source_code_id),
			decode( l_activity_rec.source_code, fnd_api.g_miss_char, null, l_activity_rec.source_code),
			--l_duration,
			l_activity_rec.duration,
			decode( p_activity_rec.description, fnd_api.g_miss_char, null, p_activity_rec.description),
			decode( p_activity_rec.doc_id, fnd_api.g_miss_num, null, p_activity_rec.doc_id),
			decode( p_activity_rec.doc_ref, fnd_api.g_miss_char, null, p_activity_rec.doc_ref),
			decode( p_activity_rec.doc_source_object_name, fnd_api.g_miss_char, null, p_activity_rec.doc_source_object_name),
			--l_end_date_time,
			l_activity_rec.end_date_time,
			decode( p_activity_rec.result_id, fnd_api.g_miss_num, null, p_activity_rec.result_id),
			decode( p_activity_rec.reason_id, fnd_api.g_miss_num, null, p_activity_rec.reason_id),
			--l_start_date_time,
			l_activity_rec.start_date_time,
			decode( p_activity_rec.action_id, fnd_api.g_miss_num, null, p_activity_rec.action_id),
			decode( p_activity_rec.interaction_action_type, fnd_api.g_miss_char, null, p_activity_rec.interaction_action_type),
			decode( p_activity_rec.media_id, fnd_api.g_miss_num, null, p_activity_rec.media_id),
			decode( p_activity_rec.outcome_id, fnd_api.g_miss_num, null, p_activity_rec.outcome_id),
			decode( p_activity_rec.action_item_id, fnd_api.g_miss_num, null, p_activity_rec.action_item_id),
			p_activity_rec.interaction_id,
			decode( p_activity_rec.task_id, fnd_api.g_miss_num, null, p_activity_rec.task_id),
			Sysdate,
			p_user_id,
			p_user_id,
			Sysdate,
			p_login_id,
			decode( p_activity_rec.cust_account_id, fnd_api.g_miss_num, null, p_activity_rec.cust_account_id),
			decode( p_activity_rec.attribute1, fnd_api.g_miss_char, null, p_activity_rec.attribute1),
			decode( p_activity_rec.attribute2, fnd_api.g_miss_char, null, p_activity_rec.attribute2),
			decode( p_activity_rec.attribute3, fnd_api.g_miss_char, null, p_activity_rec.attribute3),
			decode( p_activity_rec.attribute4, fnd_api.g_miss_char, null, p_activity_rec.attribute4),
			decode( p_activity_rec.attribute5, fnd_api.g_miss_char, null, p_activity_rec.attribute5),
			decode( p_activity_rec.attribute6, fnd_api.g_miss_char, null, p_activity_rec.attribute6),
			decode( p_activity_rec.attribute7, fnd_api.g_miss_char, null, p_activity_rec.attribute7),
      decode( p_activity_rec.attribute8, fnd_api.g_miss_char, null, p_activity_rec.attribute8),
      decode( p_activity_rec.attribute9, fnd_api.g_miss_char, null, p_activity_rec.attribute9),
      decode( p_activity_rec.attribute10, fnd_api.g_miss_char, null, p_activity_rec.attribute10),
      decode( p_activity_rec.attribute11, fnd_api.g_miss_char, null, p_activity_rec.attribute11),
      decode( p_activity_rec.attribute12, fnd_api.g_miss_char, null, p_activity_rec.attribute12),
      decode( p_activity_rec.attribute13, fnd_api.g_miss_char, null, p_activity_rec.attribute13),
      decode( p_activity_rec.attribute14, fnd_api.g_miss_char, null, p_activity_rec.attribute14),
      decode( p_activity_rec.attribute15, fnd_api.g_miss_char, null, p_activity_rec.attribute15),
      decode( p_activity_rec.attribute_category, fnd_api.g_miss_char, null, p_activity_rec.attribute_category),
			l_active,
      decode( p_activity_rec.script_trans_id, fnd_api.g_miss_num, null, p_activity_rec.script_trans_id),
      decode( p_activity_rec.role, fnd_api.g_miss_char, null, p_activity_rec.role)
--      ,l_activity_rec.resource_id
		);

Line: 6073

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

Line: 6168

PROCEDURE Update_Activity
(
	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 NOCOPY	VARCHAR2,
	x_msg_count		OUT NOCOPY	NUMBER,
	x_msg_data		OUT NOCOPY	VARCHAR2,
	p_activity_rec		IN	activity_rec_type,
    -- Bug# 2012159
    p_object_version IN NUMBER DEFAULT NULL
)
AS
		l_api_name   	CONSTANT VARCHAR2(30) := 'Update_Activity';

Line: 6244

  l_profile_id       VARCHAR2(20);  --profile option id check to update closed interaction

Line: 6246

  CURSOR c_Activity_crs IS SELECT * FROM JTF_IH_ACTIVITIES
      WHERE Activity_ID = p_activity_rec.activity_id;

Line: 6252

		SAVEPOINT update_activity_pub;

Line: 6256

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'B', 'C') THEN
				JTF_IH_PUB_CUHK.update_activity_pre(p_activity_rec=>l_activity_rec,
						     x_data=>l_data,
						     x_count=>l_count_hk,
						     x_return_code=>l_return_code);

Line: 6268

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'B', 'V') THEN
				JTF_IH_PUB_VUHK.update_activity_pre(p_activity_rec=>l_activity_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 6285

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

Line: 6315

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

Line: 6330

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

Line: 6333

		-- 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: 6340

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

Line: 6361

	    		     -- If yes then allow update on closed activity
			     fnd_profile.get('JTF_IH_ALLOW_INT_UPDATE_AFTER_CLOSE',l_profile_id);

Line: 6750

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

Line: 6769

        UPDATE jtf_ih_activities SET
	           cust_account_id = l_activity_rec.cust_account_id,
	           cust_org_id = l_activity_rec.cust_org_id,
	           role = l_activity_rec.role,
	           LAST_UPDATED_BY	= p_user_id,
                   LAST_UPDATE_DATE	= sysdate,
	           end_date_time = l_activity_rec.end_date_time,
	           start_date_time = l_activity_rec.start_date_time,
                   duration = l_activity_rec.duration,
	           task_id = l_activity_rec.task_id,
	           doc_id = l_activity_rec.doc_id,
	           doc_ref = l_activity_rec.doc_ref,
	           doc_source_object_name = l_activity_rec.doc_source_object_name,
	           media_id = l_activity_rec.media_id,
	           action_item_id = l_activity_rec.action_item_id,
	           outcome_id = l_activity_rec.outcome_id,
	           result_id = l_activity_rec.result_id,
	           reason_id = l_activity_rec.reason_id,
	           description = l_activity_rec.description,
	           action_id = l_activity_rec.action_id,
	           interaction_action_type = l_activity_rec.interaction_action_type,
	           object_id = l_activity_rec.object_id,
	           object_type = l_activity_rec.object_type,
	           source_code_id = decode( l_activity_rec.source_code_id, fnd_api.g_miss_num, NULL, l_activity_rec.source_code_id),
	           source_code = decode( l_activity_rec.source_code, fnd_api.g_miss_char, NULL, l_activity_rec.source_code),
	           script_trans_id = l_activity_rec.script_trans_id,
               object_version_number = l_object_version,
               attribute1 = l_activity_rec.attribute1,
               attribute2 = l_activity_rec.attribute2,
               attribute3 = l_activity_rec.attribute3,
               attribute4 = l_activity_rec.attribute4,
               attribute5 = l_activity_rec.attribute5,
               attribute6 = l_activity_rec.attribute6,
               attribute7 = l_activity_rec.attribute7,
               attribute8 = l_activity_rec.attribute8,
               attribute9 = l_activity_rec.attribute9,
               attribute10 = l_activity_rec.attribute10,
               attribute11 = l_activity_rec.attribute11,
               attribute12 = l_activity_rec.attribute12,
               attribute13 = l_activity_rec.attribute13,
               attribute14 = l_activity_rec.attribute14,
               attribute15 = l_activity_rec.attribute15,
               attribute_category = l_activity_rec.attribute_category
         -- resource_id = l_resource_id
        WHERE Activity_id = p_activity_rec.activity_id;

Line: 6820

				    fnd_message.set_name('JTF', 'JTF_IH_ACT_UPDATE_NOT_ALLOW');

Line: 6828

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

Line: 6832

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'A', 'V') THEN
				JTF_IH_PUB_VUHK.update_activity_post(p_activity_rec=>l_activity_rec,
						     x_data=>l_data,
						     x_count=>l_count_hk,
						     x_return_code=>l_return_code);

Line: 6844

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITY', 'A', 'C') THEN
				JTF_IH_PUB_CUHK.update_activity_post(p_activity_rec=>l_activity_rec,
						     x_data=>l_data,
						     x_count=>l_count_hk,
						     x_return_code=>l_return_code);

Line: 6866

			ROLLBACK TO update_activity_pub;

Line: 6873

			ROLLBACK TO update_activity_pub;

Line: 6880

			ROLLBACK TO update_activity_pub;

Line: 6889

	END Update_Activity;

Line: 6951

			SELECT activity_id FROM jtf_ih_activities
			WHERE interaction_id = p_interaction_id;

Line: 7023

   	SELECT outcome_id, end_date_time, start_date_time, duration
        INTO l_outcome_id, l_end_date_time, l_start_date_time, l_duration
        FROM jtf_ih_interactions
        WHERE interaction_id = p_interaction_id;

Line: 7059

      SELECT outcome_id, action_item_id, start_date_time, end_date_time, duration
      INTO la_outcome_id, l_action_item_id, la_start_date_time, la_end_date_time, la_duration
      FROM jtf_ih_activities
      WHERE activity_id = v_activity_id_c.activity_id;

Line: 7120

			  UPDATE jtf_ih_activities SET ACTIVE = l_active_perf,END_DATE_TIME = la_end_date_time, DURATION = la_duration
					WHERE ACTIVITY_ID = v_activity_id_c.activity_id;

Line: 7123

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

Line: 7134

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

Line: 7145

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

Line: 7158

			UPDATE jtf_ih_activities SET ACTIVE = 'N',end_date_time = l_end_date_time, duration = l_duration
					WHERE interaction_id = p_interaction_id;*/

Line: 7161

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

Line: 7168

		UPDATE jtf_ih_interactions SET ACTIVE = l_active_perf,end_date_time =l_end_date_time,
      duration = decode(l_duration, fnd_api.g_miss_num, l_duration_perf, l_duration)
				WHERE interaction_id = p_interaction_id;

Line: 7248

PROCEDURE Update_ActivityDuration
(
	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 NOCOPY	VARCHAR2,
	x_msg_count			OUT NOCOPY	NUMBER,
	x_msg_data			OUT NOCOPY	VARCHAR2,
	p_activity_id		IN	NUMBER,
	p_end_date_time		IN  DATE,
	p_duration			IN	NUMBER,
    -- Bug# 2012159
    p_object_version IN NUMBER DEFAULT NULL

)
AS
	l_api_name   	CONSTANT VARCHAR2(30) := 'Update_ActivityDuration';

Line: 7284

		SAVEPOINT update_activityDuration;

Line: 7286

		-- No Activity ID - No Update possible
		IF (p_activity_id IS NULL) THEN
			jtf_ih_core_util_pvt.add_null_parameter_msg(l_api_name_full, 'activity_id');

Line: 7309

		IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'B', 'C') THEN
			JTF_IH_PUB_CUHK.update_actduration_pre(
							p_activity_id=>l_activity_id,
							p_end_date_time=>l_end_date_time,
							p_duration=>l_duration,
						     	x_data=>l_data,
						     	x_count=>l_count,
						     	x_return_code=>l_return_code);

Line: 7324

		IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'B', 'V') THEN
				JTF_IH_PUB_VUHK.update_actduration_pre(
							p_activity_id=>l_activity_id,
							p_end_date_time=>l_end_date_time,
							p_duration=>l_duration,
						     	x_data=>l_data,
						     	x_count=>l_count,
						     	x_return_code=>l_return_code);

Line: 7345

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

Line: 7375

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

Line: 7381

		SELECT start_date_time, end_date_time, duration, active into
			l_start_date_time, l_end_date_time, l_duration, l_active
			FROM jtf_ih_activities
			WHERE activity_id = p_activity_id;

Line: 7386

		-- If the activity is not active, then refuse the update.
		--
		If l_active = 'N' then
			x_return_status := fnd_api.g_ret_sts_error;

Line: 7412

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

Line: 7416

		-- Bug# 2656975 Determine how the duration is to be updated - RDD
		--   If the duration is not passed, then calculate it.
		--	   else Make sure negative durations are not allowed.
		--	   else use the passed value
		IF (p_duration IS NULL) OR (p_duration = fnd_api.g_miss_num) THEN
		    l_duration := ROUND((l_end_date_time - l_start_date_time)*24*60*60);

Line: 7428

		-- Update the activity
		UPDATE jtf_ih_activities SET END_DATE_TIME = l_end_date_time,
						DURATION = l_duration,
						OBJECT_VERSION_NUMBER = p_object_version
    	WHERE activity_id = p_activity_id;

Line: 7433

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

Line: 7437

		IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'A', 'V') THEN
			JTF_IH_PUB_VUHK.update_actduration_post(
							p_activity_id=>l_activity_id,
							p_end_date_time=>l_end_date_time,
							p_duration=>l_duration,
						     	x_data=>l_data,
						     	x_count=>l_count,
						     	x_return_code=>l_return_code);

Line: 7452

		IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_ACTIVITYDURATION', 'A', 'C') THEN
			JTF_IH_PUB_CUHK.update_actduration_post(
							p_activity_id=>l_activity_id,
							p_end_date_time=>l_end_date_time,
							p_duration=>l_duration,
						     	x_data=>l_data,
						     	x_count=>l_count,
						     	x_return_code=>l_return_code);

Line: 7476

			ROLLBACK TO update_activityDuration;

Line: 7483

			ROLLBACK TO update_activityDuration;

Line: 7490

			ROLLBACK TO update_activityDuration;

Line: 7499

	END Update_ActivityDuration;

Line: 7556

   l_ao_update_pending_perf VARCHAR2(1);

Line: 7563

   l_ao_update_pending_perf := 'N';

Line: 7710

		--SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;

Line: 7714

		INSERT INTO jtf_ih_media_items
		(
			 CREATED_BY,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 LAST_UPDATE_DATE,
			 LAST_UPDATE_LOGIN,
			 MEDIA_ID,
			 DURATION,
			 DIRECTION,
			 END_DATE_TIME,
			 SOURCE_ITEM_CREATE_DATE_TIME,
			 SOURCE_ITEM_ID,
			 START_DATE_TIME,
			 SOURCE_ID,
			 MEDIA_ITEM_TYPE,
			 MEDIA_ITEM_REF,
			 MEDIA_DATA,
			 MEDIA_ABANDON_FLAG,
			 MEDIA_TRANSFERRED_FLAG,
			 ACTIVE,
             SERVER_GROUP_ID,
             DNIS,
             ANI,
             CLASSIFICATION,
             ADDRESS,
             AO_UPDATE_PENDING,
             SOFT_CLOSED
			)
			VALUES
			(
			 p_user_id,
			 Sysdate,
			 p_user_id,
			 Sysdate,
			 p_login_id,
			 --l_media_id,
			 l_media_rec.media_id,
			 --l_duration,
			 l_media_rec.duration,
			 decode( p_media_rec.direction, fnd_api.g_miss_char, null, p_media_rec.direction),
			 --l_end_date_time,
			 l_media_rec.end_date_time,
       -- Added by IAleshin 21-MAY-2002
			 --l_source_item_create_date_time,
			 l_media_rec.source_item_create_date_time,
			 decode( p_media_rec.source_item_id, fnd_api.g_miss_num, null, p_media_rec.source_item_id),
			 --l_start_date_time,
			 l_media_rec.start_date_time,
			 decode( p_media_rec.source_id, fnd_api.g_miss_num, null, p_media_rec.source_id),
			 decode( p_media_rec.media_item_type, fnd_api.g_miss_char, null, p_media_rec.media_item_type),
			 decode( p_media_rec.media_item_ref, fnd_api.g_miss_char, null, p_media_rec.media_item_ref),
			 decode( p_media_rec.media_data, fnd_api.g_miss_char, null, p_media_rec.media_data),
			 decode( p_media_rec.media_abandon_flag, fnd_api.g_miss_char, null, p_media_rec.media_abandon_flag),
			 decode( p_media_rec.media_transferred_flag, fnd_api.g_miss_char, null, p_media_rec.media_transferred_flag),
			 l_active,
             decode( p_media_rec.server_group_id, fnd_api.g_miss_num, null, p_media_rec.server_group_id),
             decode( p_media_rec.dnis, fnd_api.g_miss_char, null, p_media_rec.dnis),
             decode( p_media_rec.ani, fnd_api.g_miss_char, null, p_media_rec.ani),
             decode( p_media_rec.classification, fnd_api.g_miss_char, null, p_media_rec.classification),
             --decode( l_address, fnd_api.g_miss_char, null, l_address),
             decode( l_media_rec.address, fnd_api.g_miss_char, null, l_media_rec.address),
             l_ao_update_pending_perf,
             l_soft_closed_perf
			);

Line: 7779

		-- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO jtf_ih_media_items in JTF_IH_PUB.Open_MediaItem');

Line: 7870

	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 NOCOPY	VARCHAR2,
	x_msg_count	OUT NOCOPY	NUMBER,
	x_msg_data	OUT NOCOPY	VARCHAR2,
	p_media_rec	IN	media_rec_type,
    -- Bug# 2012159
    p_object_version IN NUMBER DEFAULT NULL
	) AS
	l_api_name   			CONSTANT VARCHAR2(30) := 'Update_MediaItem';

Line: 7915

		SELECT *
		FROM 	JTF_IH_MEDIA_ITEMS
		WHERE 	media_id = p_media_rec.media_id
		FOR UPDATE;

Line: 7927

		SAVEPOINT update_mediaitem_pub;

Line: 7931

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'B', 'C') THEN
				JTF_IH_PUB_CUHK.update_mediaitem_pre(
				                     --p_media_rec=>l_media_rec_hk,
				                     p_media_rec=>l_media_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 7945

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'B', 'V') THEN
				JTF_IH_PUB_VUHK.update_mediaitem_pre(
				                     --p_media_rec=>l_media_rec_hk,
				                     p_media_rec=>l_media_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 7966

		-- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Update_MediaItem');

Line: 7996

		-- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_MediaItem');

Line: 8263

		-- DBMS_OUTPUT.PUT_LINE('PAST Validate_MediaItem_Record in JTF_IH_PUB.Update_MediaItem');

Line: 8265

		UPDATE JTF_IH_MEDIA_ITEMS
			SET	source_id		=	l_media_rec.source_id,
				direction		=	l_media_rec.direction,
				duration		=	l_media_rec.duration,
				end_date_time		=	l_media_rec.end_date_time,
				interaction_performed	=	l_media_rec.interaction_performed,
				start_date_time		=	l_media_rec.start_date_time,
				media_data		=	decode( l_media_rec.media_data, fnd_api.g_miss_char, null, l_media_rec.media_data),
				source_item_create_date_time = l_media_rec.source_item_create_date_time,
				source_item_id		=	l_media_rec.source_item_id,
				media_item_type		=	l_media_rec.media_item_type,
				media_item_ref		=	l_media_rec.media_item_ref,
				media_abandon_flag	=	l_media_rec.media_abandon_flag,
				media_transferred_flag	=	l_media_rec.media_transferred_flag,
    -- Bug# 2338832
    server_group_id     =   decode(l_media_rec.server_group_id,fnd_api.g_miss_num,null, l_media_rec.server_group_id),
    dnis    =   decode(l_media_rec.dnis, fnd_api.g_miss_char, null, l_media_rec.dnis),
    ani     =   decode(l_media_rec.ani, fnd_api.g_miss_char, null, l_media_rec.ani),
    classification      =   decode(l_media_rec.classification, fnd_api.g_miss_char, null, l_media_rec.classification),
				last_update_date	=	sysdate,
				last_updated_by		=	p_user_id,
				last_update_login	=	p_login_id,
    object_version_number = l_object_version,
    BULK_WRITER_CODE    =   l_media_rec.bulk_writer_code,
    BULK_BATCH_TYPE     =   l_media_rec.bulk_batch_type,
    BULK_BATCH_ID       =   l_media_rec.bulk_batch_id,
    BULK_INTERACTION_ID =   l_media_rec.bulk_interaction_id,
    ADDRESS       =   decode(l_media_rec.address,fnd_api.g_miss_char, null, l_media_rec.address)
			WHERE CURRENT OF c_MediaItem_csr;

Line: 8302

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'A', 'V') THEN
				JTF_IH_PUB_VUHK.update_mediaitem_post(
				                     --p_media_rec=>l_media_rec_hk,
				                     p_media_rec=>l_media_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 8316

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIAITEM', 'A', 'C') THEN
				JTF_IH_PUB_CUHK.update_mediaitem_post(
				                     --p_media_rec=>l_media_rec_hk,
				                     p_media_rec=>l_media_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 8342

			ROLLBACK TO Update_mediaitem_pub;

Line: 8349

			ROLLBACK TO Update_mediaitem_pub;

Line: 8356

			ROLLBACK TO Update_mediaitem_pub;

Line: 8365

	END Update_MediaItem;

Line: 8424

		l_ao_update_pending VARCHAR2(1);

Line: 8434

		 	SELECT *
		 	FROM jtf_ih_media_item_lc_segs
		 	WHERE media_id = p_media_rec.media_id;

Line: 8515

   	SELECT ao_update_pending,  direction, media_item_type, end_date_time
        INTO l_ao_update_pending, l_direction, l_media_item_type, l_end_date_time
        FROM JTF_IH_MEDIA_ITEMS WHERE Media_Id = p_media_rec.media_id;

Line: 8531

		--Update MediaItem
		--
		Update_MediaItem(
					p_api_version,
					p_init_msg_list,
					'F',         -- No Commit.
					p_resp_appl_id,
					p_resp_id,
					p_user_id,
					p_login_id,
					x_return_status,
					x_msg_count,
					x_msg_data,
					l_media_rec,
        			p_object_version);

Line: 8549

		-- DBMS_OUTPUT.PUT_LINE('PAST Update_MediaItem in JTF_IH_PUB.Close_MediaItem');

Line: 8554

		IF l_ao_update_pending = 'Y' THEN
			--  Soft close the MI
			UPDATE JTF_IH_MEDIA_ITEMS
			SET SOFT_CLOSED = l_soft_closed_perf
			WHERE MEDIA_ID = p_media_rec.media_id;

Line: 8561

			UPDATE JTF_IH_MEDIA_ITEMS
			SET ACTIVE = l_active_perf
			WHERE MEDIA_ID = p_media_rec.media_id;

Line: 8567

		UPDATE JTF_IH_MEDIA_ITEMS
		set ACTIVE = l_active_perf
		WHERE MEDIA_ID = p_media_rec.media_id;

Line: 8574

  FOR cur_Milcs IN (SELECT milcs_id, start_date_time, end_date_time, duration
          FROM jtf_ih_media_item_lc_segs WHERE Media_Id = p_media_rec.media_id) LOOP
      IF (cur_Milcs.end_date_time IS NULL) OR (cur_Milcs.end_date_time = fnd_api.g_miss_date) THEN
    		cur_Milcs.end_date_time := l_end_date_time;

Line: 8593

        UPDATE JTF_IH_MEDIA_ITEM_LC_SEGS SET
			End_Date_Time = cur_Milcs.end_date_time,
        	Start_Date_time = cur_Milcs.start_date_time,
        	Duration = cur_Milcs.duration,
        	Active = l_active_perf
        	WHERE milcs_id = cur_Milcs.milcs_id;

Line: 8813

			select milcs_type_id
			--INTO l_milcs_type_id
			INTO   l_media_lc_rec.milcs_type_id
			from JTF_IH_MEDIA_ITM_LC_SEG_TYS
			where milcs_code = p_media_lc_rec.milcs_code;

Line: 8871

		--SELECT JTF_IH_MEDIA_ITEM_LC_SEG_S1.NextVal into l_milcs_id FROM dual;

Line: 8876

		INSERT INTO jtf_ih_media_item_lc_segs
		(
			 CREATED_BY,
			 CREATION_DATE,
			 LAST_UPDATED_BY,
			 LAST_UPDATE_DATE,
			 LAST_UPDATE_LOGIN,
			 MILCS_ID,
			 START_DATE_TIME,
			 TYPE_TYPE,
			 TYPE_ID,
			 DURATION,
			 END_DATE_TIME,
			 MILCS_TYPE_ID,
			 MEDIA_ID,
			 HANDLER_ID,
			 RESOURCE_ID,
			 ACTIVE
			)
			VALUES
			(
			 p_user_id,
			 Sysdate,
			 p_user_id,
			 Sysdate,
			 p_login_id,
			 --l_milcs_id,
			 l_media_lc_rec.milcs_id,
			 --l_start_date_time,
			 l_media_lc_rec.start_date_time,
			 decode(p_media_lc_rec.type_type,fnd_api.g_miss_char, null, p_media_lc_rec.type_type),
			 decode(p_media_lc_rec.type_id,fnd_api.g_miss_num, null, p_media_lc_rec.type_id),
			 --l_duration,
			 l_media_lc_rec.duration,
			 --l_end_date_time,
			 l_media_lc_rec.end_date_time,
			 --l_milcs_type_id,
			 l_media_lc_rec.milcs_type_id,
			 l_media_lc_rec.media_id,
			 l_media_lc_rec.handler_id,
			 decode(l_media_lc_rec.resource_id,fnd_api.g_miss_num, null, l_media_lc_rec.resource_id),
			 l_active
			);

Line: 8919

		-- DBMS_OUTPUT.PUT_LINE('PAST INSERT INTO Validate_Media_LC_Record in JTF_IH_PUB.Add_MediaLifeCycle');

Line: 9006

	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 NOCOPY	VARCHAR2,
	x_msg_count	OUT NOCOPY	NUMBER,
	x_msg_data	OUT NOCOPY	VARCHAR2,
	p_media_lc_rec	IN	media_lc_rec_type,
    -- Bug# 2012159
    p_object_version IN NUMBER DEFAULT NULL
	) AS
	l_api_name   			CONSTANT VARCHAR2(30) := 'Update_MediaLifecycle';

Line: 9048

	CURSOR c_Update_MediaLifecycle_csr IS
		SELECT *
		FROM 	JTF_IH_MEDIA_ITEM_LC_SEGS
		WHERE 	milcs_id = p_media_lc_rec.milcs_id
		FOR UPDATE;

Line: 9053

	v_Update_MediaLifecycle_rec	c_Update_MediaLifecycle_csr%ROWTYPE;

Line: 9069

		        SAVEPOINT update_medialifecycle_pub;

Line: 9073

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'B', 'C') THEN
				JTF_IH_PUB_CUHK.update_medialifecycle_pre(
				                     --p_media_lc_rec=>l_media_lc_rec_hk,
				                     p_media_lc_rec=>l_media_lc_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 9087

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'B', 'V') THEN
				JTF_IH_PUB_VUHK.update_medialifecycle_pre(
				                     --p_media_lc_rec=>l_media_lc_rec_hk,
				                     p_media_lc_rec=>l_media_lc_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 9106

		-- DBMS_OUTPUT.PUT_LINE('PAST fnd_api.compatible_api_call in JTF_IH_PUB.Update_MediaLifecycle');

Line: 9136

		-- DBMS_OUTPUT.PUT_LINE('PAST jtf_ih_core_util_pvt.validate_who_info in JTF_IH_PUB.Update_MediaLifecycle');

Line: 9143

			OPEN c_Update_MediaLifecycle_csr;

Line: 9144

			FETCH c_Update_MediaLifecycle_csr INTO  v_Update_MediaLifecycle_rec;

Line: 9145

			IF (c_Update_MediaLifecycle_csr%notfound) THEN
				x_return_status := fnd_api.g_ret_sts_error;

Line: 9151

			-- DBMS_OUTPUT.PUT_LINE('PAST OPEN c_Update_MediaLifecycle_csr in JTF_IH_PUB.Update_MediaLifecycle');

Line: 9153

			IF(v_Update_MediaLifecycle_rec.active <> 'N') THEN
				--
				-- Check if start_date_time requires updating
				--
				IF ((p_media_lc_rec.start_date_time IS NULL) OR (p_media_lc_rec.start_date_time = fnd_api.g_miss_date)) then
					--l_start_date_time := v_Update_MediaLifecycle_rec.start_date_time;

Line: 9159

					l_media_lc_rec.start_date_time := v_Update_MediaLifecycle_rec.start_date_time;

Line: 9168

					IF ((v_Update_MediaLifecycle_rec.end_date_time IS NULL) OR (v_Update_MediaLifecycle_rec.end_date_time = fnd_api.g_miss_date)) THEN
						--l_end_date_time := sysdate;

Line: 9172

						--l_end_date_time := v_Update_MediaLifecycle_rec.end_date_time;

Line: 9173

						l_media_lc_rec.end_date_time := v_Update_MediaLifecycle_rec.end_date_time;

Line: 9189

					--DBMS_OUTPUT.PUT_LINE('Error in Validate_StartEnd_Date of JTF_IH_PUB.Update_MediaLifecycle');

Line: 9196

				    --l_duration := v_Update_MediaLifecycle_rec.duration;

Line: 9197

				    l_media_lc_rec.duration := v_Update_MediaLifecycle_rec.duration;

Line: 9206

				--DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB.Update_MediaLifecycle');

Line: 9208

				-- DBMS_OUTPUT.PUT_LINE('hello active error in JTF_IH_PUB.Update_MediaLifecycle');

Line: 9216

				-- DBMS_OUTPUT.PUT_LINE('l_type_type1 v_Update_MediaLifecycle_rec.type_type := ' || v_Update_MediaLifecycle_rec.type_type);

Line: 9219

					-- DBMS_OUTPUT.PUT_LINE('l_type_type2 := ' || v_Update_MediaLifecycle_rec.type_type);

Line: 9220

					--l_type_type := v_Update_MediaLifecycle_rec.type_type;

Line: 9221

					l_media_lc_rec.type_type := v_Update_MediaLifecycle_rec.type_type;

Line: 9232

					--l_type_id := v_Update_MediaLifecycle_rec.type_id;

Line: 9233

					l_media_lc_rec.type_id := v_Update_MediaLifecycle_rec.type_id;

Line: 9243

					--l_milcs_type_id := v_Update_MediaLifecycle_rec.milcs_type_id;

Line: 9244

					l_media_lc_rec.milcs_type_id := v_Update_MediaLifecycle_rec.milcs_type_id;

Line: 9255

					--l_handler_id := v_Update_MediaLifecycle_rec.handler_id;

Line: 9256

					l_media_lc_rec.handler_id := v_Update_MediaLifecycle_rec.handler_id;

Line: 9267

					--l_resource_id := v_Update_MediaLifecycle_rec.resource_id;

Line: 9268

					l_media_lc_rec.resource_id := v_Update_MediaLifecycle_rec.resource_id;

Line: 9274

				-- DBMS_OUTPUT.PUT_LINE('Before UPDATE JTF_IH_MEDIA_ITEM_LC_SEGS in JTF_IH_PUB.Update_MediaLifecycle');

Line: 9279

		        l_object_version := v_Update_MediaLifecycle_rec.object_version_number;

Line: 9289

		        l_bulk_writer_code := v_Update_MediaLifecycle_rec.bulk_writer_code;

Line: 9297

		        l_bulk_batch_type := v_Update_MediaLifecycle_rec.bulk_batch_type;

Line: 9306

		        l_bulk_batch_id := v_Update_MediaLifecycle_rec.bulk_batch_id;

Line: 9314

		        l_bulk_interaction_id := v_Update_MediaLifecycle_rec.bulk_writer_code;

Line: 9331

		-- DBMS_OUTPUT.PUT_LINE('PAST Validate_MediaItem_Record in JTF_IH_PUB.Update_MediaLifecycle');

Line: 9334

				UPDATE JTF_IH_MEDIA_ITEM_LC_SEGS
				SET
					handler_id		=	l_media_lc_rec.handler_id,
					resource_id		=	l_media_lc_rec.resource_id,
					duration		=	decode( l_media_lc_rec.duration, fnd_api.g_miss_num, 0,l_media_lc_rec.duration),
					end_date_time		=	l_media_lc_rec.end_date_time,
					start_date_time		=	l_media_lc_rec.start_date_time,
					type_type		=	decode( l_media_lc_rec.type_type, fnd_api.g_miss_char, null,l_media_lc_rec.type_type),
					type_id 		= 	decode( l_media_lc_rec.type_id, fnd_api.g_miss_num, null,l_media_lc_rec.type_id),
					milcs_type_id		=	decode( l_media_lc_rec.milcs_type_id, fnd_api.g_miss_num, null,l_media_lc_rec.milcs_type_id),
					last_update_date	=	sysdate,
					last_updated_by		=	p_user_id,
					last_update_login	=	p_login_id,
        object_version_number = l_object_version,
        bulk_writer_code    =   decode( l_bulk_writer_code, fnd_api.g_miss_char, null, l_bulk_writer_code),
        bulk_batch_type     =   decode( l_bulk_batch_type, fnd_api.g_miss_char, null, l_bulk_batch_type),
        bulk_batch_id       =   decode( l_bulk_batch_id, fnd_api.g_miss_num, null, l_bulk_batch_id),
        bulk_interaction_id =   decode( l_bulk_interaction_id, fnd_api.g_miss_num, null, l_bulk_interaction_id)
				WHERE CURRENT OF c_Update_MediaLifecycle_csr;

Line: 9357

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'A', 'V') THEN
				JTF_IH_PUB_VUHK.update_medialifecycle_post(
				                     --p_media_lc_rec=>l_media_lc_rec_hk,
				                     p_media_lc_rec=>l_media_lc_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 9371

			IF JTF_USR_HKS.Ok_TO_EXECUTE('JTF_IH_PUB', 'UPDATE_MEDIALIFECYCLE', 'A', 'C') THEN
				JTF_IH_PUB_CUHK.update_medialifecycle_post(
				                     --p_media_lc_rec=>l_media_lc_rec_hk,
				                     p_media_lc_rec=>l_media_lc_rec,
						     x_data=>l_data,
						     x_count=>l_count,
						     x_return_code=>l_return_code);

Line: 9396

			ROLLBACK TO update_medialifecycle_pub;

Line: 9403

			ROLLBACK TO update_medialifecycle_pub;

Line: 9410

			ROLLBACK TO update_medialifecycle_pub;

Line: 9419

	END Update_MediaLifecycle;