DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on JTF_TASK_ASSIGNMENTS_PUB

Line 2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

2653: AND default_code = 'IN';
2654:
2655: BEGIN
2656: x_return_status := FND_API.G_RET_STS_SUCCESS;
2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2660:
2661: IF (nvl(l_Resource_id, 0) <> nvl(G_old_resource_id, 0))THEN

Line 2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;

2654:
2655: BEGIN
2656: x_return_status := FND_API.G_RET_STS_SUCCESS;
2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2660:
2661: IF (nvl(l_Resource_id, 0) <> nvl(G_old_resource_id, 0))THEN
2662: OPEN get_resource_location;

Line 2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;

2655: BEGIN
2656: x_return_status := FND_API.G_RET_STS_SUCCESS;
2657: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2658: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2659: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2660:
2661: IF (nvl(l_Resource_id, 0) <> nvl(G_old_resource_id, 0))THEN
2662: OPEN get_resource_location;
2663: FETCH get_resource_location INTO l_ship_to_location_id;

Line 2699: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;

2695:
2696: l_task_assignment_id NUMBER;
2697: BEGIN
2698: x_return_status := FND_API.G_RET_STS_SUCCESS;
2699: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2700:
2701: OPEN c_task_assignment(l_task_assignment_id);
2702: FETCH c_task_assignment INTO G_old_resource_id;
2703: CLOSE c_task_assignment;