[Home] [Help]
236: , l_eam_wo_rec.pm_suggested_end_date
237: , l_eam_wo_rec.pm_base_meter_reading
238: , l_eam_wo_rec.pm_base_meter
239: , l_eam_wo_rec.failure_code_required
240: FROM wip_discrete_jobs wdj, wip_entities we,eam_work_order_details ewod
241: WHERE wdj.wip_entity_id = we.wip_entity_id
242: AND wdj.organization_id = we.organization_id
243: AND wdj.wip_entity_id = p_wip_entity_id
244: AND wdj.organization_id = p_organization_id
266: * Parameters IN : Work Order column record
267: * Parameters OUT NOCOPY: Message Token Table
268: * Return Status
269: * Purpose : Procedure will perfrom an insert into the
270: * win_discrete_jobs and wip_entities table.
271: *********************************************************************/
272:
273: PROCEDURE Insert_Row
274: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
484: , p_eam_wo_rec.source_line_id
485: , p_eam_wo_rec.source_code
486: );
487:
488: INSERT INTO WIP_ENTITIES
489: ( wip_entity_id
490: , organization_id
491: , last_update_date
492: , last_updated_by
728: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id
729: AND organization_id = p_eam_wo_rec.organization_id;
730:
731:
732: UPDATE WIP_ENTITIES
733: SET wip_entity_name = p_eam_wo_rec.wip_entity_name
734: , description = p_eam_wo_rec.description
735: , primary_item_id = p_eam_wo_rec.asset_activity_id
736: , last_update_date = SYSDATE
783: * Parameters OUT NOCOPY: Messgae Token Table
784: * Return Status
785: * Purpose : This is the only procedure that the user will have
786: * access to when he/she needs to perform any kind of
787: * writes to the wip_discrete_jobs and wip_entities.
788: *********************************************************************/
789:
790: PROCEDURE Perform_Writes
791: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type