APPS.EAM_RES_INST_UTILITY_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 65: FROM wip_op_resource_instances

61: INTO
62: l_eam_res_inst_rec.start_date
63: , l_eam_res_inst_rec.completion_date
64: , l_eam_res_inst_rec.top_level_batch_id
65: FROM wip_op_resource_instances
66: WHERE wip_entity_id = p_wip_entity_id
67: AND organization_id = p_organization_id
68: AND operation_seq_num = p_operation_seq_num
69: AND resource_seq_num = p_resource_seq_num

Line 88: FROM wip_op_resource_instances

84: l_eam_res_inst_rec.serial_number
85: , l_eam_res_inst_rec.start_date
86: , l_eam_res_inst_rec.completion_date
87: , l_eam_res_inst_rec.top_level_batch_id
88: FROM wip_op_resource_instances
89: WHERE wip_entity_id = p_wip_entity_id
90: AND organization_id = p_organization_id
91: AND operation_seq_num = p_operation_seq_num
92: AND resource_seq_num = p_resource_seq_num

Line 139: INSERT INTO WIP_OP_RESOURCE_INSTANCES

135: fnd_message.set_name('EAM','EAM_WO_RS_IN_DT_ERR');
136: return;
137: end if;
138:
139: INSERT INTO WIP_OP_RESOURCE_INSTANCES
140: ( wip_entity_id
141: , organization_id
142: , operation_seq_num
143: , resource_seq_num

Line 195: * wip_op_resource_instances table.

191: * Parameters IN : Resource Instances column record
192: * Parameters OUT NOCOPY: Message Token Table
193: * Return Status
194: * Purpose : Procedure will perfrom an Update on the
195: * wip_op_resource_instances table.
196: *********************************************************************/
197:
198: PROCEDURE Update_Row
199: ( p_eam_res_inst_rec IN EAM_PROCESS_WO_PUB.eam_res_inst_rec_type

Line 215: UPDATE WIP_OP_RESOURCE_INSTANCES

211: fnd_message.set_name('EAM','EAM_WO_RS_IN_DT_ERR');
212: return;
213: end if;
214:
215: UPDATE WIP_OP_RESOURCE_INSTANCES
216: SET serial_number = p_eam_res_inst_rec.serial_number
217: , start_date = p_eam_res_inst_rec.start_date
218: , completion_date = p_eam_res_inst_rec.completion_date
219: , batch_id = p_eam_res_inst_rec.top_level_batch_id

Line 241: * wip_op_resource_instances table.

237: * Parameters IN : Resource Instances column record
238: * Parameters OUT NOCOPY: Message Token Table
239: * Return Status
240: * Purpose : Procedure will perfrom an Update on the
241: * wip_op_resource_instances table.
242: *********************************************************************/
243:
244: PROCEDURE Delete_Row
245: ( p_eam_res_inst_rec IN EAM_PROCESS_WO_PUB.eam_res_inst_rec_type

Line 254: DELETE FROM WIP_OP_RESOURCE_INSTANCES

250: BEGIN
251:
252: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;
253:
254: DELETE FROM WIP_OP_RESOURCE_INSTANCES
255: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id
256: AND organization_id = p_eam_res_inst_rec.organization_id
257: AND operation_seq_num = p_eam_res_inst_rec.operation_seq_num
258: AND resource_seq_num = p_eam_res_inst_rec.resource_seq_num