162: , p_eam_res_inst_rec.start_date
163: , p_eam_res_inst_rec.completion_date
164: , p_eam_res_inst_rec.top_level_batch_id
165: , SYSDATE
166: , FND_GLOBAL.user_id
167: , SYSDATE
168: , FND_GLOBAL.user_id
169: , FND_GLOBAL.login_id
170: );
164: , p_eam_res_inst_rec.top_level_batch_id
165: , SYSDATE
166: , FND_GLOBAL.user_id
167: , SYSDATE
168: , FND_GLOBAL.user_id
169: , FND_GLOBAL.login_id
170: );
171:
172:
165: , SYSDATE
166: , FND_GLOBAL.user_id
167: , SYSDATE
168: , FND_GLOBAL.user_id
169: , FND_GLOBAL.login_id
170: );
171:
172:
173: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Resource Instances') ; END IF;
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
220: , last_update_date = SYSDATE
221: , last_updated_by = FND_GLOBAL.user_id
222: , last_update_login = FND_GLOBAL.login_id
223: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id
224: AND organization_id = p_eam_res_inst_rec.organization_id
225: AND operation_seq_num = p_eam_res_inst_rec.operation_seq_num
218: , completion_date = p_eam_res_inst_rec.completion_date
219: , batch_id = p_eam_res_inst_rec.top_level_batch_id
220: , last_update_date = SYSDATE
221: , last_updated_by = FND_GLOBAL.user_id
222: , last_update_login = FND_GLOBAL.login_id
223: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id
224: AND organization_id = p_eam_res_inst_rec.organization_id
225: AND operation_seq_num = p_eam_res_inst_rec.operation_seq_num
226: AND resource_seq_num = p_eam_res_inst_rec.resource_seq_num