APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on EAM_OP_COMPLETION_TXNS

Line 169: from eam_op_completion_txns

165: return;
166: END IF;
167:
168: select max(actual_end_date) into l_max_op_end_date
169: from eam_op_completion_txns
170: where wip_entity_id = p_wip_entity_id and transaction_type = G_TXN_TYPE_COMPLETE;
171:
172: select min(actual_start_date) into l_min_op_start_date
173: from eam_op_completion_txns

Line 173: from eam_op_completion_txns

169: from eam_op_completion_txns
170: where wip_entity_id = p_wip_entity_id and transaction_type = G_TXN_TYPE_COMPLETE;
171:
172: select min(actual_start_date) into l_min_op_start_date
173: from eam_op_completion_txns
174: where wip_entity_id = p_wip_entity_id and transaction_type = G_TXN_TYPE_COMPLETE;
175:
176: IF (l_max_op_end_date is not null AND
177: p_actual_end_date is not null AND

Line 995: -- insert into eam_op_completion_txns, update wip_operations

991: p_attribute15 => p_attribute_rec.p_attribute15
992: );
993:
994: -- call eam_op_comp.op_comp to
995: -- insert into eam_op_completion_txns, update wip_operations
996:
997: if l_err_code = 1 then -- there was an error
998: x_return_status := FND_API.G_RET_STS_ERROR;
999: FND_MSG_PUB.Add;