DBA Data[Home] [Help]

APPS.CAC_TASK_PURGE_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 856: Select temp.object_id From JTF_OBJECT_PURGE_PARAM_TMP temp, fnd_attached_documents fad

852: l_entity_name VARCHAR2(40):='JTF_TASKS_B';
853:
854: Cursor C_Task_Id Is
855:
856: Select temp.object_id From JTF_OBJECT_PURGE_PARAM_TMP temp, fnd_attached_documents fad
857: Where temp.object_type = 'TASK'
858: And temp.processing_set_id = p_processing_set_id
859: And NVL(temp.purge_status,'Y') <> 'E'
860: and fad.entity_name='JTF_TASKS_B'

Line 918: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Calling FND_ATTACHED_DOCUMENTS2_DKG.Delete_Attachments API to delete attachment');

914: -- Statement level Logging
915: ----------------------------
916: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
917: THEN
918: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Calling FND_ATTACHED_DOCUMENTS2_DKG.Delete_Attachments API to delete attachment');
919: END IF;
920:
921:
922: -- Deleting attachment information from Attachment table

Line 926: FND_ATTACHED_DOCUMENTS2_PKG.Delete_Attachments (

922: -- Deleting attachment information from Attachment table
923:
924: FOR j IN 1..l_tab_task_id.LAST LOOP
925:
926: FND_ATTACHED_DOCUMENTS2_PKG.Delete_Attachments (
927: X_entity_name => 'JTF_TASKS_B' ,
928: X_pk1_value => to_char(l_tab_task_id(j)) ,
929: X_pk2_value => NULL ,
930: X_pk3_value => NULL ,