DBA Data[Home] [Help]

APPS.CAC_TASK_PURGE_PUB dependencies on FND_ATTACHED_DOCUMENTS

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 71: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>l_entity_name,

67:
68: -- Calling delete attachment API
69: For j In 1.. l_tab_task_ids.LAST loop
70:
71: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>l_entity_name,
72: X_pk1_value =>to_char(l_tab_task_ids(j)),
73: X_pk2_value => NULL,
74: X_pk3_value => NULL,
75: X_pk4_value => NULL,