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.CSL_JTF_TASK_ASS_ACC_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_JTF_TASK_ASSIGNMENTS');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASK_ASS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_JTF_TASK_ASSIGNMENTS');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENTS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ASSIGNMENT_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENTS';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_JTF_TASK_ASS_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_JTF_TASK_ASSIGNMENTS');
8: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENTS';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ASSIGNMENT_ID';
10: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
11: g_debug_level NUMBER; -- debug level
12:

Line 24: FROM JTF_TASK_ASSIGNMENTS -- don't use synonym as that one filters on OWNER records

20: -- Fix for Bug# 3466610. Added filter to get only those records whose
21: -- Resource Type is Employee Resource.
22: CURSOR c_task_assignment (b_task_assignment_id NUMBER) IS
23: SELECT *
24: FROM JTF_TASK_ASSIGNMENTS -- don't use synonym as that one filters on OWNER records
25: WHERE task_assignment_id = b_task_assignment_id
26: AND resource_type_code = 'RS_EMPLOYEE';
27:
28: r_task_assignment c_task_assignment%ROWTYPE;

Line 44: FROM JTF_TASK_ASSIGNMENTS ta

40: r_assignment_status c_assignment_status%ROWTYPE;
41:
42: CURSOR c_personal_task( b_task_assignment_id NUMBER ) IS
43: SELECT tk.TASK_ID
44: FROM JTF_TASK_ASSIGNMENTS ta
45: , JTF_TASKS_B tk
46: WHERE tk.TASK_ID = ta.TASK_ID
47: AND tk.SOURCE_OBJECT_TYPE_CODE = 'TASK'
48: AND ta.TASK_ASSIGNMENT_ID = b_task_assignment_id;

Line 317: FROM jtf_task_assignments -- don't use synonym as that one filters on OWNER records

313: IS
314: CURSOR c_task_assignment( b_task_assignment_id NUMBER )
315: IS
316: SELECT task_id
317: FROM jtf_task_assignments -- don't use synonym as that one filters on OWNER records
318: WHERE task_assignment_id = b_task_assignment_id;
319: r_task_assignment c_task_assignment%ROWTYPE;
320: BEGIN
321: OPEN c_task_assignment( p_task_assignment_id );

Line 462: FROM JTF_TASK_ASSIGNMENTS

458: /* Called during user creation */
459: PROCEDURE INSERT_ALL_ACC_RECORDS( p_resource_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2 ) IS
460: CURSOR c_task_assignment( b_resource_id NUMBER ) IS
461: SELECT TASK_ASSIGNMENT_ID
462: FROM JTF_TASK_ASSIGNMENTS
463: WHERE ASSIGNEE_ROLE = 'ASSIGNEE'
464: AND RESOURCE_ID = b_resource_id;
465: l_return_status BOOLEAN;
466: BEGIN

Line 483: FROM JTF_TASK_ASSIGNMENTS

479: /* Called during deletion of a user */
480: PROCEDURE DELETE_ALL_ACC_RECORDS( p_resource_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2 ) IS
481: CURSOR c_task_assignment( b_resource_id NUMBER ) IS
482: SELECT TASK_ASSIGNMENT_ID
483: FROM JTF_TASK_ASSIGNMENTS
484: WHERE ASSIGNEE_ROLE = 'ASSIGNEE'
485: AND RESOURCE_ID = b_resource_id;
486: BEGIN
487: FOR r_task_assignment IN c_task_assignment( p_resource_id ) LOOP

Line 525: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522: RETURN;
523: END IF;
524: /*** get assignment record details from public API ***/
525: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
526: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
527:
528: /*** get debug level ***/
529: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 526: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;

522: RETURN;
523: END IF;
524: /*** get assignment record details from public API ***/
525: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
526: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
527:
528: /*** get debug level ***/
529: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
530:

Line 577: FROM jtf_task_assignments -- don't use synonym as that one filters on OWNER records

573: )
574: IS
575: CURSOR c_task_assignment( b_task_assignment_id NUMBER ) IS
576: SELECT resource_id
577: FROM jtf_task_assignments -- don't use synonym as that one filters on OWNER records
578: WHERE task_assignment_id = b_task_assignment_id;
579:
580: r_task_assignment c_task_assignment%ROWTYPE;
581: l_task_assignment_id NUMBER;

Line 590: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587: RETURN;
588: END IF;
589: /*** get assignment record details from public API ***/
590: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
591:
592: /*** get debug level ***/
593: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
594:

Line 651: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

647: x_return_status := FND_API.G_RET_STS_SUCCESS;
648: RETURN;
649: END IF;
650: /*** get assignment record details from public API ***/
651: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
652: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
653:
654: /*** get debug level ***/
655: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 652: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;

648: RETURN;
649: END IF;
650: /*** get assignment record details from public API ***/
651: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
652: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
653:
654: /*** get debug level ***/
655: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
656:

Line 764: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;

760: x_return_status := FND_API.G_RET_STS_SUCCESS;
761: RETURN;
762: END IF;
763: /*** get assignment record details from public API ***/
764: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
765: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
766:
767: /*** get debug level ***/
768: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

Line 765: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;

761: RETURN;
762: END IF;
763: /*** get assignment record details from public API ***/
764: l_task_assignment_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id;
765: l_resource_id := jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id;
766:
767: /*** get debug level ***/
768: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
769:

Line 825: jtf_task_assignments jta,

821: IS
822: CURSOR lcur_purge_task_assignments is
823: SELECT acc.task_assignment_id, acc.resource_id
824: FROM csl_jtf_task_ass_acc acc,
825: jtf_task_assignments jta,
826: jtf_tasks_b jt,
827: jtf_task_statuses_b jts,
828: jtf_task_statuses_b jta_jts
829: WHERE acc.task_assignment_id = jta.task_assignment_id