APPS.EAM_OPERATIONS_JSP dependencies on WIP_OPERATION_RESOURCES

Line 1265: curRow wip_operation_resources%ROWTYPE;

1261: ,p_employee_id IN NUMBER -- instance id
1262: ,p_complete_rollback IN VARCHAR2 := FND_API.G_FALSE -- Added parameter to handle rollback for Mobile Handover Page.
1263: ) IS
1264:
1265: curRow wip_operation_resources%ROWTYPE;
1266: newRow wip_operation_resources%ROWTYPE;
1267:
1268: l_api_name CONSTANT VARCHAR(30) := 'operation_handover_resource';
1269: l_api_version CONSTANT NUMBER := 1.0;

Line 1266: newRow wip_operation_resources%ROWTYPE;

1262: ,p_complete_rollback IN VARCHAR2 := FND_API.G_FALSE -- Added parameter to handle rollback for Mobile Handover Page.
1263: ) IS
1264:
1265: curRow wip_operation_resources%ROWTYPE;
1266: newRow wip_operation_resources%ROWTYPE;
1267:
1268: l_api_name CONSTANT VARCHAR(30) := 'operation_handover_resource';
1269: l_api_version CONSTANT NUMBER := 1.0;
1270: l_return_status VARCHAR2(250);

Line 1380: from wip_operation_resources

1376:
1377: begin
1378: l_dept :=null;
1379: select resource_id into l_resource_id
1380: from wip_operation_resources
1381: where wip_entity_id = p_wip_entity_id
1382: and operation_seq_num = p_old_op_seq_num
1383: and resource_seq_num = p_resource_seq_num;
1384:

Line 1403: from wip_operation_resources r

1399: -- get the resource
1400: BEGIN
1401: select *
1402: into curRow
1403: from wip_operation_resources r
1404: where r.wip_entity_id = p_wip_entity_id
1405: and r.operation_seq_num = p_old_op_seq_num
1406: and r.resource_seq_num = p_resource_seq_num;
1407:

Line 1410: from wip_operation_resources_v v

1406: and r.resource_seq_num = p_resource_seq_num;
1407:
1408: select quantity_open
1409: into l_quantity_open
1410: from wip_operation_resources_v v
1411: where v.wip_entity_id = curRow.Wip_Entity_Id
1412: and v.operation_seq_num = curRow.Operation_Seq_Num
1413: and v.resource_seq_num = curRow.Resource_Seq_Num;
1414:

Line 1450: from wip_operation_resources wor

1446: -- verify that resource can be handover to that department
1447: if (x_return_status = FND_API.G_RET_STS_SUCCESS ) then
1448: select count(*)
1449: into l_num_non_compatible_resources
1450: from wip_operation_resources wor
1451: where wor.wip_entity_id = p_wip_entity_id
1452: and wor.operation_seq_num = p_old_op_seq_num
1453: and wor.resource_seq_num = p_resource_seq_num
1454: and wor.resource_id not in (

Line 1483: FROM wip_operation_resources

1479: if( x_return_status = FND_API.G_RET_STS_SUCCESS) then
1480: BEGIN
1481:
1482: SELECT 1 INTO l_res_valid
1483: FROM wip_operation_resources
1484: WHERE wip_entity_id = p_wip_entity_id
1485: AND operation_seq_num = p_new_op_seq_num
1486: AND resource_seq_num = p_resource_seq_num;
1487:

Line 1860: -- Insert into WIP_OPERATION_RESOURCES from Add Resources JSP

1856:
1857: END validate_insert;
1858:
1859:
1860: -- Insert into WIP_OPERATION_RESOURCES from Add Resources JSP
1861:
1862: procedure insert_into_wor( p_api_version IN NUMBER
1863: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1864: ,p_commit IN VARCHAR2 := fnd_api.g_false

Line 2030: from wip_operation_resources

2026: select scheduled_flag, schedule_seq_num,
2027: start_date, completion_date, usage_rate_or_amount, uom_code, assigned_units
2028: into l_old_scheduled_flag, l_old_schedule_sequence, l_old_start_date
2029: , l_old_end_date, l_old_usage_rate, l_old_uom_code, l_old_assigned_units
2030: from wip_operation_resources
2031: where wip_entity_id = p_wip_entity_id
2032: and operation_seq_num = p_operation_seq_num
2033: and resource_seq_num = p_resource_seq_num
2034: and organization_id = p_organization_id;

Line 3034: from wip_operation_resources

3030: begin
3031:
3032: select organization_id, resource_id
3033: into l_organization_id, l_resource_id
3034: from wip_operation_resources
3035: where wip_entity_id = l_wip_entity_id
3036: and operation_seq_num = l_operation_seq_num
3037: and resource_seq_num = l_resource_seq_num;
3038:

Line 3230: FROM WIP_OPERATION_RESOURCES wor

3226: AND NVL (bd.disable_date, sysdate+2) > sysdate
3227: AND NOT EXISTS
3228: (
3229: SELECT '1'
3230: FROM WIP_OPERATION_RESOURCES wor
3231: WHERE wor.organization_id = p_organization_id
3232: AND wor.wip_entity_id = p_wip_entity_id
3233: AND wor.operation_seq_num = p_operation_seq_num
3234: AND wor.resource_id not in

Line 4447: from wip_operation_resources

4443: and rownum =1;
4444:
4445: select count(*)
4446: into l_count_res
4447: from wip_operation_resources
4448: where wip_entity_id = l_wip_entity_id
4449: and operation_seq_num = l_operation_seq_num;
4450:
4451: begin