[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
291: fnd_message.set_name('EAM','EAM_WO_WORKORDER_DT_ERR');
292: return;
293: end if;
294:
295: INSERT INTO WIP_DISCRETE_JOBS
296: ( wip_entity_id
297: , organization_id
298: , description
299: , asset_number
621: * Parameters IN : Work Order column record
622: * Parameters OUT NOCOPY: Message Token Table
623: * Return Status
624: * Purpose : Procedure will perfrom an Update into the
625: * wip_discrete_jobs table.
626: *********************************************************************/
627:
628: PROCEDURE Update_Row
629: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type
643: return;
644: end if;
645:
646:
647: UPDATE WIP_DISCRETE_JOBS
648: SET description = p_eam_wo_rec.description
649: ,rebuild_serial_number = p_eam_wo_rec.rebuild_serial_number -- agaurav - Added the rebuild_serial_number column so that updation of serial number can happen
650: ,rebuild_item_id = p_eam_wo_rec.rebuild_item_id
651: ,asset_number = p_eam_wo_rec.asset_number
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