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 467: AND fndattdoc.entity_name = 'JTF_TASKS_B'

463: AND fnddoccat_tl.language = asg.language
464: AND fndattdoc.pk1_value = to_char(acc.task_id)
465: AND asg.user_id = acc.user_id
466: AND fnddoccat_tl.name = 'MISC'
467: AND fndattdoc.entity_name = 'JTF_TASKS_B'
468: AND fnddoc.datatype_id in (1,5,6)
469: AND doctype.datatype_id = fnddoc.datatype_id
470: AND doctype.language = asg.language
471: AND acc.user_id = b_user_id;

Line 836: FROM jtf_task_assignments jta, jtf_tasks_b jt,

832: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
833: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
834: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
835: fnddoc.document_id,fnddoc_tl.title
836: FROM jtf_task_assignments jta, jtf_tasks_b jt,
837: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
838: fnd_document_categories_tl fnddoccat_tl,
839: fnd_attached_documents fndattdoc,
840: -- fnd_lobs lobs,

Line 894: AND fndattdoc.entity_name = 'JTF_TASKS_B'

890: AND fndattdoc.pk1_value = to_char(acc.task_id)
891: AND acc.user_id = b_user_id
892: AND asg.user_id = b_user_id
893: AND fnddoccat_tl.name = 'MISC'
894: AND fndattdoc.entity_name = 'JTF_TASKS_B'
895: AND fnddoc.datatype_id in (1,5,6)
896: AND doctype.datatype_id = fnddoc.datatype_id
897: AND doctype.language = asg.language
898: AND NOT EXISTS (SELECT 1 FROM CSM_FND_LOBS_ACC cflacc

Line 1207: jtf_tasks_b jt

1203: b_user_id IN NUMBER) IS
1204: SELECT acc.access_id, acc.user_id
1205: FROM csm_fnd_lobs_acc acc,
1206: jtf_task_assignments jta,
1207: jtf_tasks_b jt
1208: WHERE acc.user_id = b_user_id
1209: AND acc.entity_name = 'CS_INCIDENTS'
1210: AND jt.task_id = jta.task_id
1211: AND jta.task_assignment_id = b_task_assignment_id

Line 1221: AND acc.entity_name = 'JTF_TASKS_B'

1217: SELECT acc.access_id, acc.user_id
1218: FROM csm_fnd_lobs_acc acc,
1219: jtf_task_assignments jta
1220: WHERE acc.user_id = b_user_id
1221: AND acc.entity_name = 'JTF_TASKS_B'
1222: AND jta.task_assignment_id = b_task_assignment_id
1223: AND acc.pk1_value = to_char(jta.task_id);
1224:
1225: --CURSOR to get userid

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

1341: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
1342: jtm_message_log_pkg.Log_Msg
1343: ( p_task_assignment_id
1344: , g_table_name
1345: , 'Deleting record for JTF_TASKS_B and resource_id: ' || p_resource_id
1346: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1347: END IF;
1348:
1349: OPEN l_TaskAtt_csr(p_task_assignment_id, l_userid);

Line 1470: AND fndattdoc.entity_name = 'JTF_TASKS_B'

1466: AND fndattdoc.pk1_value = to_char(acc.task_id)
1467: AND fndattdoc.pk1_value = to_char(b_task_id)
1468: AND asg.user_id = acc.user_id
1469: AND fnddoccat_tl.name = 'MISC'
1470: AND fndattdoc.entity_name = 'JTF_TASKS_B'
1471: AND fnddoc.datatype_id = b_data_typeid
1472: AND doctype.datatype_id = fnddoc.datatype_id
1473: AND doctype.language = asg.language
1474: AND acc.user_id = b_user_id

Line 1612: IF p_entity_name = 'JTF_TASKS_B' THEN

1608: l_tab_datatype_id,l_tab_document_id,l_tab_title;
1609: CLOSE l_SRAtt_csr;
1610: END IF;
1611:
1612: IF p_entity_name = 'JTF_TASKS_B' THEN
1613: --- ATTACHMENT DOWNLOAD FOR task
1614: OPEN l_TaskAtt_csr(p_PK1_value, p_user_id,p_data_typeid);
1615: FETCH l_TaskAtt_csr BULK COLLECT INTO l_tab_access_id, l_tab_file_id, l_tab_user_id, l_tab_name,
1616: l_tab_description, l_tab_language, l_tab_entity_name, l_tab_pk1_value,