DBA Data[Home] [Help]

APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_PRD_UTIL_PKG

Line 1481: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked

1477: --Get Job Number
1478: OPEN Get_job_number(p_x_req_material_tbl(i).workorder_id);
1479: FETCH Get_job_number INTO l_workorder_name,l_wip_entity_id;
1480: CLOSE Get_job_number;
1481: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked
1482: (
1483: p_workorder_id => nvl(p_x_req_material_tbl(i).workorder_id,l_workorder_id),
1484: p_ue_id => NULL,
1485: p_visit_id => NULL,

Line 3071: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(

3067: --
3068: p_x_req_material_tbl(i).workorder_id := l_workorder_id;
3069: -- rroy
3070: -- ACL Changes
3071: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(
3072: p_workorder_id => p_x_req_material_tbl(i).workorder_id,
3073: p_ue_id => NULL,
3074: p_visit_id => NULL,
3075: p_item_instance_id => NULL);

Line 3983: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked

3979: -- Bug # 6680137 - end
3980: END IF;
3981: -- rroy
3982: -- ACL Changes
3983: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked
3984: (
3985: p_workorder_id => p_x_req_material_tbl(i).workorder_id,
3986: p_ue_id => NULL,
3987: p_visit_id => NULL,

Line 4457: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked

4453: Fnd_Msg_Pub.ADD;
4454: END IF;
4455:
4456: --Check whether the item is locked.
4457: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked
4458: (
4459: p_workorder_id => l_material_req_rec.workorder_id,
4460: p_ue_id => NULL,
4461: p_visit_id => NULL,