DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on JTF_TASK_ASSIGNMENTS_PUB

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

2916: || ', l_subinventory_code = ' || l_subinventory_code);
2917: end if;
2918:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

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

2917: end if;
2918:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;

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

2918:
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:

Line 2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;

2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

2920: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;

2921: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
2922: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
2923: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
2924: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
2925: l_booking_start_date := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.booking_start_date;
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
2929: 'l_task_assignment_id = ' || l_task_assignment_id

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

4111: l_assignee_role VARCHAR2(10);
4112:
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;
4115: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4116: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4117:
4118: if l_assignee_role = 'ASSIGNEE' then
4119: OPEN c_task_assignment(l_task_assignment_id);

Line 4116: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;

4112:
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;
4115: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4116: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4117:
4118: if l_assignee_role = 'ASSIGNEE' then
4119: OPEN c_task_assignment(l_task_assignment_id);
4120: FETCH c_task_assignment INTO G_old_resource_id, g_old_tsk_asgn_sts_id;

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

4257: 'Begin');
4258: end if;
4259:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:

Line 4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;

4258: end if;
4259:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

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

4259:
4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

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

4260: x_return_status := FND_API.G_RET_STS_SUCCESS;
4261: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4262: l_assignee_role := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.assignee_role;
4263: l_resource_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_id;
4264: l_resource_type_code := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.resource_type_code;
4265:
4266: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4267: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4268: 'csp.plsql.CSP_PARTS_REQUIREMENT.TASK_ASSIGNMENT_POST_INSERT',

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

4523: 'begin ...');
4524: end if;
4525:
4526: x_return_status := FND_API.G_RET_STS_SUCCESS;
4527: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,

Line 4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;

4524: end if;
4525:
4526: x_return_status := FND_API.G_RET_STS_SUCCESS;
4527: l_task_assignment_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_assignment_id;
4528: l_task_id := JTF_TASK_ASSIGNMENTS_PUB.p_task_assignments_user_hooks.task_id;
4529:
4530: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_log_module,
4532: 'before calling CSP_SCH_INT_PVT.CLEAN_REQUIREMENT...');