[Home] [Help]
238: , l_eam_wo_rec.pm_base_meter_reading
239: , l_eam_wo_rec.pm_base_meter
240: , l_eam_wo_rec.failure_code_required
241: , l_eam_wo_rec.planner_type --vardha
242: FROM wip_discrete_jobs wdj, wip_entities we,eam_work_order_details ewod
243: WHERE wdj.wip_entity_id = we.wip_entity_id
244: AND wdj.organization_id = we.organization_id
245: AND wdj.wip_entity_id = p_wip_entity_id
246: AND wdj.organization_id = p_organization_id
268: * Parameters IN : Work Order column record
269: * Parameters OUT NOCOPY: Message Token Table
270: * Return Status
271: * Purpose : Procedure will perfrom an insert into the
272: * win_discrete_jobs and wip_entities table.
273: *********************************************************************/
274:
275: PROCEDURE Insert_Row
276: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
486: , p_eam_wo_rec.source_line_id
487: , p_eam_wo_rec.source_code
488: );
489:
490: INSERT INTO WIP_ENTITIES
491: ( wip_entity_id
492: , organization_id
493: , last_update_date
494: , last_updated_by
732: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id
733: AND organization_id = p_eam_wo_rec.organization_id;
734:
735:
736: UPDATE WIP_ENTITIES
737: SET wip_entity_name = p_eam_wo_rec.wip_entity_name
738: , description = p_eam_wo_rec.description
739: , primary_item_id = p_eam_wo_rec.asset_activity_id
740: , last_update_date = SYSDATE
788: * Parameters OUT NOCOPY: Messgae Token Table
789: * Return Status
790: * Purpose : This is the only procedure that the user will have
791: * access to when he/she needs to perform any kind of
792: * writes to the wip_discrete_jobs and wip_entities.
793: *********************************************************************/
794:
795: PROCEDURE Perform_Writes
796: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type