APPS.CAC_TASK_PURGE_PUB dependencies on JTF_TASKS_B

Line 37: from jtf_tasks_b b, fnd_attached_documents fad

33:
34:
35: cursor c_fetch_task_ids is
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

Line 43: and fad.entity_name='JTF_TASKS_B'

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);
45:
46:
47: TYPE t_tab_num Is Table Of NUMBER;

Line 49: l_entity_name VARCHAR2(30) := 'JTF_TASKS_B';

45:
46:
47: TYPE t_tab_num Is Table Of NUMBER;
48: l_tab_task_ids t_tab_num:=t_tab_num();
49: l_entity_name VARCHAR2(30) := 'JTF_TASKS_B';
50: l_api_version CONSTANT NUMBER := 1.0;
51: l_api_name CONSTANT VARCHAR2(30) := 'delete_atth_to_tasks';
52: Begin
53:

Line 137: from jtf_tasks_b

133: Cursor get_tasks_ids(b_processing_set_id NUMBER,b_object_type VARCHAR2)
134: is
135:
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

Line 490: from jtf_tasks_b

486: Cursor tasks_ids(b_processing_set_id NUMBER,b_object_type VARCHAR2)
487: is
488:
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

Line 538: and exists ( select 1 from jtf_tasks_b where

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
539: source_object_type_code=joppt.object_type
540: and nvl(open_flag,'Y')='Y'
541: and source_object_id=joppt.object_id
542: and entity='TASK');

Line 604: and object_id in (select task_id from jtf_tasks_b

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
606: and source_object_type_code=temp.object_type and
607: entity='TASK') and
608: purge_status is not null and rownum =1)

Line 613: ( select distinct b.source_object_id from jtf_tasks_b b,

609: Where temp.processing_set_id=p_processing_set_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: