eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_TASK_PURGE_PUB dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 40: from jtf_object_purge_param_tmp

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);

Line 140: (select distinct object_id from jtf_object_purge_param_tmp

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:

Line 150: (select distinct object_id from jtf_object_purge_param_tmp

146: is
147: Select task_id
148: from jtf_task_references_b
149: Where object_id in
150: (select distinct object_id from jtf_object_purge_param_tmp
151: where (processing_set_id=b_processing_set_id_sr
152: and object_type=b_object_type)
153: or (processing_set_id = b_processing_set_id_task
154: and object_type='TASK')

Line 210: Insert into jtf_object_purge_param_tmp p

206: end if;
207:
208: FORALL i in l_tab_tasks_id.first..l_tab_tasks_id.last
209:
210: Insert into jtf_object_purge_param_tmp p
211: ( processing_set_id,object_id,object_type,purge_status,purge_error_message)
212: values
213: (proc_seq_num, l_tab_tasks_id(i),'TASK', null,null);
214:

Line 223: Insert into jtf_object_purge_param_tmp p

219: Close get_escalation_tasks_ids;
220: END IF;
221:
222: FORALL i in l_tab_esc_tasks_id.first..l_tab_esc_tasks_id.last
223: Insert into jtf_object_purge_param_tmp p
224: ( processing_set_id,object_id,object_type,purge_status,purge_error_message)
225: values
226: (proc_seq_num, l_tab_esc_tasks_id(i),'TASK', null,null);
227:

Line 518: (select distinct object_id from jtf_object_purge_param_tmp

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
520: purge_status is null and object_type=b_object_type)
521: and entity='TASK';
522:

Line 559: Update jtf_object_purge_param_tmp joppt

555: --calling validations for tasks
556:
557: if (p_purge_source_with_open_task='N') then
558:
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

Line 586: Insert into jtf_object_purge_param_tmp p

582: select jtf_object_purge_proc_set_s.nextval into proc_seq_num from dual;
583:
584: FORALL i in l_tab_tasks_id.first..l_tab_tasks_id.last
585:
586: Insert into jtf_object_purge_param_tmp p
587: ( processing_set_id,object_id,object_type,purge_status,purge_error_message)
588: values
589: (proc_seq_num, l_tab_tasks_id(i),'TASK', null,null);
590:

Line 621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_task_purge_pub.validate_tasks', ' before updating jtf_object_purge_param_tmp');

617:
618: --bulk update the rows with error status E for which tasks validations have failed.
619:
620: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_task_purge_pub.validate_tasks', ' before updating jtf_object_purge_param_tmp');
622: end if;
623:
624: Update jtf_object_purge_param_tmp temp
625: Set temp.purge_status='E',

Line 624: Update jtf_object_purge_param_tmp temp

620: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
621: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cac_task_purge_pub.validate_tasks', ' before updating jtf_object_purge_param_tmp');
622: end if;
623:
624: Update jtf_object_purge_param_tmp temp
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'

Line 626: temp.purge_error_message=(select purge_error_message from jtf_object_purge_param_tmp

622: end if;
623:
624: Update jtf_object_purge_param_tmp temp
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

Line 639: jtf_object_purge_param_tmp temp where temp.object_id=b.task_id and

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