DBA Data[Home] [Help]

APPS.CSF_ACCESS_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 667: FROM jtf_task_assignments

663: ( x_resource_id number
664: )
665: IS
666: SELECT task_id
667: FROM jtf_task_assignments
668: WHERE resource_id = x_resource_id;
669:
670: v_task_id NUMBER;
671:

Line 968: n_task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;

964: n_task_assignment_id NUMBER;
965: n_task_id NUMBER;
966: n_resource_id NUMBER;
967: BEGIN
968: n_task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;
969: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;
970: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;
971:
972: Task_Assign_Trigger_Handler

Line 969: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;

965: n_task_id NUMBER;
966: n_resource_id NUMBER;
967: BEGIN
968: n_task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;
969: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;
970: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;
971:
972: Task_Assign_Trigger_Handler
973: ( o_task_assignment_id => n_task_assignment_id

Line 970: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;

966: n_resource_id NUMBER;
967: BEGIN
968: n_task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;
969: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;
970: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;
971:
972: Task_Assign_Trigger_Handler
973: ( o_task_assignment_id => n_task_assignment_id
974: , o_task_id => n_task_id

Line 1015: FROM jtf_task_assignments

1011: )
1012: IS
1013: SELECT task_id
1014: , resource_id
1015: FROM jtf_task_assignments
1016: WHERE task_assignment_id = b_task_assignment_id;
1017:
1018: task_assignment_id NUMBER;
1019:

Line 1025: task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;

1021: n_task_id NUMBER;
1022: o_resource_id NUMBER;
1023: n_resource_id NUMBER;
1024: BEGIN
1025: task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;
1026: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;
1027: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;
1028:
1029: OPEN c_task_assign

Line 1026: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;

1022: o_resource_id NUMBER;
1023: n_resource_id NUMBER;
1024: BEGIN
1025: task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;
1026: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;
1027: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;
1028:
1029: OPEN c_task_assign
1030: ( b_task_assignment_id => task_assignment_id

Line 1027: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;

1023: n_resource_id NUMBER;
1024: BEGIN
1025: task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;
1026: n_task_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Id;
1027: n_resource_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Resource_Id;
1028:
1029: OPEN c_task_assign
1030: ( b_task_assignment_id => task_assignment_id
1031: );

Line 1088: FROM jtf_task_assignments jta

1084: )
1085: IS
1086: SELECT task_id
1087: , resource_id
1088: FROM jtf_task_assignments jta
1089: WHERE task_assignment_id = b_task_assignment_id;
1090:
1091: r_task_assign c_task_assign%ROWTYPE;
1092:

Line 1097: o_task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;

1093: o_task_assignment_id NUMBER;
1094: o_task_id NUMBER;
1095: o_resource_id NUMBER;
1096: BEGIN
1097: o_task_assignment_id := Jtf_Task_Assignments_Pub.p_task_assignments_user_hooks.Task_Assignment_Id;
1098:
1099: OPEN c_task_assign
1100: ( b_task_assignment_id => o_task_assignment_id
1101: );

Line 1354: This procedure acts as a trigger on JTF_TASK_ASSIGNMENTS

1350: Name:
1351: TASK_ASSIGN_TRIGGER_HANDLER
1352:
1353: Purpose:
1354: This procedure acts as a trigger on JTF_TASK_ASSIGNMENTS
1355: and is fired in case of insert, update or delete.
1356:
1357: Arguments:
1358: