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 515: from jtf_tasks_b

511: Cursor tasks_ids(b_processing_set_id NUMBER,b_object_type VARCHAR2)
512: is
513:
514: Select task_id
515: from jtf_tasks_b
516: Where source_object_type_code=b_object_type
517: And source_object_id in
518: (select distinct object_id from jtf_object_purge_param_tmp
519: where processing_set_id=b_processing_set_id and

Line 563: and exists ( select 1 from jtf_tasks_b where

559: Update jtf_object_purge_param_tmp joppt
560: Set joppt.PURGE_STATUS='E', joppt.PURGE_ERROR_MESSAGE='JTF:JTF_TASK_PURGE_VALID_FAIL'
561: where joppt.processing_set_id=p_processing_set_id
562: and joppt.object_type=p_object_type
563: and exists ( select 1 from jtf_tasks_b where
564: source_object_type_code=joppt.object_type
565: and nvl(open_flag,'Y')='Y'
566: and source_object_id=joppt.object_id
567: and entity='TASK');

Line 629: and object_id in (select task_id from jtf_tasks_b

625: Set temp.purge_status='E',
626: temp.purge_error_message=(select purge_error_message from jtf_object_purge_param_tmp
627: where processing_set_id=proc_seq_num
628: and object_type='TASK'
629: and object_id in (select task_id from jtf_tasks_b
630: where source_object_id=temp.object_id
631: and source_object_type_code=temp.object_type and
632: entity='TASK') and
633: purge_status is not null and rownum =1)

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

634: Where temp.processing_set_id=p_processing_set_id
635: and temp.object_type=p_object_type
636: and temp.object_id in
637:
638: ( select distinct b.source_object_id from jtf_tasks_b b,
639: jtf_object_purge_param_tmp temp where temp.object_id=b.task_id and
640: temp.processing_set_id=proc_seq_num and temp.object_type='TASK' and temp.purge_status is not null
641: and b.entity='TASK');
642: