[Home] [Help]
36: select b.task_id
37: from jtf_tasks_b b, fnd_attached_documents fad
38: where b.source_object_type_code = p_object_type
39: and b.source_object_id in ( select object_id
40: from jtf_object_purge_param_tmp
41: where processing_set_id = p_processing_set_id
42: and ( purge_status is null or purge_status <> 'E'))
43: and fad.entity_name='JTF_TASKS_B'
44: and fad.pk1_value=to_char(b.task_id);
136: Select task_id
137: from jtf_tasks_b
138: Where source_object_type_code=b_object_type
139: And source_object_id in
140: (select distinct object_id from jtf_object_purge_param_tmp
141: where processing_set_id=b_processing_set_id and
142: purge_status is null and object_type=b_object_type)
143: and entity='TASK';
144:
192: end if;
193:
194: FORALL i in l_tab_tasks_id.first..l_tab_tasks_id.last
195:
196: Insert into jtf_object_purge_param_tmp p
197: ( processing_set_id,object_id,object_type,purge_status,purge_error_message)
198: values
199: (proc_seq_num, l_tab_tasks_id(i),'TASK', null,null);
200:
489: Select task_id
490: from jtf_tasks_b
491: Where source_object_type_code=b_object_type
492: And source_object_id in
493: (select distinct object_id from jtf_object_purge_param_tmp
494: where processing_set_id=b_processing_set_id and
495: purge_status is null and object_type=b_object_type)
496: and entity='TASK';
497:
530: --calling validations for tasks
531:
532: if (p_purge_source_with_open_task='N') then
533:
534: Update jtf_object_purge_param_tmp joppt
535: Set joppt.PURGE_STATUS='E', joppt.PURGE_ERROR_MESSAGE='JTF:JTF_TASK_PURGE_VALID_FAIL'
536: where joppt.processing_set_id=p_processing_set_id
537: and joppt.object_type=p_object_type
538: and exists ( select 1 from jtf_tasks_b where
557: select jtf_object_purge_proc_set_s.nextval into proc_seq_num from dual;
558:
559: FORALL i in l_tab_tasks_id.first..l_tab_tasks_id.last
560:
561: Insert into jtf_object_purge_param_tmp p
562: ( processing_set_id,object_id,object_type,purge_status,purge_error_message)
563: values
564: (proc_seq_num, l_tab_tasks_id(i),'TASK', null,null);
565:
592:
593: --bulk update the rows with error status E for which tasks validations have failed.
594:
595: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_task_purge_pub.validate_tasks', ' before updating jtf_object_purge_param_tmp');
597: end if;
598:
599: Update jtf_object_purge_param_tmp temp
600: Set temp.purge_status='E',
595: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_task_purge_pub.validate_tasks', ' before updating jtf_object_purge_param_tmp');
597: end if;
598:
599: Update jtf_object_purge_param_tmp temp
600: Set temp.purge_status='E',
601: temp.purge_error_message=(select purge_error_message from jtf_object_purge_param_tmp
602: where processing_set_id=proc_seq_num
603: and object_type='TASK'
597: end if;
598:
599: Update jtf_object_purge_param_tmp temp
600: Set temp.purge_status='E',
601: temp.purge_error_message=(select purge_error_message from jtf_object_purge_param_tmp
602: where processing_set_id=proc_seq_num
603: and object_type='TASK'
604: and object_id in (select task_id from jtf_tasks_b
605: where source_object_id=temp.object_id
610: and temp.object_type=p_object_type
611: and temp.object_id in
612:
613: ( select distinct b.source_object_id from jtf_tasks_b b,
614: jtf_object_purge_param_tmp temp where temp.object_id=b.task_id and
615: temp.processing_set_id=proc_seq_num and temp.object_type='TASK' and temp.purge_status is not null
616: and b.entity='TASK');
617:
618: