APPS.CSM_LOBS_EVENT_PKG dependencies on JTF_TASKS_B

Line 112: AND fndattdoc.entity_name = 'JTF_TASKS_B'

108: AND fndattdoc.pk1_value = to_char(acc.task_id)
109: AND asg.user_id = acc.user_id
110: AND asg.user_id=asg.owner_id
111: AND fnddoccat_tl.name = 'MISC'
112: AND fndattdoc.entity_name = 'JTF_TASKS_B'
113: AND fnddoc.datatype_id in(1,5,6)
114: AND doctype.datatype_id = fnddoc.datatype_id
115: AND doctype.language = asg.language
116: AND NOT EXISTS (SELECT 1 FROM CSM_FND_LOBS_ACC cflacc

Line 532: AND fndattdoc.entity_name = 'JTF_TASKS_B'

528: AND fnddoccat_tl.language = asg.language
529: AND fndattdoc.pk1_value = to_char(acc.task_id)
530: AND asg.user_id = acc.user_id
531: AND fnddoccat_tl.name = 'MISC'
532: AND fndattdoc.entity_name = 'JTF_TASKS_B'
533: AND fnddoc.datatype_id in (1,5,6)
534: AND doctype.datatype_id = fnddoc.datatype_id
535: AND doctype.language = asg.language
536: AND acc.user_id = b_user_id;

Line 901: FROM jtf_task_assignments jta, jtf_tasks_b jt,

897: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
898: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
899: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
900: fnddoc.document_id,fnddoc_tl.title
901: FROM jtf_task_assignments jta, jtf_tasks_b jt,
902: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
903: fnd_document_categories_tl fnddoccat_tl,
904: fnd_attached_documents fndattdoc,
905: -- fnd_lobs lobs,

Line 959: AND fndattdoc.entity_name = 'JTF_TASKS_B'

955: AND fndattdoc.pk1_value = to_char(acc.task_id)
956: AND acc.user_id = b_user_id
957: AND asg.user_id = b_user_id
958: AND fnddoccat_tl.name = 'MISC'
959: AND fndattdoc.entity_name = 'JTF_TASKS_B'
960: AND fnddoc.datatype_id in (1,5,6)
961: AND doctype.datatype_id = fnddoc.datatype_id
962: AND doctype.language = asg.language
963: AND NOT EXISTS (SELECT 1 FROM CSM_FND_LOBS_ACC cflacc

Line 1272: jtf_tasks_b jt

1268: b_user_id IN NUMBER) IS
1269: SELECT acc.access_id, acc.user_id
1270: FROM csm_fnd_lobs_acc acc,
1271: jtf_task_assignments jta,
1272: jtf_tasks_b jt
1273: WHERE acc.user_id = b_user_id
1274: AND acc.entity_name = 'CS_INCIDENTS'
1275: AND jt.task_id = jta.task_id
1276: AND jta.task_assignment_id = b_task_assignment_id

Line 1286: AND acc.entity_name = 'JTF_TASKS_B'

1282: SELECT acc.access_id, acc.user_id
1283: FROM csm_fnd_lobs_acc acc,
1284: jtf_task_assignments jta
1285: WHERE acc.user_id = b_user_id
1286: AND acc.entity_name = 'JTF_TASKS_B'
1287: AND jta.task_assignment_id = b_task_assignment_id
1288: AND acc.pk1_value = to_char(jta.task_id);
1289:
1290: --CURSOR to get userid

Line 1410: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id

1406: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1407: jtm_message_log_pkg.Log_Msg
1408: ( p_task_assignment_id
1409: , g_table_name
1410: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id
1411: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1412: END IF;
1413:
1414: OPEN l_TaskAtt_csr(p_task_assignment_id, l_userid);

Line 1535: AND fndattdoc.entity_name = 'JTF_TASKS_B'

1531: AND fndattdoc.pk1_value = to_char(acc.task_id)
1532: AND fndattdoc.pk1_value = to_char(b_task_id)
1533: AND asg.user_id = acc.user_id
1534: AND fnddoccat_tl.name = 'MISC'
1535: AND fndattdoc.entity_name = 'JTF_TASKS_B'
1536: AND fnddoc.datatype_id = b_data_typeid
1537: AND doctype.datatype_id = fnddoc.datatype_id
1538: AND doctype.language = asg.language
1539: AND acc.user_id = b_user_id

Line 1677: IF p_entity_name = 'JTF_TASKS_B' THEN

1673: l_tab_datatype_id,l_tab_document_id,l_tab_title;
1674: CLOSE l_SRAtt_csr;
1675: END IF;
1676:
1677: IF p_entity_name = 'JTF_TASKS_B' THEN
1678: --- ATTACHMENT DOWNLOAD FOR task
1679: OPEN l_TaskAtt_csr(p_PK1_value, p_user_id,p_data_typeid);
1680: FETCH l_TaskAtt_csr BULK COLLECT INTO l_tab_access_id, l_tab_file_id, l_tab_user_id, l_tab_name,
1681: l_tab_description, l_tab_language, l_tab_entity_name, l_tab_pk1_value,