APPS.EAM_RES_UTILITY_PVT dependencies on WIP_OPERATION_RESOURCES

Line 124: FROM wip_operation_resources

120: , l_eam_res_rec.attribute13
121: , l_eam_res_rec.attribute14
122: , l_eam_res_rec.attribute15
123: , l_eam_res_rec.department_id
124: FROM wip_operation_resources
125: WHERE wip_entity_id = p_wip_entity_id
126: AND organization_id = p_organization_id
127: AND operation_seq_num = p_operation_seq_num
128: AND resource_seq_num = p_resource_seq_num;

Line 175: INSERT INTO WIP_OPERATION_RESOURCES

171: fnd_message.set_name('EAM','EAM_WO_RR_DT_ERR');
172: return;
173: end if;
174:
175: INSERT INTO WIP_OPERATION_RESOURCES
176: ( wip_entity_id
177: , organization_id
178: , operation_seq_num
179: , resource_seq_num

Line 313: * wip_operation_resources table.

309: * Parameters IN : Resources column record
310: * Parameters OUT NOCOPY: Message Token Table
311: * Return Status
312: * Purpose : Procedure will perfrom an Update on the
313: * wip_operation_resources table.
314: *********************************************************************/
315:
316: PROCEDURE Update_Row
317: ( p_eam_res_rec IN EAM_PROCESS_WO_PUB.eam_res_rec_type

Line 340: FROM WIP_OPERATION_RESOURCES

336: end if;
337:
338: SELECT usage_rate_or_amount
339: INTO l_usage_rate_or_amount
340: FROM WIP_OPERATION_RESOURCES
341: WHERE wip_entity_id = p_eam_res_rec.wip_entity_id
342: AND organization_id = p_eam_res_rec.organization_id
343: AND operation_seq_num = p_eam_res_rec.operation_seq_num
344: AND resource_seq_num = p_eam_res_rec.resource_seq_num;

Line 346: UPDATE WIP_OPERATION_RESOURCES

342: AND organization_id = p_eam_res_rec.organization_id
343: AND operation_seq_num = p_eam_res_rec.operation_seq_num
344: AND resource_seq_num = p_eam_res_rec.resource_seq_num;
345:
346: UPDATE WIP_OPERATION_RESOURCES
347: SET resource_id = p_eam_res_rec.resource_id
348: , uom_code = p_eam_res_rec.uom_code
349: , basis_type = p_eam_res_rec.basis_type
350: , usage_rate_or_amount = p_eam_res_rec.usage_rate_or_amount

Line 426: * wip_operation_resources table.

422: * Parameters IN : Resources column record
423: * Parameters OUT NOCOPY: Message Token Table
424: * Return Status
425: * Purpose : Procedure will perfrom an Update on the
426: * wip_operation_resources table.
427: *********************************************************************/
428:
429: PROCEDURE Delete_Row
430: ( p_eam_res_rec IN EAM_PROCESS_WO_PUB.eam_res_rec_type

Line 465: DELETE FROM WIP_OPERATION_RESOURCES

461:
462:
463: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource: '|| p_eam_res_rec.resource_seq_num); END IF;
464:
465: DELETE FROM WIP_OPERATION_RESOURCES
466: WHERE wip_entity_id = p_eam_res_rec.wip_entity_id
467: AND organization_id = p_eam_res_rec.organization_id
468: AND operation_seq_num = p_eam_res_rec.operation_seq_num
469: AND resource_seq_num = p_eam_res_rec.resource_seq_num;

Line 556: FROM wip_operation_resources

552: SELECT count(*) into l_count
553: FROM dual
554: WHERE exists (
555: SELECT 1
556: FROM wip_operation_resources
557: WHERE operation_seq_num = p_operation_seq_num
558: and wip_entity_id = p_wip_entity_id
559: and organization_id = p_organization_id
560: ) ;