APPS.EAM_WO_UTILITY_PVT dependencies on WIP_DISCRETE_JOBS

Line 242: FROM wip_discrete_jobs wdj, wip_entities we,eam_work_order_details ewod

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

Line 297: INSERT INTO WIP_DISCRETE_JOBS

293: fnd_message.set_name('EAM','EAM_WO_WORKORDER_DT_ERR');
294: return;
295: end if;
296:
297: INSERT INTO WIP_DISCRETE_JOBS
298: ( wip_entity_id
299: , organization_id
300: , description
301: , asset_number

Line 629: * wip_discrete_jobs table.

625: * Parameters IN : Work Order column record
626: * Parameters OUT NOCOPY: Message Token Table
627: * Return Status
628: * Purpose : Procedure will perfrom an Update into the
629: * wip_discrete_jobs table.
630: *********************************************************************/
631:
632: PROCEDURE Update_Row
633: ( p_eam_wo_rec IN EAM_PROCESS_WO_PUB.eam_wo_rec_type

Line 651: UPDATE WIP_DISCRETE_JOBS

647: return;
648: end if;
649:
650:
651: UPDATE WIP_DISCRETE_JOBS
652: SET description = p_eam_wo_rec.description
653: ,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
654: ,rebuild_item_id = p_eam_wo_rec.rebuild_item_id
655: ,asset_number = p_eam_wo_rec.asset_number

Line 792: * writes to the wip_discrete_jobs and wip_entities.

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