DBA Data[Home] [Help]

APPS.EAM_WORKORDERTRANSACTIONS_PUB dependencies on EAM_OP_COMP

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 964: eam_op_comp.op_comp(

960: */
961:
962:
963: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
964: eam_op_comp.op_comp(
965: x_err_code => l_err_code,
966: x_err_msg => l_err_msg,
967:
968: p_wip_entity_id => p_wip_entity_id,

Line 996: -- call eam_op_comp.op_comp to

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

Line 997: -- insert into eam_op_completion_txns, update wip_operations

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