DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT dependencies on AHL_PRD_UTIL_PKG

Line 166: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,

162: OPEN get_wo_from_ue(l_unit_effectivity_id);
163: FETCH get_wo_from_ue INTO l_workorder_id, l_wo_name;
164: CLOSE get_wo_from_ue;
165:
166: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
167: p_visit_id => NULL,
168: p_item_instance_id => NULL);
169:
170:

Line 186: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,

182: FND_MSG_PUB.ADD;
183: RETURN FND_API.G_RET_STS_ERROR;
184: END IF;
185: ELSIF p_transaction_no = G_JOB_TXN_NO THEN
186: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
187: p_visit_id => NULL,
188: p_item_instance_id => NULL);
189: IF l_return_status = FND_API.G_TRUE THEN
190: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_UNTLCKD');

Line 199: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,

195: OPEN get_wo_from_op(l_workorder_operation_id);
196: FETCH get_wo_from_op INTO l_workorder_id;
197: CLOSE get_wo_From_op;
198:
199: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
200: p_visit_id => NULL,
201: p_item_instance_id => NULL);
202: IF l_return_status = FND_API.G_TRUE THEN
203: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');